Medallia Agile Research

Explore the interactive ERD

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	PKFK
`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	PKFK
`survey_respondent_id`	Unknown	PKFK
`survey_respondent_response_index`	Unknown	PKFK
`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	PKFK
`survey_respondent_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`survey_id`	Unknown	PKFK
`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	PKFK
`survey_question_id`	Unknown	PKFK
`survey_question_sub_question_id`	Unknown	PKFK
`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	PKFK
`survey_question_id`	Unknown	PKFK
`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	PKFK
`survey_question_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`survey_id`	Unknown	PKFK

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