MembershipCategory
- Engine: SQL (Django model / relational table)
- App: reference
- Table/Collection:
reference_membershipcategory - Verbose name: membership category
MembershipCategory(id, created, last_edit_time, last_edit_by, is_dirty, organisation, code, description, fee, renew_fee_modifier, duration, national_reg, nc, free)
| 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 | — | — | |
| organisation | ForeignKey → Organisation (FK) | organisation_id | — | — | — | |
| code | CharField | code | — | — | Code for category | |
| description | CharField | description | — | — | Description for category | |
| fee | DecimalField | fee | dflt=0.00 | — | Fee for this category | |
| renew_fee_modifier | DecimalField | renew_fee_modifier | dflt=0.00 | — | Renewal fee modifier for this category e.g. -5.00 or +5.00 | |
| duration | IntegerField | duration | null/dflt=12 | — | How many months is it for? | |
| national_reg | BooleanField | national_reg | — | — | Does the fee cover national registration? | |
| nc | BooleanField | nc | — | — | Non-competing member? | |
| free | BooleanField | free | — | — | Provided free, including national registration? |
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.
organisation
- Engine: SQL
- Type:
ForeignKey→ Organisation (FK) - Column/Key:
organisation_id
No help text yet — add a help_text on the model field and regenerate to fill this in.
code
- Engine: SQL
- Type:
CharField - Column/Key:
code
Code for category
description
- Engine: SQL
- Type:
CharField - Column/Key:
description
Description for category
fee
- Engine: SQL
- Type:
DecimalField - Column/Key:
fee - default =
0.00
Fee for this category
renew_fee_modifier
- Engine: SQL
- Type:
DecimalField - Column/Key:
renew_fee_modifier - default =
0.00
Renewal fee modifier for this category e.g. -5.00 or +5.00
duration
- Engine: SQL
- Type:
IntegerField - Column/Key:
duration - nullable; default =
12
How many months is it for?
national_reg
- Engine: SQL
- Type:
BooleanField - Column/Key:
national_reg
Does the fee cover national registration?
nc
- Engine: SQL
- Type:
BooleanField - Column/Key:
nc
Non-competing member?
free
- Engine: SQL
- Type:
BooleanField - Column/Key:
free
Provided free, including national registration?
Generated by docs_models management command for SQL.