HistoricalRole
- Engine: SQL (Django model / relational table)
- App: reference
- Table/Collection:
reference_historicalrole - Verbose name: historical role
HistoricalRole(id, created, last_edit_time, last_edit_by, role_type, role_status, payment_status, identifier, bib, date_from, date_to, eql, ordering, role_name, notes, section, data, is_renewing, renewal_fee, superceded, renewal_date, renewal_invoice, renewal_notes, person, organisation, payment, membership_category, history_id, history_date, history_change_reason, history_type, history_user)
| Field | Type | Column/Key | Null/Default | PK | Choices | Notes |
|---|---|---|---|---|---|---|
| created | DateTimeField | created | null | — | — | |
| last_edit_time | DateTimeField | last_edit_time | null | — | — | |
| last_edit_by | CharField | last_edit_by | null | — | — | |
| 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 | — | |
| 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 | |
| person | ForeignKey → Person (FK) | person_id | null | — | — | |
| organisation | ForeignKey → Organisation (FK) | organisation_id | null | — | Affiliated governing body/ club/ federation | |
| payment | ForeignKey → Payment (FK) | payment_id | null | — | — | |
| membership_category | ForeignKey → MembershipCategory (FK) | membership_category_id | null | — | For use when a club has multiple membership categories | |
| history_id | AutoField | history_id | — | PK | — | — |
| history_date | DateTimeField | history_date | — | — | — | |
| history_change_reason | CharField | history_change_reason | null | — | — | |
| history_type | CharField | history_type | — | +: Created; ~: Changed; -: Deleted | — | |
| history_user | ForeignKey → User (FK) | history_user_id | null | — | — |
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.
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.
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.
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
person
- Engine: SQL
- Type:
ForeignKey→ Person (FK) - Column/Key:
person_id - nullable
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 - nullable
Affiliated governing body/ club/ federation
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.
membership_category
- Engine: SQL
- Type:
ForeignKey→ MembershipCategory (FK) - Column/Key:
membership_category_id - nullable
For use when a club has multiple membership categories
history_id
- Engine: SQL
- Type:
AutoField - Column/Key:
history_id - primary key
No help text yet — add a help_text on the model field and regenerate to fill this in.
history_date
- Engine: SQL
- Type:
DateTimeField - Column/Key:
history_date
No help text yet — add a help_text on the model field and regenerate to fill this in.
history_change_reason
- Engine: SQL
- Type:
CharField - Column/Key:
history_change_reason - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
history_type
- Engine: SQL
- Type:
CharField - Column/Key:
history_type - choices: +: Created; ~: Changed; -: Deleted
No help text yet — add a help_text on the model field and regenerate to fill this in.
history_user
- Engine: SQL
- Type:
ForeignKey→ User (FK) - Column/Key:
history_user_id - 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 SQL.