[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</name>
    <type>varchar</type>
    <length>64</length>
    <comment>Phone type, if required</comment>
    <add>1.2</add>
    <drop>2.2</drop>
  </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>
    <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 TO	80	</foreignKey>
6a488035 TO	81	<field>
8f069c03 EM	82	<name>phone_type</name>
	83	<type>varchar</type>
	84	<length>64</length>
	85	<comment>Phone type, if required</comment>
	86	<add>1.2</add>
	87	<drop>2.2</drop>
6a488035 TO	88	</field>
6a488035 TO	89	<field>
8f069c03	90	<name>phone_type_id</name>
110684e4	91	<title>Phone Type</title>
8f069c03	92	<type>int unsigned</type>
10d067c6	93	<title>Phone type ID</title>
8f069c03 EM	94	<comment>Which type of phone does this number belongs.</comment>
8f069c03 EM	95	<add>2.2</add>
3c7d2158	96	</field>
8f069c03 EM	97	<field>
	98	<name>im_provider_id</name>
	99	<type>int unsigned</type>
10d067c6	100	<title>IM provider ID</title>
8f069c03 EM	101	<comment>Which type of IM Provider does this name belong.</comment>
	102	<add>3.0</add>
	103	<pseudoconstant>
	104	<optionGroupName>instant_messenger_service</optionGroupName>
	105	</pseudoconstant>
	106	<html>
	107	<type>Select</type>
	108	</html>
6a488035 TO	109	</field>
6a488035 TO	110	<field>
8f069c03 EM	111	<name>website_type_id</name>
8f069c03 EM	112	<type>int unsigned</type>
a265eee1	113	<title>Website type ID</title>
8f069c03 EM	114	<comment>Which type of website does this site belong</comment>
	115	<add>3.2</add>
	116	<pseudoconstant>
	117	<optionGroupName>website_type</optionGroupName>
	118	</pseudoconstant>
	119	<html>
	120	<type>Select</type>
	121	</html>
3c7d2158	122	</field>
6a488035	123	<field>
8f069c03 EM	124	<name>relationship_type_id</name>
8f069c03 EM	125	<type>int unsigned</type>
a265eee1	126	<title>Relationship type ID</title>
8f069c03 EM	127	<comment>Relationship type, if required</comment>
8f069c03 EM	128	<add>1.2</add>
6a488035 TO	129	</field>
6a488035 TO	130	<foreignKey>
8f069c03 EM	131	<name>relationship_type_id</name>
	132	<table>civicrm_relationship_type</table>
	133	<key>id</key>
	134	<add>1.2</add>
6a488035	135	</foreignKey>
3c7d2158	136	<field>
8f069c03	137	<name>relationship_direction</name>
110684e4	138	<title>Relationship Direction</title>
8f069c03 EM	139	<type>varchar</type>
	140	<length>6</length>
	141	<add>1.7</add>
3c7d2158	142	</field>
6a488035	143	<field>
8f069c03	144	<name>grouping</name>
110684e4	145	<title>Field Grouping</title>
8f069c03 EM	146	<type>int unsigned</type>
	147	<default>1</default>
	148	<comment>Used to group mapping_field records into related sets (e.g. for criteria sets in search builder
fb607354	149	mappings).</comment>
8f069c03	150	<add>1.5</add>
6a488035 TO	151	</field>
6a488035 TO	152	<field>
8f069c03 EM	153	<name>operator</name>
8f069c03 EM	154	<type>varchar</type>
110684e4	155	<title>Operator</title>
8f069c03 EM	156	<length>16</length>
	157	<type>enum</type>
	158	<comment>SQL WHERE operator for search-builder mapping fields (search criteria).</comment>
	159	<pseudoconstant>
	160	<callback>CRM_Core_SelectValues::getSearchBuilderOperators</callback>
	161	</pseudoconstant>
	162	<add>1.5</add>
	163	<html>
	164	<type>Select</type>
	165	</html>
6a488035 TO	166	</field>
6a488035 TO	167	<field>
8f069c03	168	<name>value</name>
110684e4	169	<title>Search builder where clause</title>
8f069c03 EM	170	<type>varchar</type>
	171	<length>255</length>
	172	<comment>SQL WHERE value for search-builder mapping fields.</comment>
	173	<add>1.5</add>
6a488035 TO	174	</field>
6a488035 TO	175	</table>