monprojet - Laravel Schema Designer

users

id increments
institution_id integer
role_id integer
name string (60)
first_name string (60)
username string (60)
email string (60)
password string (255)
date_of_birth date
timestamps timestamps
softDeletes softDeletes

groups

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

group_user

id increments
group_id integer
user_id integer
timestamps timestamps
softDeletes softDeletes

roles

id increments
name string (255)
timestamps timestamps
softDeletes softDeletes

institutions

id increments
name string (255)
ZIP integer
city string (255)
adress_1 string (255)
adress_2 string (255)
timestamps timestamps
softDeletes softDeletes

exercises

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

questions_answers

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

multiple_choices

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

year_subjects

id increments
name string (255)
timestamps timestamps
softDeletes softDeletes

themes

id increments
year_subject_id integer
timestamps timestamps
softDeletes softDeletes

homeworks

id increments
user_id integer
exercise_id integer
group_id integer
min_percentage integer
due_date datetime
timestamps timestamps
softDeletes softDeletes

studentworks

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

tags

id increments
name string (255)
timestamps timestamps
softDeletes softDeletes

links

id increments
category_id integer
theme_id integer
user_id integer
name string (255)
url text
timestamps timestamps
softDeletes softDeletes

categories

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

texts_with_blanks

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

exercise_tag

id increments
timestamps timestamps
softDeletes softDeletes
exercise_id integer
tag_id integer

link_tag

id increments
timestamps timestamps
softDeletes softDeletes
link_id integer
tag_id integer

medias

id increments
theme_id integer
user_id integer
year_subject_id integer
url text
name string (255)
type string (255)
timestamps timestamps
softDeletes softDeletes

exercise_media

id increments
timestamps timestamps
softDeletes softDeletes

link_exercise

id increments
timestamps timestamps
softDeletes softDeletes

exercise_homework

id increments
exercise_id integer
homework_id integer
timestamps timestamps
softDeletes softDeletes

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