Affiliation
- Engine: SQL (Django model / relational table)
- App: reference
- Table/Collection:
reference_affiliation - Verbose name: Affiliation
Affiliation(id, child, parent, date_from, date_to, identifier, category, notes, inherit)
| Field | Type | Column/Key | Null/Default | PK | Choices | Notes |
|---|---|---|---|---|---|---|
| id | AutoField | id | — | PK | — | — |
| child | ForeignKey → Organisation (FK) | child_id | — | — | — | |
| parent | ForeignKey → Organisation (FK) | parent_id | — | — | — | |
| date_from | DateField | date_from | null | — | — | |
| date_to | DateField | date_to | null | — | — | |
| identifier | CharField | identifier | — | — | ID within this league, federation etc | |
| category | CharField | category | — | — | e.g. if they have full or associate membership, or division | |
| notes | CharField | notes | — | — | — | |
| inherit | BooleanField | inherit | dflt=True | — | Should directors in the parent org have access to competitio… |
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.
child
- Engine: SQL
- Type:
ForeignKey→ Organisation (FK) - Column/Key:
child_id
No help text yet — add a help_text on the model field and regenerate to fill this in.
parent
- Engine: SQL
- Type:
ForeignKey→ Organisation (FK) - Column/Key:
parent_id
No help text yet — add a help_text on the model field and regenerate to fill this in.
date_from
- Engine: SQL
- Type:
DateField - Column/Key:
date_from - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
date_to
- Engine: SQL
- Type:
DateField - Column/Key:
date_to - 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
ID within this league, federation etc
category
- Engine: SQL
- Type:
CharField - Column/Key:
category
e.g. if they have full or associate membership, or division
notes
- Engine: SQL
- Type:
CharField - Column/Key:
notes
No help text yet — add a help_text on the model field and regenerate to fill this in.
inherit
- Engine: SQL
- Type:
BooleanField - Column/Key:
inherit - default =
True
Should directors in the parent org have access to competitions by child org?
Generated by docs_models management command for SQL.