quiz - Laravel Schema Designer

question

id increments
quiz_id ^FK integer
topic_id ^FK integer
lesson_id ^FK integer
question_title string
question_body string
imagepath string
published boolean

quiz

id increments
course_id ^FK integer
quiz_name string
quiz_desc string
quiz_text string
quiz_grade integer
quiz_start time
quiz_end time
timelimit smallInteger

topics

id increments
course_id ^FK integer
topic_name string
topic_code string
topic_desc string
topic_grade integer
topic_les_num integer

answers

id increments
question_id ^FK integer
answer_body string
iscorrect boolean
published boolean
explanation string

users

id increments
firstname string
email string
password string

courses

id increments
user_id ^FK integer
course_name string
course_code string
course_desc string
course_grade integer
course_image text

lessons

id increments
topic_id ^FK integer
lesson_code string
lesson_title string
lesson_obj string
lesson_ws string
lesson_body string
lesson_grade integer
lesson_completed boolean

digital_coach

id increments
user_id ^FK integer
result integer
progress string
current_grade string
quiz_score integer

questionanswers

id increments
question_id ^FK integer
answer_id ^FK integer

usercourses

id increments
timestamps timestamps
user_id ^FK integer
course_id ^FK integer

role

id increments
timestamps timestamps

role_user

id increments
timestamps timestamps

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