Table d47civi_0z3xa.civicrm_mailing_job Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int unsigned 10  √ 
civicrm_mailing_event_queue.job_id FK_civicrm_mailing_event_queue_job_id C
civicrm_mailing_job.parent_id FK_civicrm_mailing_job_parent_id C
civicrm_mailing_spool.job_id FK_civicrm_mailing_spool_job_id C
mailing_id int unsigned 10
civicrm_mailing.id FK_civicrm_mailing_job_mailing_id C
The ID of the mailing this Job will send.
scheduled_date datetime 19  √  null date on which this job was scheduled.
start_date datetime 19  √  null date on which this job was started.
end_date datetime 19  √  null date on which this job ended.
status varchar 12  √  null The state of this job
is_test tinyint 3  √  0 Is this job for a test mail?
job_type varchar 255  √  null Type of mailling job: null | child
parent_id int unsigned 10  √  null
civicrm_mailing_job.id FK_civicrm_mailing_job_parent_id C
Parent job id
job_offset int 10  √  0 Offset of the child job
job_limit int 10  √  0 Queue size limit for each child job

Table contained 0 rows at mer. avr. 13 16:52 EDT 2016

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
mailing_id Performance Asc FK_civicrm_mailing_job_mailing_id
parent_id Performance Asc FK_civicrm_mailing_job_parent_id

Close relationships  within of separation: