1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
4 <base>CRM/Mailing/Event
</base>
5 <class>Subscribe
</class>
6 <name>civicrm_mailing_event_subscribe
</name>
7 <comment>Tracks when a (new) contact subscribes to a group by email
</comment>
8 <archive>true
</archive>
11 <type>int unsigned
</type>
12 <required>true
</required>
16 <autoincrement>true
</autoincrement>
20 <type>int unsigned
</type>
21 <required>true
</required>
22 <comment>FK to Group
</comment>
24 <table>civicrm_group
</table>
25 <keyColumn>id
</keyColumn>
26 <labelColumn>title
</labelColumn>
34 <table>civicrm_group
</table>
36 <onDelete>CASCADE
</onDelete>
39 <name>contact_id
</name>
40 <type>int unsigned
</type>
41 <required>true
</required>
42 <comment>FK to Contact
</comment>
45 <name>contact_id
</name>
46 <table>civicrm_contact
</table>
48 <onDelete>CASCADE
</onDelete>
54 <required>true
</required>
55 <comment>Security hash
</comment>
58 <name>time_stamp
</name>
60 <required>true
</required>
61 <comment>When this subscription event occurred.
</comment>