SCHEMA.md

Schema

Quizzes

Name	Data Type
Quiz ID	integer(P)
Name	name
Owner	name
Quiz Details	line
Start Date	date
End Date	date
First Question ID	integer
Last Question ID	integer

Questions

Name	Data Type
Question ID	integer(P)
Quiz ID	integer
First Question ID	integer
Last Question ID	integer

Users

Name	Data Type
User ID	smallint(P)
Name	name
Email	text

Game

Name	Data Type
Game ID	integer(P)
Status	name
User ID	smallint
Question ID	integer
Quiz ID	integer
Score	smallint

P -> Primary Key