LicenseOption
- Engine: SQL (Django model / relational table)
- App: reference
- Table/Collection:
reference_licenseoption - Verbose name: license option
LicenseOption(id, created, last_edit_time, last_edit_by, is_dirty, federation, kind, name, price, notes, valid_from, valid_until, price_from, price_to, age_in_year)
| 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 | — | — | |
| is_dirty | BooleanField | is_dirty | dflt=True | — | — | |
| federation | ForeignKey → Federation (FK) | federation_id | — | — | — | |
| kind | CharField | kind | dflt=SEASON | ONE_TIME: One-time; SEASON: Season | — | |
| name | CharField | name | — | — | — | |
| price | DecimalField | price | dflt=0.00 | — | Price for this license option | |
| notes | CharField | notes | — | — | — | |
| valid_from | DateField | valid_from | null | — | — | |
| valid_until | DateField | valid_until | null | — | — | |
| price_from | DecimalField | price_from | dflt=0.00 | — | Minimum event price at which this becomes an option | |
| price_to | DecimalField | price_to | dflt=0.00 | — | Maximum event price at which this becomes an option | |
| age_in_year | IntegerField | age_in_year | dflt=0 | — | Minimum age in licence year for this option to apply |
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.
is_dirty
- Engine: SQL
- Type:
BooleanField - Column/Key:
is_dirty - default =
True
No help text yet — add a help_text on the model field and regenerate to fill this in.
federation
- Engine: SQL
- Type:
ForeignKey→ Federation (FK) - Column/Key:
federation_id
No help text yet — add a help_text on the model field and regenerate to fill this in.
kind
- Engine: SQL
- Type:
CharField - Column/Key:
kind - default =
SEASON; choices: ONE_TIME: One-time; SEASON: Season
No help text yet — add a help_text on the model field and regenerate to fill this in.
name
- Engine: SQL
- Type:
CharField - Column/Key:
name
No help text yet — add a help_text on the model field and regenerate to fill this in.
price
- Engine: SQL
- Type:
DecimalField - Column/Key:
price - default =
0.00
Price for this license option
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.
valid_from
- Engine: SQL
- Type:
DateField - Column/Key:
valid_from - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
valid_until
- Engine: SQL
- Type:
DateField - Column/Key:
valid_until - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
price_from
- Engine: SQL
- Type:
DecimalField - Column/Key:
price_from - default =
0.00
Minimum event price at which this becomes an option
price_to
- Engine: SQL
- Type:
DecimalField - Column/Key:
price_to - default =
0.00
Maximum event price at which this becomes an option
age_in_year
- Engine: SQL
- Type:
IntegerField - Column/Key:
age_in_year - default =
0
Minimum age in licence year for this option to apply
Generated by docs_models management command for SQL.