data_requests


Description

A row in this table represents a request by a candidate for action to be taken on their data.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
data_request_id varchar 2147483647 null

Primary key.

contact_id varchar 2147483647 null
contacts.contact_id data_requests_contact_id_fkeyN

ID of the contact that represents the personal information of a candidate independent from opportunities.

account_id varchar 2147483647 null

ID of the account the record belongs to.

status varchar 2147483647 null

The current status of this data request

type varchar 2147483647 null

The type of data request \(e.g. update/access/delete the candidate’s data\)

opened_at timestamp 29,6 null

Date when the data opened

closed_at timestamp 29,6 null

Date when the data request was completed or closed

created_at timestamp 29,6 null

Date the object referred to in this entity was created.

is_deleted bool 1 false

TRUE if the source of data for the current entity has been deleted.

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.

assigned_user_id varchar 2147483647 null
users.user_id Implied ConstraintR

ID of the user assigned to fulfill the request

closed_by_user_id varchar 2147483647 null
users.user_id Implied ConstraintR

User ID of the user that completed or closed the request

Indexes

Constraint Name Type Sort Column(s)
data_requests_pkey Primary key Asc data_request_id
data_requests_account_id_index Performance Asc account_id

Relationships