civicrm_mailing_event_subscribe

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
civicrm_mailing_event_confirm.event_subscribe_id FK_civicrm_mailing_event_confirm_event_subscribe_idC
group_id INT UNSIGNED 10 null
civicrm_group.id FK_civicrm_mailing_event_subscribe_group_idC

FK to Group
contact_id INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_mailing_event_subscribe_contact_idC

FK to Contact
hash VARCHAR 255 null

Security hash
time_stamp TIMESTAMP 19 √ CURRENT_TIMESTAMP

When this subscription event occurred.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_mailing_event_subscribe_contact_id Performance Asc contact_id
FK_civicrm_mailing_event_subscribe_group_id Performance Asc group_id

Relationships

Close relationships within degrees of separation