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>
40 <localizable>true
</localizable>
45 <title>Relationship Type Name B to A
</title>
47 <comment>Optional name for relationship of contact_b to contact_a.
</comment>
51 <name>label_b_a
</name>
53 <title>Relationship Type Label B to A
</title>
55 <comment>Optional label for relationship of contact_b to contact_a.
</comment>
60 <localizable>true
</localizable>
63 <name>description
</name>
65 <title>Relationship Description
</title>
67 <comment>Optional verbose description of the relationship type.
</comment>
72 <localizable>true
</localizable>
75 <name>contact_type_a
</name>
76 <title>Contact Type for Contact A
</title>
79 <comment>If defined, contact_a in a relationship of this type must be a specific contact_type.
</comment>
81 <table>civicrm_contact_type
</table>
82 <keyColumn>name
</keyColumn>
83 <labelColumn>label
</labelColumn>
84 <condition>parent_id IS NULL
</condition>
92 <name>contact_type_b
</name>
93 <title>Contact Type for Contact B
</title>
96 <comment>If defined, contact_b in a relationship of this type must be a specific contact_type.
</comment>
98 <table>civicrm_contact_type
</table>
99 <keyColumn>name
</keyColumn>
100 <labelColumn>label
</labelColumn>
101 <condition>parent_id IS NULL
</condition>
109 <name>contact_sub_type_a
</name>
110 <title>Contact Subtype A
</title>
113 <comment>If defined, contact_sub_type_a in a relationship of this type must be a specific contact_sub_type.
120 <table>civicrm_contact_type
</table>
121 <keyColumn>name
</keyColumn>
122 <labelColumn>label
</labelColumn>
123 <condition>parent_id IS NOT NULL
</condition>
127 <name>contact_sub_type_b
</name>
128 <title>Contact Subtype B
</title>
131 <comment>If defined, contact_sub_type_b in a relationship of this type must be a specific contact_sub_type.
138 <table>civicrm_contact_type
</table>
139 <keyColumn>name
</keyColumn>
140 <labelColumn>label
</labelColumn>
141 <condition>parent_id IS NOT NULL
</condition>
145 <name>is_reserved
</name>
147 <title>Relationship Type is Reserved
</title>
148 <comment>Is this relationship type a predefined system type (can not be changed or de-activated)?
</comment>
150 <type>CheckBox
</type>
155 <name>is_active
</name>
156 <title>Relationship Type is Active
</title>
159 <comment>Is this relationship type currently active (i.e. can be used when creating or editing relationships)?
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>