Role
- Engine: SQL (Django model / relational table)
- App: reference
- Table/Collection:
reference_role - Verbose name: role
Role played by person in organisation - coach, secretary, race director, official etc
| Field | Type | Column/Key | Null/Default | PK | Choices | Notes |
|---|---|---|---|---|---|---|
| id | AutoField | id | — | PK | — | — |
| created | DateTimeField | created | null | — | — | |
| last_edit_time | DateTimeField | last_edit_time | null | — | — | |
| last_edit_by | CharField | last_edit_by | null | — | — | |
| person | ForeignKey → Person (FK) | person_id | — | — | — | |
| organisation | ForeignKey → Organisation (FK) | organisation_id | — | — | Affiliated governing body/ club/ federation | |
| role_type | CharField | role_type | — | MEMBER: Member; REGISTERED: Registered; APPEARS_ON: Appears On; COACH: Coach; TO: Technical Official; EMAIL_RECIPIENT: Email recipient; ADMIN: Admin; MONEY: Treasurer; DIRECTOR: Director; OFFICIAL: Official; RECORDER: Recorder; OPERATOR: Operator; TEAM_MANAGER: Team Manager; TEAM_APPROVER: Team Approver; CHECKIN_APPROVER: Checkin Approver | — | |
| role_status | CharField | role_status | dflt=OK | OK: OK; AWAITING: AWAITING; EXPIRED: EXPIRED | — | |
| payment_status | CharField | payment_status | dflt=UNPAID | PAID: paid; UNPAID: unpaid; INVOICED: invoiced | — | |
| payment | ForeignKey → Payment (FK) | payment_id | null | — | — | |
| identifier | CharField | identifier | — | — | e.g. coach ID within this organisation | |
| bib | CharField | bib | — | — | Bib to be used for current season | |
| date_from | DateField | date_from | null | — | Date they commence the role | |
| date_to | DateField | date_to | null | — | Date they moved on or expired | |
| eql | IntegerField | eql | null | — | European Qualification Level | |
| ordering | IntegerField | ordering | null | — | Use for display order and/or finding key person in a role | |
| role_name | IntegerField | role_name | null/dflt=1 | — | The 'job title', committee role or whatever | |
| notes | CharField | notes | — | — | Used by organisation for any further notes needed | |
| section | CharField | section | — | — | House, College or Department within club. Optional | |
| data | CharField | data | — | — | EA api json response text | |
| is_renewing | BooleanField | is_renewing | dflt=False | — | Indicates intent to renew at end of current period; cleared … | |
| renewal_fee | DecimalField | renewal_fee | null/dflt=0.00 | — | How much to pay to renew this role? | |
| superceded | BooleanField | superceded | dflt=False | — | Later role exists, this is history | |
| renewal_date | DateField | renewal_date | null | — | Date when renewed | |
| renewal_invoice | CharField | renewal_invoice | null | — | Date and time of the invoice when requested | |
| renewal_notes | CharField | renewal_notes | — | — | Details about renewal progress, lost payments etc | |
| membership_category | ForeignKey → MembershipCategory (FK) | membership_category_id | null | — | For use when a club has multiple membership categories |
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.
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.
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.
organisation
- Engine: SQL
- Type:
ForeignKey→ Organisation (FK) - Column/Key:
organisation_id
Affiliated governing body/ club/ federation
role_type
- Engine: SQL
- Type:
CharField - Column/Key:
role_type - choices: MEMBER: Member; REGISTERED: Registered; APPEARS_ON: Appears On; COACH: Coach; TO: Technical Official; EMAIL_RECIPIENT: Email recipient; ADMIN: Admin; MONEY: Treasurer; 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.
role_status
- Engine: SQL
- Type:
CharField - Column/Key:
role_status - default =
OK; choices: OK: OK; AWAITING: AWAITING; EXPIRED: EXPIRED
No help text yet — add a help_text on the model field and regenerate to fill this in.
payment_status
- Engine: SQL
- Type:
CharField - Column/Key:
payment_status - default =
UNPAID; choices: PAID: paid; UNPAID: unpaid; INVOICED: invoiced
No help text yet — add a help_text on the model field and regenerate to fill this in.
payment
- Engine: SQL
- Type:
ForeignKey→ Payment (FK) - Column/Key:
payment_id - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
identifier
- Engine: SQL
- Type:
CharField - Column/Key:
identifier
e.g. coach ID within this organisation
bib
- Engine: SQL
- Type:
CharField - Column/Key:
bib
Bib to be used for current season
date_from
- Engine: SQL
- Type:
DateField - Column/Key:
date_from - nullable
Date they commence the role
date_to
- Engine: SQL
- Type:
DateField - Column/Key:
date_to - nullable
Date they moved on or expired
eql
- Engine: SQL
- Type:
IntegerField - Column/Key:
eql - nullable
European Qualification Level
ordering
- Engine: SQL
- Type:
IntegerField - Column/Key:
ordering - nullable
Use for display order and/or finding key person in a role
role_name
- Engine: SQL
- Type:
IntegerField - Column/Key:
role_name - nullable; default =
1
The 'job title', committee role or whatever
notes
- Engine: SQL
- Type:
CharField - Column/Key:
notes
Used by organisation for any further notes needed
section
- Engine: SQL
- Type:
CharField - Column/Key:
section
House, College or Department within club. Optional
data
- Engine: SQL
- Type:
CharField - Column/Key:
data
EA api json response text
is_renewing
- Engine: SQL
- Type:
BooleanField - Column/Key:
is_renewing - default =
False
Indicates intent to renew at end of current period; cleared on actual renewal
renewal_fee
- Engine: SQL
- Type:
DecimalField - Column/Key:
renewal_fee - nullable; default =
0.00
How much to pay to renew this role?
superceded
- Engine: SQL
- Type:
BooleanField - Column/Key:
superceded - default =
False
Later role exists, this is history
renewal_date
- Engine: SQL
- Type:
DateField - Column/Key:
renewal_date - nullable
Date when renewed
renewal_invoice
- Engine: SQL
- Type:
CharField - Column/Key:
renewal_invoice - nullable
Date and time of the invoice when requested
renewal_notes
- Engine: SQL
- Type:
CharField - Column/Key:
renewal_notes
Details about renewal progress, lost payments etc
membership_category
- Engine: SQL
- Type:
ForeignKey→ MembershipCategory (FK) - Column/Key:
membership_category_id - nullable
For use when a club has multiple membership categories
Generated by docs_models management command for SQL.