Phone Numbers
The phone_numbers table contains data about phone numbers in the organization attached to entities.
This table can be used to determine what phone numbers exist and which entities they are attached to, as well as metadata about the phone number such as when it was created.
Columns
| Column Name | Description | Type | Nullable |
|---|---|---|---|
| id | The numerical identifier of the object. | INT8 | No |
| number | The phone number in international format. | VARCHAR | No |
| ext | The phone number extension. | VARCHAR | Yes |
| number_type | The type of number. One of work or cell. |
VARCHAR | No |
| owner_id | The numerical identifier of the related entity for this phone number. Relates to the id column in the entities table. |
INT8 | No |
| owner_type | The name of the class of object this phone number is attached to. Always Entity. |
VARCHAR | No |
| created_by_id | The numerical identifier of the user that created this phone number. Relates to the id column in the users table. An ID of 1 typically means a machine-created number, such as over the API. |
INT8 | No |
| status | The status of the phone numbers, as displayed on the user interface. One of user_added, verified, bad, or do_not_contact. |
VARCHAR | Yes |
| created_at | The UTC timestamp when this object was created. | TIMESTAMP | No |
| updated_at | The UTC timestamp when this object was last updated. | TIMESTAMP | No |
| updated_by_id | The numerical identifier of the user that last updated this phone number. Relates to the id column in the users table. An ID of 1 typically means a machine-updated number, such as over the API. |
INT4 | Yes |
| dw_id | The DWID of the phone number, sourced from Catalist via the sync. | VARCHAR | Yes |
| interact_id | The UUID of the phone number, for use on the API. | UUID | No |
| source | The source of the number as displayed on the user interface. One of action_builder, upload, action_network, or api. |
VARCHAR | Yes |