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

Internal Id

contact_id INT UNSIGNED 10 null FK_civicrm_subscription_history_contact_id C

Contact Id

group_id INT UNSIGNED 10 null FK_civicrm_subscription_history_group_id C

Group Id

date DATETIME 19 null

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

Table contained 0 rows


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