Unit
- Engine: SQL (Django model / relational table)
- App: reference
- Table/Collection:
reference_unit - Verbose name: unit
This will be autogenerated my Mongo units on saving, to allow timetable queries Most fields are a copy of the Mongo unit value. This should be 100% cached and ONLY created or destroyed by the mongo Unit.save/delete. Having difficulty due to utf8mb4 -needs a --fake
| Field | Type | Column/Key | Null/Default | PK | Choices | Notes |
|---|---|---|---|---|---|---|
| id | AutoField | id | — | PK | — | — |
| competition | ForeignKey → Competition (FK) | competition_id | null | — | — | |
| event | ForeignKey → EventSpec (FK) | event_id | — | — | — | |
| event_code | CharField | event_code | — | — | — | |
| event_name | CharField | event_name | — | — | — | |
| round | IntegerField | round | dflt=1 | — | — | |
| round_name | CharField | round_name | — | — | — | |
| heat | IntegerField | heat | dflt=1 | — | — | |
| heat_name | CharField | heat_name | — | — | — | |
| mongo_unit_id | CharField | mongo_unit_id | — | — | — | |
| mongo_event_id | CharField | mongo_event_id | null | — | — | |
| day | IntegerField | day | dflt=1 | — | — | |
| scheduled_start_time | CharField | scheduled_start_time | — | — | — | |
| status | CharField | status | dflt=none | — | — | |
| results_status | CharField | results_status | dflt=unscheduled | — | — | |
| participant_count | IntegerField | participant_count | — | — | How many in start list or results? |
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.
competition
- Engine: SQL
- Type:
ForeignKey→ Competition (FK) - Column/Key:
competition_id - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
event
- Engine: SQL
- Type:
ForeignKey→ EventSpec (FK) - Column/Key:
event_id
No help text yet — add a help_text on the model field and regenerate to fill this in.
event_code
- Engine: SQL
- Type:
CharField - Column/Key:
event_code
No help text yet — add a help_text on the model field and regenerate to fill this in.
event_name
- Engine: SQL
- Type:
CharField - Column/Key:
event_name
No help text yet — add a help_text on the model field and regenerate to fill this in.
round
- Engine: SQL
- Type:
IntegerField - Column/Key:
round - default =
1
No help text yet — add a help_text on the model field and regenerate to fill this in.
round_name
- Engine: SQL
- Type:
CharField - Column/Key:
round_name
No help text yet — add a help_text on the model field and regenerate to fill this in.
heat
- Engine: SQL
- Type:
IntegerField - Column/Key:
heat - default =
1
No help text yet — add a help_text on the model field and regenerate to fill this in.
heat_name
- Engine: SQL
- Type:
CharField - Column/Key:
heat_name
No help text yet — add a help_text on the model field and regenerate to fill this in.
mongo_unit_id
- Engine: SQL
- Type:
CharField - Column/Key:
mongo_unit_id
No help text yet — add a help_text on the model field and regenerate to fill this in.
mongo_event_id
- Engine: SQL
- Type:
CharField - Column/Key:
mongo_event_id - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
day
- Engine: SQL
- Type:
IntegerField - Column/Key:
day - default =
1
No help text yet — add a help_text on the model field and regenerate to fill this in.
scheduled_start_time
- Engine: SQL
- Type:
CharField - Column/Key:
scheduled_start_time
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 =
none
No help text yet — add a help_text on the model field and regenerate to fill this in.
results_status
- Engine: SQL
- Type:
CharField - Column/Key:
results_status - default =
unscheduled
No help text yet — add a help_text on the model field and regenerate to fill this in.
participant_count
- Engine: SQL
- Type:
IntegerField - Column/Key:
participant_count
How many in start list or results?
Generated by docs_models management command for SQL.