Skip to content
Luke Cassar edited this page Aug 21, 2018 · 4 revisions

To record region information and act as placeholder to define relationships between entities.

DB Table Schema

Attribute Type
id integer
name string
parent_id integer
time_zone string

Validations

Attribute Constraint Value
name max length MAX_LOCATION_NAME_LENGTH
name uniqueness true
time_zone values [see Australian Time Zones below]

Australian Time Zones

  • (GMT+08:00) Perth
  • (GMT+08:45) Australia/Eucla
  • (GMT+09:30) Adelaide
  • (GMT+09:30) Australia/Broken_Hill
  • (GMT+09:30) Darwin
  • (GMT+10:00) Australia/Currie
  • (GMT+10:00) Australia/Lindeman
  • (GMT+10:00) Brisbane
  • (GMT+10:00) Canberra
  • (GMT+10:00) Hobart
  • (GMT+10:00) Melbourne
  • (GMT+10:00) Sydney
  • (GMT+10:30) Australia/Lord_Howe
  • (GMT+11:00) Antarctica/Macquarie

Associations

  • One Region can have many Assignments as Assignable.
  • One Region can have many child Regions.
  • One Region can have many Events.
  • One Region can have many DataSets.
  • One Region can have many Challenges.
  • One Region can have many Sponsorships as sponsorable.

Possible Assignments

  • Region Director
  • Region Support

Permissions

Title Create Update Read Destroy
GovHack Management Team
(Public User)
Clone this wiki locally