</foreignKey>
<field>
<name>name</name>
+ <title>Field Name (or unique reference)</title>
<type>varchar</type>
<length>255</length>
<comment>Mapping field key</comment>
</field>
<field>
<name>contact_type</name>
+ <title>Contact Type</title>
<type>varchar</type>
<length>64</length>
<comment>Contact Type in mapping</comment>
</field>
<field>
<name>column_number</name>
+ <title>Column Number to map to</title>
<type>int unsigned</type>
<required>true</required>
<comment>Column number for mapping set</comment>
<title>Location type ID</title>
<comment>Location type of this mapping, if required</comment>
<add>1.2</add>
+ <pseudoconstant>
+ <table>civicrm_location_type</table>
+ <keyColumn>id</keyColumn>
+ <labelColumn>display_name</labelColumn>
+ </pseudoconstant>
</field>
<foreignKey>
<name>location_type_id</name>
</field>
<field>
<name>phone_type_id</name>
+ <title>Phone Type</title>
<type>int unsigned</type>
<title>Phone type ID</title>
<comment>Which type of phone does this number belongs.</comment>
</foreignKey>
<field>
<name>relationship_direction</name>
+ <title>Relationship Direction</title>
<type>varchar</type>
<length>6</length>
<add>1.7</add>
</field>
<field>
<name>grouping</name>
+ <title>Field Grouping</title>
<type>int unsigned</type>
<default>1</default>
<comment>Used to group mapping_field records into related sets (e.g. for criteria sets in search builder
<field>
<name>operator</name>
<type>varchar</type>
+ <title>Operator</title>
<length>16</length>
<type>enum</type>
<comment>SQL WHERE operator for search-builder mapping fields (search criteria).</comment>
</field>
<field>
<name>value</name>
+ <title>Search builder where clause</title>
<type>varchar</type>
<length>255</length>
<comment>SQL WHERE value for search-builder mapping fields.</comment>