GetFeedback

Explore the interactive ERD

Table & Field Reference

survey_merge_key

Column	Type	Keys
`index`	Unknown	PK
`survey_id`	Unknown	PKFK
`merge_key`	Unknown

survey_enabled_language

Column	Type	Keys
`index`	Unknown	PK
`survey_id`	Unknown	PKFK
`languages`	Unknown

users

Column	Type	Keys
`id`	Unknown	PK
`card_expiration_date`	Unknown
`default_tab`	Unknown
`email`	Unknown
`has_invalid_card`	Unknown
`is_team_owner`	Unknown
`name`	Unknown
`permission`	Unknown
`source`	Unknown
`status`	Unknown
`team_id`	Unknown
`time_zone`	Unknown
`uuid`	Unknown

theme

Column	Type	Keys
`id`	Unknown	PK
`survey_id`	Unknown	PKFK
`answer_color`	Unknown
`background_color`	Unknown
`background_display`	Unknown
`background_image_brightness`	Unknown
`background_image_bucket_type`	Unknown
`background_image_id`	Unknown
`background_image_uploaded`	Unknown
`background_image_url`	Unknown
`background_image_url_256`	Unknown
`background_image_url_512`	Unknown
`background_image_url_768`	Unknown
`background_type`	Unknown
`button_color`	Unknown
`category`	Unknown
`font`	Unknown
`name`	Unknown
`question_color`	Unknown

component_choice_stats

Column	Type	Keys
`choice_id`	Unknown	PKFK
`component_id`	Unknown	PKFK
`survey_id`	Unknown	PKFK
`answer_count`	Unknown

component_map_field

Column	Type	Keys
`index`	Unknown	PK
`component_id`	Unknown	PKFK
`survey_id`	Unknown	PKFK
`type`	Unknown

translation

Column	Type	Keys
`id`	Unknown	PK
`index`	Unknown	PK
`choice_id`	Unknown	FK
`component_id`	Unknown	FK
`grid_item_id`	Unknown
`label_path`	Unknown
`languages`	Unknown
`text`	Unknown

choice

Column	Type	Keys
`id`	Unknown	PK
`component_id`	Unknown	PKFK
`survey_id`	Unknown	PKFK
`cm_list_key`	Unknown
`comment_enabled`	Unknown
`custom_dropdown_list`	Unknown
`form_field_type`	Unknown
`has_matching_rule_criteria`	Unknown
`is_other`	Unknown
`list_type`	Unknown
`mappable_field_type`	Json
`media_object`	Unknown
`pardot_value`	Unknown
`position`	Unknown
`required`	Unknown
`should_hide_merge_field`	Unknown
`text`	Unknown
`value`	Unknown

component

Column	Type	Keys
`id`	Unknown	PK
`survey_id`	Unknown	PKFK
`alignment`	Unknown
`answers_count`	Unknown
`button_text`	Unknown
`button_url`	Unknown
`can_hide_merge_field`	Unknown
`comment_enabled`	Unknown
`comment_header`	Unknown
`commentable`	Unknown
`description`	Unknown
`embedded_answer_key`	Unknown
`grid_item`	Json
`has_grid_item`	Unknown
`include_not_applicable`	Unknown
`is_email_embeddable`	Unknown
`is_embedded_answerable`	Unknown
`is_embedded_auto`	Unknown
`is_question`	Unknown
`lhs_condition_id`	Json
`markup`	Unknown
`max_answer`	Unknown
`maximum_label`	Unknown
`media_object`	Unknown
`min_answer`	Unknown
`minimum_label`	Unknown
`multiline`	Unknown
`multiple_answer`	Unknown
`number`	Unknown
`ordered_rule`	Json
`randomize`	Unknown
`randomize_grid_item`	Unknown
`required`	Unknown
`shape`	Unknown
`should_hide_merge_field`	Unknown
`show_description`	Unknown
`show_media`	Unknown
`show_top_media`	Unknown
`start_at`	Unknown
`stats_average`	Unknown
`target_action_id`	Json
`title`	Unknown
`top_media_object`	Unknown
`type`	Unknown

campaign

Column	Type	Keys
`id`	Unknown	PK
`survey_id`	Unknown	PKFK
`autoclose_timing_second`	Unknown
`custom_url`	Json
`ended_at`	Unknown
`expiry_period`	Unknown
`icon`	Unknown
`icon_color`	Unknown
`label`	Unknown
`logo_media_object`	Unknown
`percent_visitor`	Unknown
`placement`	Unknown
`scroll_position`	Unknown
`show_mobile`	Unknown
`show_tab`	Unknown
`style`	Unknown
`tab_color`	Unknown
`timing_second`	Unknown
`token`	Unknown
`trigger_once`	Unknown
`type`	Unknown
`url`	Json

rule_action

Column	Type	Keys
`id`	Unknown	PK
`rule_id`	Unknown	PKFK
`survey_id`	Unknown	PKFK
`component_id`	Unknown	FK
`email`	Json
`email_subject`	Unknown
`field_mapping_token`	Unknown
`grid_item_id`	Unknown
`include_response`	Unknown
`parameter`	Unknown
`pardot_field_mapping_id`	Unknown
`pardot_object_mapping_id`	Unknown
`salesforce_field_mapping_id`	Unknown
`salesforce_object_mapping_id`	Unknown
`slack_conversation_id`	Unknown
`slack_message`	Unknown
`slack_team_id`	Unknown
`type`	Unknown
`value`	Unknown

rule

Column	Type	Keys
`id`	Unknown	PK
`survey_id`	Unknown	PKFK
`component_id`	Unknown	FK
`active`	Unknown
`condition`	Json
`condition_operator`	Unknown
`created_at`	Unknown
`label`	Unknown
`purpose`	Unknown
`type`	Unknown
`updated_at`	Unknown

survey

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	FK
`answer_color_override`	Unknown
`automagic_salesforce_sync`	Unknown
`background_color_override`	Unknown
`background_display_override`	Unknown
`background_image_brightness`	Unknown
`background_image_override_bucket_type`	Unknown
`background_image_override_id`	Unknown
`background_image_override_uploaded`	Unknown
`background_image_override_url`	Unknown
`background_image_override_url_256`	Unknown
`background_image_override_url_512`	Unknown
`background_image_override_url_768`	Unknown
`background_type_override`	Unknown
`button_color_override`	Unknown
`completed_response_count`	Unknown
`created_at`	Unknown
`custom_domain`	Unknown
`defined_merge_key`	Json
`discard_invalid_value`	Unknown
`draft_differ`	Unknown
`draft_id`	Unknown
`draft_pardot_credential_id`	Unknown
`draft_salesforce_credential_id`	Unknown
`embedded_answer_key_error`	Json
`financial_data_field`	Unknown
`financial_data_path`	Json
`folder_id`	Unknown
`font_override`	Unknown
`languages`	Unknown
`last_published`	Unknown
`limited_response_count`	Unknown
`locale`	Unknown
`logo_media_object`	Unknown
`merge_field_encryption`	Unknown
`multi_language`	Unknown
`name`	Unknown
`notification_level`	Unknown
`only_defined_merge_key`	Unknown
`pardot_credential`	Unknown
`pardot_object_mapping`	Json
`public_setting_host`	Unknown
`public_setting_protocol`	Unknown
`publish_to_id`	Unknown
`publishing`	Unknown
`push_incomplete_response_status`	Unknown
`question_color_override`	Unknown
`question_count`	Unknown
`response_graph_token`	Unknown
`salesforce_activity_mapping`	Json
`salesforce_credential`	Unknown
`salesforce_mapping_failure_strategy_email_notifications_enabled`	Unknown
`salesforce_mapping_failure_strategy_email_summaries_enabled`	Unknown
`salesforce_mapping_failure_strategy_email_summaries_sent_count`	Unknown
`salesforce_mapping_failure_strategy_email_summary_scheduled_for`	Unknown
`salesforce_mapping_failure_strategy_id`	Unknown
`salesforce_object_mapping`	Json
`send_incomplete_response`	Unknown
`server_held_change_count`	Unknown
`share`	Json
`share_token`	Unknown
`show_incomplete_response`	Unknown
`started_response_count`	Unknown
`store_ipdata`	Unknown
`survey_share`	Json
`survey_url`	Unknown
`updated_at`	Unknown
`use_rich_text`	Unknown
`walkthrough`	Unknown
`white_labeled`	Unknown
`zendesk_connection_vox_id`	Unknown

answer_choice

Column	Type	Keys
`answer_id`	Unknown	PKFK
`choice_id`	Unknown	PKFK
`response_id`	Unknown	PKFK

answer

Column	Type	Keys
`id`	Unknown	PK
`response_id`	Unknown	PKFK
`component_id`	Unknown	FK
`comment`	Unknown
`created_at`	Unknown
`embedded`	Unknown
`grid_item`	Unknown
`not_applicable`	Unknown
`number`	Unknown
`scale`	Unknown
`text`	Unknown
`type`	Unknown
`updated_at`	Unknown

response

Column	Type	Keys
`id`	Unknown	PK
`survey_id`	Unknown	PKFK
`browser`	Unknown
`completed_at`	Unknown
`country_code_with_emoji`	Unknown
`created_at`	Unknown
`languages`	Unknown
`limited`	Unknown
`platform`	Unknown
`status`	Unknown
`token`	Unknown
`updated_at`	Unknown
`merge_map_`