civicrm_phone

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
civicrm_activity.phone_id FK_civicrm_activity_phone_idN
civicrm_loc_block.phone_2_id FK_civicrm_loc_block_phone_2_idN
civicrm_loc_block.phone_id FK_civicrm_loc_block_phone_idN
civicrm_mailing_event_queue.phone_id FK_civicrm_mailing_event_queue_phone_idN
civicrm_mailing_recipients.phone_id FK_civicrm_mailing_recipients_phone_idN

Unique Phone ID
contact_id INT UNSIGNED 10 √ null
civicrm_contact.id FK_civicrm_phone_contact_idC

FK to Contact ID
location_type_id INT UNSIGNED 10 √ null

Which Location does this phone belong to.
is_primary TINYINT 3 √ 0

Is this the primary phone for this contact and location.
is_billing TINYINT 3 √ 0

Is this the billing?
mobile_provider_id INT UNSIGNED 10 √ null

Which Mobile Provider does this phone belong to.
phone VARCHAR 32 √ null

Complete phone number.
phone_ext VARCHAR 16 √ null

Optional extension for a phone number.
phone_numeric VARCHAR 32 √ null

Phone number stripped of all whitespace, letters, and punctuation.
phone_type_id INT UNSIGNED 10 √ null

Which type of phone does this number belongs.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_phone_contact_id Performance Asc contact_id
index_is_billing Performance Asc is_billing
index_is_primary Performance Asc is_primary
index_location_type Performance Asc location_type_id
index_phone_numeric Performance Asc phone_numeric
UI_mobile_provider_id Performance Asc mobile_provider_id

Relationships

Close relationships within degrees of separation