Skip to content

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.