civicrm_loc_block


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_id N
civicrm_group_contact.location_id FK_civicrm_group_contact_location_id N

Unique ID

address_id INT UNSIGNED 10 null
civicrm_address.id FK_civicrm_loc_block_address_id N
email_id INT UNSIGNED 10 null
civicrm_email.id FK_civicrm_loc_block_email_id N
phone_id INT UNSIGNED 10 null
civicrm_phone.id FK_civicrm_loc_block_phone_id N
im_id INT UNSIGNED 10 null
civicrm_im.id FK_civicrm_loc_block_im_id N
address_2_id INT UNSIGNED 10 null
civicrm_address.id FK_civicrm_loc_block_address_2_id N
email_2_id INT UNSIGNED 10 null
civicrm_email.id FK_civicrm_loc_block_email_2_id N
phone_2_id INT UNSIGNED 10 null
civicrm_phone.id FK_civicrm_loc_block_phone_2_id N
im_2_id INT UNSIGNED 10 null
civicrm_im.id FK_civicrm_loc_block_im_2_id N

Table contained 0 rows

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