Skip to content

CompetitionSeries

  • Engine: SQL (Django model / relational table)
  • App: reference
  • Table/Collection: reference_competitionseries
  • Verbose name: competition series

Links together e.g. Diamond Leagues, WACT Europe Tour etc Competitions can belong to one or more series

Field Type Column/Key Null/Default PK Choices Notes
id AutoField id — PK — —
created DateTimeField created null — —
last_edit_time DateTimeField last_edit_time null — —
last_edit_by CharField last_edit_by null — —
wa_id IntegerField wa_id null — ID in World Athletics calendar database
name CharField name — — —
country ForeignKey → Country (FK) country_id null — Lack of country denotes international in scope
organiser ForeignKey → Organisation (FK) organiser_id null — —
active BooleanField active dflt=True — Is this still taking place, or historical?
short_name CharField short_name — — Short version of formal name
slug SlugField slug — — —
level ForeignKey → CompetitionLevel (FK) level_id null — IAAF level code or codes; may be overridden per competition
type CharField type — VIRTUAL: Virtual; TRACK: Track; INDOOR: Indoor; CROSSCOUNTRY: Cross Country; ROAD: Road; WALK: Walk; MOUNTAIN: Mountain and Trail; CONFERENCE: Conference or Meeting —
ea_order IntegerField ea_order null — Order in European Calendar
banner_background CharField banner_background — — CSS background value — solid colour (#BD94FF), named colour …
banner_text_colour CharField banner_text_colour — — CSS colour for banner text (e.g. #FFFFFF). Defaults to white…
banner_text CharField banner_text — — Text shown in the banner (e.g. 'World Athletics Continental …
banner_link_url CharField banner_link_url — — Override link URL for the banner (e.g. https://worldathletic…
summary_text TextField summary_text — — —
image FileField image null — Size for sharing on social media (e.g. 600x350)
is_league BooleanField is_league dflt=False — Is this a league, with seasonal points accumulating?
league_end_month IntegerField league_end_month dflt=12 — A month between seasons - e.g. 6 for winter XC

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.

id

  • Engine: SQL
  • Type: AutoField
  • Column/Key: id
  • primary key

No help text yet — add a help_text on the model field and regenerate to fill this in.

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.

wa_id

  • Engine: SQL
  • Type: IntegerField
  • Column/Key: wa_id
  • nullable

ID in World Athletics calendar database

name

  • Engine: SQL
  • Type: CharField
  • Column/Key: name

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
  • nullable

Lack of country denotes international in scope

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.

active

  • Engine: SQL
  • Type: BooleanField
  • Column/Key: active
  • default = True

Is this still taking place, or historical?

short_name

  • Engine: SQL
  • Type: CharField
  • Column/Key: short_name

Short version of formal name

slug

  • Engine: SQL
  • Type: SlugField
  • Column/Key: slug

No help text yet — add a help_text on the model field and regenerate to fill this in.

level

  • Engine: SQL
  • Type: ForeignKey → CompetitionLevel (FK)
  • Column/Key: level_id
  • nullable

IAAF level code or codes; may be overridden per competition

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.

ea_order

  • Engine: SQL
  • Type: IntegerField
  • Column/Key: ea_order
  • nullable

Order in European Calendar

  • Engine: SQL
  • Type: CharField
  • Column/Key: banner_background

CSS background value — solid colour (#BD94FF), named colour (gold), or gradient (linear-gradient(to right, #BD94FF, #FF873C)). Leave blank to suppress banner.

  • Engine: SQL
  • Type: CharField
  • Column/Key: banner_text_colour

CSS colour for banner text (e.g. #FFFFFF). Defaults to white if blank.

  • Engine: SQL
  • Type: CharField
  • Column/Key: banner_text

Text shown in the banner (e.g. 'World Athletics Continental Tour Gold'). Falls back to short_name then name if blank.

  • Engine: SQL
  • Type: CharField
  • Column/Key: banner_link_url

Override link URL for the banner (e.g. https://worldathletics.org/...). Falls back to internal series-detail page via slug if blank.

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.

image

  • Engine: SQL
  • Type: FileField
  • Column/Key: image
  • nullable

Size for sharing on social media (e.g. 600x350)

is_league

  • Engine: SQL
  • Type: BooleanField
  • Column/Key: is_league
  • default = False

Is this a league, with seasonal points accumulating?

league_end_month

  • Engine: SQL
  • Type: IntegerField
  • Column/Key: league_end_month
  • default = 12

A month between seasons - e.g. 6 for winter XC

Generated by docs_models management command for SQL.