Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
civicrm_activity.phone_id FK_civicrm_activity_phone_id N
civicrm_loc_block.phone_2_id FK_civicrm_loc_block_phone_2_id N
civicrm_loc_block.phone_id FK_civicrm_loc_block_phone_id N
civicrm_mailing_event_queue.phone_id FK_civicrm_mailing_event_queue_phone_id N
civicrm_mailing_recipients.phone_id FK_civicrm_mailing_recipients_phone_id N

Unique Phone ID

contact_id INT UNSIGNED 10 null FK_civicrm_phone_contact_id C

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.

Table contained 0 rows


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