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