civicrm_subscription_history - civicrm Database

Columns

Related columns Constraint Comments

Search:

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

Showing 1 to 7 of 7 entries

Indexes

Search:

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

Showing 1 to 3 of 3 entries

Relationships

Close relationships within degrees of separation

One
Two degrees