Tracking - Laravel Schema Designer

Teachers

id char (3)
user_id ^FK integer
names string
softDeletes softDeletes

Students

id text
user_id ^FK integer
names string
pupil_premium boolean
softDeletes softDeletes
Cohort_id ^FK integer

Grade_Boundaries

id increments
Name enum
Mark integer
Test_id ^FK integer

Results

id increments
Mark integer
Test_id ^FK integer
Student_UPN text
Grade string
Release_date datetime
timestamps timestamps

Groups

id increments
Name string (10)
Faculty text
Cohort_id ^FK integer
timestamps timestamps
softDeletes softDeletes
Acadmic_year_id ^FK integer

Group_Student

Class_id ^FK integer
target string (2)
Student_id text

Tests

id increments
Name text
Max_Mark integer
timestamps timestamps
Season_id ^FK integer

Users

id increments
timestamps timestamps
softDeletes softDeletes

Roles

id increments
timestamps timestamps

role_user

id increments
timestamps timestamps
role_id ^FK integer
user_id ^FK integer

Faculties

id increments
Name string
short_name string (5)
Parent_faculty_id string

AcademicYears

id increments
Name string

Seasons

id integer
name string

Cohorts

id increments
calendaryear_id ^FK integer
Acadmicyear_id ^FK integer

group_teacher

id increments
Teacher_id string
Group_id string
is_responsibility boolean
is_teaching_class boolean

Group_Test

id increments
Group_id ^FK integer
Test_id ^FK integer

responsibilities

id increments
timestamps timestamps
faculty_id ^FK integer
teacher_id ^FK integer

calendaryears

id increments
year integer

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