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>
43 <table>civicrm_group
</table>
46 <onDelete>CASCADE
</onDelete>
51 <required>true
</required>
52 <comment>Date of the (un)subscription
</comment>
58 <values>Admin, Email, Web, API
</values>
59 <comment>How the (un)subscription was triggered
</comment>
65 <values>Added, Removed, Pending, Deleted
</values>
66 <comment>The state of the contact within the group
</comment>
73 <comment>IP address or other tracking info
</comment>