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 |