Table d47civi_0z3xa.civicrm_mailing_spool 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  √ 
job_id int unsigned 10
civicrm_mailing_job.id FK_civicrm_mailing_spool_job_id C
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 datetime 19  √  null date on which this job was added.
removed_at datetime 19  √  null date on which this job was removed.

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

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

Close relationships  within of separation: