civicrm_loc_block

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
civicrm_event.loc_block_id FK_civicrm_event_loc_block_idN
civicrm_group_contact.location_id FK_civicrm_group_contact_location_idN

Unique ID
address_id INT UNSIGNED 10 √ null
civicrm_address.id FK_civicrm_loc_block_address_idN
email_id INT UNSIGNED 10 √ null
civicrm_email.id FK_civicrm_loc_block_email_idN
phone_id INT UNSIGNED 10 √ null
civicrm_phone.id FK_civicrm_loc_block_phone_idN
im_id INT UNSIGNED 10 √ null
civicrm_im.id FK_civicrm_loc_block_im_idN
address_2_id INT UNSIGNED 10 √ null
civicrm_address.id FK_civicrm_loc_block_address_2_idN
email_2_id INT UNSIGNED 10 √ null
civicrm_email.id FK_civicrm_loc_block_email_2_idN
phone_2_id INT UNSIGNED 10 √ null
civicrm_phone.id FK_civicrm_loc_block_phone_2_idN
im_2_id INT UNSIGNED 10 √ null
civicrm_im.id FK_civicrm_loc_block_im_2_idN

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_loc_block_address_2_id Performance Asc address_2_id
FK_civicrm_loc_block_address_id Performance Asc address_id
FK_civicrm_loc_block_email_2_id Performance Asc email_2_id
FK_civicrm_loc_block_email_id Performance Asc email_id
FK_civicrm_loc_block_im_2_id Performance Asc im_2_id
FK_civicrm_loc_block_im_id Performance Asc im_id
FK_civicrm_loc_block_phone_2_id Performance Asc phone_2_id
FK_civicrm_loc_block_phone_id Performance Asc phone_id

Relationships

Close relationships within degrees of separation