Competitor
- Engine: MongoDB (mongoengine document)
- App: reference
- Table/Collection:
competitor - Verbose name: Competitor
One person taking part in a competition
| Field | Type | Column/Key | Null/Default | PK | Choices | Notes |
|---|---|---|---|---|---|---|
| _about | EmbeddedDocumentField → embedded <class 'docengine.mongoutils.models.VersionInfo'> | _about | null | — | — | |
| competitor_id | StringField | competitor_id | — | — | Bib, or unique identifier for athlete within a competition | |
| national_id | StringField | national_id | null | — | Unique identifier in National Governing Body or Federation | |
| first_name | StringField | first_name | null | — | — | |
| first_name_local | StringField | first_name_local | null | — | — | |
| last_name | StringField | last_name | null | — | — | |
| last_name_local | StringField | last_name_local | null | — | — | |
| gender | StringField | gender | null | M: M; F: F; X: X | — | |
| date_of_birth | DateField | date_of_birth | null | — | — | |
| age_group | StringField | age_group | null | — | — | |
| category | StringField | category | null | — | Grouping of age groups / genders for prizes | |
| StringField | null | — | — | |||
| team_category | StringField | team_category | null | — | Alternate category for team scores only | |
| team_id | StringField | team_id | null | — | — | |
| team | AffiliationField | team | null/dflt={} | — | — | |
| flag_url | StringField | flag_url | null | — | Calculated on saving | |
| flag_colour | StringField | flag_colour | null | — | Calculated on saving | |
| team_name | StringField | team_name | null | — | Calculated on saving | |
| team_name_local | StringField | team_name_local | null | — | Team name in local language | |
| team2_code | StringField | team2_code | null | — | Secondary team's code | |
| non_scorer | BooleanField | non_scorer | null/dflt=False | — | Eliminate from team scores and rankings? | |
| yellow_card | BooleanField | yellow_card | null/dflt=False | — | Has the athlete been awarded a yellow card? | |
| yellow_card_note | StringField | yellow_card_note | null | — | Rule number under which yellow card was awarded | |
| ot_athlete_id | DBReferenceField | ot_athlete_id | null | — | Opentrack ID of athlete | |
| tp_athlete_id | StringField | tp_athlete_id | null | — | — | |
| competition | ReferenceField → <class 'project.reference.mongo.competition.Competition'> | competition | — | — | — | |
| events_entered | EmbeddedDocumentListField | events_entered | null/dflt=[] | — | — | |
| numbered | BooleanField | numbered | null/dflt=False | — | Has a number been allocated yet? | |
| sort_event_code | StringField | sort_event_code | null | — | — | |
| sort_bib | StringField | sort_bib | null | — | — | |
| sort_age_group | StringField | sort_age_group | null | — | — | |
| checked_in | BooleanField | checked_in | null/dflt=False | — | — | |
| nationality | StringField | nationality | null | — | — | |
| residence | StringField | residence | null | — | — | |
| notable_performances | ListField | notable_performances | null/dflt=[] | — | What have they done lately? | |
| comparison_grade | FloatField | comparison_grade | null | — | Constant age-grade for rankings | |
| entry_id | IntField | entry_id | null | — | ID for a paid entry in the entries table, which produce this… | |
| region_of_birth | StringField | region_of_birth | null | — | — | |
| region_of_residence | StringField | region_of_residence | null | — | — | |
| department1 | StringField | department1 | null | — | — | |
| department2 | StringField | department2 | null | — | — | |
| coach_text | StringField | coach_text | null | — | — | |
| medical_exam_date | DateField | medical_exam_date | null | — | — | |
| medical_exam_expiry_date | DateField | medical_exam_expiry_date | null | — | — | |
| is_team_entry | BooleanField | is_team_entry | null/dflt=False | — | Entered through team entry system | |
| exclude_from_events | BooleanField | exclude_from_events | null/dflt=False | — | Exclude them from being in the start list / results for vari… | |
| ipc_classification_track | StringField | ipc_classification_track | null | : --------; T11: T11 - Vision impairment; T12: T12 - Vision impairment; T13: T13 - Vision impairment; T20: T20 - Intellectual impairment; T32: T32 - Co-ordination impairments (hypertonia, ataxia and athetosis); T33: T33 - Co-ordination impairments (hypertonia, ataxia and athetosis); T34: T34 - Co-ordination impairments (hypertonia, ataxia and athetosis); T35: T35 - Co-ordination impairments (hypertonia, ataxia and athetosis); T36: T36 - Co-ordination impairments (hypertonia, ataxia and athetosis); T37: T37 - Co-ordination impairments (hypertonia, ataxia and athetosis); T38: T38 - Co-ordination impairments (hypertonia, ataxia and athetosis); T40: T40 - Short stature; T41: T41 - Short stature; T42: T42 - Lower limb competing without prosthesis affected by limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; T43: T43 - Lower limb competing without prosthesis affected by limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; T44: T44 - Lower limb competing without prosthesis affected by limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; T45: T45 - Upper limb/s affected by limb deficiency, impaired muscle power or impaired passive range of movement; T46: T46 - Upper limb/s affected by limb deficiency, impaired muscle power or impaired passive range of movement; T47: T47 - Upper limb/s affected by limb deficiency, impaired muscle power or impaired passive range of movement; T51: T51 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; T52: T52 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; T53: T53 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; T54: T54 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; T61: T61 - Lower limb/s competing with prosthesis affected by limb deficiency and leg length difference; T62: T62 - Lower limb/s competing with prosthesis affected by limb deficiency and leg length difference; T63: T63 - Lower limb/s competing with prosthesis affected by limb deficiency and leg length difference; T64: T64 - Lower limb/s competing with prosthesis affected by limb deficiency and leg length difference; T71: T71 - athletes with severe co-ordination impairment (hypertonia, ataxia, athetosis); T72: T72 - athletes with severe co-ordination impairment (hypertonia, ataxia, athetosis) | International Paralympic Committee classification code for P… | |
| ipc_classification_field | StringField | ipc_classification_field | null | : --------; F11: F11 - Vision impairment; F12: F12 - Vision impairment; F13: F13 - Vision impairment; F20: F20 - Intellectual impairment; F31: F31 - Co-ordination impairments (hypertonia, ataxia and athetosis); F32: F32 - Co-ordination impairments (hypertonia, ataxia and athetosis); F33: F33 - Co-ordination impairments (hypertonia, ataxia and athetosis); F34: F34 - Co-ordination impairments (hypertonia, ataxia and athetosis); F35: F35 - Co-ordination impairments (hypertonia, ataxia and athetosis); F36: F36 - Co-ordination impairments (hypertonia, ataxia and athetosis); F37: F37 - Co-ordination impairments (hypertonia, ataxia and athetosis); F38: F38 - Co-ordination impairments (hypertonia, ataxia and athetosis); F40: F40 - Short stature; F41: F41 - Short stature; F42: F42 - Lower limb competing without prosthesis affected by limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F43: F43 - Lower limb competing without prosthesis affected by limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F44: F44 - Lower limb competing without prosthesis affected by limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F45: F45 - Upper limb/s affected by limb deficiency, impaired muscle power or impaired passive range of movement; F46: F46 - Upper limb/s affected by limb deficiency, impaired muscle power or impaired passive range of movement; F51: F51 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F52: F52 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F53: F53 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F54: F54 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F55: F55 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F56: F56 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F57: F57 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F61: F61 - Lower limb/s competing with prosthesis affected by limb deficiency and leg length difference; F62: F62 - Lower limb/s competing with prosthesis affected by limb deficiency and leg length difference; F63: F63 - Lower limb/s competing with prosthesis affected by limb deficiency and leg length difference; F64: F64 - Lower limb/s competing with prosthesis affected by limb deficiency and leg length difference | International Paralympic Committee classification code for P… | |
| id | ObjectIdField | _id | — | PK | — | — |
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.
_about
- Engine: MongoDB
- Type:
EmbeddedDocumentField→ embedded <class 'docengine.mongoutils.models.VersionInfo'> - Column/Key:
_about - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
competitor_id
- Engine: MongoDB
- Type:
StringField - Column/Key:
competitor_id
Bib, or unique identifier for athlete within a competition
national_id
- Engine: MongoDB
- Type:
StringField - Column/Key:
national_id - nullable
Unique identifier in National Governing Body or Federation
first_name
- Engine: MongoDB
- Type:
StringField - Column/Key:
first_name - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
first_name_local
- Engine: MongoDB
- Type:
StringField - Column/Key:
first_name_local - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
last_name
- Engine: MongoDB
- Type:
StringField - Column/Key:
last_name - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
last_name_local
- Engine: MongoDB
- Type:
StringField - Column/Key:
last_name_local - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
gender
- Engine: MongoDB
- Type:
StringField - Column/Key:
gender - nullable; choices: M: M; F: F; X: X
No help text yet — add a help_text on the model field and regenerate to fill this in.
date_of_birth
- Engine: MongoDB
- Type:
DateField - Column/Key:
date_of_birth - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
age_group
- Engine: MongoDB
- Type:
StringField - Column/Key:
age_group - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
category
- Engine: MongoDB
- Type:
StringField - Column/Key:
category - nullable
Grouping of age groups / genders for prizes
- Engine: MongoDB
- Type:
StringField - Column/Key:
email - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
team_category
- Engine: MongoDB
- Type:
StringField - Column/Key:
team_category - nullable
Alternate category for team scores only
team_id
- Engine: MongoDB
- Type:
StringField - Column/Key:
team_id - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
team
- Engine: MongoDB
- Type:
AffiliationField - Column/Key:
team - nullable; default =
{}
No help text yet — add a help_text on the model field and regenerate to fill this in.
flag_url
- Engine: MongoDB
- Type:
StringField - Column/Key:
flag_url - nullable
Calculated on saving
flag_colour
- Engine: MongoDB
- Type:
StringField - Column/Key:
flag_colour - nullable
Calculated on saving
team_name
- Engine: MongoDB
- Type:
StringField - Column/Key:
team_name - nullable
Calculated on saving
team_name_local
- Engine: MongoDB
- Type:
StringField - Column/Key:
team_name_local - nullable
Team name in local language
team2_code
- Engine: MongoDB
- Type:
StringField - Column/Key:
team2_code - nullable
Secondary team's code
non_scorer
- Engine: MongoDB
- Type:
BooleanField - Column/Key:
non_scorer - nullable; default =
False
Eliminate from team scores and rankings?
yellow_card
- Engine: MongoDB
- Type:
BooleanField - Column/Key:
yellow_card - nullable; default =
False
Has the athlete been awarded a yellow card?
yellow_card_note
- Engine: MongoDB
- Type:
StringField - Column/Key:
yellow_card_note - nullable
Rule number under which yellow card was awarded
ot_athlete_id
- Engine: MongoDB
- Type:
DBReferenceField - Column/Key:
ot_athlete_id - nullable
Opentrack ID of athlete
tp_athlete_id
- Engine: MongoDB
- Type:
StringField - Column/Key:
tp_athlete_id - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
competition
- Engine: MongoDB
- Type:
ReferenceField→ <class 'project.reference.mongo.competition.Competition'> - Column/Key:
competition
No help text yet — add a help_text on the model field and regenerate to fill this in.
events_entered
- Engine: MongoDB
- Type:
EmbeddedDocumentListField - Column/Key:
events_entered - nullable; default =
[]
No help text yet — add a help_text on the model field and regenerate to fill this in.
numbered
- Engine: MongoDB
- Type:
BooleanField - Column/Key:
numbered - nullable; default =
False
Has a number been allocated yet?
sort_event_code
- Engine: MongoDB
- Type:
StringField - Column/Key:
sort_event_code - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
sort_bib
- Engine: MongoDB
- Type:
StringField - Column/Key:
sort_bib - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
sort_age_group
- Engine: MongoDB
- Type:
StringField - Column/Key:
sort_age_group - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
checked_in
- Engine: MongoDB
- Type:
BooleanField - Column/Key:
checked_in - nullable; default =
False
No help text yet — add a help_text on the model field and regenerate to fill this in.
nationality
- Engine: MongoDB
- Type:
StringField - Column/Key:
nationality - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
residence
- Engine: MongoDB
- Type:
StringField - Column/Key:
residence - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
notable_performances
- Engine: MongoDB
- Type:
ListField - Column/Key:
notable_performances - nullable; default =
[]
What have they done lately?
comparison_grade
- Engine: MongoDB
- Type:
FloatField - Column/Key:
comparison_grade - nullable
Constant age-grade for rankings
entry_id
- Engine: MongoDB
- Type:
IntField - Column/Key:
entry_id - nullable
ID for a paid entry in the entries table, which produce this. Blank for entries from other sources
region_of_birth
- Engine: MongoDB
- Type:
StringField - Column/Key:
region_of_birth - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
region_of_residence
- Engine: MongoDB
- Type:
StringField - Column/Key:
region_of_residence - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
department1
- Engine: MongoDB
- Type:
StringField - Column/Key:
department1 - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
department2
- Engine: MongoDB
- Type:
StringField - Column/Key:
department2 - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
coach_text
- Engine: MongoDB
- Type:
StringField - Column/Key:
coach_text - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
medical_exam_date
- Engine: MongoDB
- Type:
DateField - Column/Key:
medical_exam_date - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
medical_exam_expiry_date
- Engine: MongoDB
- Type:
DateField - Column/Key:
medical_exam_expiry_date - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
is_team_entry
- Engine: MongoDB
- Type:
BooleanField - Column/Key:
is_team_entry - nullable; default =
False
Entered through team entry system
exclude_from_events
- Engine: MongoDB
- Type:
BooleanField - Column/Key:
exclude_from_events - nullable; default =
False
Exclude them from being in the start list / results for various reasons e.g. not having up-to-date medical exam
ipc_classification_track
- Engine: MongoDB
- Type:
StringField - Column/Key:
ipc_classification_track - nullable; choices: : --------; T11: T11 - Vision impairment; T12: T12 - Vision impairment; T13: T13 - Vision impairment; T20: T20 - Intellectual impairment; T32: T32 - Co-ordination impairments (hypertonia, ataxia and athetosis); T33: T33 - Co-ordination impairments (hypertonia, ataxia and athetosis); T34: T34 - Co-ordination impairments (hypertonia, ataxia and athetosis); T35: T35 - Co-ordination impairments (hypertonia, ataxia and athetosis); T36: T36 - Co-ordination impairments (hypertonia, ataxia and athetosis); T37: T37 - Co-ordination impairments (hypertonia, ataxia and athetosis); T38: T38 - Co-ordination impairments (hypertonia, ataxia and athetosis); T40: T40 - Short stature; T41: T41 - Short stature; T42: T42 - Lower limb competing without prosthesis affected by limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; T43: T43 - Lower limb competing without prosthesis affected by limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; T44: T44 - Lower limb competing without prosthesis affected by limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; T45: T45 - Upper limb/s affected by limb deficiency, impaired muscle power or impaired passive range of movement; T46: T46 - Upper limb/s affected by limb deficiency, impaired muscle power or impaired passive range of movement; T47: T47 - Upper limb/s affected by limb deficiency, impaired muscle power or impaired passive range of movement; T51: T51 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; T52: T52 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; T53: T53 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; T54: T54 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; T61: T61 - Lower limb/s competing with prosthesis affected by limb deficiency and leg length difference; T62: T62 - Lower limb/s competing with prosthesis affected by limb deficiency and leg length difference; T63: T63 - Lower limb/s competing with prosthesis affected by limb deficiency and leg length difference; T64: T64 - Lower limb/s competing with prosthesis affected by limb deficiency and leg length difference; T71: T71 - athletes with severe co-ordination impairment (hypertonia, ataxia, athetosis); T72: T72 - athletes with severe co-ordination impairment (hypertonia, ataxia, athetosis)
International Paralympic Committee classification code for Para Athletes
ipc_classification_field
- Engine: MongoDB
- Type:
StringField - Column/Key:
ipc_classification_field - nullable; choices: : --------; F11: F11 - Vision impairment; F12: F12 - Vision impairment; F13: F13 - Vision impairment; F20: F20 - Intellectual impairment; F31: F31 - Co-ordination impairments (hypertonia, ataxia and athetosis); F32: F32 - Co-ordination impairments (hypertonia, ataxia and athetosis); F33: F33 - Co-ordination impairments (hypertonia, ataxia and athetosis); F34: F34 - Co-ordination impairments (hypertonia, ataxia and athetosis); F35: F35 - Co-ordination impairments (hypertonia, ataxia and athetosis); F36: F36 - Co-ordination impairments (hypertonia, ataxia and athetosis); F37: F37 - Co-ordination impairments (hypertonia, ataxia and athetosis); F38: F38 - Co-ordination impairments (hypertonia, ataxia and athetosis); F40: F40 - Short stature; F41: F41 - Short stature; F42: F42 - Lower limb competing without prosthesis affected by limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F43: F43 - Lower limb competing without prosthesis affected by limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F44: F44 - Lower limb competing without prosthesis affected by limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F45: F45 - Upper limb/s affected by limb deficiency, impaired muscle power or impaired passive range of movement; F46: F46 - Upper limb/s affected by limb deficiency, impaired muscle power or impaired passive range of movement; F51: F51 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F52: F52 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F53: F53 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F54: F54 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F55: F55 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F56: F56 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F57: F57 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F61: F61 - Lower limb/s competing with prosthesis affected by limb deficiency and leg length difference; F62: F62 - Lower limb/s competing with prosthesis affected by limb deficiency and leg length difference; F63: F63 - Lower limb/s competing with prosthesis affected by limb deficiency and leg length difference; F64: F64 - Lower limb/s competing with prosthesis affected by limb deficiency and leg length difference
International Paralympic Committee classification code for Para Athletes
id
- Engine: MongoDB
- Type:
ObjectIdField - Column/Key:
_id - primary key; nullable
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 MongoDB.