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 <type>int unsigned
</type>
13 <required>true
</required>
14 <comment>Internal Id
</comment>
19 <autoincrement>true
</autoincrement>
22 <name>contact_id
</name>
23 <type>int unsigned
</type>
24 <required>true
</required>
25 <comment>Contact Id
</comment>
29 <name>contact_id
</name>
30 <table>civicrm_contact
</table>
33 <onDelete>CASCADE
</onDelete>
37 <type>int unsigned
</type>
38 <comment>Group Id
</comment>
41 <table>civicrm_group
</table>
42 <keyColumn>id
</keyColumn>
43 <labelColumn>title
</labelColumn>
51 <table>civicrm_group
</table>
54 <onDelete>CASCADE
</onDelete>
59 <required>true
</required>
60 <comment>Date of the (un)subscription
</comment>
67 <comment>How the (un)subscription was triggered
</comment>
69 <callback>CRM_Core_SelectValues::getSubscriptionHistoryMethods
</callback>
80 <comment>The state of the contact within the group
</comment>
82 <callback>CRM_Core_SelectValues::groupContactStatus
</callback>
90 <comment>IP address or other tracking info
</comment>