1 <?xml version=
"1.0" encoding=
"utf-8" ?>
3 <base>CRM/Activity
</base>
4 <class>ActivityAssignment
</class>
5 <name>civicrm_activity_assignment
</name>
6 <comment>Activity assignments
</comment>
11 <type>int unsigned
</type>
12 <title>Activity Assignment ID
</title>
13 <required>true
</required>
14 <comment>Activity assignment id
</comment>
19 <autoincrement>true
</autoincrement>
23 <name>activity_entity_table
</name>
26 <required>true
</required>
27 <comment>Name of table where item being referenced is stored (activity, phonecall or meeting).
</comment>
33 <name>activity_entity_id
</name>
34 <type>int unsigned
</type>
35 <required>true
</required>
36 <comment>Entity (activity, phonecall or meeting) id for which the assigment is created
</comment>
42 <idColumn>activity_entity_id
</idColumn>
43 <typeColumn>activity_entity_table
</typeColumn>
49 <name>target_entity_table
</name>
52 <required>true
</required>
53 <comment>Name of table where item being referenced is stored (contact assigned to given activity).
</comment>
59 <name>target_entity_id
</name>
60 <type>int unsigned
</type>
61 <required>true
</required>
62 <comment>Foreign key to the referenced item.
</comment>
68 <idColumn>target_entity_id
</idColumn>
69 <typeColumn>target_entity_table
</typeColumn>
75 <name>activity_id
</name>
76 <type>int unsigned
</type>
77 <title>Activity ID
</title>
78 <required>true
</required>
79 <comment>Foreign key to the activity for this assignment.
</comment>
83 <name>activity_id
</name>
84 <table>civicrm_activity
</table>
87 <onDelete>CASCADE
</onDelete>
91 <name>assignee_contact_id
</name>
92 <type>int unsigned
</type>
93 <title>Assignee Contact ID
</title>
94 <required>true
</required>
95 <comment>Foreign key to the contact for this assignment.
</comment>
99 <name>assignee_contact_id
</name>
100 <table>civicrm_contact
</table>
103 <onDelete>CASCADE
</onDelete>
107 <name>UI_activity_assignee_contact_id
</name>
108 <fieldName>assignee_contact_id
</fieldName>
109 <fieldName>activity_id
</fieldName>
110 <unique>true
</unique>