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>
23 <autoincrement>true
</autoincrement>
26 <name>contact_id
</name>
27 <title>Contact ID
</title>
28 <type>int unsigned
</type>
29 <required>true
</required>
30 <comment>Contact ID
</comment>
32 <label>Contact
</label>
37 <name>contact_id
</name>
38 <table>civicrm_contact
</table>
41 <onDelete>CASCADE
</onDelete>
45 <title>Group ID
</title>
46 <type>int unsigned
</type>
47 <comment>Group ID
</comment>
50 <table>civicrm_group
</table>
51 <keyColumn>id
</keyColumn>
52 <labelColumn>title
</labelColumn>
61 <table>civicrm_group
</table>
64 <onDelete>CASCADE
</onDelete>
68 <title>Group Membership Action Date
</title>
69 <type>timestamp
</type>
70 <required>true
</required>
71 <default>CURRENT_TIMESTAMP
</default>
72 <comment>Date of the (un)subscription
</comment>
77 <title>Group Membership Action
</title>
80 <comment>How the (un)subscription was triggered
</comment>
82 <callback>CRM_Core_SelectValues::getSubscriptionHistoryMethods
</callback>
91 <title>Group Membership Status
</title>
94 <comment>The state of the contact within the group
</comment>
96 <callback>CRM_Core_SelectValues::groupContactStatus
</callback>
101 <name>tracking
</name>
102 <title>Group Membership Tracking
</title>
105 <comment>IP address or other tracking info
</comment>