civicrm_mailing_recipients


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
mailing_id INT UNSIGNED 10 null
civicrm_mailing.id FK_civicrm_mailing_recipients_mailing_id C

The ID of the mailing this Job will send.

contact_id INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_mailing_recipients_contact_id C

FK to Contact

email_id INT UNSIGNED 10 null
civicrm_email.id FK_civicrm_mailing_recipients_email_id N

FK to Email

phone_id INT UNSIGNED 10 null
civicrm_phone.id FK_civicrm_mailing_recipients_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_recipients_contact_id Performance Asc contact_id
FK_civicrm_mailing_recipients_email_id Performance Asc email_id
FK_civicrm_mailing_recipients_mailing_id Performance Asc mailing_id
FK_civicrm_mailing_recipients_phone_id Performance Asc phone_id

Relationships