Official
- Engine: SQL (Django model / relational table)
- App: reference
- Table/Collection:
reference_official - Verbose name: official
Official(id, person, competition, role, team_code, title, is_active, events)
| Field | Type | Column/Key | Null/Default | PK | Choices | Notes |
|---|---|---|---|---|---|---|
| id | AutoField | id | — | PK | — | — |
| person | ForeignKey → Person (FK) | person_id | — | — | — | |
| competition | ForeignKey → Competition (FK) | competition_id | — | — | — | |
| role | CharField | role | dflt=OFFICIAL | DIRECTOR: Director; OFFICIAL: Official; RECORDER: Recorder; OPERATOR: Operator; TEAM_MANAGER: Team Manager; TEAM_APPROVER: Team Approver; CHECKIN_APPROVER: Checkin Approver | — | |
| team_code | CharField | team_code | — | — | Only relevant for Team Managers/Approvers | |
| title | CharField | title | — | — | — | |
| is_active | BooleanField | is_active | dflt=True | — | — | |
| events | JSONField | events | null | — | Event codes |
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.
person
- Engine: SQL
- Type:
ForeignKey→ Person (FK) - Column/Key:
person_id
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
No help text yet — add a help_text on the model field and regenerate to fill this in.
role
- Engine: SQL
- Type:
CharField - Column/Key:
role - default =
OFFICIAL; choices: DIRECTOR: Director; OFFICIAL: Official; RECORDER: Recorder; OPERATOR: Operator; TEAM_MANAGER: Team Manager; TEAM_APPROVER: Team Approver; CHECKIN_APPROVER: Checkin Approver
No help text yet — add a help_text on the model field and regenerate to fill this in.
team_code
- Engine: SQL
- Type:
CharField - Column/Key:
team_code
Only relevant for Team Managers/Approvers
title
- Engine: SQL
- Type:
CharField - Column/Key:
title
No help text yet — add a help_text on the model field and regenerate to fill this in.
is_active
- Engine: SQL
- Type:
BooleanField - Column/Key:
is_active - default =
True
No help text yet — add a help_text on the model field and regenerate to fill this in.
events
- Engine: SQL
- Type:
JSONField - Column/Key:
events - nullable
Event codes
Generated by docs_models management command for SQL.