<log>true</log>
<field>
<name>id</name>
+ <title>Group Membership History ID</title>
<type>int unsigned</type>
<required>true</required>
<comment>Internal Id</comment>
</primaryKey>
<field>
<name>contact_id</name>
+ <title>Contact ID</title>
<type>int unsigned</type>
<required>true</required>
<comment>Contact Id</comment>
</foreignKey>
<field>
<name>group_id</name>
+ <title>Group</title>
<type>int unsigned</type>
<comment>Group Id</comment>
<add>1.1</add>
</foreignKey>
<field>
<name>date</name>
+ <title>Group Membership Action Date</title>
<type>datetime</type>
<required>true</required>
<comment>Date of the (un)subscription</comment>
</field>
<field>
<name>method</name>
+ <title>Group Membership Action</title>
<type>varchar</type>
<length>8</length>
<comment>How the (un)subscription was triggered</comment>
</field>
<field>
<name>status</name>
+ <title>Group Membership Status</title>
<type>varchar</type>
<length>8</length>
<comment>The state of the contact within the group</comment>
</field>
<field>
<name>tracking</name>
+ <title>Group Membership Tracking</title>
<type>varchar</type>
<length>255</length>
<comment>IP address or other tracking info</comment>