1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
4 <base>CRM/Contact
</base>
5 <class>RelationshipType
</class>
6 <name>civicrm_relationship_type
</name>
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>
12 <type>int unsigned
</type>
13 <title>Relationship Type ID
</title>
14 <required>true
</required>
15 <comment>Primary key
</comment>
20 <autoincrement>true
</autoincrement>
25 <title>Relationship Type Name A to B
</title>
27 <comment>name for relationship of contact_a to contact_b.
</comment>
31 <name>label_a_b
</name>
33 <title>Relationship Type Label A to B
</title>
35 <comment>label for relationship of contact_a to contact_b.
</comment>
37 <localizable>true
</localizable>
42 <title>Relationship Type Name B to A
</title>
44 <comment>Optional name for relationship of contact_b to contact_a.
</comment>
48 <name>label_b_a
</name>
50 <title>Relationship Type Label B to A
</title>
52 <comment>Optional label for relationship of contact_b to contact_a.
</comment>
54 <localizable>true
</localizable>
57 <name>description
</name>
59 <title>Relationship Description
</title>
61 <comment>Optional verbose description of the relationship type.
</comment>
63 <localizable>true
</localizable>
66 <name>contact_type_a
</name>
67 <title>Contact Type for Contact A
</title>
70 <comment>If defined, contact_a in a relationship of this type must be a specific contact_type.
</comment>
72 <table>civicrm_contact_type
</table>
73 <keyColumn>name
</keyColumn>
74 <labelColumn>label
</labelColumn>
75 <condition>parent_id IS NULL
</condition>
83 <name>contact_type_b
</name>
84 <title>Contact Type for Contact B
</title>
87 <comment>If defined, contact_b in a relationship of this type must be a specific contact_type.
</comment>
89 <table>civicrm_contact_type
</table>
90 <keyColumn>name
</keyColumn>
91 <labelColumn>label
</labelColumn>
92 <condition>parent_id IS NULL
</condition>
100 <name>contact_sub_type_a
</name>
101 <title>Contact Subtype A
</title>
104 <comment>If defined, contact_sub_type_a in a relationship of this type must be a specific contact_sub_type.
111 <table>civicrm_contact_type
</table>
112 <keyColumn>name
</keyColumn>
113 <labelColumn>label
</labelColumn>
114 <condition>parent_id IS NOT NULL
</condition>
118 <name>contact_sub_type_b
</name>
119 <title>Contact Subtype B
</title>
122 <comment>If defined, contact_sub_type_b in a relationship of this type must be a specific contact_sub_type.
129 <table>civicrm_contact_type
</table>
130 <keyColumn>name
</keyColumn>
131 <labelColumn>label
</labelColumn>
132 <condition>parent_id IS NOT NULL
</condition>
136 <name>is_reserved
</name>
138 <title>Relationship Type is Reserved
</title>
139 <comment>Is this relationship type a predefined system type (can not be changed or de-activated)?
</comment>
143 <name>is_active
</name>
144 <title>Relationship Type is Active
</title>
147 <comment>Is this relationship type currently active (i.e. can be used when creating or editing relationships)?
152 <name>UI_name_a_b
</name>
153 <fieldName>name_a_b
</fieldName>
154 <unique>true
</unique>
158 <name>UI_name_b_a
</name>
159 <fieldName>name_b_a
</fieldName>
160 <unique>true
</unique>