IMTIAZ_ACADEMY_DB - Laravel Schema Designer

Teachers

id increments
name string
email string
mobile string (20)
specialization_id ^FK bigInteger
gender_id ^FK bigInteger
personal_id string
joining_date date
address string
status integer
timestamps timestamps

Students

id increments
name string
email string
mobile string (20)
gender_id ^FK bigInteger
personal_id string
age integer
address string
status integer
timestamps timestamps

Programs

id increments
name string
notes text
timestamps timestamps

Program_Types

id increments
name string
program_id ^FK bigInteger
timestamps timestamps

Classrooms

id increments
name string
programType_id ^FK bigInteger
schedule string
starting_date date
notes text
duration integer
timestamps timestamps

Genders

id increments
name string (20)
timestamps timestamps

Specializations

id increments
name string
timestamps timestamps

Classroom_Student

id increments
classroom_id ^FK bigInteger
student_id ^FK bigInteger
timestamps timestamps

Classroom_Teacher

id increments
timestamps timestamps
classroom_id ^FK bigInteger
teacher_id ^FK bigInteger

Registrations

id increments
student_id ^FK bigInteger
teacher_id ^FK bigInteger
classroom_id ^FK bigInteger
program_id ^FK bigInteger
programType_id ^FK bigInteger
Invoice_id bigInteger
timestamps timestamps

Invoices

id increments
timestamps timestamps
invoice_no string
amount decimal
registration_id ^FK bigInteger
notes text

Money

id increments
timestamps timestamps
purpose string
in-out integer
amount decimal
description text

attendances

id increments
student_id ^FK bigInteger
classroom_id ^FK bigInteger
teacher_id ^FK bigInteger
attendence_date date
attendence_status boolean
session_duration integer
comment text
timestamps timestamps

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01