azmoon - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
role_id tinyInteger
name string

lessons

id increments
timestamps timestamps
name string

lesson_user

user_id ^FK bigInteger
lesson_id ^FK bigInteger

chapter

id increments
timestamps timestamps
name string (191)
lesson_id ^FK bigInteger

questions

id increments
timestamps timestamps
body string (191)
chapter_id ^FK bigInteger
lesson_id ^FK bigInteger
level tinyInteger

answers

id increments
timestamps timestamps
body string (191)
is_correct tinyInteger
question_id ^FK bigInteger

chapter_question

id increments
timestamps timestamps
chapter_id ^FK bigInteger
question_id ^FK bigInteger

quizes

id increments
timestamps timestamps
name string (191)

question_quiz

question_id ^FK bigInteger
quiz_id ^FK bigInteger

question_quiz_user

quiz_id ^FK bigInteger
question_id ^FK bigInteger
user_id ^FK bigInteger

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