sms - Laravel Schema Designer

student

id increments
timestamps timestamps
softDeletes softDeletes
first_name string (255)
middle_name string (255)
last_name string (255)
sex string (10)
birth_date date

employee

id increments
timestamps timestamps
softDeletes softDeletes
first_name string (255)
middle_name string (255)
last_name string (255)
sex string (10)
birth_date date
join_at date
position string (255)

teachers

id increments
timestamps timestamps
softDeletes softDeletes
employee_id ^FK integer

school

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
moto string (255)
logo string (255)
mission text
vision text
address text
location text
background text
owner string
description text

grade

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)

section

id increments
timestamps timestamps
grade_id ^FK integer
name string (255)
capacity integer

subject

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
description text

assesment

id increments
timestamps timestamps
teacher_id ^FK integer
subject_id ^FK integer
assesment_type_id ^FK integer
section_id ^FK integer
academic_year string (255)
semester integer
locked boolean
max_score integer
feedback string (255)
remark string (255)

assesment_type

id increments
timestamps timestamps
name string (255)
description text

student_assesment

id increments
timestamps timestamps
softDeletes softDeletes
assesment_id ^FK integer
student_id ^FK integer
score integer
control integer
re_exam boolean

semester

id increments
timestamps timestamps
softDeletes softDeletes
student_id ^FK integer
section_id ^FK integer
academic_year string
semester integer
total float
average float
rank integer
conduct string
absence integer

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