Child pages
  • cm_identifiers
Skip to end of metadata
Go to start of metadata

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

  • true: This identifier can be used to login to Registry
  • false: This identifier cannot be used to login to Registry
Only applies to identifiers attached to Org Identities.

status

varchar(2)

Identifier's status

  • A: Active
  • S: Suspended

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 co_person_idorg_identity_id, co_group_id, or co_department_id may be specified

org_identity_id

integer, foreign key

Org Identity Record ID

cm_org_identities:id

Only one of co_person_idorg_identity_id, co_group_id, or co_department_id may be specified

co_department_idinteger, foreign keyCO Department Record IDcm_co_departments:idOnly one of co_person_idorg_identity_id, co_group_id, or co_department_id may be specified. Added in Registry v3.1.0.
co_group_idinteger, foreign keyCO Group Record IDcm_co_groups:idOnly one of co_person_idorg_identity_id, co_group_id, or co_department_id may be specified. Added in Registry v3.3.0.
source_identifier_idinteger, foreign keyIf Pipelines are in use, the Identifier ID for the Org Identity Identifier that created this record.cm_identifiers:idAdded in Registry v2.0.0.
co_provisioning_target_idinteger, foreign keyCO Provisioning Target IDcm_co_provisioning_targets:id

ie: The Provisioning Target that assigned (and is responsible for managing) this Identifier.

Added in Registry v3.1.0.

  • No labels