survey_response_answers


Description

A row in this table represents an answer to a specific question on a specific survey.

Columns

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

ID of the question connected to this answer.

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_answers_survey_response_id_fkeyN

ID of the survey response associated with this entity.

question_index int4 10 null

The numeric order of the question in the survey, starting with 0.

question_text varchar 2147483647 null

The text of the question as displayed when the survey was filled out.

question_type varchar 2147483647 null

The type of survey question.

answer_index numeric 131089 null

used to indicate the order in the case of multiple selections being possible.

answer varchar 2147483647 null

The value of the answer selected by the survey taker.

created_at timestamp 29,6 null

Date the object referred to in this entity was created.

survey_response_answer_id varchar 2147483647 null

Primary key.

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_answers_pkey Primary key Asc survey_response_answer_id
survey_response_answers_account_id_index Performance Asc account_id

Relationships