gistfile1.txt

# table: svs_events

event_id: uniq
event_name: "name"
event_start: UTC datetime
event_end: UTC datetime

# table: event_teams

team_id: uniq
team_name: "name"
team_art: "URI to team logo"

# table: participants

participant_id: uniq
participant_name: "name"
participant_discord: "discord ID"
participant_email: "email"
participant_socials: [list, of, socials]

# table: event_honors

honor_id: uniq
honor_event: event_id
honor_track: track_id
honor_type: "placement|mention|special"
honor_placement: "1|2|3" (optional)
honor_name: "name" (best EP, best track, honorable mention, etc)

# table: svs_collections

collection_id: uniq
collection_event: event_id
collection_team: team_id
collection_type: "ep|1v1"
collection_title: "name"
collection_track_count: int
collection_art: "URI to art asset"

# table: svs_tracks

track_id: uniq
track_event: event_id
track_team: team_id
track_collection: collection_id
track_title: "name"
track_number: int
track_streamable: bool
track_url: "URI to streamable track"

# table: track_credits

track_credit_id: uniq
track_credit: track_id
track_credit_participant: participant_id
track_credit_contribution: "string of contributions"

# table: collection_credits

collection_credit_id: uniq
collection_credit: collection_id
collection_credit_participant: participant_id
collection_credit_contribution: "string of contributions"