Organisation
- Engine: SQL (Django model / relational table)
- App: reference
- Table/Collection:
reference_organisation - Verbose name: Organisation
Clubs, Federations and everything in between. If it organises a competition, takes part in a competition, or people belong to it, we want it in our database. With this and the Affiliations table, we can map the web of organisations in the sport.
| 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 | dflt=30010101-5fda-4c3a-8bdc-88442548c2e1 | PK | — | — |
| code | CharField | code | — | — | URL-safe, unique-per-country acronym | |
| code_key | CharField | code_key | — | — | — | |
| local_code | CharField | local_code | — | — | Optional version of code with local accents, for display | |
| org_type | CharField | org_type | — | CLUB: Club; RUNGROUP: Informal Running or Fitness Group; ASSOCIATION: Association; NATTEAM: National Team; FEDERATION: Federation/NGB; LEAGUE: League; GOV: Government Body; REGION: Regional Association; SPONSOR: Sponsor; SCHASSOC: School Association; SCHOOL: School; UNIVERSITY: University; MILITARY: Military; EVENTPRO: Event Organiser; DATABASE: Results or other database; COMPOSITE: Composite Team | — | |
| is_demo | BooleanField | is_demo | dflt=False | — | Used for demo/training, hide on live site | |
| formal_name | CharField | formal_name | — | — | How the club names itself, normalised | |
| short_name | CharField | short_name | — | — | What runners and other non-officials call the club | |
| english_name | CharField | english_name | — | — | If location name is not english, it will be stored here | |
| name_local | CharField | name_local | — | — | For non Latin Alphabets | |
| ngb_affiliated | BooleanField | ngb_affiliated | null | None: Unaffiliated; True: Registered; False: Unregistered | — | |
| archived | BooleanField | archived | dflt=False | — | — | |
| country | ForeignKey → Country (FK) | country_id | null/dflt=GBR | — | — | |
| ngb | CharField | ngb | null | EA: England Athletics; SA: Scottish Athletics; WA: Welsh Athletics; ANI: Athletics Northern Ireland; RFEA: Real Federacion Espanola de Atletismo | — | |
| national_id | CharField | national_id | null | — | ID in national system; general spare field when importing da… | |
| flag | FileField | flag | null | — | Simple icon representing a club, for use similar to country … | |
| logo | FileField | logo | null | — | Detailed logo or crest for the organisation. Ideally square … | |
| website | CharField | website | — | — | — | |
| phone | CharField | phone | null | — | — | |
| CharField | — | — | The club's contact email. | |||
| home_track | ForeignKey → Venue (FK) | home_track_id | null | — | — | |
| hq_address | CharField | hq_address | — | — | Address or postcode used to locate club geographically | |
| latitude | FloatField | latitude | null | — | — | |
| longitude | FloatField | longitude | null | — | — | |
| location_type | CharField | location_type | — | HQ: HeadQuarters; TRACK: Track; OFFICE: Office; VENUE: Venue; TOWN: Town; REGION: RegionCenter | — | |
| 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… | |
| region | CharField | region | — | — | As taken from Trinity for UK; Norway also | |
| locality | CharField | locality | — | — | Town or county in UK, from Trinity | |
| public_description | TextField | public_description | — | — | How the organisation describes itself. Hidden if unused. | |
| instagram_user | CharField | instagram_user | — | — | Instagram username, without the @ symbol | |
| twitter_user | CharField | twitter_user | — | — | Twitter/X username, without the @ symbol | |
| membership_managed_here | BooleanField | membership_managed_here | dflt=False | — | — | |
| membership_year_end_day | IntegerField | membership_year_end_day | dflt=31 | — | — | |
| membership_year_end_month | IntegerField | membership_year_end_month | dflt=12 | — | — | |
| membership_renewal_window_days | IntegerField | membership_renewal_window_days | dflt=45 | — | — | |
| membership_has_magazine | BooleanField | membership_has_magazine | dflt=False | — | — | |
| membership_hidden_from_public | BooleanField | membership_hidden_from_public | dflt=False | — | — | |
| receive_membership_emails | BooleanField | receive_membership_emails | dflt=True | — | — | |
| show_donation_box | BooleanField | show_donation_box | dflt=False | — | Show donation box when joining and renewing? | |
| issue_ids | BooleanField | issue_ids | dflt=False | — | Issue an autogenerated id to new Memberships? | |
| next_id | IntegerField | next_id | dflt=0 | — | Membership number to issue to next new athlete | |
| athlete_membership_tc | TextField | athlete_membership_tc | — | — | — | |
| athlete_membership_email | TextField | athlete_membership_email | — | — | A field containing the html template of the email to be sent… | |
| people | ManyToManyField → Person (M2M) | people | — | — | — |
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; default =
27e5e01b-cf9b-4935-b10d-40a6e1c2094f
No help text yet — add a help_text on the model field and regenerate to fill this in.
code
- Engine: SQL
- Type:
CharField - Column/Key:
code
URL-safe, unique-per-country acronym
code_key
- Engine: SQL
- Type:
CharField - Column/Key:
code_key
No help text yet — add a help_text on the model field and regenerate to fill this in.
local_code
- Engine: SQL
- Type:
CharField - Column/Key:
local_code
Optional version of code with local accents, for display
org_type
- Engine: SQL
- Type:
CharField - Column/Key:
org_type - choices: CLUB: Club; RUNGROUP: Informal Running or Fitness Group; ASSOCIATION: Association; NATTEAM: National Team; FEDERATION: Federation/NGB; LEAGUE: League; GOV: Government Body; REGION: Regional Association; SPONSOR: Sponsor; SCHASSOC: School Association; SCHOOL: School; UNIVERSITY: University; MILITARY: Military; EVENTPRO: Event Organiser; DATABASE: Results or other database; COMPOSITE: Composite Team
No help text yet — add a help_text on the model field and regenerate to fill this in.
is_demo
- Engine: SQL
- Type:
BooleanField - Column/Key:
is_demo - default =
False
Used for demo/training, hide on live site
formal_name
- Engine: SQL
- Type:
CharField - Column/Key:
formal_name
How the club names itself, normalised
short_name
- Engine: SQL
- Type:
CharField - Column/Key:
short_name
What runners and other non-officials call the club
english_name
- Engine: SQL
- Type:
CharField - Column/Key:
english_name
If location name is not english, it will be stored here
name_local
- Engine: SQL
- Type:
CharField - Column/Key:
name_local
For non Latin Alphabets
ngb_affiliated
- Engine: SQL
- Type:
BooleanField - Column/Key:
ngb_affiliated - nullable; choices: None: Unaffiliated; True: Registered; False: Unregistered
No help text yet — add a help_text on the model field and regenerate to fill this in.
archived
- Engine: SQL
- Type:
BooleanField - Column/Key:
archived - default =
False
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; default =
GBR
No help text yet — add a help_text on the model field and regenerate to fill this in.
ngb
- Engine: SQL
- Type:
CharField - Column/Key:
ngb - nullable; choices: EA: England Athletics; SA: Scottish Athletics; WA: Welsh Athletics; ANI: Athletics Northern Ireland; RFEA: Real Federacion Espanola de Atletismo
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 - nullable
ID in national system; general spare field when importing data
flag
- Engine: SQL
- Type:
FileField - Column/Key:
flag - nullable
Simple icon representing a club, for use similar to country flags in results. Usually based on club vest colours. 90x60 SVG or PNG
logo
- Engine: SQL
- Type:
FileField - Column/Key:
logo - nullable
Detailed logo or crest for the organisation. Ideally square SVG or 160x160 PNG
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.
phone
- Engine: SQL
- Type:
CharField - Column/Key:
phone - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
- Engine: SQL
- Type:
CharField - Column/Key:
email
The club's contact email.
home_track
- Engine: SQL
- Type:
ForeignKey→ Venue (FK) - Column/Key:
home_track_id - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
hq_address
- Engine: SQL
- Type:
CharField - Column/Key:
hq_address
Address or postcode used to locate club geographically
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.
location_type
- Engine: SQL
- Type:
CharField - Column/Key:
location_type - choices: HQ: HeadQuarters; TRACK: Track; OFFICE: Office; VENUE: Venue; TOWN: Town; REGION: RegionCenter
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
region
- Engine: SQL
- Type:
CharField - Column/Key:
region
As taken from Trinity for UK; Norway also
locality
- Engine: SQL
- Type:
CharField - Column/Key:
locality
Town or county in UK, from Trinity
public_description
- Engine: SQL
- Type:
TextField - Column/Key:
public_description
How the organisation describes itself. Hidden if unused.
instagram_user
- Engine: SQL
- Type:
CharField - Column/Key:
instagram_user
Instagram username, without the @ symbol
twitter_user
- Engine: SQL
- Type:
CharField - Column/Key:
twitter_user
Twitter/X username, without the @ symbol
membership_managed_here
- Engine: SQL
- Type:
BooleanField - Column/Key:
membership_managed_here - default =
False
No help text yet — add a help_text on the model field and regenerate to fill this in.
membership_year_end_day
- Engine: SQL
- Type:
IntegerField - Column/Key:
membership_year_end_day - default =
31
No help text yet — add a help_text on the model field and regenerate to fill this in.
membership_year_end_month
- Engine: SQL
- Type:
IntegerField - Column/Key:
membership_year_end_month - default =
12
No help text yet — add a help_text on the model field and regenerate to fill this in.
membership_renewal_window_days
- Engine: SQL
- Type:
IntegerField - Column/Key:
membership_renewal_window_days - default =
45
No help text yet — add a help_text on the model field and regenerate to fill this in.
membership_has_magazine
- Engine: SQL
- Type:
BooleanField - Column/Key:
membership_has_magazine - default =
False
No help text yet — add a help_text on the model field and regenerate to fill this in.
membership_hidden_from_public
- Engine: SQL
- Type:
BooleanField - Column/Key:
membership_hidden_from_public - default =
False
No help text yet — add a help_text on the model field and regenerate to fill this in.
receive_membership_emails
- Engine: SQL
- Type:
BooleanField - Column/Key:
receive_membership_emails - default =
True
No help text yet — add a help_text on the model field and regenerate to fill this in.
show_donation_box
- Engine: SQL
- Type:
BooleanField - Column/Key:
show_donation_box - default =
False
Show donation box when joining and renewing?
issue_ids
- Engine: SQL
- Type:
BooleanField - Column/Key:
issue_ids - default =
False
Issue an autogenerated id to new Memberships?
next_id
- Engine: SQL
- Type:
IntegerField - Column/Key:
next_id - default =
0
Membership number to issue to next new athlete
athlete_membership_tc
- Engine: SQL
- Type:
TextField - Column/Key:
athlete_membership_tc
No help text yet — add a help_text on the model field and regenerate to fill this in.
athlete_membership_email
- Engine: SQL
- Type:
TextField - Column/Key:
athlete_membership_email
A field containing the html template of the email to be sent to the athlete upon joining/renewing. Includes 'organisation', 'role' and 'person'.
people
- Engine: SQL
- Type:
ManyToManyField→ Person (M2M) - Column/Key:
people
No help text yet — add a help_text on the model field and regenerate to fill this in.
Generated by docs_models management command for SQL.