civicrm_mailing_event_subscribe


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_id C
group_id INT UNSIGNED 10 null
civicrm_group.id FK_civicrm_mailing_event_subscribe_group_id C

FK to Group

contact_id INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_mailing_event_subscribe_contact_id C

FK to Contact

hash VARCHAR 255 null

Security hash

time_stamp DATETIME 19 null

When this subscription event occurred.

Table contained 0 rows

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