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>
28 <type>int unsigned
</type>
29 <required>true
</required>
30 <comment>Case ID of case-activity association.
</comment>
35 <table>civicrm_case
</table>
38 <onDelete>CASCADE
</onDelete>
41 <name>activity_id
</name>
42 <title>Activity ID
</title>
43 <type>int unsigned
</type>
44 <required>true
</required>
45 <comment>Activity ID of case-activity association.
</comment>
49 <name>activity_id
</name>
50 <table>civicrm_activity
</table>
53 <onDelete>CASCADE
</onDelete>
56 <name>UI_case_activity_id
</name>
57 <fieldName>case_id
</fieldName>
58 <fieldName>activity_id
</fieldName>