1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
6 <name>civicrm_user_job
</name>
7 <comment>Tracking for user jobs (eg. imports).
</comment>
12 <title>User Job ID
</title>
13 <type>int unsigned
</type>
14 <required>true
</required>
15 <comment>Job ID
</comment>
23 <autoincrement>true
</autoincrement>
27 <title>User job name
</title>
30 <comment>Unique name for job.
</comment>
35 <fieldName>name
</fieldName>
40 <name>created_id
</name>
41 <type>int unsigned
</type>
42 <title>Created By Contact ID
</title>
43 <comment>FK to contact table.
</comment>
45 <label>Created By
</label>
50 <name>created_id
</name>
51 <table>civicrm_contact
</table>
54 <onDelete>SET NULL
</onDelete>
57 <name>created_date
</name>
58 <type>timestamp
</type>
59 <default>CURRENT_TIMESTAMP
</default>
60 <required>true
</required>
61 <title>Import Job Created Date
</title>
62 <readonly>true
</readonly>
63 <comment>Date and time this job was created.
</comment>
66 <type>Select Date
</type>
67 <formatType>activityDateTime
</formatType>
71 <name>start_date
</name>
72 <type>timestamp
</type>
73 <required>false
</required>
74 <title>Import Job Started Date
</title>
75 <comment>Date and time this import job started.
</comment>
78 <type>Select Date
</type>
79 <formatType>activityDateTime
</formatType>
81 <readonly>true
</readonly>
85 <type>timestamp
</type>
86 <required>false
</required>
87 <title>Job Ended Date
</title>
88 <comment>Date and time this import job ended.
</comment>
91 <type>Select Date
</type>
92 <formatType>activityDateTime
</formatType>
96 <name>expires_date
</name>
97 <type>timestamp
</type>
98 <required>false
</required>
99 <title>Import Job Expires Date
</title>
100 <comment>Date and time to clean up after this import job (temp table deletion date).
</comment>
103 <type>Select Date
</type>
104 <formatType>activityDateTime
</formatType>
108 <name>status_id
</name>
109 <title>User Job Status ID
</title>
110 <type>int unsigned
</type>
111 <required>true
</required>
113 <label>Job Status
</label>
116 <callback>CRM_Core_BAO_UserJob::getStatuses
</callback>
122 <title>User Job Type ID
</title>
123 <type>int unsigned
</type>
124 <required>true
</required>
126 <label>Job Type
</label>
129 <callback>CRM_Core_BAO_UserJob::getTypes
</callback>
134 <name>queue_id
</name>
135 <title>Queue ID
</title>
136 <type>int unsigned
</type>
137 <comment>FK to Queue
</comment>
143 <name>queue_id
</name>
144 <table>civicrm_queue
</table>
146 <onDelete>SET NULL
</onDelete>
149 <name>metadata
</name>
151 <title>Job metadata
</title>
152 <comment>Data pertaining to job configuration
</comment>
153 <serialize>JSON
</serialize>