survey_response_tracking


Description

A row in this table represents a key:value pair meant to hold dimensional information that we want to save at the time the survey was taken. For example, we could have “key:postingTeam”, “value:Engineering” to capture the fact that the postings was linked to the team “Engineering” when the respondent took the survey.

Columns

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

Primary key.

account_id varchar 2147483647 null

ID of the account the record belongs to.

survey_response_id varchar 2147483647 null
survey_responses.survey_response_id survey_response_tracking_survey_response_id_fkeyN

ID of the survey response associated with this entity.

tracking_index int4 10 null

The numeric order this tracking information appears on the survey response, starting with 0.

key varchar 2147483647 null

The tracking key used for this data.

value varchar 2147483647 null

The value of the tracking key if it is a string.

value_number numeric 131089 null

The value of the tracking key if it is a number.

value_timestamp timestamp 29,6 null

The value of the tracking key if it is a timestamp.

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.

Indexes

Constraint Name Type Sort Column(s)
survey_response_tracking_pkey Primary key Asc survey_response_tracking_id
survey_response_tracking_account_id_index Performance Asc account_id

Relationships