Schema Notes

ShareContent body, :string

Add to the documentation: Different body per network? (Twitter is shorter.) Tied to a user?

SocialNetworkRequest type: string (e.g. facebook, twitter, linkedin) content: string api_results: text (JSON) request_successful: boolean error_message: string made_on: date

UrlShortenerRequest social_network_request_id original_url: string new_url: string api_results: text request_successful: boolean error_message: string made_on: date

Conversion: referrer_id: integer social_network: string email: string user_id: integer # if they actually convert created_a_player: boolean created_a_backer: boolean

User Avatar username: string email: string encrypted_password: string first_name: string last_name: string has_played: boolean has_backed: boolean

Registration user_id: integer event_id: integer eventbrite_reference: string

Event name: string start_time: date time slug: string