Qualtrics

Explore the interactive ERD

Table & Field Reference

batch_transaction_membership

Column	Type	Keys
`batch_id`	String	PKFK
`directory_id`	String	PKFK
`transaction_id`	String	PKFK
`date_added_to_batch`	Instant

survey_embedded_data

Column	Type	Keys
`import_id`	String	PK
`key`	String	PK
`response_id`	String	PKFK
`value`	String

distribution

Column	Type	Keys
`id`	String	PK
`message_library_id`	String	FK
`message_message_id`	String	FK
`owner_id`	String	FK
`recipient_library_id`	String	FK
`survey_link_survey_id`	String	FK
`created_date`	Instant
`message_message_text`	String
`modified_date`	Instant
`organization_id`	String
`parent_distribution_id`	String
`recipient_contact_id`	String
`recipient_mailing_list_id`	String
`recipient_sample_id`	String
`request_status`	String
`request_type`	String
`send_date`	Instant
`survey_link_expiration_date`	Instant
`survey_link_link_type`	String
`header_`
`stats_`

directory_mailing_list

Column	Type	Keys
`id`	String	PK
`directory_id`	String	PKFK
`owner_id`	String	FK
`creation_date`	Instant
`last_modified_date`	Instant
`name`	String

question_response

Column	Type	Keys
`_fivetran_id`	String	PK
`question_id`	String	FK
`question_option_key`	String	FK
`response_id`	String	FK
`sub_question_key`	String	FK
`label`	String
`loop_id`	String
`question`	String
`sub_question_text`	String
`text`	String
`value`	String

survey_version_publish_event

Column	Type	Keys
`date`	Instant	PK
`survey_id`	String	PKFK
`user_id`	String	PKFK
`version_id`	String	PKFK

library_message

Column	Type	Keys
`id`	String	PK
`library_id`	String	PKFK
`category`	String
`description`	String

question_option

Column	Type	Keys
`key`	String	PK
`question_id`	String	PKFK
`survey_id`	String	PKFK
`recode_value`	String
`text`	String

quota_group

Column	Type	Keys
`id`	String	PK
`survey_id`	String	PKFK
`multi_match`	String
`name`	String
`public`	Boolean
`selected`	Boolean

library

Column	Type	Keys
`id`	String	PK
`name`	String

directory_contact

Column	Type	Keys
`id`	String	PK
`directory_id`	String	PKFK
`creation_date`	Instant
`directory_unsubscribe_date`	Instant
`directory_unsubscribed`	Boolean
`email`	String
`email_domain`	String
`ext_ref`	String
`first_name`	String
`language`	String
`last_modified`	Instant
`last_name`	String
`phone`	String
`write_blanks`	Boolean

directory_sample

Column	Type	Keys
`id`	String	PK
`directory_id`	String	PKFK
`creator_id`	String	FK
`owner_id`	String	FK
`category`	String
`creation_logic`	Json
`description`	String
`frozen`	Boolean
`hidden`	Boolean
`name`	String
`parent_group_id`	String

transaction_batch

Column	Type	Keys
`id`	String	PK
`directory_id`	String	PKFK
`creation_date`	Instant

block

Column	Type	Keys
`id`	String	PK
`survey_id`	String	PKFK
`block_locking`	String
`block_visibility`	String
`description`	String
`randomize_questions`	String
`type`	String

frequency_rule

Column	Type	Keys
`id`	String	PK
`directory_id`	String	PKFK
`always_send`	Boolean
`days_between`	Int
`email_type`	String
`num_messages`	Int
`period`	String
`target_type`	String

distribution_contact

Column	Type	Keys
`contact_id`	String	PK
`contact_lookup_id`	String	PK
`distribution_id`	String	PK
`response_id`	String	FK
`contact_frequency_rule_id`	String
`opened_at`	Instant
`response_completed_at`	Instant
`response_started_at`	Instant
`sent_at`	Instant
`status`	String
`survey_link`	String
`survey_session_id`	String

survey_version

Column	Type	Keys
`id`	String	PK
`survey_id`	String	PKFK
`user_id`	String	FK
`creation_date`	Instant
`description`	String
`published`	Boolean
`version_number`	Int
`was_published`	Boolean

sub_question

Column	Type	Keys
`key`	String	PK
`question_id`	String	PKFK
`survey_id`	String	PKFK
`choice_data_export_tag`	String
`text`	String

survey

Column	Type	Keys
`id`	String	PK
`owner_id`	String	FK
`auto_scoring_category`	String
`brand_base_url`	String
`brand_id`	String
`bundle_short_name`	String
`composition_type`	String
`creator_id`	String
`default_scoring_category`	String
`division_id`	String
`is_active`	Boolean
`last_accessed`	Instant
`last_activated`	Instant
`last_modified`	Instant
`project_category`	String
`project_type`	String
`registry_sha`	String
`registry_version`	String
`schema_version`	String
`scoring_summary_after_questions`	Boolean
`scoring_summary_after_survey`	Boolean
`scoring_summary_category`	String
`survey_name`	String
`survey_status`	String

sms_distribution_contact

Column	Type	Keys
`contact_id`	String	PK
`contact_lookup_id`	String	PK
`distribution_id`	String	PK
`response_id`	String	FK
`contact_frequency_rule_id`	String
`opened_at`	Instant
`response_completed_at`	Instant
`response_started_at`	Instant
`sent_at`	Instant
`status`	String
`survey_link`	String
`survey_session_id`	String

group_quota_membership

Column	Type	Keys
`quota_group_id`	String	PKFK
`quota_id`	String	PKFK

ticket

Column	Type	Keys
`id`	String	PK
`source_id`	String	FK
`survey_response_id`	String	FK
`closed_at`	Instant
`created_at`	Instant
`data`	Json
`first_time_entered`	Json
`first_time_left`	Json
`follow_up_details`	Json
`most_recent_time_entered`	Json
`most_recent_time_left`	Json
`name`	String
`owner_name`	String
`priority`	String
`root_cause`	String
`source_type`	String
`status`	String
`team_name`	String
`updated_at`	Instant

question

Column	Type	Keys
`id`	String	PK
`survey_id`	String	PKFK
`data_export_tag`	String
`data_visibility_hidden`	Boolean
`data_visibility_private`	Boolean
`next_answer_id`	Int
`next_choice_id`	Int
`question_description`	String
`question_description_option`	String
`question_text`	String
`question_text_unsafe`	String
`question_type`	String
`selector`	String
`sub_selector`	String
`validation_setting_force_response`	String
`validation_setting_force_response_type`	String
`validation_setting_type`	String

library_question

Column	Type	Keys
`folder_name`	String	PK
`library_question_id`	String	PK
`library_id`	String	PKFK
`question_name`	String

library_block

Column	Type	Keys
`folder_name`	String	PK
`library_block_id`	String	PK
`library_id`	String	PKFK
`block_name`	String

sms_distribution

Column	Type	Keys
`id`	String	PK
`message_library_id`	String	FK
`message_message_id`	String	FK
`owner_id`	String	FK
`recipient_library_id`	String	FK
`recipient_transaction_batch_id`	String	FK
`recipient_transaction_id`	String	FK
`survey_id`	String	FK
`message_message_type`	String
`name`	String
`organization_id`	String
`recipient_contact_id`	String
`recipient_mailing_list_id`	String
`recipient_sample_id`	String
`request_status`	String
`request_type`	String
`send_date`	Instant
`survey_link_expiration_date`	Instant

user

Column	Type	Keys
`id`	String	PK
`account_creation_date`	Instant
`account_expiration_date`	Instant
`account_status`	String
`division_id`	String
`email`	String
`first_name`	String
`language`	String
`last_login_date`	Instant
`last_name`	String
`organization_id`	String
`password_expiration_date`	Instant
`password_last_changed_date`	Instant
`response_count_auditable`	Int
`response_count_deleted`	Int
`response_count_generated`	Int
`time_zone`	String
`unsubscribed`	Boolean
`user_type`	String
`username`	String

contact_transaction

Column	Type	Keys
`id`	String	PK
`directory_id`	String	PKFK
`contact_id`	String	FK
`mailing_list_id`	String	FK
`transaction_date`	Instant

survey_response

Column	Type	Keys
`id`	String	PK
`survey_id`	String	FK
`distribution_channel`	String
`duration_in_seconds`	String
`end_date`	Instant
`external_reference`	String
`finished`	String
`ip_address`	String
`location_latitude`	String
`location_longitude`	String
`participant_email`	String
`participant_name`	String
`progress`	String
`recipient_email`	String
`recipient_first_name`	String
`recipient_last_name`	String
`recorded_date`	Instant
`start_date`	Instant
`status`	String
`user_language`	String

block_question

Column	Type	Keys
`block_id`	String	PKFK
`question_id`	String	PKFK
`survey_id`	String	PKFK

quota

Column	Type	Keys
`id`	String	PK
`survey_id`	String	PKFK
`count`	Int
`count_for_undo`	Int
`logic_type`	String
`name`	String
`occurrences`	Long
`perform_action_on_user`	Boolean
`quota_action`	String
`quota_realm`	String

library_survey

Column	Type	Keys
`folder_name`	String	PK
`library_survey_id`	String	PK
`library_id`	String	PKFK
`survey_name`	String

frequency_rule_target

Column	Type	Keys
`target_id`	String	PK
`directory_id`	String	PKFK
`rule_id`	String	PKFK

contact_mailing_list_membership

Column	Type	Keys
`contact_lookup_id`	String	PK
`contact_id`	String	FK
`directory_id`	String	FK
`mailing_list_id`	String	FK
`owner_id`	String	FK
`name`	String
`unsubscribe_date`	Instant
`unsubscribed`	Boolean