school - Laravel Schema Designer

users

id increments
role_id integer
name string (255)
fist_name string (255)
username string (255)
email string (255)
password string (255)
timestamps timestamps
softDeletes softDeletes

roles

id increments
name string (255)
timestamps timestamps
softDeletes softDeletes

institutions

id increments
name string (255)
timestamps timestamps
softDeletes softDeletes

exercises

id increments
theme_id integer
type_id integer
user_id integer
name string (255)
source string (255)
statement text
timestamps timestamps
softDeletes softDeletes

year_subjects

id increments
name string
timestamps timestamps
softDeletes softDeletes

themes

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
year_subject_id integer

questions_answers

id increments
exercise_id integer
question text
correction integer
timestamps timestamps
softDeletes softDeletes

texts_with_blanks

id increments
exercise_id integer
question text
correction text
timestamps timestamps
softDeletes softDeletes

mutliple_choices

id increments
exercise_id integer
question text
choices text
correction text
timestamps timestamps
softDeletes softDeletes

homeworks

id increments
group_id integer
timestamps timestamps
softDeletes softDeletes

groups

id increments
holder_id integer
name string (255)
timestamps timestamps
softDeletes softDeletes

exercise_homework

id increments
timestamps timestamps
softDeletes softDeletes
exercise_id integer
homework_id integer

studentworks

id increments
homework_id integer
user_id integer
time_spent integer
work_date datetime
right_percentage integer
counter integer
percentage_counter text
status integer
timestamps timestamps
softDeletes softDeletes

institution_user

id increments
institution_id integer
user_id integer
timestamps timestamps
softDeletes softDeletes

group_user

id increments
group_id integer
user_id integer
timestamps timestamps
softDeletes softDeletes

medias

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

exercise_media

id increments
timestamps timestamps
softDeletes softDeletes
exercise_id integer
media_id integer

links

id increments
category_id integer
theme_id integer
user_id integer
link text
timestamps timestamps
softDeletes softDeletes

categories

id increments
name string (255)
year_subject_id integer
timestamps timestamps
softDeletes softDeletes

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