Table: Customer Phone Entity

Table: 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
idint(11)The id of the entity
entity_idint(11)ID of the associated entity
entity_typechar(100)Type of the associated entity
phonechar(20)Phone number
typechar(100)Phone type codecustomer.phoneType.*
is_primarytinyint(4)Whether or not this is a primary phone number1 - yes, 0 - no
is_secondarytinyint(4)Whether or not this is a secondary phone number1 - yes, 0 - no
sbt_act_verify_pendingtinyint(1)Whether or not a Solutions by Text (SBT) verification is pending for account texts1 - yes, 0 - no
sbt_act_verify_pinchar(20)PIN for SBT verification for account texts
sbt_act_verifiedtinyint(1)Whether or not the phone number has been verified with SBT for account texts1 - yes, 0 - no
sbt_mkt_verify_pendingtinyint(1)Whether or not a Solutions by Text (SBT) verification is pending for marketing texts1 - yes, 0 - no
sbt_mkt_verify_pinchar(20)PIN for SBT verification for marketing texts
sbt_mkt_verifiedtinyint(1)Whether or not the phone number has been verified with SBT for marketing texts1 - yes, 0 - no
carrier_namevarchar(255)Name of phone carrier
carrier_verifiedtinyint(1)Whether or not the carrier has been verified1 - yes, 0 - no
landlinetinyint(1)Whether or not the phone is a landline1 - yes, 0 - no
dnd_enabledtinyint(1)Whether or not Do not Disturb settings are enabled1 - yes, 0 - no
activetinyint(1)Whether or not the entity is active1 - yes, 0 - no
deletedtinyint(1)Whether or not the entity was deleted1 - yes, 0 - no
createdtimestampTimestamp of when the entity was created
lastUpdatedtimestampTimestamp of when the entity was last updated

< Back to List