quiz - Laravel Schema Designer

question

id increments
timestamps timestamps
softDeletes softDeletes
title text
hint string
explanation text
referencematerial string
imagepath string
published boolean

quiz

id increments
timestamps timestamps
name string
description text
timelimit smallInteger

category

id increments
timestamps timestamps
name string
description text

answer

id increments
timestamps timestamps
text string
iscorrect boolean

user

id increments
timestamps timestamps

category_question

id increments
timestamps timestamps
question_id ^FK integer
category_id ^FK integer

question_quiz

id increments
timestamps timestamps
quiz_id ^FK integer
question_id ^FK integer

attempt_question

id increments
timestamps timestamps
attempcount integer
timestart datetime
timefinish datetime
score integer

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