[civicrm-core.git] / xml / schema / Core / MappingField.xml

<?xml version="1.0" encoding="iso-8859-1" ?>

<table>
  <base>CRM/Core</base>
  <class>MappingField</class>
  <name>civicrm_mapping_field</name>
  <comment>Individual field mappings for Mapping</comment>
  <add>1.2</add>
  <field>
    <name>id</name>
    <type>int unsigned</type>
    <title>Mapping Field ID</title>
    <required>true</required>
    <comment>Mapping Field ID</comment>
    <add>1.2</add>
  </field>
  <primaryKey>
    <name>id</name>
    <autoincrement>true</autoincrement>
    <add>1.2</add>
  </primaryKey>
  <field>
    <name>mapping_id</name>
    <type>int unsigned</type>
    <title>Mapping ID</title>
    <required>true</required>
    <comment>Mapping to which this field belongs</comment>
    <add>1.2</add>
  </field>
  <foreignKey>
    <name>mapping_id</name>
    <table>civicrm_mapping</table>
    <key>id</key>
    <add>1.2</add>
  </foreignKey>
  <field>
    <name>name</name>
    <title>Field Name (or unique reference)</title>
    <type>varchar</type>
    <length>255</length>
    <comment>Mapping field key</comment>
    <add>1.2</add>
  </field>
  <field>
    <name>contact_type</name>
    <title>Contact Type</title>
    <type>varchar</type>
    <length>64</length>
    <comment>Contact Type in mapping</comment>
    <html>
      <type>Select</type>
    </html>
    <add>1.2</add>
  </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>
    <add>1.2</add>
  </field>
  <field>
    <name>location_type_id</name>
    <type>int unsigned</type>
    <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>
    <table>civicrm_location_type</table>
    <key>id</key>
    <add>1.2</add>
  </foreignKey>
  <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>
    <add>2.2</add>
  </field>
  <field>
    <name>im_provider_id</name>
    <type>int unsigned</type>
    <title>IM provider ID</title>
    <comment>Which type of IM Provider does this name belong.</comment>
    <add>3.0</add>
    <pseudoconstant>
      <optionGroupName>instant_messenger_service</optionGroupName>
    </pseudoconstant>
    <html>
      <type>Select</type>
    </html>
  </field>
  <field>
    <name>website_type_id</name>
    <type>int unsigned</type>
    <title>Website type ID</title>
    <comment>Which type of website does this site belong</comment>
    <add>3.2</add>
    <pseudoconstant>
      <optionGroupName>website_type</optionGroupName>
    </pseudoconstant>
    <html>
      <type>Select</type>
    </html>
  </field>
  <field>
    <name>relationship_type_id</name>
    <type>int unsigned</type>
    <title>Relationship type ID</title>
    <comment>Relationship type, if required</comment>
    <add>1.2</add>
  </field>
  <foreignKey>
    <name>relationship_type_id</name>
    <table>civicrm_relationship_type</table>
    <key>id</key>
    <add>1.2</add>
  </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
      mappings).</comment>
    <add>1.5</add>
  </field>
  <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>
    <pseudoconstant>
      <callback>CRM_Core_SelectValues::getSearchBuilderOperators</callback>
    </pseudoconstant>
    <add>1.5</add>
    <html>
      <type>Select</type>
    </html>
  </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>
    <add>1.5</add>
  </field>
</table>
Commit	Line	Data
6a488035 TO	1	<?xml version="1.0" encoding="iso-8859-1" ?>
	2
	3	<table>
	4	<base>CRM/Core</base>
	5	<class>MappingField</class>
	6	<name>civicrm_mapping_field</name>
	7	<comment>Individual field mappings for Mapping</comment>
	8	<add>1.2</add>
	9	<field>
8f069c03 EM	10	<name>id</name>
8f069c03 EM	11	<type>int unsigned</type>
10d067c6	12	<title>Mapping Field ID</title>
8f069c03 EM	13	<required>true</required>
	14	<comment>Mapping Field ID</comment>
	15	<add>1.2</add>
6a488035 TO	16	</field>
6a488035 TO	17	<primaryKey>
8f069c03 EM	18	<name>id</name>
	19	<autoincrement>true</autoincrement>
	20	<add>1.2</add>
6a488035 TO	21	</primaryKey>
6a488035 TO	22	<field>
8f069c03 EM	23	<name>mapping_id</name>
8f069c03 EM	24	<type>int unsigned</type>
10d067c6	25	<title>Mapping ID</title>
8f069c03 EM	26	<required>true</required>
	27	<comment>Mapping to which this field belongs</comment>
	28	<add>1.2</add>
6a488035 TO	29	</field>
6a488035 TO	30	<foreignKey>
8f069c03 EM	31	<name>mapping_id</name>
	32	<table>civicrm_mapping</table>
	33	<key>id</key>
	34	<add>1.2</add>
6a488035 TO	35	</foreignKey>
6a488035 TO	36	<field>
8f069c03	37	<name>name</name>
110684e4	38	<title>Field Name (or unique reference)</title>
8f069c03 EM	39	<type>varchar</type>
	40	<length>255</length>
	41	<comment>Mapping field key</comment>
	42	<add>1.2</add>
6a488035 TO	43	</field>
6a488035 TO	44	<field>
8f069c03	45	<name>contact_type</name>
110684e4	46	<title>Contact Type</title>
8f069c03 EM	47	<type>varchar</type>
	48	<length>64</length>
	49	<comment>Contact Type in mapping</comment>
8f069c03 EM	50	<html>
	51	<type>Select</type>
	52	</html>
	53	<add>1.2</add>
6a488035 TO	54	</field>
6a488035 TO	55	<field>
8f069c03	56	<name>column_number</name>
110684e4	57	<title>Column Number to map to</title>
8f069c03 EM	58	<type>int unsigned</type>
	59	<required>true</required>
	60	<comment>Column number for mapping set</comment>
	61	<add>1.2</add>
6a488035 TO	62	</field>
6a488035 TO	63	<field>
8f069c03 EM	64	<name>location_type_id</name>
8f069c03 EM	65	<type>int unsigned</type>
10d067c6	66	<title>Location type ID</title>
8f069c03 EM	67	<comment>Location type of this mapping, if required</comment>
8f069c03 EM	68	<add>1.2</add>
3c5a48c7	69	<pseudoconstant>
	70	<table>civicrm_location_type</table>
	71	<keyColumn>id</keyColumn>
	72	<labelColumn>display_name</labelColumn>
	73	</pseudoconstant>
6a488035 TO	74	</field>
6a488035 TO	75	<foreignKey>
8f069c03 EM	76	<name>location_type_id</name>
	77	<table>civicrm_location_type</table>
	78	<key>id</key>
	79	<add>1.2</add>
6a488035	80	</foreignKey>
6a488035	81	<field>
8f069c03	82	<name>phone_type_id</name>
110684e4	83	<title>Phone Type</title>
8f069c03	84	<type>int unsigned</type>
10d067c6	85	<title>Phone type ID</title>
8f069c03 EM	86	<comment>Which type of phone does this number belongs.</comment>
8f069c03 EM	87	<add>2.2</add>
3c7d2158	88	</field>
8f069c03 EM	89	<field>
	90	<name>im_provider_id</name>
	91	<type>int unsigned</type>
10d067c6	92	<title>IM provider ID</title>
8f069c03 EM	93	<comment>Which type of IM Provider does this name belong.</comment>
	94	<add>3.0</add>
	95	<pseudoconstant>
	96	<optionGroupName>instant_messenger_service</optionGroupName>
	97	</pseudoconstant>
	98	<html>
	99	<type>Select</type>
	100	</html>
6a488035 TO	101	</field>
6a488035 TO	102	<field>
8f069c03 EM	103	<name>website_type_id</name>
8f069c03 EM	104	<type>int unsigned</type>
a265eee1	105	<title>Website type ID</title>
8f069c03 EM	106	<comment>Which type of website does this site belong</comment>
	107	<add>3.2</add>
	108	<pseudoconstant>
	109	<optionGroupName>website_type</optionGroupName>
	110	</pseudoconstant>
	111	<html>
	112	<type>Select</type>
	113	</html>
3c7d2158	114	</field>
6a488035	115	<field>
8f069c03 EM	116	<name>relationship_type_id</name>
8f069c03 EM	117	<type>int unsigned</type>
a265eee1	118	<title>Relationship type ID</title>
8f069c03 EM	119	<comment>Relationship type, if required</comment>
8f069c03 EM	120	<add>1.2</add>
6a488035 TO	121	</field>
6a488035 TO	122	<foreignKey>
8f069c03 EM	123	<name>relationship_type_id</name>
	124	<table>civicrm_relationship_type</table>
	125	<key>id</key>
	126	<add>1.2</add>
6a488035	127	</foreignKey>
3c7d2158	128	<field>
8f069c03	129	<name>relationship_direction</name>
110684e4	130	<title>Relationship Direction</title>
8f069c03 EM	131	<type>varchar</type>
	132	<length>6</length>
	133	<add>1.7</add>
3c7d2158	134	</field>
6a488035	135	<field>
8f069c03	136	<name>grouping</name>
110684e4	137	<title>Field Grouping</title>
8f069c03 EM	138	<type>int unsigned</type>
	139	<default>1</default>
	140	<comment>Used to group mapping_field records into related sets (e.g. for criteria sets in search builder
fb607354	141	mappings).</comment>
8f069c03	142	<add>1.5</add>
6a488035 TO	143	</field>
6a488035 TO	144	<field>
8f069c03 EM	145	<name>operator</name>
8f069c03 EM	146	<type>varchar</type>
110684e4	147	<title>Operator</title>
8f069c03 EM	148	<length>16</length>
	149	<type>enum</type>
	150	<comment>SQL WHERE operator for search-builder mapping fields (search criteria).</comment>
	151	<pseudoconstant>
	152	<callback>CRM_Core_SelectValues::getSearchBuilderOperators</callback>
	153	</pseudoconstant>
	154	<add>1.5</add>
	155	<html>
	156	<type>Select</type>
	157	</html>
6a488035 TO	158	</field>
6a488035 TO	159	<field>
8f069c03	160	<name>value</name>
110684e4	161	<title>Search builder where clause</title>
8f069c03 EM	162	<type>varchar</type>
	163	<length>255</length>
	164	<comment>SQL WHERE value for search-builder mapping fields.</comment>
	165	<add>1.5</add>
6a488035 TO	166	</field>
6a488035 TO	167	</table>