Table | cm_council_delegates |
---|---|
Description | Per-person, per-cou council delegate status |
Column | Format | Description | Definition | Comments |
---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement |
|
co_person_id | integer, foreign key | CO Person Record ID | cm_co_people:id | Can only hold one seat per COU, to be checked in model |
cou_id | integer, foreign key | pointer to cou | cm_cous:id | |
active_from | datetime | Time at which invitation is valid |
|
|
active_to | datetime | Time at which invitation is no longer valid |
|
|
status | varchar(2) | Person's status within CO |
|
|
Table | cm_council_delegations |
---|---|
Description | COUS that have council delegates |
Column | Format | Description | Definition | Comments |
---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement |
|
cou_id | integer, foreign key | pointer to cou | cm_cous:id | unique |
count | integer | Number of delegates the COU is allowed to have |
| determined by a function |
Table | cm_council_delegate_change_logs |
---|---|
Description | Changes to council delegates |
Column | Format | Description | Definition | Comments |
---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement |
|
time | datetime | Time at which change was made |
|
|
changer | integer, foreign key | CO Person Record ID that made the change | cm_co_people:id |
|
ligo_council_delegate_id | integer, foreign key | Council Delegate record | as was written to the row in cm_co_ligo_council_delegates | |
co_person_id | integer, foreign key | CO Person Record ID | cm_co_people:id | as was written to the row in cm_co_ligo_council_delegates |
cou_id | integer, foreign key | pointer to cou | cm_cous:id | as was written to the row in cm_co_ligo_council_delegates |
active_from | datetime | Time at which invitation is valid |
| as was written to the row in cm_co_ligo_council_delegates |
active_to | datetime | Time at which invitation is no longer valid |
| as was written to the row in cm_co_ligo_council_delegates |
status | varchar(2) | Person's status within CO |
| as was written to the row in cm_council_delegates |