User Split

Current Models

User

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]

Proposed Models

User

For Authentication purposes.

Attribute	Type
id	integer
email	integer
accepted_terms_and_conditions	boolean
how_did_you_hear	text
[devise_attributes]	[multiple]

Placeholder

To be able to save a place for a user before they login as an authenticated user.

Attribute	Type
id	integer
email	string

Participant

To store all user personal data that can be used across competitions.

Attribute	Type
id	integer
userable_id	integer
userable_type	string
title	string
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)

Competition Profile

To store user data specific to a competition year.

Attribute	Type
id	integer
user_id	integer
competition_id	integer
registration_type	string
parent_guardian	string
request_not_photographed	boolean
data_cruncher	boolean
coder	boolean
creative	boolean
facilitator	boolean

Bank Account

To store user bank account details.

Attribute	Type
id	integer
user_id	integer
bsb	string
acc_number	string
acc_name	string
branch_name	string