course assistant - Laravel Schema Designer

users

id increments
type tinyInteger
login string (16)
password string (32)
fname string (16)
lname string (16)
timestamps timestamps

quizzes

id increments
name string (50)
timestamps timestamps

questions

id increments
quiz_id ^FK integer
question string (500)
multichoice tinyInteger
timestamps timestamps

answers

id increments
question_id ^FK integer
answer string (250)
answer_correct boolean
timestamps timestamps

attempts

id increments
user_id ^FK integer
question_id ^FK integer
answer_id ^FK integer
timestamps timestamps

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