Skip to content
Luke Cassar edited this page Nov 18, 2018 · 3 revisions

To manage all the information associated with an authenticated user.

DB Table Schema

Attribute Type
id integer
email string (default: '')
full_name string (default: '')
preferred_name string
organisation_name string
phone_number string
google_img string
preferred_img string
dietary_requirements text
tshirt_size string
twitter string
mailing_list boolean (default: false)
challenge_sponsor_contact_place boolean (default: false)
challenge_sponsor_contact_enter boolean (default: false)
my_project_sponsor_contact boolean (default: false)
me_govhack_contact boolean (default: false)
how_did_you_hear text
accepted_terms_and_conditions boolean
registration_type string
parent_guardian string
request_not_photographed boolean
data_cruncher boolean
coder boolean
creative boolean
facilitator boolean
bsb string
acc_number string
acc_name string
branch_name string
[devise_attributes] [multiple]

Validations

Attribute Constraint Value
full_name max length MAX_FULL_NAME_LENGTH
preferred_name max length MAX_FULL_NAME_LENGTH
organisation_name max length MAX_FULL_NAME_LENGTH
phone_number max length PHONE_NUMBER_LENGTH
preferred_img values GovHack, Google, Gravitar
dietary_requirements max length MAX_TEXT_LENGTH
t-shirt_size values S, M, L, etc
user_id, entity instance unique true
how_did_you_hear max length MAX_TEXT_LENGTH

Associations

  • One User can have many Assignments.
  • One User can have many Registrations.
  • One User can have one GovHackImg attached.
    • As an asset in an external storage platform (AWS S3)

Possible Assignments

Assignment Title
Competition GovHack Management Team
Competition Admin
Competition Competition Director
Competition Sponsorship Director
Competition Chief Judge
Competition GovHack Volunteer
Competition VIP
Competition Participant
Region Region Director
Region Region Support
Event Event Host
Event Event Support
TeamProject Team Captain
TeamProject Team Member
Sponsor Sponsor Contact
Challenge Judge

Permissions

For Unauthenticated User Instance

Title Create Update Read Destroy
GovHack Management Team

For Authenticated User Instance

Title Create Update Read Destroy
(Authenticated User)
Admin
Clone this wiki locally