Fivetran documentation

Search the docs

/

SurveyMonkey

Explore the interactive ERD

Table & Field Reference

contact

Column	Type	Keys
`id`	String	PK
`email`	String
`first_name`	String
`last_name`	String
`phone_number`	String

response_answer

Column	Type	Keys
`index`	Long	PK
`question_id`	String	PKFK
`response_id`	String	PKFK
`response_page_id`	String	PKFK
`choice_id`	String
`col_id`	String
`content_type`	String
`download_url`	String
`other_id`	String
`row_id`	String
`tag_data`	Json
`text`	String

response_history

Column	Type	Keys
`id`	String	PK
`collector_id`	String	FK
`recipient_id`	String	FK
`survey_id`	String	FK
`collection_mode`	String
`created_at`	Instant
`custom_value`	String
`ip_address`	String
`response_status`	String
`total_time`	Long
`updated_at`	Instant

recipient

Column	Type	Keys
`id`	String	PK
`message_id`	String	FK
`email`	String
`mail_status`	String
`phone_number`	String
`remove_link`	String
`survey_link`	String
`survey_response_status`	String

survey_history

Column	Type	Keys
`id`	String	PK
`category_id`	String	FK
`folder_id`	String	FK
`analyze_url`	String
`collect_url`	String
`created_at`	Instant
`edit_url`	String
`footer`	Boolean
`href`	String
`is_owner`	Boolean
`language`	String
`nickname`	String
`page_count`	Int
`preview`	String
`question_count`	Int
`response_count`	Int
`summary_url`	String
`title`	String
`updated_at`	Instant
`buttons_text_`

question_option_history

Column	Type	Keys
`position`	Int	PK
`question_id`	String	PKFK
`description`	String
`id`	String
`is_na`	Boolean
`quiz_option_score`	Int
`text`	String
`visible`	Boolean
`weight`	Int

sub_question_history

Column	Type	Keys
`position`	Int	PK
`question_id`	String	PKFK
`id`	String
`required`	Boolean
`text`	String
`type`	String
`visible`	Boolean

contact_list_contact

Column	Type	Keys
`contact_id`	String	PKFK
`contact_list_id`	String	PKFK

survey_page_history

Column	Type	Keys
`id`	String	PK
`survey_id`	String	FK
`description`	String
`href`	String
`position`	Long
`question_count`	Int
`title`	String

message

Column	Type	Keys
`id`	String	PK
`collector_id`	String	FK
`body`	String
`created_at`	Instant
`embed_first_question`	Boolean
`is_branding_enabled`	Boolean
`is_scheduled`	Boolean
`recipient_status`	String
`scheduled_date`	Instant
`status`	String
`subject`	String
`type`	String

question_history

Column	Type	Keys
`id`	String	PK
`survey_page_id`	String	PKFK
`family`	String
`forced_ranking`	Boolean
`position`	Long
`required_amount`	String
`required_text`	String
`required_type`	String
`sorting_ignore_last`	Boolean
`sorting_type`	String
`structure_metadata`	Json
`subtype`	String
`visible`	Boolean
`validation_`

collector

Column	Type	Keys
`id`	String	PK
`survey_id`	String	FK
`allow_multiple_responses`	Boolean
`anonymous_type`	String
`border_color`	String
`close_date`	Instant
`closed_page_message`	String
`created_at`	Instant
`display_survey_results`	Boolean
`disqualification_message`	String
`disqualification_url`	String
`edit_response_type`	String
`headline`	String
`height`	Int
`is_branding_enabled`	Boolean
`message`	String
`name`	String
`password_enabled`	Boolean
`primary_button_bg_color`	String
`primary_button_text`	String
`primary_button_text_color`	String
`redirect_type`	String
`redirect_url`	String
`sample_rate`	String
`secondary_button_bg_color`	String
`secondary_button_text`	String
`secondary_button_text_color`	String
`sender_email`	String
`status`	String
`thank_you_message`	String
`type`	String
`updated_at`	Instant
`url`	String
`width`	Int

contact_list

Column	Type	Keys
`id`	String	PK
`name`	String

response_page

Column	Type	Keys
`id`	String	PK
`response_id`	String	PKFK

survey_folder

Column	Type	Keys
`id`	String	PK
`title`	String

question_heading_history

Column	Type	Keys
`index`	Long	PK
`question_id`	String	PKFK
`description`	String
`heading`	String
`image_url`	String
`random_assignment_`

survey_category

Column	Type	Keys
`id`	String	PK
`name`	String