Database – Customer Phone Entity (customer_phone_entity)
This holds information concerning customer phone numbers, such as the number, carrier, and whether or not it is subscribed for text messages.
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 |