Database – Customer Phone Entity (customer_phone_entity)

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