1 <?xml version=
"1.0" encoding=
"utf-8" ?>
3 <base>CRM/Activity
</base>
4 <class>ActivityTarget
</class>
5 <name>civicrm_activity_target
</name>
6 <comment>Activity targets
</comment>
11 <type>int unsigned
</type>
12 <title>Activity Target ID
</title>
13 <required>true
</required>
14 <comment>Activity target id
</comment>
19 <autoincrement>true
</autoincrement>
22 <name>activity_id
</name>
23 <type>int unsigned
</type>
24 <title>Activity ID
</title>
25 <required>true
</required>
26 <comment>Foreign key to the activity for this target.
</comment>
30 <name>activity_id
</name>
31 <table>civicrm_activity
</table>
34 <onDelete>CASCADE
</onDelete>
38 <name>target_contact_id
</name>
39 <title>Contact ID (match to contact)
</title>
41 <type>int unsigned
</type>
42 <required>true
</required>
43 <comment>Foreign key to the contact for this target.
</comment>
47 <name>target_contact_id
</name>
48 <table>civicrm_contact
</table>
51 <onDelete>CASCADE
</onDelete>
55 <name>UI_activity_target_contact_id
</name>
56 <fieldName>target_contact_id
</fieldName>
57 <fieldName>activity_id
</fieldName>