civicrm_subscription_history

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null

Internal Id

contact_id INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_subscription_history_contact_idC

Contact Id

group_id INT UNSIGNED 10 null
civicrm_group.id FK_civicrm_subscription_history_group_idC

Group Id

date TIMESTAMP 19 CURRENT_TIMESTAMP

Date of the (un)subscription

method VARCHAR 8 null

How the (un)subscription was triggered

status VARCHAR 8 null

The state of the contact within the group

tracking VARCHAR 255 null

IP address or other tracking info

Indexes

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

Relationships