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>
23 <autoincrement>true
</autoincrement>
28 <title>Relationship Type Name A to B
</title>
30 <comment>name for relationship of contact_a to contact_b.
</comment>
34 <name>label_a_b
</name>
36 <title>Relationship Type Label A to B
</title>
38 <comment>label for relationship of contact_a to contact_b.
</comment>
43 <localizable>true
</localizable>
48 <title>Relationship Type Name B to A
</title>
50 <comment>Optional name for relationship of contact_b to contact_a.
</comment>
54 <name>label_b_a
</name>
56 <title>Relationship Type Label B to A
</title>
58 <comment>Optional label for relationship of contact_b to contact_a.
</comment>
63 <localizable>true
</localizable>
66 <name>description
</name>
68 <title>Relationship Description
</title>
70 <comment>Optional verbose description of the relationship type.
</comment>
75 <localizable>true
</localizable>
78 <name>contact_type_a
</name>
79 <title>Contact Type for Contact A
</title>
82 <comment>If defined, contact_a in a relationship of this type must be a specific contact_type.
</comment>
84 <table>civicrm_contact_type
</table>
85 <keyColumn>name
</keyColumn>
86 <labelColumn>label
</labelColumn>
87 <condition>parent_id IS NULL
</condition>
95 <name>contact_type_b
</name>
96 <title>Contact Type for Contact B
</title>
99 <comment>If defined, contact_b in a relationship of this type must be a specific contact_type.
</comment>
101 <table>civicrm_contact_type
</table>
102 <keyColumn>name
</keyColumn>
103 <labelColumn>label
</labelColumn>
104 <condition>parent_id IS NULL
</condition>
112 <name>contact_sub_type_a
</name>
113 <title>Contact Subtype A
</title>
116 <comment>If defined, contact_sub_type_a in a relationship of this type must be a specific contact_sub_type.
</comment>
122 <table>civicrm_contact_type
</table>
123 <keyColumn>name
</keyColumn>
124 <labelColumn>label
</labelColumn>
125 <condition>parent_id IS NOT NULL
</condition>
129 <name>contact_sub_type_b
</name>
130 <title>Contact Subtype B
</title>
133 <comment>If defined, contact_sub_type_b in a relationship of this type must be a specific contact_sub_type.
</comment>
139 <table>civicrm_contact_type
</table>
140 <keyColumn>name
</keyColumn>
141 <labelColumn>label
</labelColumn>
142 <condition>parent_id IS NOT NULL
</condition>
146 <name>is_reserved
</name>
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>
151 <type>CheckBox
</type>
156 <name>is_active
</name>
157 <title>Relationship Type is Active
</title>
160 <comment>Is this relationship type currently active (i.e. can be used when creating or editing relationships)?
</comment>
162 <type>CheckBox
</type>
167 <name>UI_name_a_b
</name>
168 <fieldName>name_a_b
</fieldName>
169 <unique>true
</unique>
173 <name>UI_name_b_a
</name>
174 <fieldName>name_b_a
</fieldName>
175 <unique>true
</unique>