civicrm_mailing_recipients

0 rows


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_idC

The ID of the mailing this Job will send.
contact_id INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_mailing_recipients_contact_idC

FK to Contact
email_id INT UNSIGNED 10 √ null
civicrm_email.id FK_civicrm_mailing_recipients_email_idN

FK to Email
phone_id INT UNSIGNED 10 √ null
civicrm_phone.id FK_civicrm_mailing_recipients_phone_idN

FK to Phone

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

Close relationships within degrees of separation