Skip to content

Latest commit

 

History

History
44 lines (35 loc) · 672 Bytes

SCHEMA.md

File metadata and controls

44 lines (35 loc) · 672 Bytes

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