Schema

Schema Template

table_name

Field Names	Attributes	Type	Description
first_field	PK	text
second_field	FK: table_name.value	int
third_field

Schema

campaigns

Field Names	Attributes	Type	Description
title		varchar	Title that describes campaign
html		text	Educational component in HTML format
active		boolean	Active/enforcing campaign status
grace_period		time	Period of time where skip-mercy is granted
start_date		datetime	Campaign start time
stop_date		datetime	Campaign stop time
pass_percent		smallint	Quiz score percentage considered passing
questions_weighted		boolean	Question weight (order) is followed

questions

Field Names	Attributes	Type	Description
campaign_ID	FK: campaign.ID	integer	Campaign associated with question
answers_weighted		boolean	Answer weight (order) is followed
weight		integer	Weight of question for ordering purposes
html		text	Question content in HTML format
multiple_answers		boolean	Multiple answers are accepted