Table | telephone_numbers |
|---|---|
Description | Telephone Numbers for an Entity |
Column | Format | Description | Definition | Required | Comments |
|---|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement |  | |
| person_id | integer, foreign key | Person ID | people:id | Exactly one entity foreign key is required | |
| person_role_id | integer, foreign key | Person Role ID | person_roles:id | Exactly one entity foreign key is required | |
| external_identity_id | integer, foreign key | External Identity ID | external_identities:id | Exactly one entity foreign key is required | |
| external_identity_role_id | integer, foreign key | External Identity Role ID | external_identity_roles:id | Exactly one entity foreign key is required | |
| country_code | varchar(3) | Telephone Country Code | ITU E.164 | Governed by co_settings | |
| area_code | varchar(8) | Telephone Area (National Destination) Code | ITU E.164 | Governed by co_settings | |
| number | varchar(64) | Telephone Subscriber Number | ITU E.164 | Governed by co_settings | |
| extension | varchar(16) | Telephone Extension | Location specific | Governed by co_settings | |
description | varchar(128) | Description | |||
| type_id | integer, foreign key | Type of this Telephone Number | types:id | | |
| source_telephone_number_id | integer, foreign key | External Identity Telephone Number that was the source for this Telephone Number | telephone_numbers:id | ||
| frozen | boolean | Whether or not Pipeline processing will update this record |
|