Database – Customer Phone Entity (customer_phone_entity)
Description
This holds information concerning customer phone numbers, such as the number, carrier, and whether or not it is subscribed for text messages. For information on adding and editing customer phone numbers in the API, see API - Customer Phones.
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the entity | ||
entity_id | int(11) | ID of the associated entity | ||
entity_type | char(100) | Type of the associated entity | ||
phone | char(20) | Phone number | ||
type | char(100) | Phone type code | customer.phoneType.* | |
is_primary | tinyint(4) | Whether or not this is a primary phone number | 1 - yes, 0 - no | |
is_secondary | tinyint(4) | Whether or not this is a secondary phone number | 1 - yes, 0 - no | |
sbt_act_verify_pending | tinyint(1) | Whether or not a Solutions by Text (SBT) verification is pending for account texts | 1 - yes, 0 - no | |
sbt_act_verify_pin | char(20) | PIN for SBT verification for account texts | ||
sbt_act_verified | tinyint(1) | Whether or not the phone number has been verified with SBT for account texts | 1 - yes, 0 - no | |
sbt_mkt_verify_pending | tinyint(1) | Whether or not a Solutions by Text (SBT) verification is pending for marketing texts | 1 - yes, 0 - no | |
sbt_mkt_verify_pin | char(20) | PIN for SBT verification for marketing texts | ||
sbt_mkt_verified | tinyint(1) | Whether or not the phone number has been verified with SBT for marketing texts | 1 - yes, 0 - no | |
carrier_name | varchar(255) | Name of phone carrier | ||
carrier_verified | tinyint(1) | Whether or not the carrier has been verified | 1 - yes, 0 - no | |
landline | tinyint(1) | Whether or not the phone is a landline | 1 - yes, 0 - no | |
dnd_enabled | tinyint(1) | Whether or not Do not Disturb settings are enabled | 1 - yes, 0 - no | |
active | tinyint(1) | Whether or not the entity is active | 1 - yes, 0 - no | |
deleted | tinyint(1) | Whether or not the entity was deleted | 1 - yes, 0 - no | |
created | timestamp | Timestamp of when the entity was created | ||
lastUpdated | timestamp | Timestamp of when the entity was last updated |