1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
4 <base>CRM/Contact
</base>
5 <class>SubscriptionHistory
</class>
6 <name>civicrm_subscription_history
</name>
7 <comment>History information of subscribe/unsubscribe actions
</comment>
12 <title>Group Membership History ID
</title>
13 <type>int unsigned
</type>
14 <required>true
</required>
15 <comment>Internal Id
</comment>
20 <autoincrement>true
</autoincrement>
23 <name>contact_id
</name>
24 <title>Contact ID
</title>
25 <type>int unsigned
</type>
26 <required>true
</required>
27 <comment>Contact Id
</comment>
31 <name>contact_id
</name>
32 <table>civicrm_contact
</table>
35 <onDelete>CASCADE
</onDelete>
40 <type>int unsigned
</type>
41 <comment>Group Id
</comment>
44 <table>civicrm_group
</table>
45 <keyColumn>id
</keyColumn>
46 <labelColumn>title
</labelColumn>
54 <table>civicrm_group
</table>
57 <onDelete>CASCADE
</onDelete>
61 <title>Group Membership Action Date
</title>
63 <required>true
</required>
64 <comment>Date of the (un)subscription
</comment>
69 <title>Group Membership Action
</title>
72 <comment>How the (un)subscription was triggered
</comment>
74 <callback>CRM_Core_SelectValues::getSubscriptionHistoryMethods
</callback>
83 <title>Group Membership Status
</title>
86 <comment>The state of the contact within the group
</comment>
88 <callback>CRM_Core_SelectValues::groupContactStatus
</callback>
94 <title>Group Membership Tracking
</title>
97 <comment>IP address or other tracking info
</comment>