CRM-13497 - getting there on main tables
[civicrm-core.git] / xml / schema / Mailing / MailingJob.xml
1 <?xml version="1.0" encoding="iso-8859-1" ?>
2
3 <table>
4 <base>CRM/Mailing</base>
5 <class>MailingJob</class>
6 <name>civicrm_mailing_job</name>
7 <comment>Stores information about the job that executes this mailing</comment>
8 <archive>true</archive>
9 <field>
10 <name>id</name>
11 <type>int unsigned</type>
12 <required>true</required>
13 </field>
14 <primaryKey>
15 <name>id</name>
16 <autoincrement>true</autoincrement>
17 </primaryKey>
18 <field>
19 <name>mailing_id</name>
20 <type>int unsigned</type>
21 <required>true</required>
22 <comment>The ID of the mailing this Job will send.</comment>
23 </field>
24 <foreignKey>
25 <name>mailing_id</name>
26 <table>civicrm_mailing</table>
27 <key>id</key>
28 <onDelete>CASCADE</onDelete>
29 </foreignKey>
30 <field>
31 <name>scheduled_date</name>
32 <type>datetime</type>
33 <comment>date on which this job was scheduled.</comment>
34 </field>
35 <field>
36 <name>start_date</name>
37 <type>datetime</type>
38 <comment>date on which this job was started.</comment>
39 </field>
40 <field>
41 <name>end_date</name>
42 <type>datetime</type>
43 <comment>date on which this job ended.</comment>
44 </field>
45 <field>
46 <name>status</name>
47 <type>enum</type>
48 <values>Scheduled, Running, Complete, Paused, Canceled</values>
49 <comment>The state of this job</comment>
50 <html>
51 <type>Select</type>
52 </html>
53 </field>
54 <field>
55 <name>is_test</name>
56 <type>boolean</type>
57 <default>0</default>
58 <comment>Is this job for a test mail?</comment>
59 <add>1.9</add>
60 </field>
61 <field>
62 <name>job_type</name>
63 <type>varchar</type>
64 <length>255</length>
65 <comment>Type of mailling job: null | child </comment>
66 <add>3.3</add>
67 </field>
68 <field>
69 <name>parent_id</name>
70 <type>int unsigned</type>
71 <comment>Parent job id</comment>
72 <default>NULL</default>
73 <add>3.3</add>
74 </field>
75 <foreignKey>
76 <name>parent_id</name>
77 <table>civicrm_mailing_job</table>
78 <key>id</key>
79 <onDelete>CASCADE</onDelete>
80 </foreignKey>
81 <field>
82 <name>job_offset</name>
83 <type>int</type>
84 <comment>Offset of the child job</comment>
85 <default>0</default>
86 <add>3.3</add>
87 </field>
88 <field>
89 <name>job_limit</name>
90 <type>int</type>
91 <comment>Queue size limit for each child job</comment>
92 <default>0</default>
93 <add>3.3</add>
94 </field>
95 </table>