Fivetran documentation

Search the docs

/

Survicate

Explore the interactive ERD

Table & Field Reference

question_answer_choice

Column	Type	Keys
`id`	Unknown	PK
`question_id`	Unknown	PKFK
`survey_id`	Unknown	PKFK
`content`	Unknown

question

Column	Type	Keys
`id`	Unknown	PK
`survey_id`	Unknown	PKFK
`introduction`	Unknown
`question`	Unknown
`type`	Unknown

response

Column	Type	Keys
`uuid`	Unknown	PK
`survey_id`	Unknown	FK
`collected_at`	Unknown
`device_type`	Unknown
`languages`	Unknown
`operating_system`	Unknown
`respondent_attributes`	Json
`respondent_uuid`	Unknown
`url`	Unknown

nps_response

Column	Type	Keys
`question_id`	Unknown	PK
`response_uuid`	Unknown	PKFK
`survey_id`	Unknown	FK
`answer_content`	Unknown
`answer_tag`	Unknown

text_response

Column	Type	Keys
`question_id`	Unknown	PK
`response_uuid`	Unknown	PKFK
`survey_id`	Unknown	FK
`answer`	Unknown

smiley_scale_response

Column	Type	Keys
`question_id`	Unknown	PK
`response_uuid`	Unknown	PKFK
`survey_id`	Unknown	FK
`answer_content`	Unknown
`answer_id`	Unknown
`answer_rating`	Unknown

ranking_response

Column	Type	Keys
`answer_id`	Unknown	PK
`question_id`	Unknown	PK
`response_uuid`	Unknown	PK
`answer_content`	Unknown
`answer_rank`	Unknown
`survey_id`	Unknown

form_response

Column	Type	Keys
`_fivetran_id`	String	PK
`response_uuid`	Unknown	FK
`survey_id`	Unknown	FK
`field_content`	Unknown
`field_type`	Unknown
`question_id`	Unknown

button_next_response

Column	Type	Keys
`question_id`	Unknown	PK
`response_uuid`	Unknown	PKFK
`survey_id`	Unknown	FK
`action_performed`	Unknown

empty_response

Column	Type	Keys
`question_id`	Unknown	PK
`response_uuid`	Unknown	PKFK
`survey_id`	Unknown	FK
`action_performed`	Unknown

single_response

Column	Type	Keys
`answer_id`	Unknown	PK
`question_id`	Unknown	PK
`response_uuid`	Unknown	PKFK
`survey_id`	Unknown	FK
`answer_comment`	Unknown
`answer_content`	Unknown

numerical_scale_response

Column	Type	Keys
`question_id`	Unknown	PK
`response_uuid`	Unknown	PKFK
`survey_id`	Unknown	FK
`answer_comment`	Unknown
`answer_content`	Unknown
`answer_disclaimer_accepted`	Unknown
`answer_id`	Unknown
`answer_rating`	Unknown
`answer_translated_comment`	Unknown

matrix_response

Column	Type	Keys
`answer_id`	Unknown	PK
`question_id`	Unknown	PK
`response_uuid`	Unknown	PK
`answer_content`	Unknown
`answer_score`	Unknown
`survey_id`	Unknown

rating_response

Column	Type	Keys
`question_id`	Unknown	PK
`response_uuid`	Unknown	PKFK
`survey_id`	Unknown	FK
`answer_content`	Unknown
`answer_id`	Unknown
`answer_rating`	Unknown

date_response

Column	Type	Keys
`question_id`	Unknown	PK
`response_uuid`	Unknown	PKFK
`survey_id`	Unknown	FK
`answer`	Unknown

multiple_response

Column	Type	Keys
`answer_id`	Unknown	PK
`question_id`	Unknown	PK
`response_uuid`	Unknown	PKFK
`survey_id`	Unknown	FK
`answer_comment`	Unknown
`answer_content`	Unknown
`question_type`	Unknown

dropdown_response

Column	Type	Keys
`answer_id`	Unknown	PK
`question_id`	Unknown	PK
`response_uuid`	Unknown	PKFK
`survey_id`	Unknown	FK
`answer_comment`	Unknown
`answer_content`	Unknown

survey

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`enabled`	Unknown
`launch_end_at`	Unknown
`launch_response_limit`	Unknown
`launch_start_at`	Unknown
`name`	Unknown
`response`	Unknown
`type`	Unknown

respondent_attribute

Column	Type	Keys
`id`	Unknown	PK
`name`	Unknown
`response_respondent_uuid`	Unknown
`value`	Unknown