Merge pull request #19525 from eileenmcnaughton/member_soft
[civicrm-core.git] / xml / schema / Mailing / Event / Forward.xml
CommitLineData
6a488035
TO
1<?xml version="1.0" encoding="iso-8859-1" ?>
2
3<table>
5435b737
EM
4 <base>CRM/Mailing/Event</base>
5 <class>Forward</class>
6 <name>civicrm_mailing_event_forward</name>
7 <comment>Tracks when a contact forwards a mailing to a (new) contact</comment>
8 <archive>true</archive>
d31fb4e3 9 <component>CiviMail</component>
65efffdd
ML
10 <title>Mailing Forwarded Event</title>
11 <titlePlural>Mailing Forwarded Events</titlePlural>
5435b737
EM
12 <field>
13 <name>id</name>
f3ea5182 14 <title>Forward ID</title>
5435b737
EM
15 <type>int unsigned</type>
16 <required>true</required>
0481e12c
A
17 <html>
18 <type>Number</type>
19 </html>
5435b737
EM
20 </field>
21 <primaryKey>
22 <name>id</name>
23 <autoincrement>true</autoincrement>
24 </primaryKey>
25 <field>
26 <name>event_queue_id</name>
047c5009 27 <title>Event Queue ID</title>
5435b737
EM
28 <type>int unsigned</type>
29 <required>true</required>
30 <comment>FK to EventQueue</comment>
57e94608 31 <html>
047c5009 32 <label>Event Queue</label>
57e94608 33 </html>
5435b737
EM
34 </field>
35 <foreignKey>
36 <name>event_queue_id</name>
37 <table>civicrm_mailing_event_queue</table>
38 <key>id</key>
39 <onDelete>CASCADE</onDelete>
40 </foreignKey>
41 <field>
42 <name>dest_queue_id</name>
57e94608 43 <title>Destination Queue ID</title>
5435b737
EM
44 <type>int unsigned</type>
45 <comment>FK to EventQueue for destination</comment>
57e94608
A
46 <html>
47 <label>Destination Queue</label>
48 </html>
5435b737
EM
49 </field>
50 <foreignKey>
51 <name>dest_queue_id</name>
52 <table>civicrm_mailing_event_queue</table>
53 <key>id</key>
54 <onDelete>SET NULL</onDelete>
55 </foreignKey>
56 <field>
57 <name>time_stamp</name>
f3ea5182 58 <title>Timestamp</title>
4387c66f 59 <type>timestamp</type>
60 <default>CURRENT_TIMESTAMP</default>
5435b737
EM
61 <required>true</required>
62 <comment>When this forward event occurred.</comment>
63 </field>
6a488035 64</table>