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 | Extended Type |
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 |
| ordr | integer | Order/Rank/Priority of this Person Role | Added in Registry v3.2.0 | |
status | varchar(2) | Person's Role status within CO |
|
| source_org_identity_id | integer, foreign key | If Pipelines are in use, the Org Identity ID of record that created this Person Role | cm_org_identities:id |