Table |
cm_co_person_roles |
|---|---|
Description |
Per-CO person roles |
Column |
Format |
Description |
Definition |
Comments |
|---|---|---|---|---|
id |
integer, primary key |
Row identifier |
autoincrement |
|
co_person_id |
integer, foreign key |
CO Person ID |
cm_co_people:id |
|
sponsor_co_person_id |
integer, foreign key |
CO Person ID of Sponsor for continued membership |
cm_co_people:id |
not necessarily the same as the enrollment sponsor in cm_co_petitions |
cou_id |
integer, foreign key |
COU ID |
cm_cous:id |
|
affiliation |
varchar(8) |
Broad affiliation to CO |
eduPerson person |
ennumerated in enum.php as: |
title |
varchar(128) |
Title at CO |
X.520 via RFC 4519 person |
|
o |
varchar(128) |
CO |
X.520 via RFC 4519 person |
|
ou |
varchar(128) |
Departmental affiliation at CO |
X.520 via RFC 4519 person |
|
valid_from |
datetime |
Person Role is valid member of CO from this time |
If null, valid any time through valid_through |
|
valid_through |
datetime |
Person Role is valid member of CO through (but not past) this time |
If null, valid any time from valid_from |
|
status |
varchar(2) |
Person's Role status within CO |
|
|