academy_bynat - Laravel Schema Designer

track

id increments
short_title string (10)
title string (20)
description string (500)
notes string (100)
timestamps timestamps

employee

id increments
offices_id ^FK integer
department_id_fk ^FK integer
group_id ^FK integer
full_name string (200)
national_identity integer
Job_title enum
mobile integer
status enum
timestamps timestamps
photo binary

department

id increments
title string (100)
notes string (100)
timestamps timestamps

grades

id increments
track_id_fk integer
title string (20)
time enum
description string (500)
notes string (100)
timestamps timestamps

courses

id increments
title string (100)
Subjects enum
author string (100)
reviewer string (100)
cover binary
textbook binary
notes string (100)
timestamps timestamps

grades_courses

id increments
academic_year enum
grades_id_fk ^FK integer
courses_id_fk ^FK integer
levels enum
semesters enum
description string (500)
weekly_lessons integer
min_mark integer
max_mark integer

students

id increments
full_name string (200)
birthday string
mobile integer
phone integer
nationality_id integer
national_identity integer
blood_type enum
guardian_relation enum
guardian_name string (20)
guardian_mobile string
guardian_phone integer
address string
qualification enum
Quran_course string
Quran_count integer
status enum
timestamps timestamps

enrolled

id increments
students_id_fk ^FK integer
grades_id_fk ^FK integer
academic_year enum
feedback1 string
feedback2 string
feedback3 string
status enum

classroom

id increments
title string (20)
symbol string (10)
notes string (100)
timestamps timestamps

marks

id increments
grades_id_fk ^FK integer
courses_id_fk ^FK integer
students_id_fk ^FK integer
attend_mark float
activity_mark float
project_mark float
homework_mark float
timestamps timestamps

exams

id increments
grades_id_fk integer
courses_id_fk integer
students_id_fk integer
mark1 float
type enum

offices

id increments
name string (50)
address string (200)
registrationID integer
phone integer
mobile integer
fax integer
logo binary
lat float
lan float
timestamps timestamps
type enum

group

id increments
title string (100)
notes string (100)
timestamps timestamps

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