Event

To manage information concerning all competition events.

DB Table Schema

Attribute	Type
id	integer
region_id	integer
competition_id	integer
name	string
category_type	string
registration_type	string
capacity	integer
email	string
twitter	string
address	text
accessibility	text
youth_support	text
parking	text
public_transport	text
operation_hours	text
catering	text
lat	float
long	float
video_url	string
start_time	date-time
end_time	date-time
approval	boolean (default: true)

Validations

Attribute	Constraint	Value
name	max length	MAX_LOCATION_NAME_LENGTH
category_type	values	[see Event Category Types below]
registration_type	values	[see Registration Types below]
capacity	max length	MAX_ATTENDANCE_CAPACITY
email	validity	VALID_EMAIL_REGEX
twitter	max length	MAX_TWITTER_LENGTH
accessibility	max length	MAX_TEXT_LENGTH
youth_support	max length	MAX_TEXT_LENGTH
parking	max length	MAX_TEXT_LENGTH
public_transport	max length	MAX_TEXT_LENGTH
operation_hours	max length	MAX_TEXT_LENGTH
catering	max length	MAX_TEXT_LENGTH
video_url	max length	MAX_URL_LENGTH

Event Category Types

• Competition
• State Connections
• State Awards
• National Awards

Event Registration Types

• Open
• Open Invitation
• Invitations Only

Associations

• One Event can have many Assignments as assignable.
• One Event can have only one Region.
• One Event can have only one Competition.
• One Event can have many PromoCodes.
• One Event can have only one Sponsorship through sponsorable.
• One Event can have many Registrations.

Possible Assignments

• Event Hosts
• Event Support

Permissions

Title	Create	Update	Read	Destroy
GovHack Management Team	⭕	⭕
Region Directors	⭕	⭕
Region Support	⭕	⭕
Event Hosts		⭕
Event Support		⭕
(Public User)			⭕