Alchemer

Explore the interactive ERD

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	PKFK
`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	PKFK

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	PKFK
`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	PKFK

rule

Column	Type	Keys
`id`	Unknown	PK
`groups_id`	String	PKFK
`answers_type`	Unknown
`input_value`	Unknown
`next_operator`	Unknown
`operator`	Unknown
`rule_percentage`	Unknown

groups

Column	Type	Keys
`id`	String	PK
`quota_id`	Unknown	PKFK

quota

Column	Type	Keys
`id`	Unknown	PK
`survey_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`survey_id`	Unknown	PKFK
`survey_page_id`	Unknown	PKFK
`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	PKFK
`sub_question_index`	Unknown	PKFK
`survey_id`	Unknown	PKFK
`survey_page_id`	Unknown	PKFK
`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	PKFK
`survey_id`	Unknown	PKFK
`survey_page_id`	Unknown	PKFK
`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	PKFK
`survey_page_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`survey_response_id`	Unknown	PKFK
`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	PKFK
`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