Table d45civi_b72v5.civicrm_phone Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int unsigned 10  √ 
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 C
civicrm_mailing_recipients.phone_id FK_civicrm_mailing_recipients_phone_id C
Unique Phone ID
contact_id int unsigned 10  √  null
civicrm_contact.id 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 159 rows at Wed Nov 11 17:12 EST 2015

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

Close relationships  within of separation: