Table | cm_telephone_numbers |
|---|---|
Description | Telephone Numbers |
Column | Format | Description | Definition | Comments |
|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement |
|
| country_code | varchar(3) | Telephone Country Code | ITU E.164 | |
| area_code | varchar(8) | Telephone Area (National Destination) Code | ITU E.164 | |
number | varchar(64) | Telephone Subscriber Number | ITU E.164 |
|
| extension | varchar(16) | Telephone Extension | Location specific | |
| description | varchar(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 | 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, or co_department_id may be specified. Added in Registry v3.1.0. |
| source_telephone_number_id | integer, foreign key | If Pipelines are in use, the Telephone Number ID for the Org Identity Telephone Number that created this record. | cm_telephone_numbers:id | Added in Registry v2.0.0. |