Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | √ | null |
|
|
Mapping Field ID |
|||
| mapping_id | INT UNSIGNED | 10 | null |
|
|
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 | null |
|
|
Column number for mapping set |
||||
| location_type_id | INT UNSIGNED | 10 | √ | null |
|
|
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 |
|
|
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 |
|||
| 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. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| FK_civicrm_mapping_field_location_type_id | Performance | Asc | location_type_id |
| FK_civicrm_mapping_field_mapping_id | Performance | Asc | mapping_id |
| FK_civicrm_mapping_field_relationship_type_id | Performance | Asc | relationship_type_id |
Relationships
Close relationships within degrees of separation
