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>
12 <type>int unsigned
</type>
13 <title>Relationship ID
</title>
14 <required>true
</required>
15 <comment>Relationship ID
</comment>
20 <autoincrement>true
</autoincrement>
23 <name>contact_id_a
</name>
24 <type>int unsigned
</type>
25 <title>Contact A
</title>
26 <required>true
</required>
27 <comment>id of the first contact
</comment>
31 <name>contact_id_a
</name>
32 <table>civicrm_contact
</table>
35 <onDelete>CASCADE
</onDelete>
38 <name>contact_id_b
</name>
39 <type>int unsigned
</type>
40 <title>Contact B
</title>
41 <required>true
</required>
42 <comment>id of the second contact
</comment>
45 <type>EntityRef
</type>
49 <name>contact_id_b
</name>
50 <table>civicrm_contact
</table>
53 <onDelete>CASCADE
</onDelete>
56 <name>relationship_type_id
</name>
57 <type>int unsigned
</type>
58 <title>Relationship Type
</title>
59 <required>true
</required>
60 <comment>id of the relationship
</comment>
67 <name>relationship_type_id
</name>
68 <table>civicrm_relationship_type
</table>
71 <onDelete>CASCADE
</onDelete>
74 <name>start_date
</name>
76 <title>Relationship Start Date
</title>
77 <comment>date when the relationship started
</comment>
80 <type>Select Date
</type>
81 <formatType>activityDate
</formatType>
87 <title>Relationship End Date
</title>
88 <comment>date when the relationship ended
</comment>
91 <type>Select Date
</type>
92 <formatType>activityDate
</formatType>
96 <name>is_active
</name>
98 <title>Relationship Is Active
</title>
100 <comment>is the relationship active ?
</comment>
103 <type>CheckBox
</type>
107 <name>description
</name>
109 <title>Relationship Description
</title>
111 <comment>Optional verbose description for the relationship.
</comment>
118 <name>is_permission_a_b
</name>
119 <type>int unsigned
</type>
120 <title>Contact A has Permission Over Contact B
</title>
121 <required>true
</required>
123 <comment>Permission that Contact A has to view/update Contact B
</comment>
126 <callback>CRM_Core_SelectValues::getPermissionedRelationshipOptions
</callback>
133 <name>is_permission_b_a
</name>
134 <type>int unsigned
</type>
135 <title>Contact B has Permission Over Contact A
</title>
136 <required>true
</required>
138 <comment>Permission that Contact B has to view/update Contact A
</comment>
141 <callback>CRM_Core_SelectValues::getPermissionedRelationshipOptions
</callback>
149 <type>int unsigned
</type>
150 <title>Relationship Case
</title>
151 <default>NULL
</default>
152 <comment>FK to civicrm_case
</comment>
157 <table>civicrm_case
</table>
160 <onDelete>CASCADE
</onDelete>