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 v1.1.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 |