Database Project 2 - Laravel Schema Designer

users

id increments
name string (100)
email string (100)
password string (60)
role tinyInteger
avatar string (255)
created_at timestamps
updated_at timestamps
deleted_at timestamps

subjects

id increments
name string (100)
created_at timestamps
updated_at timestamps
deleted_at timestamps

exams

id increments
subject_id ^FK integer
user_id ^FK integer
status tinyInteger
duration integer
question_number integer
spent_time time
activity boolean
result integer
created_at timestamps
updated_at timestamps
deleted_at timestamps

questions

id increments
subject_id ^FK integer
content string (255)
question_type tinyInteger
is_approve boolean
created_at timestamps
updated_at timestamps
deleted_at timestamps

options

id increments
question_id ^FK integer
content string (255)
is_correct boolean
created_at timestamps
updated_at timestamps
deleted_at timestamps

exam_questions

id increments
exam_id ^FK integer
question_id ^FK integer
created_at timestamps
updated_at timestamps
deleted_at timestamps

user_questions

id increments
user_id ^FK integer
question_id ^FK integer
created_at timestamps
updated_at timestamps
deleted_at timestamps

activities

id increments
user_id ^FK integer
target_id integer
action_type string
created_at timestamps
updated_at timestamps
deleted_at timestamps

socials

id increments
type_social string (100)
social_user_id integer

answers

id increments
option_id ^FK integer
exam_questions_id ^FK integer
content string (255)
is_correct boolean
created_at timestamps
updated_at timestamps
deleted_at timestamps

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