contact_consent_events


Description

A row in this table represents the candidate’s permission \(or denial\) to various data retention and use actions \(like sending emails, storing personal data etc…\). Candidates are Data Subjects within GDPR, these events helps you track your compliance with GDPR related rules \(if they apply to your business\).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
contact_id varchar 2147483647 null
contacts.contact_id contacts_consent_events_contact_id_fkeyN

ID of the contact that represents the personal information of a candidate independent from opportunities.
contact_consent_event_id varchar 2147483647 null
contact_consent_event_enum.contact_consent_event_id contacts_consent_events_contact_consent_event_id_fkeyN

ID of the value that the consent was updated to.
event_at timestamp 29,6 null

Date and time when the event occurred.
user_id varchar 2147483647 √ null
users.user_id contacts_consent_events_user_id_fkeyN

ID of the user.
account_id varchar 2147483647 null

ID of the account the record belongs to.
event_date_id varchar 2147483647 √ null
dates.date_id contacts_consent_events_event_date_id_fkeyN

ID of the date and time when the event occurred. It’s used in combination with the datetime dimension table to simplify the creation of temporal queries.
created_at timestamp 29,6 √ null

Date the object referred to in this entity was created.
row_updated_at timestamp 29,6 √ CURRENT_TIMESTAMP

Date this entity was updated in the database. Useful to setup incremental refreshes of the data in your periodic ETL job.
event_key varchar 2147483647 null
contact_consent_activity_id varchar 2147483647 √ null
contact_consent_activity_enum.contact_consent_activity_id Implied ConstraintR

The data usage activity related to this contact consent event.
contact_consent_status_id varchar 2147483647 √ null
contact_consent_status_enum.contact_consent_status_id Implied ConstraintR

The status of the data usage activity related to this contact consent event.
previous_contact_consent_status_id varchar 2147483647 √ null
contact_consent_status_enum.contact_consent_status_id Implied ConstraintR

The previous status of the data usage activity related to this contact consent event.
previous_event_at timestamp 29,6 √ null

Date and time of the previous event for the same contact_consent_activity_id and contact_id, or the creation of the contact.
next_event_at timestamp 29,6 √ null

Date and time of the next event for the contact_consent_activity_id and contact_id. Is 9999-09-09T12:00:00Z if last event.

Indexes

Constraint Name Type Sort Column(s)
contact_consent_events_pkey Primary key Asc event_key
contact_consent_events_contact_id_idx Performance Asc contact_id
contact_consent_events_user_id_idx Performance Asc user_id
contacts_consent_events_account_id_index Performance Asc account_id

Relationships

Close relationships within degrees of separation