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 | |
manager_co_person_id | integer, foreign key | CO Person ID of Manager | cm_co_people:id | Added in Registry v4.1.0 |
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 |
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 | |
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 |