ScoringTable
- Engine: MongoDB (mongoengine document)
- App: reference
- Table/Collection:
scoring_table - Verbose name: ScoringTable
Define how to work out scores for a specific event, usually running EventSpecs have a get_scores() method which will look for one of these.
| Field | Type | Column/Key | Null/Default | PK | Choices | Notes |
|---|---|---|---|---|---|---|
| _about | EmbeddedDocumentField → embedded <class 'docengine.mongoutils.models.WhoWhenInfo'> | _about | null | — | — | |
| last_calculated | DateTimeField | last_calculated | null | — | — | |
| competition | ReferenceField → <class 'project.reference.mongo.competition.Competition'> | competition | — | — | — | |
| event | ReferenceField → <class 'project.reference.mongo.eventspec.EventSpec'> | event | null | — | — | |
| order | IntField | order | null | — | — | |
| name | StringField | name | dflt=Race scores | — | — | |
| slug | StringField | slug | null | — | — | |
| subtitle | StringField | subtitle | null | — | — | |
| method | StringField | method | null/dflt=POSITION | POSITION: Sum of filtered race positions; ABSOLUTE: Sum of absolute race positions; TOTAL_TIME: Sum of times; TOTAL_ATHLON: Combined Events Total Team Score; AVERAGE_ATHLON: Combined Events Average Team Score; TOTAL_PERF: Total distance or performance (for fixed-time races); AVERAGE_PERF: Average distance or performance (for fixed-time races); MULTISTAGE: Multi-stage sum of times; AGE_GRADE: Sum of age grades; NONE: No team scores, filtered listing only | — | |
| applies_to | StringField | applies_to | null/dflt=PRIMARY | PRIMARY: Primary team; SECONDARY: Secondary team | — | |
| num_teams | StringField | num_teams | null/dflt=1 | 1: One team per club; 2: A and B teams only; N: Any number of teams | — | |
| scorers | IntField | scorers | null/dflt=6 | — | Max No. of finishers of a team which are eligible to score | |
| women_per_team | IntField | women_per_team | null/dflt=0 | — | Exactly this many women score, or at least this many, depend… | |
| allows_non_scorers | BooleanField | allows_non_scorers | null/dflt=False | — | Include non-scorers when calculating places? | |
| filter_categories | ListField | filter_categories | null/dflt=[] | — | comma-separated list of categories (like age groups: `U45, U… | |
| filter_teams | ListField | filter_teams | null/dflt=[] | — | comma-separated list of team codes | |
| filter_gender | StringField | filter_gender | null/dflt=X | X: Mixed, exact number of women; M: Men only; F: Women only; Z: Mixed, minimum number of women | "Exact": precisely the women per team specified, the other s… | |
| incomplete_allowed | BooleanField | incomplete_allowed | null/dflt=False | — | — | |
| displacement | BooleanField | displacement | null/dflt=False | — | 5th and 6th scorers bump up scores of their rival teams, in … | |
| special_rules | StringField | special_rules | null | : ------; MOB: Mob Match, all runners in smallest team count; MOB-EXCLUDE-1: Mob Match, last runner in smallest team excluded; MOB-EXCLUDE-2: Mob Match, last 2 runners in smallest team excluded; MOB-DOUBLE-FIRST8: First 8 score double (Oxford/Cambridge lower teams match) | — | |
| team_scores | EmbeddedDocumentListField | team_scores | null/dflt=[] | — | — | |
| finishers | EmbeddedDocumentListField | finishers | null/dflt=[] | — | — | |
| penalty | IntField | penalty | null/dflt=0 | — | — | |
| bibs | ListField | bibs | null/dflt=[] | — | — | |
| filter_penalty_score_to_category | BooleanField | filter_penalty_score_to_category | null/dflt=False | — | Filters the penalty score to the categories specified in 'fi… | |
| 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.WhoWhenInfo'> - Column/Key:
_about - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
last_calculated
- Engine: MongoDB
- Type:
DateTimeField - Column/Key:
last_calculated - 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.
event
- Engine: MongoDB
- Type:
ReferenceField→ <class 'project.reference.mongo.eventspec.EventSpec'> - Column/Key:
event - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
order
- Engine: MongoDB
- Type:
IntField - Column/Key:
order - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
name
- Engine: MongoDB
- Type:
StringField - Column/Key:
name - default =
Race scores
No help text yet — add a help_text on the model field and regenerate to fill this in.
slug
- Engine: MongoDB
- Type:
StringField - Column/Key:
slug - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
subtitle
- Engine: MongoDB
- Type:
StringField - Column/Key:
subtitle - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
method
- Engine: MongoDB
- Type:
StringField - Column/Key:
method - nullable; default =
POSITION; choices: POSITION: Sum of filtered race positions; ABSOLUTE: Sum of absolute race positions; TOTAL_TIME: Sum of times; TOTAL_ATHLON: Combined Events Total Team Score; AVERAGE_ATHLON: Combined Events Average Team Score; TOTAL_PERF: Total distance or performance (for fixed-time races); AVERAGE_PERF: Average distance or performance (for fixed-time races); MULTISTAGE: Multi-stage sum of times; AGE_GRADE: Sum of age grades; NONE: No team scores, filtered listing only
No help text yet — add a help_text on the model field and regenerate to fill this in.
applies_to
- Engine: MongoDB
- Type:
StringField - Column/Key:
applies_to - nullable; default =
PRIMARY; choices: PRIMARY: Primary team; SECONDARY: Secondary team
No help text yet — add a help_text on the model field and regenerate to fill this in.
num_teams
- Engine: MongoDB
- Type:
StringField - Column/Key:
num_teams - nullable; default =
1; choices: 1: One team per club; 2: A and B teams only; N: Any number of teams
No help text yet — add a help_text on the model field and regenerate to fill this in.
scorers
- Engine: MongoDB
- Type:
IntField - Column/Key:
scorers - nullable; default =
6
Max No. of finishers of a team which are eligible to score
women_per_team
- Engine: MongoDB
- Type:
IntField - Column/Key:
women_per_team - nullable; default =
0
Exactly this many women score, or at least this many, depending on the gender option
allows_non_scorers
- Engine: MongoDB
- Type:
BooleanField - Column/Key:
allows_non_scorers - nullable; default =
False
Include non-scorers when calculating places?
filter_categories
- Engine: MongoDB
- Type:
ListField - Column/Key:
filter_categories - nullable; default =
[]
comma-separated list of categories (like age groups: U45, U50, ...)
filter_teams
- Engine: MongoDB
- Type:
ListField - Column/Key:
filter_teams - nullable; default =
[]
comma-separated list of team codes
filter_gender
- Engine: MongoDB
- Type:
StringField - Column/Key:
filter_gender - nullable; default =
X; choices: X: Mixed, exact number of women; M: Men only; F: Women only; Z: Mixed, minimum number of women
"Exact": precisely the women per team specified, the other scorers must be men. "Minimum": at least that many women, the other scorers are the fastest of either gender
incomplete_allowed
- Engine: MongoDB
- Type:
BooleanField - Column/Key:
incomplete_allowed - nullable; default =
False
No help text yet — add a help_text on the model field and regenerate to fill this in.
displacement
- Engine: MongoDB
- Type:
BooleanField - Column/Key:
displacement - nullable; default =
False
5th and 6th scorers bump up scores of their rival teams, in a 4-to-score race; as do runners from incomplete teams. Guests do not displace.
special_rules
- Engine: MongoDB
- Type:
StringField - Column/Key:
special_rules - nullable; choices: : ------; MOB: Mob Match, all runners in smallest team count; MOB-EXCLUDE-1: Mob Match, last runner in smallest team excluded; MOB-EXCLUDE-2: Mob Match, last 2 runners in smallest team excluded; MOB-DOUBLE-FIRST8: First 8 score double (Oxford/Cambridge lower teams match)
No help text yet — add a help_text on the model field and regenerate to fill this in.
team_scores
- Engine: MongoDB
- Type:
EmbeddedDocumentListField - Column/Key:
team_scores - nullable; default =
[]
No help text yet — add a help_text on the model field and regenerate to fill this in.
finishers
- Engine: MongoDB
- Type:
EmbeddedDocumentListField - Column/Key:
finishers - nullable; default =
[]
No help text yet — add a help_text on the model field and regenerate to fill this in.
penalty
- Engine: MongoDB
- Type:
IntField - Column/Key:
penalty - nullable; default =
0
No help text yet — add a help_text on the model field and regenerate to fill this in.
bibs
- Engine: MongoDB
- Type:
ListField - Column/Key:
bibs - nullable; default =
[]
No help text yet — add a help_text on the model field and regenerate to fill this in.
filter_penalty_score_to_category
- Engine: MongoDB
- Type:
BooleanField - Column/Key:
filter_penalty_score_to_category - nullable; default =
False
Filters the penalty score to the categories specified in 'filter category' box
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.