civicrm_mailing_event_queue


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_id C
civicrm_mailing_event_delivered.event_queue_id FK_civicrm_mailing_event_delivered_event_queue_id C
civicrm_mailing_event_forward.dest_queue_id FK_civicrm_mailing_event_forward_dest_queue_id N
civicrm_mailing_event_forward.event_queue_id FK_civicrm_mailing_event_forward_event_queue_id C
civicrm_mailing_event_opened.event_queue_id FK_civicrm_mailing_event_opened_event_queue_id C
civicrm_mailing_event_reply.event_queue_id FK_civicrm_mailing_event_reply_event_queue_id C
civicrm_mailing_event_trackable_url_open.event_queue_id FK_civicrm_mailing_event_trackable_url_open_event_queue_id C
civicrm_mailing_event_unsubscribe.event_queue_id FK_civicrm_mailing_event_unsubscribe_event_queue_id C
job_id INT UNSIGNED 10 null
civicrm_mailing_job.id FK_civicrm_mailing_event_queue_job_id C

FK to Job

email_id INT UNSIGNED 10 null
civicrm_email.id FK_civicrm_mailing_event_queue_email_id N

FK to Email

contact_id INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_mailing_event_queue_contact_id C

FK to Contact

hash VARCHAR 255 null

Security hash

phone_id INT UNSIGNED 10 null
civicrm_phone.id FK_civicrm_mailing_event_queue_phone_id N

FK to Phone

Table contained 0 rows

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