we-score - Laravel Schema Designer

pupils

id increments
timestamps timestamps
softDeletes softDeletes
first_name string
middle_name string
customer_id ^FK integer
last_name string

users

id increments
timestamps timestamps
email string
name string

staff_members

id increments
timestamps timestamps
softDeletes softDeletes
first_name string
middle_name string
last_name string
user_id ^FK integer

function_titles

id increments
name string
code string (16)
ordering integer

schools

id increments
timestamps timestamps
softDeletes softDeletes
name string
email string
city string

locations

id increments
timestamps timestamps
softDeletes softDeletes
name string
city string

sections

id increments
timestamps timestamps
softDeletes softDeletes
name string
code string (16)
ordering integer
location_id ^FK integer
sublocation_id ^FK integer

courses

id increments
timestamps timestamps
softDeletes softDeletes
name string
code string (16)

competencies

id increments
timestamps timestamps
softDeletes softDeletes
name string
code string (16)
description string
course_id ^FK integer

subscriptions

id increments
timestamps timestamps
softDeletes softDeletes
name string
code string (16)
duration string
price_type string
price decimal

planned_lesson

id increments
timestamps timestamps
softDeletes softDeletes
starts_at timestamp
ends_at timestamp
lesson_type_id ^FK integer
section_id ^FK integer

pupil_lesson_registration

id increments
timestamps timestamps
status string (16)
planned_lesson_id ^FK integer
pupil_id ^FK integer
course_product_id ^FK integer
price decimal

lesson_scores

id increments
timestamps timestamps
lesson_id ^FK integer
competencies_results json
scored_by ^FK integer
scored_at timestamp
created_by ^FK integer
updated_by ^FK integer

schedule

id increments
timestamps timestamps
type string
schedulable_id integer
schedulable_type string
valid_from timestamp
valid_till timestamp

lesson_type

id increments
name string
code string (16)
ordering integer

sublocations

id increments
timestamps timestamps
softDeletes softDeletes
name string
code string
ordering integer
location_id ^FK integer

course_planned_lesson

course_id ^FK integer
planned_lesson_id ^FK integer
ordering integer
nr_pupils integer

course_pupil

timestamps timestamps
pupil_id ^FK integer
course_id ^FK integer
competencies longText

lesson_sets

id increments
name string
timestamps timestamps

staff_member_lesson_registration

id increments
timestamps timestamps
status string (16)
planned_lesson_id ^FK integer
staff_member_id ^FK integer

customers

id increments
timestamps timestamps
softDeletes softDeletes
first_name string
midde_name string
last_name string
user_id ^FK integer

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