# Medallia Agile Research schema ERD

Table and field reference for the Fivetran Medallia Agile Research connector.

## Table & Field Reference

### lookup_survey_language

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### lookup_distribution

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### survey_responserate

| Column | Type | Keys |
| --- | --- | --- |
| panelist_status_id | Unknown | PK |
| survey_id | Unknown | PK, FK |
| groups | Unknown |  |
| panelist_count | Unknown |  |

### lookup_state

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### survey_respondent_response_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| survey_id | Unknown | PK, FK |
| survey_respondent_id | Unknown | PK, FK |
| survey_respondent_response_index | Unknown | PK, FK |
| salience_score | Unknown |  |
| sentiment_score | Unknown |  |
| tag_id | Unknown |  |
| tagged_by_text_mining | Unknown |  |

### survey_respondent_response

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| survey_id | Unknown | PK, FK |
| survey_respondent_id | Unknown | PK, FK |
| question_id | Unknown | FK |
| response_id | Unknown | FK |
| data_label | Unknown |  |
| response_caption | Unknown |  |
| scale_value | Unknown |  |
| score | Unknown |  |
| value | Unknown |  |

### survey_respondent

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| survey_id | Unknown | PK, FK |
| browser_id | Unknown | FK |
| contact_id | Unknown | FK |
| contact_status_id | Unknown | FK |
| distribution_method_id | Unknown | FK |
| location_country_id | Unknown | FK |
| os_id | Unknown | FK |
| respondent_status_id | Unknown | FK |
| completion_time | Unknown |  |
| date_responded | Instant |  |
| edit_url | Unknown |  |
| ip_address | Unknown |  |
| is_mobile | Unknown |  |
| language_code | Unknown |  |
| location_city | Unknown |  |
| location_latitude | Unknown |  |
| location_longitude | Unknown |  |
| report_url | Unknown |  |
| respondent_hash | Unknown |  |
| respondent_report_url | Unknown |  |
| response_date | Unknown |  |
| score | Unknown |  |

### contact_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | PK, FK |
| name | Unknown |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| country_id | Unknown | FK |
| state | Unknown | FK |
| city | Unknown |  |
| date_of_birth | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| gender | Unknown |  |
| house_number | Unknown |  |
| is_bounced | Unknown |  |
| is_opted_out | Unknown |  |
| lang_code | Unknown |  |
| last_name | Unknown |  |
| phone | Unknown |  |
| postal_code | Unknown |  |
| province | Unknown |  |
| street | Unknown |  |
| suite | Unknown |  |
| custom_** |  |  |

### lookup_data_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### survey_contact

| Column | Type | Keys |
| --- | --- | --- |
| contact_id | Unknown | PK, FK |
| survey_id | Unknown | PK, FK |
| contact_status_id | Unknown | FK |
| optout_source_id | Unknown | FK |
| panelist_status_id | Unknown | FK |
| date_added | Unknown |  |
| date_clicked_through | Unknown |  |
| date_invited | Unknown |  |
| date_last_modified | Instant |  |
| date_reminded | Unknown |  |
| date_reminded_partial | Unknown |  |
| date_responded | Unknown |  |
| date_saw_mail | Unknown |  |
| date_second_reminder | Unknown |  |
| date_sent_thank_you_mail | Unknown |  |
| date_to_be_invited | Unknown |  |
| date_to_expire | Unknown |  |
| live_url | Unknown |  |
| mail_preview_url | Unknown |  |
| password | Unknown |  |
| preview_url | Unknown |  |
| report_url | Unknown |  |
| custom_** |  |  |

### lookup_os

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### lookup_question_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### lookup_scale_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### lookup_contact_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### contact_optout

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| contact_id | Unknown | FK |
| country_id | Unknown | FK |
| optout_source_id | Unknown | FK |
| date_opt_out | Instant |  |
| survey_participation | Unknown |  |

### import_config_column_mapping

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| import_config_id | Unknown | FK |
| source_column_number | Unknown |  |
| target_column_name | Unknown |  |

### import_config

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_group_id | Unknown | FK |
| contact_id | Unknown | FK |
| survey_id | Unknown | FK |
| update_type_id | Unknown | FK |
| back_office_user_id | Unknown |  |
| date_format | Unknown |  |
| default_language_code | Unknown |  |
| email_is_required | Unknown |  |
| email_must_be_unique_within_account | Unknown |  |
| email_must_be_unique_within_file | Unknown |  |
| email_must_be_unique_within_group | Unknown |  |
| field_delimiter | Unknown |  |
| first_row | Unknown |  |
| is_custom | Unknown |  |
| is_reusable | Unknown |  |
| name | Unknown |  |
| row_delimiter | Unknown |  |
| send_answer_notification | Unknown |  |
| send_notification_mail | Unknown |  |
| survey_setting_account_cooldown_after_invitation | Unknown |  |
| survey_setting_account_cooldown_after_response | Unknown |  |
| survey_setting_consider_cooldown_period | Unknown |  |
| survey_setting_expiration_after_days | Unknown |  |
| survey_setting_expiration_time | Unknown |  |
| survey_setting_invitation_delay_in_days | Unknown |  |
| survey_setting_invitation_time | Unknown |  |
| survey_setting_survey_cooldown_after_invitation | Unknown |  |
| survey_setting_survey_cooldown_after_response | Unknown |  |
| user_id | Unknown |  |

### lookup_import_config_update_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### survey_question_sub_question_response

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| survey_id | Unknown | PK, FK |
| survey_question_id | Unknown | PK, FK |
| survey_question_sub_question_id | Unknown | PK, FK |
| caption | Unknown |  |
| hidden | Unknown |  |
| not_applicable | Unknown |  |
| orders | Unknown |  |
| other | Unknown |  |
| scale_value | Unknown |  |
| value | Unknown |  |

### survey_question_sub_question

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| survey_id | Unknown | PK, FK |
| survey_question_id | Unknown | PK, FK |
| data_type_id | Unknown | FK |
| parent_question_id | Unknown | FK |
| question_type_id | Unknown | FK |
| scale_type_id | Unknown | FK |
| caption | Unknown |  |
| data_label | Unknown |  |
| hidden | Unknown |  |
| languages | Unknown |  |
| max_value | Unknown |  |
| min_value | Unknown |  |
| order_number | Unknown |  |
| page_number | Unknown |  |
| question_number | Unknown |  |
| required | Unknown |  |
| use_sentiment_score | Unknown |  |

### survey_question_response

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| survey_id | Unknown | PK, FK |
| survey_question_id | Unknown | PK, FK |
| caption | Unknown |  |
| hidden | Unknown |  |
| not_applicable | Unknown |  |
| orders | Unknown |  |
| other | Unknown |  |
| scale_value | Unknown |  |
| value | Unknown |  |

### survey_question

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| survey_id | Unknown | PK, FK |
| data_type_id | Unknown | FK |
| parent_question_id | Unknown | FK |
| question_type_id | Unknown | FK |
| scale_type_id | Unknown | FK |
| caption | Unknown |  |
| data_label | Unknown |  |
| hidden | Unknown |  |
| languages | Unknown |  |
| max_value | Unknown |  |
| min_value | Unknown |  |
| order_number | Unknown |  |
| page_number | Unknown |  |
| question_number | Unknown |  |
| required | Unknown |  |
| use_sentiment_score | Unknown |  |

### lookup_browser

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### lookup_respondent_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### lookup_optout_source

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### lookup_country

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### survey_language

| Column | Type | Keys |
| --- | --- | --- |
| languages | Unknown | PK, FK |
| survey_id | Unknown | PK, FK |

### survey_respondent_visibility

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| survey_id | Unknown | FK |
| show_contact_id | Unknown |  |
| show_email | Unknown |  |
| show_firstname | Unknown |  |
| show_lastname | Unknown |  |
| show_panelist_status | Unknown |  |
| custom_** |  |  |

### survey

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| survey_status_id | Unknown | FK |
| allow_editing_responses | Unknown |  |
| allow_multiple_submissions | Unknown |  |
| anonymous_panel | Unknown |  |
| client_ref | Unknown |  |
| cooldown_in_days_after_invitation | Unknown |  |
| cooldown_in_days_after_response | Unknown |  |
| create_date | Unknown |  |
| created_by | Unknown |  |
| default_lang | Unknown |  |
| end_date | Unknown |  |
| is_trial | Unknown |  |
| last_modify_date | Instant |  |
| maximum_completes | Unknown |  |
| maximum_respondents | Unknown |  |
| score_max | Unknown |  |
| show_question_numbering | Unknown |  |
| start_date | Unknown |  |
| survey_folder_id | Unknown |  |
| title | Unknown |  |
| via_email_is_active | Unknown |  |
| via_kiosk_is_active | Unknown |  |
| via_panel_provider_is_active | Unknown |  |
| via_paper_is_active | Unknown |  |
| via_sms_is_active | Unknown |  |
| via_telephone_is_active | Unknown |  |
| via_web_is_active | Unknown |  |
| custom_** |  |  |

### lookup_survey_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

## Relationships

- survey_responserate(survey_id) → survey(id)
- survey_respondent_response_tag(survey_respondent_response_index) → survey_respondent_response(index)
- survey_respondent_response_tag(survey_respondent_id) → survey_respondent_response(survey_respondent_id)
- survey_respondent_response_tag(survey_id) → survey_respondent_response(survey_id)
- survey_respondent_response(question_id) → survey_question(id)
- survey_respondent_response(response_id) → survey_question_response(id)
- survey_respondent_response(survey_respondent_id) → survey_respondent(id)
- survey_respondent_response(survey_id) → survey_respondent(survey_id)
- survey_respondent(browser_id) → lookup_browser(id)
- survey_respondent(location_country_id) → lookup_country(id)
- survey_respondent(contact_status_id) → lookup_contact_status(id)
- survey_respondent(respondent_status_id) → lookup_respondent_status(id)
- survey_respondent(contact_id) → contact(id)
- survey_respondent(os_id) → lookup_os(id)
- survey_respondent(distribution_method_id) → lookup_distribution(id)
- survey_respondent(survey_id) → survey(id)
- contact_group(contact_id) → contact(id)
- contact(state) → lookup_state(id)
- contact(country_id) → lookup_country(id)
- survey_contact(panelist_status_id) → survey_responserate(panelist_status_id)
- survey_contact(optout_source_id) → lookup_optout_source(id)
- survey_contact(contact_status_id) → lookup_contact_status(id)
- survey_contact(contact_id) → contact(id)
- survey_contact(survey_id) → survey(id)
- contact_optout(contact_id) → contact(id)
- contact_optout(optout_source_id) → lookup_optout_source(id)
- contact_optout(country_id) → lookup_country(id)
- import_config_column_mapping(import_config_id) → import_config(id)
- import_config(contact_group_id) → contact_group(id)
- import_config(update_type_id) → lookup_import_config_update_type(id)
- import_config(survey_id) → survey(id)
- import_config(contact_id) → contact(id)
- survey_question_sub_question_response(survey_question_sub_question_id) → survey_question_sub_question(id)
- survey_question_sub_question_response(survey_question_id) → survey_question_sub_question(survey_question_id)
- survey_question_sub_question_response(survey_id) → survey_question_sub_question(survey_id)
- survey_question_sub_question(data_type_id) → lookup_data_type(id)
- survey_question_sub_question(parent_question_id) → survey_question(id)
- survey_question_sub_question(question_type_id) → lookup_question_type(id)
- survey_question_sub_question(scale_type_id) → lookup_scale_type(id)
- survey_question_sub_question(survey_question_id) → survey_question(id)
- survey_question_sub_question(survey_id) → survey_question(survey_id)
- survey_question_response(survey_question_id) → survey_question(id)
- survey_question_response(survey_id) → survey_question(survey_id)
- survey_question(data_type_id) → lookup_data_type(id)
- survey_question(parent_question_id) → survey_question(id)
- survey_question(question_type_id) → lookup_question_type(id)
- survey_question(scale_type_id) → lookup_scale_type(id)
- survey_question(survey_id) → survey(id)
- survey_language(languages) → lookup_survey_language(id)
- survey_language(survey_id) → survey(id)
- survey_respondent_visibility(survey_id) → survey(id)
- survey(survey_status_id) → lookup_survey_status(id)