Table d47civi_0z3xa.civicrm_im Generated by
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_loc_block.im_2_id FK_civicrm_loc_block_im_2_id N
civicrm_loc_block.im_id FK_civicrm_loc_block_im_id N
Unique IM ID
contact_id int unsigned 10  √  null FK_civicrm_im_contact_id C
FK to Contact ID
location_type_id int unsigned 10  √  null Which Location does this email belong to.
name varchar 64  √  null IM screen name
provider_id int unsigned 10  √  null Which IM Provider does this screen name belong to.
is_primary tinyint 3  √  0 Is this the primary IM for this contact and location.
is_billing tinyint 3  √  0 Is this the billing?

Table contained 0 rows at mer. avr. 13 16:52 EDT 2016

Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
contact_id Performance Asc FK_civicrm_im_contact_id
is_billing Performance Asc index_is_billing
is_primary Performance Asc index_is_primary
location_type_id Performance Asc index_location_type
provider_id Performance Asc UI_provider_id

Close relationships  within of separation: