# GetFeedback schema ERD

Table and field reference for the Fivetran GetFeedback connector.

## Table & Field Reference

### survey_merge_key

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| survey_id | Unknown | PK, FK |
| merge_key | Unknown |  |

### survey_enabled_language

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| survey_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| component_id | Unknown | PK, FK |
| survey_id | Unknown | PK, FK |
| answer_count | Unknown |  |

### component_map_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| component_id | Unknown | PK, FK |
| survey_id | Unknown | PK, FK |
| 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 | PK, FK |
| survey_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| survey_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| choice_id | Unknown | PK, FK |
| response_id | Unknown | PK, FK |

### answer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| response_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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_** |  |  |

## Relationships

- survey_merge_key(survey_id) → survey(id)
- survey_enabled_language(survey_id) → survey(id)
- theme(survey_id) → survey(id)
- component_choice_stats(choice_id) → choice(id)
- component_choice_stats(component_id) → component(id)
- component_choice_stats(survey_id) → component(survey_id)
- component_map_field(component_id) → component(id)
- component_map_field(survey_id) → component(survey_id)
- translation(component_id) → component(id)
- translation(choice_id) → choice(id)
- choice(survey_id) → component(survey_id)
- choice(component_id) → component(id)
- component(survey_id) → survey(id)
- campaign(survey_id) → survey(id)
- rule_action(component_id) → component(id)
- rule_action(rule_id) → rule(id)
- rule_action(survey_id) → rule(survey_id)
- rule(component_id) → component(id)
- rule(survey_id) → survey(id)
- survey(user_id) → users(id)
- answer_choice(choice_id) → choice(id)
- answer_choice(answer_id) → answer(id)
- answer_choice(response_id) → answer(response_id)
- answer(component_id) → component(id)
- answer(response_id) → response(id)
- response(survey_id) → survey(id)