Fivetran documentation

Search the docs

/

Zonka Feedback

Explore the interactive ERD

Table & Field Reference

location

Column	Type	Keys
`id`	Unknown	PK
`address`	Unknown
`external_id`	Unknown
`is_active`	Unknown
`labels`	Json
`name`	Unknown

contact_survey

Column	Type	Keys
`contact_id`	Unknown	PKFK
`id`	Unknown	PKFK

contact

Column	Type	Keys
`id`	Unknown	PK
`created_by`	Unknown	FK
`last_survey_viewed_id`	Unknown	FK
`modified_by`	Unknown	FK
`android_session_counts`	Unknown
`attributes`	Json
`average_nps`	Unknown
`bounced`	Unknown
`company_id`	Unknown
`contact_source`	Unknown
`created_date`	Unknown
`email_address`	Unknown
`external_id`	Unknown
`first_page`	Unknown
`first_referring_site`	Unknown
`first_seen`	Unknown
`first_seen_on_android`	Unknown
`first_seen_on_ios`	Unknown
`first_seen_on_web`	Unknown
`has_note`	Unknown
`history_imported_from_anonymous`	Unknown
`ios_session_counts`	Unknown
`last_email_survey_sent_datetime`	Unknown
`last_nps`	Unknown
`last_page`	Unknown
`last_referring_site`	Unknown
`last_response_date_time`	Unknown
`last_seen`	Unknown
`last_seen_on_android`	Unknown
`last_seen_on_ios`	Unknown
`last_seen_on_web`	Unknown
`last_session_active_at`	Unknown
`last_sms_survey_sent_datetime`	Unknown
`last_survey_viewed_date`	Unknown
`last_web_widget_shown`	Unknown
`lists`	Json
`locations`	Json
`mau_next_count_after_date`	Unknown
`mobile`	Unknown
`modified_date`	Unknown
`name`	Unknown
`num_notes`	Unknown
`num_pending_tasks`	Unknown
`num_tasks`	Unknown
`pages_viewed_count`	Unknown
`pre_mongified_id`	Unknown
`session_counts`	Unknown
`source`	Unknown
`surveys_visits`	Json
`thirdparty_created_date`	Unknown
`thirdparty_singup_date`	Unknown
`thirdparty_updated_date`	Unknown
`total_responses`	Unknown
`unique_id`	Unknown
`unsubscribe_email`	Unknown
`unsubscribe_sms`	Unknown
`utm_campaign`	Unknown
`utm_content`	Unknown
`utm_medium`	Unknown
`utm_source`	Unknown
`utm_term`	Unknown
`web_session_counts`	Unknown

task_assigned

Column	Type	Keys
`assigned_to`	Unknown	PKFK
`task_id`	Unknown	PKFK

task

Column	Type	Keys
`id`	Unknown	PK
`contact_id`	Unknown	FK
`response_id`	Unknown	FK
`description`	Unknown
`due_date_time`	Unknown
`is_completed`	Unknown
`name`	Unknown
`reminder_setting`	Unknown
`type_id`	Unknown
`type_name`	Unknown

device_label

Column	Type	Keys
`index`	Unknown	PK
`device_id`	Unknown	PKFK
`label`	Unknown

device

Column	Type	Keys
`id`	Unknown	PK
`location_id`	Unknown	FK
`app_status`	Unknown
`app_version`	Unknown
`charging`	Unknown
`description`	Unknown
`device_battery_level`	Unknown
`device_brand`	Unknown
`device_category`	Unknown
`device_imei`	Unknown
`device_model`	Unknown
`device_os`	Unknown
`device_os_version`	Unknown
`device_resolution`	Unknown
`device_serial_number`	Unknown
`device_time_zone`	Unknown
`friendly_name`	Unknown
`ip_address`	Unknown
`is_active`	Unknown
`is_preview_mode`	Unknown
`last_communication`	Unknown
`last_logged_user_name`	Unknown
`last_login_time`	Unknown
`name`	Unknown
`unique_id`	Unknown

survey

Column	Type	Keys
`id`	Unknown	PK
`modified_by`	Unknown	FK
`workspace_id`	Unknown	FK
`description`	Unknown
`is_active`	Unknown
`location_id`	Json
`modified_date`	Unknown
`name`	Unknown
`web_survey_title`	Unknown
`web_survey_url`	Json

workspace

Column	Type	Keys
`id`	Unknown	PK
`modified_by`	Unknown	FK
`modified_date`	Unknown
`workspace_name`	Unknown

user_location

Column	Type	Keys
`id`	Unknown	PKFK
`user_id`	Unknown	PKFK

users

Column	Type	Keys
`id`	Unknown	PK
`designation`	Unknown
`email`	Unknown
`external_id`	Unknown
`is_active`	Unknown
`is_owner`	Unknown
`labels`	Json
`last_login`	Unknown
`mobile`	Unknown
`name`	Unknown
`role`	Unknown

response_attribute

Column	Type	Keys
`value`	Unknown	PK
`response_id`	Unknown	PKFK
`variable_id`	Unknown

response_survey

Column	Type	Keys
`question_id`	Unknown	PK
`response_id`	Unknown	PKFK
`answer`	Unknown
`question_label`	Unknown
`variable_id`	Unknown

response_tags

Column	Type	Keys
`index`	Unknown	PK
`response_id`	Unknown	PKFK
`tags`	Unknown

response

Column	Type	Keys
`id`	Unknown	PK
`location_id`	Unknown	FK
`rated_user_id`	Unknown	FK
`respondent_id`	Unknown	FK
`survey_id`	Unknown	FK
`taken_by_user_id`	Unknown	FK
`browser`	Unknown
`ces`	Unknown
`channel`	Unknown
`channel_email_opened`	Unknown
`channel_sent`	Unknown
`channel_survey_opened`	Unknown
`channel_survey_submitted`	Unknown
`channel_user_agent`	Unknown
`contact_attributes`	Json
`csat`	Unknown
`duration`	Unknown
`geo_location`	Unknown
`has_comments`	Unknown
`has_notes`	Unknown
`has_task`	Unknown
`integration_ticket_id`	Unknown
`integration_type`	Unknown
`is_important`	Unknown
`is_starred`	Unknown
`nps`	Unknown
`os`	Unknown
`rated_user_name`	Unknown
`received_date`	Unknown
`received_date_local`	Unknown
`respondent_email_address`	Unknown
`respondent_external_id`	Unknown
`respondent_mobile`	Unknown
`respondent_name`	Unknown
`response_url`	Unknown
`survey_language`	Unknown
`task_id`	Unknown
`time_zone`	Unknown
`web_device`	Unknown