civicrm_im

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
civicrm_loc_block.im_2_id FK_civicrm_loc_block_im_2_idN
civicrm_loc_block.im_id FK_civicrm_loc_block_im_idN

Unique IM ID

contact_id INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_im_contact_idC

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?

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_im_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
UI_provider_id Performance Asc provider_id

Relationships