Competition
- Engine: SQL (Django model / relational table)
- App: reference
- Table/Collection:
reference_competition - Verbose name: competition
Enough descriptive info for an open global directory of competitions This does not assume we are taking entries or organising the competition. If we are, there will be a 1:1 record in the 'comp' app, where the complexity will lie.
| Field | Type | Column/Key | Null/Default | PK | Choices | Notes |
|---|---|---|---|---|---|---|
| created | DateTimeField | created | null | — | — | |
| last_edit_time | DateTimeField | last_edit_time | null | — | — | |
| last_edit_by | CharField | last_edit_by | null | — | — | |
| is_dirty | BooleanField | is_dirty | dflt=True | — | — | |
| id | CharField | id | — | PK | — | — |
| full_name | CharField | full_name | — | — | — | |
| short_name | CharField | short_name | — | — | Max 50 characters | |
| slug | CharField | slug | — | — | — | |
| country | ForeignKey → Country (FK) | country_id | dflt=TBC | — | — | |
| home_country | CharField | home_country | — | ENG: England; WAL: Wales; SCO: Scotland; NIR: Northern Ireland | Used for UK only at present, so we can separately serve Wale… | |
| address | CharField | address | — | — | — | |
| city | CharField | city | — | — | For display purposes | |
| venue | ForeignKey → Venue (FK) | venue_id | null | — | — | |
| date | DateField | date | — | — | — | |
| finish_date | DateField | finish_date | null | — | — | |
| type | CharField | type | — | VIRTUAL: Virtual; TRACK: Track; INDOOR: Indoor; CROSSCOUNTRY: Cross Country; ROAD: Road; WALK: Walk; MOUNTAIN: Mountain and Trail; CONFERENCE: Conference or Meeting | — | |
| wa_rankings_category | ForeignKey → CompetitionLevel (FK) | wa_rankings_category_id | null | — | World Rankings Category, usually blank but overriding catego… | |
| english_name | CharField | english_name | — | — | If name is not english, english name will be stored here | |
| name_local | CharField | name_local | — | — | Not English | |
| name_local_short | CharField | name_local_short | — | — | Not English. Max 50 characters | |
| facilities_url | CharField | facilities_url | — | — | URL to an external info document | |
| latitude | FloatField | latitude | null | — | — | |
| longitude | FloatField | longitude | null | — | — | |
| altitude | FloatField | altitude | null | — | — | |
| status | CharField | status | dflt=PUBLIC | PUBLIC: Public; COPIED: Copied from previous year; DRAFT: Draft / in planning | — | |
| is_managed_by_ot | BooleanField | is_managed_by_ot | dflt=False | — | Is this competition managed by OpenTrack? | |
| is_demo | BooleanField | is_demo | dflt=False | — | Tick to hide competition from public view | |
| demo_expiry_date | DateField | demo_expiry_date | null | — | Will be deleted after this date | |
| wa_id | IntegerField | wa_id | null | — | — | |
| wa_application_id | IntegerField | wa_application_id | null | — | — | |
| wa_application_submitter | ForeignKey → User (FK) | wa_application_submitter_id | null | — | User account who submitted the competition to WA | |
| wa_application_submission_date | DateTimeField | wa_application_submission_date | null | — | — | |
| wa_application_submission_log | TextField | wa_application_submission_log | — | — | Log of latest World Athletics submission | |
| wa_results_submission_date | DateTimeField | wa_results_submission_date | null | — | — | |
| ea_comp_id | IntegerField | ea_comp_id | null | — | — | |
| ea_comp_code | CharField | ea_comp_code | null | — | — | |
| tp_comp_id | IntegerField | tp_comp_id | null | — | — | |
| national_id | CharField | national_id | — | — | — | |
| age_groups | CharField | age_groups | — | — | — | |
| timed_events | TextField | timed_events | — | — | — | |
| field_events | TextField | field_events | — | — | — | |
| year | IntegerField | year | — | — | — | |
| organiser | ForeignKey → Organisation (FK) | organiser_id | null | — | — | |
| league | ForeignKey → League (FK) | league_id | null | — | — | |
| league_season | ForeignKey → Season (FK) | league_season_id | null | — | — | |
| basic_description | CharField | basic_description | — | — | — | |
| summary_text | TextField | summary_text | — | — | — | |
| website | CharField | website | — | — | — | |
| contact_name | CharField | contact_name | — | — | Please choose a contact name to go along with the email | |
| contact_details | CharField | contact_details | — | — | Will be visible on the home page. Be sure to include an emai… | |
| entry_link | CharField | entry_link | — | — | — | |
| results_link | CharField | results_link | — | — | — | |
| ot_supported | BooleanField | ot_supported | dflt=True | — | OpenTrack providing support | |
| ot_support_summary | CharField | ot_support_summary | — | — | Summary of OT support | |
| ot_support_details | TextField | ot_support_details | — | — | Details of OT support | |
| num_competitors | IntegerField | num_competitors | dflt=0 | — | Cached number of competitors | |
| num_results | IntegerField | num_results | dflt=0 | — | Cached number of official results | |
| num_prov_results | IntegerField | num_prov_results | dflt=0 | — | Cached number of provisional results | |
| num_paid_entries | IntegerField | num_paid_entries | null | — | — | |
| num_free_entries | IntegerField | num_free_entries | null | — | — | |
| gross_revenue | DecimalField | gross_revenue | dflt=0.00 | — | How much did the meeting make? | |
| organiser_revenue | DecimalField | organiser_revenue | dflt=0.00 | — | Net revenue received by organiser | |
| stripe_fees | DecimalField | stripe_fees | dflt=0.00 | — | Amount paid to Stripe | |
| opentrack_revenue | DecimalField | opentrack_revenue | dflt=0.00 | — | Amount earned by OpenTrack | |
| display_organiser_logo | BooleanField | display_organiser_logo | dflt=True | — | — | |
| custom_image | FileField | custom_image | null | — | Ideal size around 400x400. Will be visible on social media | |
| is_highlighted | BooleanField | is_highlighted | dflt=False | — | — | |
| cancelled | BooleanField | cancelled | dflt=False | — | Only true if the event has been cancelled explicitly | |
| groups | ManyToManyField → CompetitionSeries (M2M) | groups | — | — | Belongs to Series |
Field names link to their fuller explanation below.
Field details
Click a field name in the table above to jump to its explanation. Fields with no help text yet show a prompt, and are the ones to improve by adding a help_text on the model field, then regenerating.
created
- Engine: SQL
- Type:
DateTimeField - Column/Key:
created - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
last_edit_time
- Engine: SQL
- Type:
DateTimeField - Column/Key:
last_edit_time - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
last_edit_by
- Engine: SQL
- Type:
CharField - Column/Key:
last_edit_by - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
is_dirty
- Engine: SQL
- Type:
BooleanField - Column/Key:
is_dirty - default =
True
No help text yet — add a help_text on the model field and regenerate to fill this in.
id
- Engine: SQL
- Type:
CharField - Column/Key:
id - primary key
No help text yet — add a help_text on the model field and regenerate to fill this in.
full_name
- Engine: SQL
- Type:
CharField - Column/Key:
full_name
No help text yet — add a help_text on the model field and regenerate to fill this in.
short_name
- Engine: SQL
- Type:
CharField - Column/Key:
short_name
Max 50 characters
slug
- Engine: SQL
- Type:
CharField - Column/Key:
slug
No help text yet — add a help_text on the model field and regenerate to fill this in.
country
- Engine: SQL
- Type:
ForeignKey→ Country (FK) - Column/Key:
country_id - default =
TBC
No help text yet — add a help_text on the model field and regenerate to fill this in.
home_country
- Engine: SQL
- Type:
CharField - Column/Key:
home_country - choices: ENG: England; WAL: Wales; SCO: Scotland; NIR: Northern Ireland
Used for UK only at present, so we can separately serve Wales
address
- Engine: SQL
- Type:
CharField - Column/Key:
address
No help text yet — add a help_text on the model field and regenerate to fill this in.
city
- Engine: SQL
- Type:
CharField - Column/Key:
city
For display purposes
venue
- Engine: SQL
- Type:
ForeignKey→ Venue (FK) - Column/Key:
venue_id - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
date
- Engine: SQL
- Type:
DateField - Column/Key:
date
No help text yet — add a help_text on the model field and regenerate to fill this in.
finish_date
- Engine: SQL
- Type:
DateField - Column/Key:
finish_date - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
type
- Engine: SQL
- Type:
CharField - Column/Key:
type - choices: VIRTUAL: Virtual; TRACK: Track; INDOOR: Indoor; CROSSCOUNTRY: Cross Country; ROAD: Road; WALK: Walk; MOUNTAIN: Mountain and Trail; CONFERENCE: Conference or Meeting
No help text yet — add a help_text on the model field and regenerate to fill this in.
wa_rankings_category
- Engine: SQL
- Type:
ForeignKey→ CompetitionLevel (FK) - Column/Key:
wa_rankings_category_id - nullable
World Rankings Category, usually blank but overriding category of Series it belongs to
english_name
- Engine: SQL
- Type:
CharField - Column/Key:
english_name
If name is not english, english name will be stored here
name_local
- Engine: SQL
- Type:
CharField - Column/Key:
name_local
Not English
name_local_short
- Engine: SQL
- Type:
CharField - Column/Key:
name_local_short
Not English. Max 50 characters
facilities_url
- Engine: SQL
- Type:
CharField - Column/Key:
facilities_url
URL to an external info document
latitude
- Engine: SQL
- Type:
FloatField - Column/Key:
latitude - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
longitude
- Engine: SQL
- Type:
FloatField - Column/Key:
longitude - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
altitude
- Engine: SQL
- Type:
FloatField - Column/Key:
altitude - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
status
- Engine: SQL
- Type:
CharField - Column/Key:
status - default =
PUBLIC; choices: PUBLIC: Public; COPIED: Copied from previous year; DRAFT: Draft / in planning
No help text yet — add a help_text on the model field and regenerate to fill this in.
is_managed_by_ot
- Engine: SQL
- Type:
BooleanField - Column/Key:
is_managed_by_ot - default =
False
Is this competition managed by OpenTrack?
is_demo
- Engine: SQL
- Type:
BooleanField - Column/Key:
is_demo - default =
False
Tick to hide competition from public view
demo_expiry_date
- Engine: SQL
- Type:
DateField - Column/Key:
demo_expiry_date - nullable
Will be deleted after this date
wa_id
- Engine: SQL
- Type:
IntegerField - Column/Key:
wa_id - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
wa_application_id
- Engine: SQL
- Type:
IntegerField - Column/Key:
wa_application_id - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
wa_application_submitter
- Engine: SQL
- Type:
ForeignKey→ User (FK) - Column/Key:
wa_application_submitter_id - nullable
User account who submitted the competition to WA
wa_application_submission_date
- Engine: SQL
- Type:
DateTimeField - Column/Key:
wa_application_submission_date - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
wa_application_submission_log
- Engine: SQL
- Type:
TextField - Column/Key:
wa_application_submission_log
Log of latest World Athletics submission
wa_results_submission_date
- Engine: SQL
- Type:
DateTimeField - Column/Key:
wa_results_submission_date - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
ea_comp_id
- Engine: SQL
- Type:
IntegerField - Column/Key:
ea_comp_id - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
ea_comp_code
- Engine: SQL
- Type:
CharField - Column/Key:
ea_comp_code - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
tp_comp_id
- Engine: SQL
- Type:
IntegerField - Column/Key:
tp_comp_id - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
national_id
- Engine: SQL
- Type:
CharField - Column/Key:
national_id
No help text yet — add a help_text on the model field and regenerate to fill this in.
age_groups
- Engine: SQL
- Type:
CharField - Column/Key:
age_groups
No help text yet — add a help_text on the model field and regenerate to fill this in.
timed_events
- Engine: SQL
- Type:
TextField - Column/Key:
timed_events
No help text yet — add a help_text on the model field and regenerate to fill this in.
field_events
- Engine: SQL
- Type:
TextField - Column/Key:
field_events
No help text yet — add a help_text on the model field and regenerate to fill this in.
year
- Engine: SQL
- Type:
IntegerField - Column/Key:
year
No help text yet — add a help_text on the model field and regenerate to fill this in.
organiser
- Engine: SQL
- Type:
ForeignKey→ Organisation (FK) - Column/Key:
organiser_id - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
league
- Engine: SQL
- Type:
ForeignKey→ League (FK) - Column/Key:
league_id - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
league_season
- Engine: SQL
- Type:
ForeignKey→ Season (FK) - Column/Key:
league_season_id - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
basic_description
- Engine: SQL
- Type:
CharField - Column/Key:
basic_description
No help text yet — add a help_text on the model field and regenerate to fill this in.
summary_text
- Engine: SQL
- Type:
TextField - Column/Key:
summary_text
No help text yet — add a help_text on the model field and regenerate to fill this in.
website
- Engine: SQL
- Type:
CharField - Column/Key:
website
No help text yet — add a help_text on the model field and regenerate to fill this in.
contact_name
- Engine: SQL
- Type:
CharField - Column/Key:
contact_name
Please choose a contact name to go along with the email
contact_details
- Engine: SQL
- Type:
CharField - Column/Key:
contact_details
Will be visible on the home page. Be sure to include an email address
entry_link
- Engine: SQL
- Type:
CharField - Column/Key:
entry_link
No help text yet — add a help_text on the model field and regenerate to fill this in.
results_link
- Engine: SQL
- Type:
CharField - Column/Key:
results_link
No help text yet — add a help_text on the model field and regenerate to fill this in.
ot_supported
- Engine: SQL
- Type:
BooleanField - Column/Key:
ot_supported - default =
True
OpenTrack providing support
ot_support_summary
- Engine: SQL
- Type:
CharField - Column/Key:
ot_support_summary
Summary of OT support
ot_support_details
- Engine: SQL
- Type:
TextField - Column/Key:
ot_support_details
Details of OT support
num_competitors
- Engine: SQL
- Type:
IntegerField - Column/Key:
num_competitors - default =
0
Cached number of competitors
num_results
- Engine: SQL
- Type:
IntegerField - Column/Key:
num_results - default =
0
Cached number of official results
num_prov_results
- Engine: SQL
- Type:
IntegerField - Column/Key:
num_prov_results - default =
0
Cached number of provisional results
num_paid_entries
- Engine: SQL
- Type:
IntegerField - Column/Key:
num_paid_entries - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
num_free_entries
- Engine: SQL
- Type:
IntegerField - Column/Key:
num_free_entries - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
gross_revenue
- Engine: SQL
- Type:
DecimalField - Column/Key:
gross_revenue - default =
0.00
How much did the meeting make?
organiser_revenue
- Engine: SQL
- Type:
DecimalField - Column/Key:
organiser_revenue - default =
0.00
Net revenue received by organiser
stripe_fees
- Engine: SQL
- Type:
DecimalField - Column/Key:
stripe_fees - default =
0.00
Amount paid to Stripe
opentrack_revenue
- Engine: SQL
- Type:
DecimalField - Column/Key:
opentrack_revenue - default =
0.00
Amount earned by OpenTrack
display_organiser_logo
- Engine: SQL
- Type:
BooleanField - Column/Key:
display_organiser_logo - default =
True
No help text yet — add a help_text on the model field and regenerate to fill this in.
custom_image
- Engine: SQL
- Type:
FileField - Column/Key:
custom_image - nullable
Ideal size around 400x400. Will be visible on social media
is_highlighted
- Engine: SQL
- Type:
BooleanField - Column/Key:
is_highlighted - default =
False
No help text yet — add a help_text on the model field and regenerate to fill this in.
cancelled
- Engine: SQL
- Type:
BooleanField - Column/Key:
cancelled - default =
False
Only true if the event has been cancelled explicitly
groups
- Engine: SQL
- Type:
ManyToManyField→ CompetitionSeries (M2M) - Column/Key:
groups
Belongs to Series
Generated by docs_models management command for SQL.