1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
4 <base>CRM/Contact
</base>
5 <class>Relationship
</class>
6 <name>civicrm_relationship
</name>
7 <comment>Relationship between any
2 types of contacts.
</comment>
10 <icon>fa-handshake-o
</icon>
13 <type>int unsigned
</type>
14 <title>Relationship ID
</title>
15 <required>true
</required>
16 <comment>Relationship ID
</comment>
21 <autoincrement>true
</autoincrement>
24 <name>contact_id_a
</name>
25 <type>int unsigned
</type>
26 <title>Contact A
</title>
27 <required>true
</required>
28 <comment>id of the first contact
</comment>
32 <name>contact_id_a
</name>
33 <table>civicrm_contact
</table>
36 <onDelete>CASCADE
</onDelete>
39 <name>contact_id_b
</name>
40 <type>int unsigned
</type>
41 <title>Contact B
</title>
42 <required>true
</required>
43 <comment>id of the second contact
</comment>
46 <type>EntityRef
</type>
50 <name>contact_id_b
</name>
51 <table>civicrm_contact
</table>
54 <onDelete>CASCADE
</onDelete>
57 <name>relationship_type_id
</name>
58 <type>int unsigned
</type>
59 <title>Relationship Type
</title>
60 <required>true
</required>
61 <comment>id of the relationship
</comment>
68 <name>relationship_type_id
</name>
69 <table>civicrm_relationship_type
</table>
72 <onDelete>CASCADE
</onDelete>
75 <name>start_date
</name>
76 <uniqueName>relationship_start_date
</uniqueName>
78 <title>Relationship Start Date
</title>
79 <comment>date when the relationship started
</comment>
82 <type>Select Date
</type>
83 <formatType>activityDate
</formatType>
88 <uniqueName>relationship_end_date
</uniqueName>
90 <title>Relationship End Date
</title>
91 <comment>date when the relationship ended
</comment>
94 <type>Select Date
</type>
95 <formatType>activityDate
</formatType>
99 <name>is_active
</name>
101 <title>Relationship Is Active
</title>
103 <comment>is the relationship active ?
</comment>
106 <type>CheckBox
</type>
110 <name>description
</name>
112 <title>Relationship Description
</title>
114 <comment>Optional verbose description for the relationship.
</comment>
121 <name>is_permission_a_b
</name>
122 <type>int unsigned
</type>
123 <title>Contact A has Permission Over Contact B
</title>
124 <required>true
</required>
126 <comment>Permission that Contact A has to view/update Contact B
</comment>
129 <callback>CRM_Core_SelectValues::getPermissionedRelationshipOptions
</callback>
136 <name>is_permission_b_a
</name>
137 <type>int unsigned
</type>
138 <title>Contact B has Permission Over Contact A
</title>
139 <required>true
</required>
141 <comment>Permission that Contact B has to view/update Contact A
</comment>
144 <callback>CRM_Core_SelectValues::getPermissionedRelationshipOptions
</callback>
152 <type>int unsigned
</type>
153 <title>Relationship Case
</title>
154 <default>NULL
</default>
155 <comment>FK to civicrm_case
</comment>
160 <table>civicrm_case
</table>
163 <onDelete>CASCADE
</onDelete>