civicrm_mailing_spool

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
job_id INT UNSIGNED 10 null
civicrm_mailing_job.id FK_civicrm_mailing_spool_job_idC

The ID of the Job .

recipient_email TEXT 65535 null

The email of the receipients this mail is to be sent.

headers TEXT 65535 null

The header information of this mailing .

body TEXT 65535 null

The body of this mailing.

added_at TIMESTAMP 19 null

date on which this job was added.

removed_at TIMESTAMP 19 null

date on which this job was removed.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_mailing_spool_job_id Performance Asc job_id

Relationships