Table d47civi_0z3xa.civicrm_mapping_field 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  √  Mapping Field ID
mapping_id int unsigned 10
civicrm_mapping.id FK_civicrm_mapping_field_mapping_id R
Mapping to which this field belongs
name varchar 255  √  null Mapping field key
contact_type varchar 64  √  null Contact Type in mapping
column_number int unsigned 10 Column number for mapping set
location_type_id int unsigned 10  √  null
civicrm_location_type.id FK_civicrm_mapping_field_location_type_id R
Location type of this mapping, if required
phone_type_id int unsigned 10  √  null Which type of phone does this number belongs.
im_provider_id int unsigned 10  √  null Which type of IM Provider does this name belong.
website_type_id int unsigned 10  √  null Which type of website does this site belong
relationship_type_id int unsigned 10  √  null
civicrm_relationship_type.id FK_civicrm_mapping_field_relationship_type_id R
Relationship type, if required
relationship_direction varchar 6  √  null
grouping int unsigned 10  √  1 Used to group mapping_field records into related sets (e.g. for criteria sets in search builder
mappings).
operator varchar 16  √  null SQL WHERE operator for search-builder mapping fields (search criteria).
value varchar 255  √  null SQL WHERE value for search-builder mapping fields.

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
location_type_id Performance Asc FK_civicrm_mapping_field_location_type_id
mapping_id Performance Asc FK_civicrm_mapping_field_mapping_id
relationship_type_id Performance Asc FK_civicrm_mapping_field_relationship_type_id

Close relationships  within of separation: