# Zonka Feedback schema ERD

Table and field reference for the Fivetran Zonka Feedback connector.

## 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 | PK, FK |
| id | Unknown | PK, FK |

### 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 | PK, FK |
| task_id | Unknown | PK, FK |

### 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 | PK, FK |
| 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 | PK, FK |
| user_id | Unknown | PK, FK |

### 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 | PK, FK |
| variable_id | Unknown |  |

### response_survey

| Column | Type | Keys |
| --- | --- | --- |
| question_id | Unknown | PK |
| response_id | Unknown | PK, FK |
| answer | Unknown |  |
| question_label | Unknown |  |
| variable_id | Unknown |  |

### response_tags

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| response_id | Unknown | PK, FK |
| 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 |  |

## Relationships

- contact_survey(id) → survey(id)
- contact_survey(contact_id) → contact(id)
- contact(created_by) → users(id)
- contact(last_survey_viewed_id) → survey(id)
- contact(modified_by) → users(id)
- task_assigned(assigned_to) → users(id)
- task_assigned(task_id) → task(id)
- task(response_id) → response(id)
- task(contact_id) → contact(id)
- device_label(device_id) → device(id)
- device(location_id) → location(id)
- survey(workspace_id) → workspace(id)
- survey(modified_by) → users(id)
- workspace(modified_by) → users(id)
- user_location(id) → location(id)
- user_location(user_id) → users(id)
- response_attribute(response_id) → response(id)
- response_survey(response_id) → response(id)
- response_tags(response_id) → response(id)
- response(rated_user_id) → users(id)
- response(respondent_id) → users(id)
- response(taken_by_user_id) → users(id)
- response(location_id) → location(id)
- response(survey_id) → survey(id)