Table d47civi_0z3xa.civicrm_loc_block 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_event.loc_block_id FK_civicrm_event_loc_block_id N
civicrm_group_contact.location_id FK_civicrm_group_contact_location_id N
civicrm_volunteer_project.loc_block_id FK_civicrm_volunteer_project_loc_block_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 3 rows at mer. avr. 13 16:52 EDT 2016

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

Close relationships  within of separation: