Skip to content

Sponsor

Luke Cassar edited this page Aug 21, 2018 · 3 revisions

To hold information on organisations sponsoring competition regions.

DB Table Schema

Attribute Type
id integer
competition_id integer
name string
description text
website string

Validations

Attribute Constraint Value
name max length MAX_FULL_NAME_LENGTH
description max length MAX_TEXT_LENGTH
website max length MAX_URL_LENGTH

Possible Assignments

  • Sponsor Contact

Associations

  • One Sponsor can have many Assignments as assignable.
  • One Sponsor can have one Logo attached.
    • As an asset in an external storage platform (AWS S3)

Permissions

Title Create Update Read Destroy
GovHack Management Team
Region Directors
Sponsorship Director
Sponsor Contact
Clone this wiki locally