# Alchemer schema ERD

Table and field reference for the Fivetran Alchemer connector.

## Table & Field Reference

### contact_custom_field

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

### survey_campaign_email_message

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| survey_campaign_id | Unknown | PK |
| survey_id | Unknown | PK, FK |
| body_html | Unknown |  |
| body_text | Unknown |  |
| date_created | Unknown |  |
| date_modified | Unknown |  |
| disable_styles | Unknown |  |
| embed_question | Unknown |  |
| footer | Unknown |  |
| from_email | Unknown |  |
| from_name | Unknown |  |
| invite_identity | Unknown |  |
| medium | Unknown |  |
| message_type | Unknown |  |
| status | Unknown |  |
| subject | Unknown |  |
| subtype | Unknown |  |

### sso_attribute

| Column | Type | Keys |
| --- | --- | --- |
| attribute | String | PK |
| sso_id | Unknown | PK, FK |

### sso

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| cert_domain | Unknown |  |
| cert_fingerprint | Unknown |  |
| creat_users | Unknown |  |
| created | Unknown |  |
| customer_id | Unknown |  |
| d_modified | Unknown |  |
| deleted | Unknown |  |
| disable_users | Unknown |  |
| email_notification | Unknown |  |
| entity_id | Unknown |  |
| force_sso_login | Unknown |  |
| i_user_id_created | Unknown |  |
| login | Unknown |  |
| logout | Unknown |  |
| name | Unknown |  |
| sp_login | Unknown |  |
| sp_metadata | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |
| user_last_modified | Unknown |  |
| user_license | Unknown |  |
| user_role | Unknown |  |
| user_solo | Unknown |  |
| user_team | Unknown |  |
| weeks_to_disable | Unknown |  |

### survey_theme

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| accent | Unknown |  |
| accent_checked | Unknown |  |
| accent_text | Unknown |  |
| accent_text_checked | Unknown |  |
| auto_mobile | Unknown |  |
| auto_mobile_checked | Unknown |  |
| back_button | Unknown |  |
| back_button_checked | Unknown |  |
| background_grad_orient | Unknown |  |
| background_grad_orient_checked | Unknown |  |
| background_gradient | Unknown |  |
| background_image | Unknown |  |
| background_image_style | Unknown |  |
| background_image_style_checked | Unknown |  |
| base_font_color | Unknown |  |
| base_font_color_checked | Unknown |  |
| base_font_family | Unknown |  |
| base_font_family_checked | Unknown |  |
| base_font_size | Unknown |  |
| base_font_size_checked | Unknown |  |
| base_font_weight | Unknown |  |
| base_font_weight_checked | Unknown |  |
| base_web_font_name | Unknown |  |
| base_web_font_url | Unknown |  |
| body | Unknown |  |
| body_background_color | Unknown |  |
| body_background_color_checked | Unknown |  |
| body_background_opacity | Unknown |  |
| body_background_opacity_checked | Unknown |  |
| column_width | Unknown |  |
| comment_width | Unknown |  |
| created | Unknown |  |
| css | Unknown |  |
| custom_head | Unknown |  |
| custom_head_checked | Unknown |  |
| header_background_color | Unknown |  |
| header_background_color_checked | Unknown |  |
| header_background_opacity | Unknown |  |
| header_background_opacity_checked | Unknown |  |
| header_image_url | Unknown |  |
| header_image_url_checked | Unknown |  |
| header_text_color | Unknown |  |
| header_text_color_checked | Unknown |  |
| image_align | Unknown |  |
| image_align_checked | Unknown |  |
| img_width | Unknown |  |
| img_width_checked | Unknown |  |
| img_width_max | Unknown |  |
| img_width_max_checked | Unknown |  |
| name | Unknown |  |
| page_background_color | Unknown |  |
| page_background_color_checked | Unknown |  |
| page_background_opacity | Unknown |  |
| page_description | Unknown |  |
| page_description_checked | Unknown |  |
| page_title | Unknown |  |
| page_title_align | Unknown |  |
| page_title_align_checked | Unknown |  |
| page_title_checked | Unknown |  |
| page_top_margin | Unknown |  |
| page_width | Unknown |  |
| page_width_checked | Unknown |  |
| page_width_number | Unknown |  |
| page_width_number_checked | Unknown |  |
| page_width_unit | Unknown |  |
| page_width_unit_checked | Unknown |  |
| powered_by | Unknown |  |
| powered_by_checked | Unknown |  |
| progress_bar | Unknown |  |
| progress_bar_checked | Unknown |  |
| question_border | Unknown |  |
| question_border_checked | Unknown |  |
| question_number | Unknown |  |
| question_number_checked | Unknown |  |
| question_title | Unknown |  |
| question_title_checked | Unknown |  |
| replace_icons | Unknown |  |
| replace_icons_checked | Unknown |  |
| required_ast | Unknown |  |
| required_ast_checked | Unknown |  |
| so_masthead_image_show | Unknown |  |
| so_masthead_image_show_checked | Unknown |  |
| status | Unknown |  |
| style_mode | Unknown |  |
| survey_round_corner_number | Unknown |  |
| survey_round_corner_number_checked | Unknown |  |
| survey_title | Unknown |  |
| survey_title_checked | Unknown |  |
| survey_width | Unknown |  |
| survey_width_checked | Unknown |  |
| survey_width_number | Unknown |  |
| survey_width_number_checked | Unknown |  |
| survey_width_unit | Unknown |  |
| survey_width_unit_checked | Unknown |  |
| table_header_width | Unknown |  |
| theme_id | Unknown |  |
| theme_upgraded | Unknown |  |
| theme_version | Unknown |  |
| theme_version_checked | Unknown |  |
| title_align | Unknown |  |
| title_align_checked | Unknown |  |
| title_font_family | Unknown |  |
| title_font_family_checked | Unknown |  |
| title_font_size | Unknown |  |
| title_font_size_checked | Unknown |  |
| title_font_weight | Unknown |  |
| title_font_weight_checked | Unknown |  |
| title_web_font_name | Unknown |  |
| title_web_font_url | Unknown |  |

### survey_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| survey_id | Unknown | FK |
| id | Unknown |  |
| last_run | Unknown |  |
| name | Unknown |  |
| publish_link | Unknown |  |
| responses | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |
| version | Unknown |  |

### user_data

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_user_id | Unknown | PK, FK |
| description | Unknown |  |
| name | Unknown |  |
| value | Unknown |  |

### account_user

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| admin | Unknown |  |
| default_team | Unknown |  |
| email | Unknown |  |
| last_login | Unknown |  |
| license | Unknown |  |
| phone_support | Unknown |  |
| status | Unknown |  |
| username | Unknown |  |

### answer_value

| Column | Type | Keys |
| --- | --- | --- |
| answers_value | Unknown | PK |
| rule_id | Unknown | PK, FK |

### rule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| groups_id | String | PK, FK |
| answers_type | Unknown |  |
| input_value | Unknown |  |
| next_operator | Unknown |  |
| operator | Unknown |  |
| rule_percentage | Unknown |  |

### groups

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| quota_id | Unknown | PK, FK |

### quota

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| survey_id | Unknown | PK, FK |
| description | Unknown |  |
| distributed | Unknown |  |
| limits | Unknown |  |
| name | Unknown |  |
| responses | Unknown |  |

### survey_contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| survey_campaign_id | Unknown | PK |
| survey_id | Unknown | PK, FK |
| business_phone | Unknown |  |
| customfield_1 | Unknown |  |
| customfield_10 | Unknown |  |
| customfield_2 | Unknown |  |
| customfield_3 | Unknown |  |
| customfield_4 | Unknown |  |
| customfield_5 | Unknown |  |
| customfield_6 | Unknown |  |
| customfield_7 | Unknown |  |
| customfield_8 | Unknown |  |
| customfield_9 | Unknown |  |
| date_last_sent | Unknown |  |
| department | Unknown |  |
| division | Unknown |  |
| email_address | Unknown |  |
| fax_phone | Unknown |  |
| first_name | Unknown |  |
| groups | Unknown |  |
| home_phone | Unknown |  |
| last_name | Unknown |  |
| mailing_address | Unknown |  |
| mailing_address_2 | Unknown |  |
| mailing_address_city | Unknown |  |
| mailing_address_country | Unknown |  |
| mailing_address_postal | Unknown |  |
| mailing_address_state | Unknown |  |
| mobilephone | Unknown |  |
| organization | Unknown |  |
| role | Unknown |  |
| status | Unknown |  |
| subscriber_status | Unknown |  |
| team | Unknown |  |
| test | Unknown |  |
| test_2 | Unknown |  |
| test_3 | Unknown |  |
| test_4 | Unknown |  |
| test_5 | Unknown |  |
| title | Unknown |  |
| url | Unknown |  |

### option

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| question_id | Unknown | PK, FK |
| survey_id | Unknown | PK, FK |
| survey_page_id | Unknown | PK, FK |
| properties_all | Unknown |  |
| properties_checked | Unknown |  |
| properties_dependent | Unknown |  |
| properties_disabled | Unknown |  |
| properties_fixed | Unknown |  |
| properties_na | Unknown |  |
| properties_none | Unknown |  |
| properties_other | Unknown |  |
| properties_other_required | Unknown |  |
| properties_show_rules | Json |  |
| title_english | Unknown |  |
| value | Unknown |  |

### sub_question_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| question_id | Unknown | PK, FK |
| sub_question_index | Unknown | PK, FK |
| survey_id | Unknown | PK, FK |
| survey_page_id | Unknown | PK, FK |
| properties_all | Unknown |  |
| properties_checked | Unknown |  |
| properties_dependent | Unknown |  |
| properties_disabled | Unknown |  |
| properties_fixed | Unknown |  |
| properties_na | Unknown |  |
| properties_none | Unknown |  |
| properties_other | Unknown |  |
| properties_other_required | Unknown |  |
| properties_show_rules | Json |  |
| title_english | Unknown |  |
| value | Unknown |  |

### sub_question

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| question_id | Unknown | PK, FK |
| survey_id | Unknown | PK, FK |
| survey_page_id | Unknown | PK, FK |
| base_type | Unknown |  |
| comment | Unknown |  |
| description | Json |  |
| has_showhide_deps | Unknown |  |
| id | Unknown |  |
| properties_hidden | Unknown |  |
| properties_minimum_response | Unknown |  |
| properties_required | Unknown |  |
| shortname | Unknown |  |
| title_english | Unknown |  |
| type | Unknown |  |
| varname | Json |  |

### question

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| survey_id | Unknown | PK, FK |
| survey_page_id | Unknown | PK, FK |
| base_type | Unknown |  |
| break_after | Unknown |  |
| center_label | Json |  |
| comment | Unknown |  |
| conjoint_best_label | Json |  |
| conjoint_card_label | Json |  |
| conjoint_error_label | Json |  |
| conjoint_none_label | Json |  |
| conjoint_worst_label | Json |  |
| custom_css | Unknown |  |
| description | Json |  |
| disabled | Unknown |  |
| exclude_number | Unknown |  |
| force_currency | Unknown |  |
| force_numeric | Unknown |  |
| force_percent | Unknown |  |
| has_showhide_deps | Unknown |  |
| hidden | Unknown |  |
| hide_after_response | Unknown |  |
| inputmask | Json |  |
| l_extreme_label | Json |  |
| labels_right | Unknown |  |
| left_label | Json |  |
| limits | Unknown |  |
| map_key | Unknown |  |
| max_number | Unknown |  |
| maxdiff_attribute_label | Json |  |
| maxdiff_best_label | Json |  |
| maxdiff_of | Json |  |
| maxdiff_sets_message | Json |  |
| maxdiff_worst_label | Json |  |
| min_answers_per_row | Unknown |  |
| min_number | Unknown |  |
| minimum_response | Unknown |  |
| na_text_english | Unknown |  |
| only_whole_num | Unknown |  |
| option_sort | Unknown |  |
| orientation | Unknown |  |
| question_description_above | Unknown |  |
| question_description_english | Unknown |  |
| r_extreme_label | Json |  |
| required | Unknown |  |
| right_label | Json |  |
| shortname | Unknown |  |
| show_title | Unknown |  |
| soft_required | Unknown |  |
| subtype | Unknown |  |
| th_content | Json |  |
| title_english | Unknown |  |
| type | Unknown |  |
| url | Unknown |  |
| varname | Json |  |

### survey_page

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| survey_id | Unknown | PK, FK |
| description | Json |  |
| properties_hidden | Unknown |  |
| properties_piped_from | Unknown |  |
| title_english | Unknown |  |

### contact_list_contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_list_id | Unknown | PK, FK |
| business_phone | Unknown |  |
| department | Unknown |  |
| division | Unknown |  |
| email_address | Unknown |  |
| fax_phone | Unknown |  |
| first_name | Unknown |  |
| groups | Unknown |  |
| home_phone | Unknown |  |
| is_manager | Unknown |  |
| last_name | Unknown |  |
| mailing_address | Unknown |  |
| mailing_address_2 | Unknown |  |
| mailing_address_city | Unknown |  |
| mailing_address_country | Unknown |  |
| mailing_address_postal | Unknown |  |
| mailing_address_state | Unknown |  |
| organization | Unknown |  |
| role | Unknown |  |
| status | Unknown |  |
| team | Unknown |  |
| title | Unknown |  |
| url | Unknown |  |

### account_team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| default_role | Unknown |  |
| description | Unknown |  |
| status | Unknown |  |
| team_name | Unknown |  |

### survey_data

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| survey_id | Unknown | PK, FK |
| survey_response_id | Unknown | PK, FK |
| answer | Unknown |  |
| answer_id | Unknown |  |
| comment | Unknown |  |
| options | Json |  |
| original_answer | Unknown |  |
| parent | Unknown |  |
| question | Unknown |  |
| section_id | Unknown |  |
| shown | Unknown |  |
| subquestions | Json |  |
| type | Unknown |  |

### survey_response

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| survey_id | Unknown | PK |
| city | Unknown |  |
| comments | Unknown |  |
| contact_id | Unknown |  |
| country | Unknown |  |
| data_quality | Json |  |
| date_started | Unknown |  |
| date_submitted | Unknown |  |
| dma | Unknown |  |
| ip_address | Unknown |  |
| is_test_data | Unknown |  |
| languages | Unknown |  |
| latitude | Unknown |  |
| link_id | Unknown |  |
| longitude | Unknown |  |
| postal | Unknown |  |
| referer | Unknown |  |
| region | Unknown |  |
| response_time | Unknown |  |
| session_id | Unknown |  |
| status | Unknown |  |
| url_variables | Json |  |
| user_agent | Unknown |  |

### breakdown

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| survey_statistic_id | Unknown | FK |
| count | Unknown |  |
| label | Unknown |  |
| percentage | Unknown |  |

### survey_statistic

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| survey_id | Unknown | PK, FK |
| average | Unknown |  |
| max | Unknown |  |
| min | Unknown |  |
| std_dev | Unknown |  |
| sum | Unknown |  |
| total_responses | Unknown |  |
| type | Unknown |  |

### domain

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created | Unknown |  |
| customer_id | Unknown |  |
| domain | Unknown |  |
| estatus | Unknown |  |
| redirect | Unknown |  |
| type | Unknown |  |

### survey

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_on | Unknown |  |
| links_default | Unknown |  |
| links_edit | Unknown |  |
| links_publish | Unknown |  |
| modified_on | Unknown |  |
| statistics_complete | Unknown |  |
| status | Unknown |  |
| team | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |

### contact_list

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| date_created | Unknown |  |
| date_modifed | Unknown |  |
| list_name | Unknown |  |
| user_id_created | Unknown |  |
| user_id_modified | Unknown |  |

### survey_campaign

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| survey_id | Unknown | FK |
| close_message | Unknown |  |
| date_created | Unknown |  |
| date_modified | Unknown |  |
| id | Unknown |  |
| invite_id | Unknown |  |
| languages | Unknown |  |
| limit_responses | Unknown |  |
| link_close_date | Unknown |  |
| link_open_date | Unknown |  |
| link_type | Unknown |  |
| name | Unknown |  |
| primary_theme_content | Unknown |  |
| primary_theme_options | Unknown |  |
| ssl | Unknown |  |
| status | Unknown |  |
| sub_type | Unknown |  |
| token_variables | Unknown |  |
| type | Unknown |  |
| uri | Unknown |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_phone | Unknown |  |
| date_created | Unknown |  |
| login_link | Unknown |  |
| organization | Unknown |  |
| reseller | Unknown |  |
| reseller_uuid | Unknown |  |
| resellers_customer_id | Unknown |  |
| sso | Json |  |

## Relationships

- survey_campaign_email_message(survey_id) → survey(id)
- sso_attribute(sso_id) → sso(id)
- survey_report(survey_id) → survey(id)
- user_data(account_user_id) → account_user(id)
- answer_value(rule_id) → rule(id)
- rule(groups_id) → groups(id)
- groups(quota_id) → quota(id)
- quota(survey_id) → survey(id)
- survey_contact(survey_id) → survey(id)
- option(question_id) → question(id)
- option(survey_id) → question(survey_id)
- option(survey_page_id) → question(survey_page_id)
- sub_question_option(question_id) → sub_question(question_id)
- sub_question_option(sub_question_index) → sub_question(index)
- sub_question_option(survey_id) → sub_question(survey_id)
- sub_question_option(survey_page_id) → sub_question(survey_page_id)
- sub_question(question_id) → question(id)
- sub_question(survey_id) → question(survey_id)
- sub_question(survey_page_id) → question(survey_page_id)
- question(survey_id) → survey_page(survey_id)
- question(survey_page_id) → survey_page(id)
- survey_page(survey_id) → survey(id)
- contact_list_contact(contact_list_id) → contact_list(id)
- survey_data(survey_response_id) → survey_response(id)
- survey_data(survey_id) → survey_response(survey_id)
- breakdown(survey_statistic_id) → survey_statistic(id)
- survey_statistic(survey_id) → survey(id)
- survey_campaign(survey_id) → survey(id)