Challenge

To store information on a regional challenges and manage its associated entities.

DB Table Schema

Attribute	Type
id	integer
region_id	integer
competition_id	integer
name	string
short_desc	text
long_desc	text
eligibility	text
img_url	string
video_url	string
data_set_url	string
approved	boolean

Validations

Attribute	Constraint	Value
name	max length	MAX_STRING_LENGTH
short_desc	max length	MAX_TEXT_LENGTH
long_desc	max length	MAX_TEXT_LENGTH
eligibility	max length	MAX_TEXT_LENGTH
img_url	max length	MAX_URL_LENGTH
video_url	max length	MAX_URL_LENGTH
data_set_url	max length	MAX_URL_LENGTH

Associations

• One Challenge has only one Region.
• One Challenge can have many Assignments as assignable.

Possible Assignments

• Judge

Permissions

Approval only

Title	Create	Update	Read	Destroy
GovHack Management Team		⭕
Competition Director		⭕

Remaining

Title	Create	Update	Read	Destroy
GovHack Management Team	⭕	⭕
Competition Director	⭕	⭕
Region Director	⭕	⭕
(Public User)			⭕