Table | cm_identifiers |
|---|---|
Description | Person identifiers |
Column | Format | Description | Definition | Comments |
|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement | |
identifier | varchar(256) | Identifier | As per type definition | |
type | varchar(32) | Type of identifier | Arbitrary values may be configured via cm_co_extended_types (for identifiers attached to COs, only) or default values available are
| mail is intended for CO generated mail aliases/addresses to be stored, regardless of whether or not they are in use. Email addresses intended to be reflected into directories or other downstream locations should be stored in the email_addresses table. |
login | boolean | Registry login flag |
| Only applies to identifiers attached to Org Identities. |
status | varchar(2) | Identifier's status |
| An identifier marked deleted is no longer considered in use by COmanage, but it cannot be reassigned. Prior to v2.0.0, the status D/Deleted was used instead of S/Suspended. |
co_person_id | integer, foreign key | CO Person Record ID | cm_co_people:id | Only one of |
org_identity_id | integer, foreign key | Org Identity Record ID | Only one of | |
| co_department_id | integer, foreign key | CO Department Record ID | cm_co_departments:id | Only one of co_person_id, org_identity_id, co_group_id, or co_department_id may be specified. Added in Registry v3.1.0. |
| co_group_id | integer, foreign key | CO Group Record ID | cm_co_groups:id | Only one of co_person_id, org_identity_id, co_group_id, or co_department_id may be specified. Added in Registry v3.3.0. |
| source_identifier_id | integer, foreign key | If Pipelines are in use, the Identifier ID for the Org Identity Identifier that created this record. | cm_identifiers:id | Added in Registry v2.0.0. |
| co_provisioning_target_id | integer, foreign key | CO Provisioning Target ID | cm_co_provisioning_targets:id | ie: The Provisioning Target that assigned (and is responsible for managing) this Identifier. Added in Registry v3.1.0. |