Table

cm_telephone_numbers

Description

Telephone Numbers

Column

Format

Description

Definition

Comments

id

integer, primary key

Row identifier

autoincrement

 

country_codevarchar(3)Telephone Country CodeITU E.164 
area_codevarchar(8)Telephone Area (National Destination) CodeITU E.164  

number

varchar(64)

Telephone Subscriber Number

ITU E.164

 

extensionvarchar(16)Telephone ExtensionLocation specific 
descriptionvarchar(128)Description Added in Registry v3.1.0.

type

varchar(2)

Type of telephone

 

When attached to a CO Person Role, types may be configured on a per-CO basis. See Extending the Registry Data Model.

co_person_role_id

integer, foreign key

CO Person Role Record ID

cm_co_person_roles:id

Only one of co_person_idorg_identity_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, 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, or co_department_id may be specified. Added in Registry v3.1.0.
source_telephone_number_idinteger, foreign keyIf Pipelines are in use, the Telephone Number ID for the Org Identity Telephone Number that created this record.cm_telephone_numbers:idAdded in Registry v2.0.0.