1 <?xml version=
"1.0" encoding=
"utf-8" ?>
4 <class>CaseActivity
</class>
5 <name>civicrm_case_activity
</name>
6 <comment>Joining table for case-activity associations.
</comment>
9 <component>CiviCase
</component>
12 <title>Case Activity ID
</title>
13 <type>int unsigned
</type>
14 <required>true
</required>
15 <comment>Unique case-activity association id
</comment>
23 <autoincrement>true
</autoincrement>
27 <title>Case ID
</title>
28 <type>int unsigned
</type>
29 <required>true
</required>
30 <comment>Case ID of case-activity association.
</comment>
38 <table>civicrm_case
</table>
41 <onDelete>CASCADE
</onDelete>
44 <name>activity_id
</name>
45 <title>Activity ID
</title>
46 <type>int unsigned
</type>
47 <required>true
</required>
48 <comment>Activity ID of case-activity association.
</comment>
50 <label>Activity
</label>
55 <name>activity_id
</name>
56 <table>civicrm_activity
</table>
59 <onDelete>CASCADE
</onDelete>
62 <name>UI_case_activity_id
</name>
63 <fieldName>case_id
</fieldName>
64 <fieldName>activity_id
</fieldName>