civicrm_mailing_event_queue

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
civicrm_mailing_event_bounce.event_queue_id FK_civicrm_mailing_event_bounce_event_queue_idC
civicrm_mailing_event_delivered.event_queue_id FK_civicrm_mailing_event_delivered_event_queue_idC
civicrm_mailing_event_forward.dest_queue_id FK_civicrm_mailing_event_forward_dest_queue_idN
civicrm_mailing_event_forward.event_queue_id FK_civicrm_mailing_event_forward_event_queue_idC
civicrm_mailing_event_opened.event_queue_id FK_civicrm_mailing_event_opened_event_queue_idC
civicrm_mailing_event_reply.event_queue_id FK_civicrm_mailing_event_reply_event_queue_idC
civicrm_mailing_event_trackable_url_open.event_queue_id FK_civicrm_mailing_event_trackable_url_open_event_queue_idC
civicrm_mailing_event_unsubscribe.event_queue_id FK_civicrm_mailing_event_unsubscribe_event_queue_idC
job_id INT UNSIGNED 10 null
civicrm_mailing_job.id FK_civicrm_mailing_event_queue_job_idC

FK to Job
email_id INT UNSIGNED 10 √ null
civicrm_email.id FK_civicrm_mailing_event_queue_email_idN

FK to Email
contact_id INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_mailing_event_queue_contact_idC

FK to Contact
hash VARCHAR 255 null

Security hash
phone_id INT UNSIGNED 10 √ null
civicrm_phone.id FK_civicrm_mailing_event_queue_phone_idN

FK to Phone

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_mailing_event_queue_contact_id Performance Asc contact_id
FK_civicrm_mailing_event_queue_email_id Performance Asc email_id
FK_civicrm_mailing_event_queue_job_id Performance Asc job_id
FK_civicrm_mailing_event_queue_phone_id Performance Asc phone_id
index_hash Performance Asc hash

Relationships

Close relationships within degrees of separation