[civicrm-core.git] / xml / schema / Contact / RelationshipType.xml

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

<table>
  <base>CRM/Contact</base>
  <class>RelationshipType</class>
  <name>civicrm_relationship_type</name>
  <comment>Relationship types s/b structured with contact_a as the 'subject/child' contact and contact_b as the 'object/parent' contact (e.g. Individual A is Employee of Org B).</comment>
  <add>1.1</add>
  <log>true</log>
  <field>
    <name>id</name>
    <type>int unsigned</type>
    <title>Relationship Type ID</title>
    <required>true</required>
    <comment>Primary key</comment>
    <html>
      <type>Number</type>
    </html>
    <add>1.1</add>
  </field>
  <primaryKey>
    <name>id</name>
    <autoincrement>true</autoincrement>
  </primaryKey>
  <field>
    <name>name_a_b</name>
    <type>varchar</type>
    <title>Relationship Type Name A to B</title>
    <length>64</length>
    <comment>name for relationship of contact_a to contact_b.</comment>
    <add>1.1</add>
  </field>
  <field>
    <name>label_a_b</name>
    <type>varchar</type>
    <title>Relationship Type Label A to B</title>
    <length>64</length>
    <comment>label for relationship of contact_a to contact_b.</comment>
    <html>
      <type>Text</type>
    </html>
    <add>3.0</add>
    <localizable>true</localizable>
  </field>
  <field>
    <name>name_b_a</name>
    <type>varchar</type>
    <title>Relationship Type Name B to A</title>
    <length>64</length>
    <comment>Optional name for relationship of contact_b to contact_a.</comment>
    <add>1.1</add>
  </field>
  <field>
    <name>label_b_a</name>
    <type>varchar</type>
    <title>Relationship Type Label B to A</title>
    <length>64</length>
    <comment>Optional label for relationship of contact_b to contact_a.</comment>
    <html>
      <type>Text</type>
    </html>
    <add>3.0</add>
    <localizable>true</localizable>
  </field>
  <field>
    <name>description</name>
    <type>varchar</type>
    <title>Relationship Description</title>
    <length>255</length>
    <comment>Optional verbose description of the relationship type.</comment>
    <add>1.1</add>
    <html>
      <type>Text</type>
    </html>
    <localizable>true</localizable>
  </field>
  <field>
    <name>contact_type_a</name>
    <title>Contact Type for Contact A</title>
    <type>varchar</type>
    <length>12</length>
    <comment>If defined, contact_a in a relationship of this type must be a specific contact_type.</comment>
    <pseudoconstant>
      <table>civicrm_contact_type</table>
      <keyColumn>name</keyColumn>
      <labelColumn>label</labelColumn>
      <condition>parent_id IS NULL</condition>
    </pseudoconstant>
    <add>1.1</add>
    <html>
      <type>Select</type>
    </html>
  </field>
  <field>
    <name>contact_type_b</name>
    <title>Contact Type for Contact B</title>
    <type>varchar</type>
    <length>12</length>
    <comment>If defined, contact_b in a relationship of this type must be a specific contact_type.</comment>
    <pseudoconstant>
      <table>civicrm_contact_type</table>
      <keyColumn>name</keyColumn>
      <labelColumn>label</labelColumn>
      <condition>parent_id IS NULL</condition>
    </pseudoconstant>
    <add>1.1</add>
    <html>
      <type>Select</type>
    </html>
  </field>
  <field>
    <name>contact_sub_type_a</name>
    <title>Contact Subtype A</title>
    <type>varchar</type>
    <length>64</length>
    <comment>If defined, contact_sub_type_a in a relationship of this type must be a specific contact_sub_type.</comment>
    <add>3.1</add>
    <html>
      <type>Select</type>
    </html>
    <pseudoconstant>
      <table>civicrm_contact_type</table>
      <keyColumn>name</keyColumn>
      <labelColumn>label</labelColumn>
      <condition>parent_id IS NOT NULL</condition>
    </pseudoconstant>
  </field>
  <field>
    <name>contact_sub_type_b</name>
    <title>Contact Subtype B</title>
    <type>varchar</type>
    <length>64</length>
    <comment>If defined, contact_sub_type_b in a relationship of this type must be a specific contact_sub_type.</comment>
    <add>3.1</add>
    <html>
      <type>Select</type>
    </html>
    <pseudoconstant>
      <table>civicrm_contact_type</table>
      <keyColumn>name</keyColumn>
      <labelColumn>label</labelColumn>
      <condition>parent_id IS NOT NULL</condition>
    </pseudoconstant>
  </field>
  <field>
    <name>is_reserved</name>
    <type>boolean</type>
    <title>Relationship Type is Reserved</title>
    <comment>Is this relationship type a predefined system type (can not be changed or de-activated)?</comment>
    <html>
      <type>CheckBox</type>
    </html>
    <add>1.1</add>
  </field>
  <field>
    <name>is_active</name>
    <title>Relationship Type is Active</title>
    <type>boolean</type>
    <default>1</default>
    <comment>Is this relationship type currently active (i.e. can be used when creating or editing relationships)?</comment>
    <html>
      <type>CheckBox</type>
    </html>
    <add>1.1</add>
  </field>
  <index>
    <name>UI_name_a_b</name>
    <fieldName>name_a_b</fieldName>
    <unique>true</unique>
    <add>2.1</add>
  </index>
  <index>
    <name>UI_name_b_a</name>
    <fieldName>name_b_a</fieldName>
    <unique>true</unique>
    <add>2.1</add>
  </index>
</table>
Commit	Line	Data
6a488035 TO	1	<?xml version="1.0" encoding="iso-8859-1" ?>
	2
	3	<table>
	4	<base>CRM/Contact</base>
	5	<class>RelationshipType</class>
	6	<name>civicrm_relationship_type</name>
d91a4be3	7	<comment>Relationship types s/b structured with contact_a as the 'subject/child' contact and contact_b as the 'object/parent' contact (e.g. Individual A is Employee of Org B).</comment>
6a488035 TO	8	<add>1.1</add>
	9	<log>true</log>
	10	<field>
8f069c03 EM	11	<name>id</name>
	12	<type>int unsigned</type>
	13	<title>Relationship Type ID</title>
	14	<required>true</required>
	15	<comment>Primary key</comment>
0481e12c A	16	<html>
	17	<type>Number</type>
	18	</html>
8f069c03	19	<add>1.1</add>
6a488035 TO	20	</field>
6a488035 TO	21	<primaryKey>
8f069c03 EM	22	<name>id</name>
8f069c03 EM	23	<autoincrement>true</autoincrement>
6a488035 TO	24	</primaryKey>
6a488035 TO	25	<field>
8f069c03 EM	26	<name>name_a_b</name>
	27	<type>varchar</type>
	28	<title>Relationship Type Name A to B</title>
	29	<length>64</length>
	30	<comment>name for relationship of contact_a to contact_b.</comment>
	31	<add>1.1</add>
6a488035 TO	32	</field>
6a488035 TO	33	<field>
8f069c03 EM	34	<name>label_a_b</name>
	35	<type>varchar</type>
	36	<title>Relationship Type Label A to B</title>
	37	<length>64</length>
	38	<comment>label for relationship of contact_a to contact_b.</comment>
a9999eb6	39	<html>
	40	<type>Text</type>
	41	</html>
8f069c03	42	<add>3.0</add>
f2f99298	43	<localizable>true</localizable>
6a488035 TO	44	</field>
6a488035 TO	45	<field>
8f069c03 EM	46	<name>name_b_a</name>
	47	<type>varchar</type>
	48	<title>Relationship Type Name B to A</title>
	49	<length>64</length>
	50	<comment>Optional name for relationship of contact_b to contact_a.</comment>
	51	<add>1.1</add>
6a488035 TO	52	</field>
6a488035 TO	53	<field>
8f069c03 EM	54	<name>label_b_a</name>
	55	<type>varchar</type>
	56	<title>Relationship Type Label B to A</title>
	57	<length>64</length>
	58	<comment>Optional label for relationship of contact_b to contact_a.</comment>
a9999eb6	59	<html>
	60	<type>Text</type>
	61	</html>
8f069c03	62	<add>3.0</add>
f2f99298	63	<localizable>true</localizable>
6a488035 TO	64	</field>
6a488035 TO	65	<field>
8f069c03 EM	66	<name>description</name>
	67	<type>varchar</type>
	68	<title>Relationship Description</title>
	69	<length>255</length>
	70	<comment>Optional verbose description of the relationship type.</comment>
	71	<add>1.1</add>
a9999eb6	72	<html>
	73	<type>Text</type>
	74	</html>
f2f99298	75	<localizable>true</localizable>
6a488035 TO	76	</field>
6a488035 TO	77	<field>
8f069c03 EM	78	<name>contact_type_a</name>
	79	<title>Contact Type for Contact A</title>
	80	<type>varchar</type>
	81	<length>12</length>
	82	<comment>If defined, contact_a in a relationship of this type must be a specific contact_type.</comment>
	83	<pseudoconstant>
5c237603 CW	84	<table>civicrm_contact_type</table>
	85	<keyColumn>name</keyColumn>
	86	<labelColumn>label</labelColumn>
	87	<condition>parent_id IS NULL</condition>
8f069c03 EM	88	</pseudoconstant>
	89	<add>1.1</add>
	90	<html>
	91	<type>Select</type>
	92	</html>
6a488035 TO	93	</field>
6a488035 TO	94	<field>
8f069c03 EM	95	<name>contact_type_b</name>
	96	<title>Contact Type for Contact B</title>
	97	<type>varchar</type>
	98	<length>12</length>
	99	<comment>If defined, contact_b in a relationship of this type must be a specific contact_type.</comment>
	100	<pseudoconstant>
5c237603 CW	101	<table>civicrm_contact_type</table>
	102	<keyColumn>name</keyColumn>
	103	<labelColumn>label</labelColumn>
	104	<condition>parent_id IS NULL</condition>
8f069c03 EM	105	</pseudoconstant>
	106	<add>1.1</add>
	107	<html>
	108	<type>Select</type>
	109	</html>
6a488035 TO	110	</field>
6a488035 TO	111	<field>
8f069c03 EM	112	<name>contact_sub_type_a</name>
	113	<title>Contact Subtype A</title>
	114	<type>varchar</type>
	115	<length>64</length>
fb607354	116	<comment>If defined, contact_sub_type_a in a relationship of this type must be a specific contact_sub_type.</comment>
8f069c03 EM	117	<add>3.1</add>
	118	<html>
	119	<type>Select</type>
	120	</html>
5c237603 CW	121	<pseudoconstant>
	122	<table>civicrm_contact_type</table>
	123	<keyColumn>name</keyColumn>
	124	<labelColumn>label</labelColumn>
	125	<condition>parent_id IS NOT NULL</condition>
	126	</pseudoconstant>
6a488035 TO	127	</field>
6a488035 TO	128	<field>
8f069c03 EM	129	<name>contact_sub_type_b</name>
	130	<title>Contact Subtype B</title>
	131	<type>varchar</type>
	132	<length>64</length>
fb607354	133	<comment>If defined, contact_sub_type_b in a relationship of this type must be a specific contact_sub_type.</comment>
8f069c03 EM	134	<add>3.1</add>
	135	<html>
	136	<type>Select</type>
	137	</html>
5c237603 CW	138	<pseudoconstant>
	139	<table>civicrm_contact_type</table>
	140	<keyColumn>name</keyColumn>
	141	<labelColumn>label</labelColumn>
	142	<condition>parent_id IS NOT NULL</condition>
	143	</pseudoconstant>
6a488035 TO	144	</field>
6a488035 TO	145	<field>
8f069c03 EM	146	<name>is_reserved</name>
	147	<type>boolean</type>
	148	<title>Relationship Type is Reserved</title>
	149	<comment>Is this relationship type a predefined system type (can not be changed or de-activated)?</comment>
a9999eb6	150	<html>
	151	<type>CheckBox</type>
	152	</html>
8f069c03	153	<add>1.1</add>
6a488035 TO	154	</field>
6a488035 TO	155	<field>
8f069c03 EM	156	<name>is_active</name>
	157	<title>Relationship Type is Active</title>
	158	<type>boolean</type>
	159	<default>1</default>
fb607354	160	<comment>Is this relationship type currently active (i.e. can be used when creating or editing relationships)?</comment>
a9999eb6	161	<html>
	162	<type>CheckBox</type>
	163	</html>
8f069c03	164	<add>1.1</add>
6a488035 TO	165	</field>
	166	<index>
	167	<name>UI_name_a_b</name>
	168	<fieldName>name_a_b</fieldName>
	169	<unique>true</unique>
	170	<add>2.1</add>
	171	</index>
	172	<index>
	173	<name>UI_name_b_a</name>
	174	<fieldName>name_b_a</fieldName>
	175	<unique>true</unique>
	176	<add>2.1</add>
	177	</index>
	178	</table>