civicrm_mailing_event_subscribe

Columns

Related columns Constraint Comments

Search:

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.

Showing 1 to 5 of 5 entries

Indexes

Search:

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

Showing 1 to 3 of 3 entries

Relationships

Close relationships within degrees of separation

One
Two degrees