# Zoom schema ERD

Table and field reference for the Fivetran Zoom connector.

## Table & Field Reference

### channel

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| channel_settings_allow_to_add_external_users | Long |  |
| channel_settings_new_members_can_see_previous_messages_files | Boolean |  |
| channel_settings_posting_permissions | Long |  |
| jid | String |  |
| name | String |  |
| type | String |  |

### meeting_report_custom_key

| Column | Type | Keys |
| --- | --- | --- |
| key | String | PK |
| meeting_report_uuid | String | PK, FK |
| value | String |  |

### meeting_report_tracking

| Column | Type | Keys |
| --- | --- | --- |
| field | String | PK |
| meeting_report_uuid | String | PK, FK |
| value | String |  |

### meeting_report

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK, FK |
| dept | String |  |
| duration | Long |  |
| end_time | Instant |  |
| meeting_id | Long |  |
| participants_count | Long |  |
| start_time | Instant |  |
| topic | String |  |
| total_minutes | Long |  |
| type | String |  |
| user_email | String |  |
| user_name | String |  |

### meeting

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| host_id | String | FK |
| created_at | Instant |  |
| duration | Long |  |
| id | Long |  |
| join_url | String |  |
| start_time | Instant |  |
| timezone | String |  |
| topic | String |  |
| type | Long |  |

### event_survey_report_question_answer

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| event_survey_report_fivetran_id | Unknown | PK, FK |
| answer | Unknown |  |
| question | Unknown |  |

### event_survey_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| event_id | Unknown | PK, FK |
| email | Unknown |  |
| session_id | Unknown |  |
| session_name | Unknown |  |

### account_parent_team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_team_id | Unknown | PK, FK |
| name | Unknown |  |

### account_team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |
| leaf | Unknown |  |
| member_size | Unknown |  |
| name | Unknown |  |
| supervisor_size | Unknown |  |
| type | Unknown |  |

### event_attendance_report_ticket_question

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_attendance_fivetran_id | Unknown | PK, FK |
| event_attendance_report_ticket_index | Unknown | PK, FK |
| event_id | Unknown | PK, FK |
| answer | Unknown |  |
| title | Unknown |  |

### event_attendance_report_ticket

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_attendance_fivetran_id | Unknown | PK, FK |
| event_id | Unknown | PK, FK |
| ticket_id | Unknown |  |
| ticket_type_id | Unknown |  |
| ticket_type_name | Unknown |  |

### event_attendance_report_session_attendance

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_attendance_report_fivetran_id | Unknown | PK, FK |
| event_id | Unknown | PK, FK |
| chat_messages_sent | Unknown |  |
| duration_spent_in_session | Unknown |  |
| live_streaming_view | Unknown |  |
| live_streaming_view_duration | Unknown |  |
| material_download | Unknown |  |
| recording_view | Unknown |  |
| recording_view_duration | Unknown |  |
| session_attendance | Unknown |  |
| session_id | Unknown |  |
| session_name | Unknown |  |

### event_attendance_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| event_id | Unknown | PK, FK |
| attendance_type | Json |  |
| connection_made | Unknown |  |
| display_name | Unknown |  |
| email | Unknown |  |
| event_attendance | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| lobby_attendance | Unknown |  |
| lobby_chat_sent | Unknown |  |
| marketing_consent_prechecked | Unknown |  |
| number_of_tickets | Unknown |  |
| opt_in_marketing | Unknown |  |
| personal_chats | Unknown |  |
| profile_created | Unknown |  |
| role | Unknown |  |
| survey_taken | Unknown |  |
| total_sessions_joined | Unknown |  |

### user_meeting_report

| Column | Type | Keys |
| --- | --- | --- |
| uuid | Unknown | PK |
| user_id | String | PK, FK |
| host_id | Unknown | FK |
| duration | Unknown |  |
| end_time | Unknown |  |
| has_chat | Unknown |  |
| host_email | Unknown |  |
| host_organization | Unknown |  |
| id | Unknown |  |
| join_time | Unknown |  |
| join_waiting_room_time | Unknown |  |
| leave_time | Unknown |  |
| meeting_encryption_status | Unknown |  |
| participants_count | Unknown |  |
| participants_count_my_account | Unknown |  |
| schedule_time | Unknown |  |
| session_key | Unknown |  |
| source | Unknown |  |
| start_time | Unknown |  |
| topic | Unknown |  |
| total_minutes | Unknown |  |
| type | Unknown |  |

### webinar_participant

| Column | Type | Keys |
| --- | --- | --- |
| user_id | String | PK, FK |
| webinar_uuid | String | PK, FK |
| participant_user_id | String | FK |
| customer_key | String |  |
| duration | Long |  |
| failover | Boolean |  |
| join_time | Instant |  |
| leave_time | Instant |  |
| name | String |  |
| registrant_id | String |  |
| status | String |  |
| user_email | String |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| access_level | Unknown |  |
| attendance_type | Unknown |  |
| blocked_countries | Json |  |
| calendar | Json |  |
| categories | Json |  |
| contact_email | Unknown |  |
| contact_name | Unknown |  |
| description | Unknown |  |
| end_time | Instant |  |
| event_status_type | Unknown |  |
| event_type | Unknown |  |
| event_url | Unknown |  |
| hub_id | Unknown |  |
| lobby_end_time | Instant |  |
| lobby_start_time | Instant |  |
| meeting_type | Unknown |  |
| name | Unknown |  |
| physical_location | Unknown |  |
| recurrence_duration | Unknown |  |
| recurrence_end_date_time | Unknown |  |
| recurrence_end_times | Unknown |  |
| recurrence_monthly_days | Unknown |  |
| recurrence_monthly_week | Unknown |  |
| recurrence_monthly_week_day | Unknown |  |
| recurrence_repeat_interval | Unknown |  |
| recurrence_type | Unknown |  |
| recurrence_weekly_days | Unknown |  |
| role_type | Unknown |  |
| start_time | Instant |  |
| status | Unknown |  |
| tagline | Unknown |  |
| tags | Json |  |
| timezone | Unknown |  |

### webinar_question_and_answer_question_detail

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| webinar_question_and_answer_id | Long | FK |
| webinar_question_and_answer_question_index | Unknown | FK |
| webinar_uuid | String | FK |
| answer | Unknown |  |
| question | Unknown |  |

### webinar_question_and_answer_question

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| webinar_question_and_answer_id | Long | PK, FK |
| webinar_uuid | String | PK, FK |
| email | Unknown |  |
| name | Unknown |  |

### webinar_question_and_answer

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| webinar_uuid | String | PK, FK |
| start_time | Instant |  |
| uuid | String |  |

### webinar_absentee

| Column | Type | Keys |
| --- | --- | --- |
| registrant_id | String | PK, FK |
| webinar_uuid | String | PK, FK |
| email | Unknown | FK |

### phone_sms_mms_charge_usage_report

| Column | Type | Keys |
| --- | --- | --- |
| message_id | Unknown | PK |
| session_id | Unknown | PK |
| billing_number | Unknown |  |
| cost_center | Unknown |  |
| currency | Unknown |  |
| department | Unknown |  |
| from_display_name | Unknown |  |
| from_extension_number | Unknown |  |
| from_number | Unknown |  |
| message_type | Unknown |  |
| rate | Unknown |  |
| sent_time | Unknown |  |
| to_display_name | Unknown |  |
| to_extension_number | Unknown |  |
| to_number | Unknown |  |
| total_charge | Unknown |  |

### webinar_panelist

| Column | Type | Keys |
| --- | --- | --- |
| user_id | String | PK, FK |
| webinar_uuid | String | PK, FK |
| email | String |  |
| join_url | String |  |
| name | String |  |
| name_tag_description | String |  |
| name_tag_id | String |  |
| name_tag_name | String |  |
| name_tag_pronouns | String |  |
| virtual_background_id | String |  |

### event_registration_ticket_question

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| event_registration_fivetran_id | Unknown | PK, FK |
| event_registration_index | Unknown | PK, FK |
| answer | Unknown |  |
| title | Unknown |  |

### event_registration_ticket

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| event_registration_fivetran_id | Unknown | PK, FK |
| authentication_method | Unknown |  |
| external_ticket_id | Unknown |  |
| ticket_id | Unknown |  |
| ticket_type_id | Unknown |  |
| ticket_type_name | Unknown |  |

### event_registration

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| event_id | Unknown | PK, FK |
| attendance_type | Json |  |
| display_name | Unknown |  |
| email | Unknown |  |
| event_attendance | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| marketing_consent_prechecked | Unknown |  |
| opt_in_marketing | Unknown |  |
| register_date | Unknown |  |
| registration_method | Unknown |  |
| registration_source | Unknown |  |

### disposition

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| modified_by | Unknown | FK |
| disposition_description | Unknown |  |
| disposition_name | Unknown |  |
| disposition_type | Unknown |  |
| last_modified_time | Instant |  |
| queue_count | Unknown |  |
| status | Unknown |  |

### webinar_poll_question

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| webinar_poll_id | String | PK, FK |
| webinar_uuid | String | PK, FK |
| answer_max_character | Long |  |
| answer_min_character | Long |  |
| answer_required | Boolean |  |
| answers | Json |  |
| case_sensitive | Boolean |  |
| name | String |  |
| prompts | Json |  |
| rating_max_label | String |  |
| rating_max_value | Long |  |
| rating_min_label | String |  |
| rating_min_value | Long |  |
| right_answers | Json |  |
| show_as_dropdown | Boolean |  |
| type | String |  |

### webinar_poll

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| webinar_uuid | String | PK, FK |
| anonymous | Boolean |  |
| poll_type | Long |  |
| status | String |  |
| title | String |  |

### webinar_registrant_custom_question

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | String | PK, FK |
| webinar_uuid | String | PK, FK |
| title | String |  |
| value | String |  |

### webinar_registrant

| Column | Type | Keys |
| --- | --- | --- |
| user_id | String | PK, FK |
| webinar_uuid | String | PK, FK |
| email | Unknown | FK |
| address | String |  |
| city | String |  |
| comments | String |  |
| country | String |  |
| create_time | Instant |  |
| industry | String |  |
| job_title | String |  |
| join_url | String |  |
| no_of_employees | String |  |
| org | String |  |
| phone | String |  |
| purchasing_time_frame | String |  |
| role_in_purchase_process | String |  |
| state | String |  |
| zip | String |  |

### phone_call_path

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| phone_call_history_id | Unknown | PK, FK |
| callee_country_code | Unknown |  |
| callee_country_iso_code | Unknown |  |
| callee_device_type | Unknown |  |
| callee_did_number | Unknown |  |
| callee_email | Unknown |  |
| callee_ext_id | Unknown |  |
| callee_ext_number | Unknown |  |
| callee_ext_type | Unknown |  |
| callee_name | Unknown |  |
| callee_number_type | Unknown |  |
| caller_country_code | Unknown |  |
| caller_country_iso_code | Unknown |  |
| caller_device_type | Unknown |  |
| caller_did_number | Unknown |  |
| caller_email | Unknown |  |
| caller_ext_number | Unknown |  |
| caller_ext_type | Unknown |  |
| caller_name | Unknown |  |
| caller_number_type | Unknown |  |
| client_code | Unknown |  |
| cost_center | Unknown |  |
| device_private_ip | Unknown |  |
| device_public_ip | Unknown |  |
| event | Unknown |  |
| hold_time | Unknown |  |
| is_node | Unknown |  |
| node | Unknown |  |
| operator_ext_id | Unknown |  |
| operator_ext_number | Unknown |  |
| operator_ext_type | Unknown |  |
| operator_name | Unknown |  |
| press_key | Unknown |  |
| recording_id | Unknown |  |
| recording_type | Unknown |  |
| result | Unknown |  |
| result_reason | Unknown |  |
| segment | Unknown |  |
| voicemail_id | Unknown |  |
| wait_time | Unknown |  |

### webinar_tracking_source

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| webinar_uuid | String | PK, FK |
| registration_count | Long |  |
| source_name | String |  |
| tracking_url | String |  |
| visitor_count | Long |  |

### phone_call_history

| Column | Type | Keys |
| --- | --- | --- |
| call_id | Unknown | PK |
| id | Unknown | PK |
| group_id | Unknown | FK |
| answer_time | Unknown |  |
| call_result | Unknown |  |
| call_type | Unknown |  |
| callee_country_code | Unknown |  |
| callee_country_iso_code | Unknown |  |
| callee_device_type | Unknown |  |
| callee_did_number | Unknown |  |
| callee_email | Unknown |  |
| callee_ext_id | Unknown |  |
| callee_ext_number | Unknown |  |
| callee_ext_type | Unknown |  |
| callee_name | Unknown |  |
| callee_number_type | Unknown |  |
| caller_country_code | Unknown |  |
| caller_country_iso_code | Unknown |  |
| caller_device_type | Unknown |  |
| caller_did_number | Unknown |  |
| caller_email | Unknown |  |
| caller_ext_id | Unknown |  |
| caller_ext_number | Unknown |  |
| caller_ext_type | Unknown |  |
| caller_name | Unknown |  |
| caller_number_type | Unknown |  |
| client_code | Unknown |  |
| connect_type | Unknown |  |
| cost_center | Unknown |  |
| department | Unknown |  |
| direction | Unknown |  |
| duration | Unknown |  |
| end_time | Instant |  |
| international | Unknown |  |
| recording_status | Unknown |  |
| sbc_id | Unknown |  |
| sbc_name | Unknown |  |
| sip_group_id | Unknown |  |
| sip_group_name | Unknown |  |
| site_id | Unknown |  |
| site_name | Unknown |  |
| spam | Unknown |  |
| start_time | Instant |  |

### webinar

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| host_id | String | FK |
| created_at | Instant |  |
| duration | Long |  |
| id | Long |  |
| join_url | String |  |
| start_time | Instant |  |
| timezone | String |  |
| topic | String |  |
| type | Long |  |

### user_group

| Column | Type | Keys |
| --- | --- | --- |
| group_id | String | PK |
| user_id | String | PK, FK |

### user_im_group

| Column | Type | Keys |
| --- | --- | --- |
| im_group_id | String | PK |
| user_id | String | PK, FK |

### user_custom_attribute

| Column | Type | Keys |
| --- | --- | --- |
| key | String | PK |
| user_id | String | PK, FK |
| name | String |  |
| value | String |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_at | Instant |  |
| dept | String |  |
| email | String |  |
| employee_unique_id | String |  |
| first_name | String |  |
| host_key | String |  |
| languages | String |  |
| last_client_version | String |  |
| last_login_time | Instant |  |
| last_name | String |  |
| phone_number | String |  |
| plan_united_type | String |  |
| pmi | Long |  |
| role_id | String |  |
| status | String |  |
| timezone | String |  |
| type | Long |  |
| verified | Long |  |

### webinar_report_custom_key

| Column | Type | Keys |
| --- | --- | --- |
| key | String | PK |
| webinar_report_fivetran_id | Unknown | PK, FK |
| value | String |  |

### webinar_report_tracking

| Column | Type | Keys |
| --- | --- | --- |
| field | String | PK |
| webinar_report_fivetran_id | Unknown | PK, FK |
| value | String |  |

### webinar_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| uuid | String | FK |
| dept | String |  |
| duration | Long |  |
| end_time | Instant |  |
| id | Unknown |  |
| participants_count | Long |  |
| start_time | Instant |  |
| topic | String |  |
| total_minutes | Long |  |
| type | String |  |
| user_email | String |  |
| user_name | String |  |

### phone_call_charge_usage_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| billing_number | Unknown |  |
| call_id | Unknown |  |
| call_log_id | Unknown |  |
| call_type | Unknown |  |
| callee_billing_number | Unknown |  |
| callee_number | Unknown |  |
| caller_billing_number | Unknown |  |
| caller_number | Unknown |  |
| calling_party_name | Unknown |  |
| charge_mode | Unknown |  |
| cost_center | Unknown |  |
| currency | Unknown |  |
| department | Unknown |  |
| duration | Unknown |  |
| employee_id | Unknown |  |
| end_time | Instant |  |
| forward_number_billing | Unknown |  |
| rate | Unknown |  |
| service_type | Unknown |  |
| total_charge | Unknown |  |

### meeting_participant

| Column | Type | Keys |
| --- | --- | --- |
| user_id | String | PK, FK |
| user_meeting_report_uuid | Unknown | PK, FK |
| participant_user_id | String | FK |
| bo_mtg_id | String |  |
| customer_key | String |  |
| duration | Long |  |
| failover | Boolean |  |
| join_time | Instant |  |
| leave_time | Instant |  |
| name | String |  |
| registrant_id | String |  |
| status | String |  |
| user_email | String |  |

### room

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_type | Unknown |  |
| calender_name | Unknown |  |
| camera | Unknown |  |
| device_ip | Unknown |  |
| email | Unknown |  |
| health | Unknown |  |
| issues | Json |  |
| last_start_time | Unknown |  |
| location | Unknown |  |
| location_id | Unknown |  |
| microphone | Unknown |  |
| room_name | Unknown |  |
| speaker | Unknown |  |
| status | Unknown |  |

### voice_historical_detail_report_channel

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| channel | Unknown |  |
| channel_source | Unknown |  |

### voice_historical_detail_report_flow

| Column | Type | Keys |
| --- | --- | --- |
| flow_id | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| flow_name | Unknown |  |
| flow_version | Unknown |  |

### voice_historical_detail_report_queue

| Column | Type | Keys |
| --- | --- | --- |
| cc_queue_id | Unknown | PK, FK |
| engagement_id | Unknown | PK, FK |
| queue_name | Unknown |  |

### voice_historical_detail_report_agent

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| display_name | Unknown |  |
| user_id | Unknown |  |

### voice_historical_detail_report_required_skill

| Column | Type | Keys |
| --- | --- | --- |
| skill_id | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| minimum_proficiency_level | Unknown |  |
| skill_name | Unknown |  |

### voice_historical_detail_report_optional_skill

| Column | Type | Keys |
| --- | --- | --- |
| skill_id | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| minimum_proficiency_level | Unknown |  |
| skill_name | Unknown |  |

### voice_historical_detail_report_agent_skill

| Column | Type | Keys |
| --- | --- | --- |
| skill_id | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| minimum_proficiency_level | Unknown |  |
| skill_name | Unknown |  |

### voice_historical_detail_report

| Column | Type | Keys |
| --- | --- | --- |
| engagement_id | Unknown | PK |
| disposition_id | Unknown | FK |
| agent_first_message_speed | Unknown |  |
| callback_pending_duration | Unknown |  |
| callback_waiting_duration | Unknown |  |
| channel | Unknown |  |
| consumer_id | Unknown |  |
| consumer_name | Unknown |  |
| consumer_number | Unknown |  |
| dialed_numbers | Json |  |
| direction | Unknown |  |
| disposition_name | Unknown |  |
| handling_duration | Unknown |  |
| hold_duration | Unknown |  |
| ivr_duration | Unknown |  |
| last_widget_name | Unknown |  |
| queue_wait_type | Unknown |  |
| results | Unknown |  |
| ring_duration | Unknown |  |
| start_time | Instant |  |
| talking_duration | Unknown |  |
| total_duration | Unknown |  |
| total_flow_duration | Unknown |  |
| waiting_duration | Unknown |  |
| wrap_up_duration | Unknown |  |

### voice_historical_queue_report

| Column | Type | Keys |
| --- | --- | --- |
| cc_queue_id | Unknown | PK |
| queue_name | Unknown |  |
| total_completed | Unknown |  |
| total_inbound | Unknown |  |
| total_transferred_in | Unknown |  |
| total_transferred_out | Unknown |  |
| voice_average_outbound_answer_duration | Unknown |  |
| voice_average_outbound_hold_duration | Unknown |  |
| voice_average_outbound_wrap_up_duration | Unknown |  |
| voice_end_time_interval | Unknown |  |
| voice_hangup_outbound | Unknown |  |
| voice_hold_abandoned | Unknown |  |
| voice_inbound_average_talking_duration | Unknown |  |
| voice_inbound_average_waiting_duration | Unknown |  |
| voice_inbound_average_wrap_up_duration | Unknown |  |
| voice_inbound_longest_talking_duration | Unknown |  |
| voice_inbound_longest_waiting_duration | Unknown |  |
| voice_inbound_longest_wrap_up_duration | Unknown |  |
| voice_inbound_shortest_talking_duration | Unknown |  |
| voice_inbound_shortest_waiting_duration | Unknown |  |
| voice_inbound_shortest_wrap_up_duration | Unknown |  |
| voice_long_abandoned | Unknown |  |
| voice_long_outbound | Unknown |  |
| voice_service_level | Unknown |  |
| voice_short_abandoned | Unknown |  |
| voice_short_outbound | Unknown |  |
| voice_start_time_interval | Unknown |  |
| voice_total_abandoned_duration | Unknown |  |
| voice_total_answer_duration | Unknown |  |
| voice_total_answered_users | Unknown |  |
| voice_total_hold_duration | Unknown |  |
| voice_total_missed | Unknown |  |
| voice_total_outbound | Unknown |  |
| voice_total_outbound_answer_duration | Unknown |  |
| voice_total_outbound_hold_duration | Unknown |  |
| voice_total_outbound_wrap_up_duration | Unknown |  |
| voice_total_overflowed | Unknown |  |
| voice_total_queue_wait_duration | Unknown |  |
| voice_total_wrap_up_duration | Unknown |  |
| voice_upgraded_to_video_call | Unknown |  |

### phone_sms_session_participant

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| phone_sms_session_id | Unknown | PK, FK |
| display_name | Unknown |  |
| extension_deleted_time | Unknown |  |
| extension_status | Unknown |  |
| is_session_owner | Unknown |  |
| owner_id | Unknown |  |
| owner_type | Unknown |  |
| phone_number | Unknown |  |

### phone_sms_session

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| last_access_time | Unknown |  |
| session_type | Unknown |  |

### messaging_historical_queue_report

| Column | Type | Keys |
| --- | --- | --- |
| cc_queue_id | Unknown | PK |
| messaging_average_agent_first_message_speed | Unknown |  |
| messaging_average_outbound_answer_duration | Unknown |  |
| messaging_average_outbound_wrap_up_duration | Unknown |  |
| messaging_average_sent | Unknown |  |
| messaging_channel_sources | Json |  |
| messaging_end_time_interval | Unknown |  |
| messaging_inbound_average_messaging_duration | Unknown |  |
| messaging_inbound_average_waiting_duration | Unknown |  |
| messaging_inbound_longest_messaging_duration | Unknown |  |
| messaging_inbound_longest_waiting_duration | Unknown |  |
| messaging_inbound_shortest_messaging_duration | Unknown |  |
| messaging_inbound_shortest_waiting_duration | Unknown |  |
| messaging_longest_agent_first_message_speed | Unknown |  |
| messaging_service_level | Unknown |  |
| messaging_shortest_agent_first_message_speed | Unknown |  |
| messaging_start_time_interval | Unknown |  |
| messaging_total_abandoned | Unknown |  |
| messaging_total_auto_closed | Unknown |  |
| messaging_total_outbound | Unknown |  |
| messaging_total_outbound_answer_duration | Unknown |  |
| messaging_total_outbound_wrap_up_duration | Unknown |  |
| messaging_total_overflowed | Unknown |  |
| messaging_total_released | Unknown |  |
| messaging_total_sent | Unknown |  |
| messaging_upgraded_to_video_call | Unknown |  |
| messaging_upgraded_to_voice_call | Unknown |  |
| queue_name | Unknown |  |
| total_completed | Unknown |  |
| total_inbound | Unknown |  |
| total_transferred_in | Unknown |  |
| total_transferred_out | Unknown |  |

### video_historical_queue_report

| Column | Type | Keys |
| --- | --- | --- |
| cc_queue_id | Unknown | PK |
| queue_name | Unknown |  |
| total_completed | Unknown |  |
| total_inbound | Unknown |  |
| total_transferred_in | Unknown |  |
| total_transferred_out | Unknown |  |
| video_average_talking_duration | Unknown |  |
| video_average_waiting_duration | Unknown |  |
| video_average_wrap_up_duration | Unknown |  |
| video_end_time_interval | Unknown |  |
| video_hold_abandoned | Unknown |  |
| video_long_abandoned | Unknown |  |
| video_longest_talking_duration | Unknown |  |
| video_longest_waiting_duration | Unknown |  |
| video_longest_wrap_up_duration | Unknown |  |
| video_service_level | Unknown |  |
| video_short_abandoned | Unknown |  |
| video_shortest_talking_duration | Unknown |  |
| video_shortest_waiting_duration | Unknown |  |
| video_shortest_wrap_up_duration | Unknown |  |
| video_start_time_interval | Unknown |  |
| video_total_missed | Unknown |  |
| video_total_overflowed | Unknown |  |

### phone_call_log

| Column | Type | Keys |
| --- | --- | --- |
| call_id | Unknown | PK |
| callee_codec | Unknown |  |
| callee_device_private_ip | Unknown |  |
| callee_device_public_ip | Unknown |  |
| callee_device_type | Unknown |  |
| callee_extension_number | Unknown |  |
| callee_headset | Unknown |  |
| callee_isp | Unknown |  |
| callee_microphone | Unknown |  |
| callee_phone_number | Unknown |  |
| callee_site_id | Unknown |  |
| caller_codec | Unknown |  |
| caller_device_private_ip | Unknown |  |
| caller_device_public_ip | Unknown |  |
| caller_device_type | Unknown |  |
| caller_extension_number | Unknown |  |
| caller_headset | Unknown |  |
| caller_isp | Unknown |  |
| caller_microphone | Unknown |  |
| caller_phone_number | Unknown |  |
| caller_site_id | Unknown |  |
| date_time | Unknown |  |
| direction | Unknown |  |
| duration | Unknown |  |
| mos | Unknown |  |

### agent_status_history

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| user_id | Unknown | FK |
| display_name | Unknown |  |
| duration | Unknown |  |
| end_time | Instant |  |
| occupied_engagements | Json |  |
| start_time | Instant |  |
| status_id | Unknown |  |
| status_name | Unknown |  |
| sub_status_id | Unknown |  |
| sub_status_name | Unknown |  |

### deal

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| owner_id | Unknown | FK |
| account_name | Unknown |  |
| account_type | Unknown |  |
| amount | Unknown |  |
| close_date | Unknown |  |
| create_time | Instant |  |
| currency_type | Unknown |  |
| description | Unknown |  |
| is_closed | Unknown |  |
| is_private | Unknown |  |
| last_activity_time | Instant |  |
| name | Unknown |  |
| number_of_conversations | Unknown |  |
| owner_email | Unknown |  |
| owner_name | Unknown |  |
| stage | Unknown |  |
| time_in_stage | Unknown |  |

### messaging_agent_leg_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| cc_queue_id | Unknown | FK |
| disposition_id | Unknown | FK |
| engagement_id | Unknown | FK |
| agent_end_time | Unknown |  |
| agent_first_response_duration | Unknown |  |
| agent_offered | Unknown |  |
| agent_start_time | Unknown |  |
| channel | Unknown |  |
| channel_source | Unknown |  |
| conference_count | Unknown |  |
| conference_duration | Unknown |  |
| conversation_duration | Unknown |  |
| direct_transfer | Unknown |  |
| display_name | Unknown |  |
| disposition_name | Unknown |  |
| handle_duration | Unknown |  |
| handled_engagement | Unknown |  |
| hold_count | Unknown |  |
| hold_duration | Unknown |  |
| queue_name | Unknown |  |
| refused_engagement | Unknown |  |
| ring_duration | Unknown |  |
| user_email | Unknown |  |
| user_id | Unknown |  |
| warm_conference | Unknown |  |
| warm_conference_duration | Unknown |  |
| warm_transfer_completed | Unknown |  |
| warm_transfer_duration | Unknown |  |
| warm_transfer_initiated | Unknown |  |
| wrap_up_duration | Unknown |  |

### agent_time_sheet

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| user_id | Unknown | FK |
| average_video_call_talking_duration | Unknown |  |
| average_wrap_up_duration | Unknown |  |
| display_name | Unknown |  |
| end_time_interval | Unknown |  |
| inbound_average_voice_call_talking_duration | Unknown |  |
| not_ready_duration | Unknown |  |
| not_ready_percentage | Unknown |  |
| occupied_duration | Unknown |  |
| occupied_percentage | Unknown |  |
| offline_duration | Unknown |  |
| online_duration | Unknown |  |
| ready_duration | Unknown |  |
| ready_percentage | Unknown |  |
| start_time_interval | Unknown |  |
| total_inbound_voice_call | Unknown |  |
| total_inbound_voice_call_duration | Unknown |  |
| total_outbound_voice_call | Unknown |  |
| total_outbound_voice_call_duration | Unknown |  |

### voice_agent_leg_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| cc_queue_id | Unknown | FK |
| disposition_id | Unknown | FK |
| engagement_id | Unknown | FK |
| agent_end_time | Unknown |  |
| agent_first_response_duration | Unknown |  |
| agent_offered | Unknown |  |
| agent_start_time | Unknown |  |
| channel | Unknown |  |
| channel_source | Unknown |  |
| conference_count | Unknown |  |
| conference_duration | Unknown |  |
| conversation_duration | Unknown |  |
| direct_transfer | Unknown |  |
| display_name | Unknown |  |
| disposition_name | Unknown |  |
| handle_duration | Unknown |  |
| handled_engagement | Unknown |  |
| hold_count | Unknown |  |
| hold_duration | Unknown |  |
| queue_name | Unknown |  |
| refused_engagement | Unknown |  |
| ring_duration | Unknown |  |
| user_email | Unknown |  |
| user_id | Unknown |  |
| warm_conference | Unknown |  |
| warm_conference_duration | Unknown |  |
| warm_transfer_completed | Unknown |  |
| warm_transfer_duration | Unknown |  |
| warm_transfer_initiated | Unknown |  |
| wrap_up_duration | Unknown |  |

### conversation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| deal_id | Unknown | FK |
| host_id | Unknown | FK |
| conversation_topic | Unknown |  |
| conversation_type | Unknown |  |
| duration | Unknown |  |
| duration_sec | Unknown |  |
| engagement_score | Unknown |  |
| engaging_questions_count | Unknown |  |
| filler_words_count | Unknown |  |
| iq_processed_time | Unknown |  |
| meeting_id | Unknown |  |
| meeting_start_time | Unknown |  |
| meeting_uuid | Unknown |  |
| next_steps_count | Unknown |  |
| processing_analysis | Unknown |  |
| sentiment_score | Unknown |  |
| topic | Unknown |  |

### email_historical_queue_report

| Column | Type | Keys |
| --- | --- | --- |
| cc_queue_id | Unknown | PK |
| email_end_time_interval | Unknown |  |
| email_inbound_average_agent_first_reply_duration | Unknown |  |
| email_inbound_average_agent_reply_duration | Unknown |  |
| email_inbound_average_inactive_duration | Unknown |  |
| email_inbound_average_messaging_duration | Unknown |  |
| email_inbound_average_waiting_duration | Unknown |  |
| email_inbound_longest_agent_first_reply_duration | Unknown |  |
| email_inbound_longest_agent_reply_duration | Unknown |  |
| email_inbound_longest_inactive_duration | Unknown |  |
| email_inbound_longest_messaging_duration | Unknown |  |
| email_inbound_longest_waiting_duration | Unknown |  |
| email_inbound_shortest_agent_first_reply_duration | Unknown |  |
| email_inbound_shortest_agent_reply_duration | Unknown |  |
| email_inbound_shortest_inactive_duration | Unknown |  |
| email_inbound_shortest_messaging_duration | Unknown |  |
| email_inbound_shortest_waiting_duration | Unknown |  |
| email_service_level | Unknown |  |
| email_start_time_interval | Unknown |  |
| email_total_auto_closed | Unknown |  |
| email_total_handled | Unknown |  |
| email_total_offered | Unknown |  |
| email_total_offers | Unknown |  |
| email_total_offers_acd | Unknown |  |
| email_total_offers_answered | Unknown |  |
| email_total_offers_declined | Unknown |  |
| email_total_offers_missed | Unknown |  |
| email_total_offers_non_acd | Unknown |  |
| email_total_overflowed | Unknown |  |
| email_total_released | Unknown |  |
| email_total_transferred_in_to_agent | Unknown |  |
| email_total_transferred_in_to_queue | Unknown |  |
| email_total_transferred_out_of_queue | Unknown |  |
| email_total_transferred_out_within_queue | Unknown |  |
| queue_name | Unknown |  |
| total_completed | Unknown |  |
| total_inbound | Unknown |  |
| total_transferred_in | Unknown |  |
| total_transferred_out | Unknown |  |

### email_historical_detail_report_channel

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| channel | Unknown |  |
| channel_source | Unknown |  |

### email_historical_detail_report_flow

| Column | Type | Keys |
| --- | --- | --- |
| flow_id | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| flow_name | Unknown |  |
| flow_version | Unknown |  |

### email_historical_detail_report_queue

| Column | Type | Keys |
| --- | --- | --- |
| cc_queue_id | Unknown | PK, FK |
| engagement_id | Unknown | PK, FK |
| queue_name | Unknown |  |

### email_historical_detail_report_agent

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| display_name | Unknown |  |
| user_id | Unknown |  |

### email_historical_detail_report_required_skill

| Column | Type | Keys |
| --- | --- | --- |
| skill_id | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| minimum_proficiency_level | Unknown |  |
| skill_name | Unknown |  |

### email_historical_detail_report_optional_skill

| Column | Type | Keys |
| --- | --- | --- |
| skill_id | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| minimum_proficiency_level | Unknown |  |
| skill_name | Unknown |  |

### email_historical_detail_report_agent_skill

| Column | Type | Keys |
| --- | --- | --- |
| skill_id | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| minimum_proficiency_level | Unknown |  |
| skill_name | Unknown |  |

### email_historical_detail_report

| Column | Type | Keys |
| --- | --- | --- |
| engagement_id | Unknown | PK |
| disposition_id | Unknown | FK |
| agent_first_message_speed | Unknown |  |
| callback_pending_duration | Unknown |  |
| callback_waiting_duration | Unknown |  |
| channel | Unknown |  |
| consumer_id | Unknown |  |
| consumer_name | Unknown |  |
| consumer_number | Unknown |  |
| dialed_numbers | Json |  |
| direction | Unknown |  |
| disposition_name | Unknown |  |
| handling_duration | Unknown |  |
| hold_duration | Unknown |  |
| ivr_duration | Unknown |  |
| last_widget_name | Unknown |  |
| queue_wait_type | Unknown |  |
| results | Unknown |  |
| ring_duration | Unknown |  |
| start_time | Instant |  |
| talking_duration | Unknown |  |
| total_duration | Unknown |  |
| total_flow_duration | Unknown |  |
| waiting_duration | Unknown |  |
| wrap_up_duration | Unknown |  |

### video_historical_detail_report_channel

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| channel | Unknown |  |
| channel_source | Unknown |  |

### video_historical_detail_report_flow

| Column | Type | Keys |
| --- | --- | --- |
| flow_id | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| flow_name | Unknown |  |
| flow_version | Unknown |  |

### video_historical_detail_report_queue

| Column | Type | Keys |
| --- | --- | --- |
| cc_queue_id | Unknown | PK, FK |
| engagement_id | Unknown | PK, FK |
| queue_name | Unknown |  |

### video_historical_detail_report_agent

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| display_name | Unknown |  |
| user_id | Unknown |  |

### video_historical_detail_report_required_skill

| Column | Type | Keys |
| --- | --- | --- |
| skill_id | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| minimum_proficiency_level | Unknown |  |
| skill_name | Unknown |  |

### video_historical_detail_report_optional_skill

| Column | Type | Keys |
| --- | --- | --- |
| skill_id | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| minimum_proficiency_level | Unknown |  |
| skill_name | Unknown |  |

### video_historical_detail_report_agent_skill

| Column | Type | Keys |
| --- | --- | --- |
| skill_id | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| minimum_proficiency_level | Unknown |  |
| skill_name | Unknown |  |

### video_historical_detail_report

| Column | Type | Keys |
| --- | --- | --- |
| engagement_id | Unknown | PK |
| disposition_id | Unknown | FK |
| agent_first_message_speed | Unknown |  |
| callback_pending_duration | Unknown |  |
| callback_waiting_duration | Unknown |  |
| channel | Unknown |  |
| consumer_id | Unknown |  |
| consumer_name | Unknown |  |
| consumer_number | Unknown |  |
| dialed_numbers | Json |  |
| direction | Unknown |  |
| disposition_name | Unknown |  |
| handling_duration | Unknown |  |
| hold_duration | Unknown |  |
| ivr_duration | Unknown |  |
| last_widget_name | Unknown |  |
| queue_wait_type | Unknown |  |
| results | Unknown |  |
| ring_duration | Unknown |  |
| start_time | Instant |  |
| talking_duration | Unknown |  |
| total_duration | Unknown |  |
| total_flow_duration | Unknown |  |
| waiting_duration | Unknown |  |
| wrap_up_duration | Unknown |  |

### messaging_historical_detail_report_channel

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| channel | Unknown |  |
| channel_source | Unknown |  |

### messaging_historical_detail_report_flow

| Column | Type | Keys |
| --- | --- | --- |
| flow_id | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| flow_name | Unknown |  |
| flow_version | Unknown |  |

### messaging_historical_detail_report_queue

| Column | Type | Keys |
| --- | --- | --- |
| cc_queue_id | Unknown | PK, FK |
| engagement_id | Unknown | PK, FK |
| queue_name | Unknown |  |

### messaging_historical_detail_report_agent

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| display_name | Unknown |  |
| user_id | Unknown |  |

### messaging_historical_detail_report_required_skill

| Column | Type | Keys |
| --- | --- | --- |
| skill_id | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| minimum_proficiency_level | Unknown |  |
| skill_name | Unknown |  |

### messaging_historical_detail_report_optional_skill

| Column | Type | Keys |
| --- | --- | --- |
| skill_id | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| minimum_proficiency_level | Unknown |  |
| skill_name | Unknown |  |

### messaging_historical_detail_report_agent_skill

| Column | Type | Keys |
| --- | --- | --- |
| skill_id | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| minimum_proficiency_level | Unknown |  |
| skill_name | Unknown |  |

### messaging_historical_detail_report

| Column | Type | Keys |
| --- | --- | --- |
| engagement_id | Unknown | PK |
| disposition_id | Unknown | FK |
| agent_first_message_speed | Unknown |  |
| callback_pending_duration | Unknown |  |
| callback_waiting_duration | Unknown |  |
| channel | Unknown |  |
| consumer_id | Unknown |  |
| consumer_name | Unknown |  |
| consumer_number | Unknown |  |
| dialed_numbers | Json |  |
| direction | Unknown |  |
| disposition_name | Unknown |  |
| handling_duration | Unknown |  |
| hold_duration | Unknown |  |
| ivr_duration | Unknown |  |
| last_widget_name | Unknown |  |
| queue_wait_type | Unknown |  |
| results | Unknown |  |
| ring_duration | Unknown |  |
| start_time | Instant |  |
| talking_duration | Unknown |  |
| total_duration | Unknown |  |
| total_flow_duration | Unknown |  |
| waiting_duration | Unknown |  |
| wrap_up_duration | Unknown |  |

### deal_activity

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| deal_id | Unknown | PK, FK |
| conversation_id | Unknown | FK |
| host_id | Unknown | FK |
| activity_type | Unknown |  |
| conversation_topic | Unknown |  |
| direction | Unknown |  |
| duration | Unknown |  |
| engagement_score | Unknown |  |
| message_id | Unknown |  |
| number_of_message_in_thread | Unknown |  |
| processing_analysis | Unknown |  |
| sentiment_score | Unknown |  |
| stage | Unknown |  |
| stage_during_conversation | Unknown |  |
| start_date | Instant |  |

### conversation_scorecard_question

| Column | Type | Keys |
| --- | --- | --- |
| question_id | Unknown | PK |
| conversation_id | Unknown | PK, FK |
| conversation_scorecard_id | Unknown | PK, FK |
| max_score_label | Unknown |  |
| min_score_label | Unknown |  |
| question_comment | Unknown |  |
| question_description | Unknown |  |
| question_title | Unknown |  |
| score | Unknown |  |

### conversation_scorecard

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| conversation_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| average_score | Unknown |  |
| rate_time | Unknown |  |
| rater_display_name | Unknown |  |
| rater_email | Unknown |  |
| rater_user_id | Unknown |  |
| scorecard_description | Unknown |  |
| scorecard_name | Unknown |  |

### engagement_survey_result

| Column | Type | Keys |
| --- | --- | --- |
| question_id | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| survey_id | Unknown | PK, FK |
| answer | Unknown |  |
| date_time | Unknown |  |
| file_url | Unknown |  |
| question_name | Unknown |  |
| question_order | Unknown |  |
| question_type | Unknown |  |

### engagement_survey

| Column | Type | Keys |
| --- | --- | --- |
| survey_id | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| flow_id | Unknown | FK |
| queue_id | Unknown | FK |
| flow_name | Unknown |  |
| queue_name | Unknown |  |
| survey_name | Unknown |  |
| survey_trigger_level | Unknown |  |

### engagement_channel

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| channel | Unknown |  |
| channel_source | Unknown |  |

### engagement_consumer

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| consumer_display_name | Unknown |  |
| consumer_id | Unknown |  |
| consumer_number | Unknown |  |

### engagement_flow

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| flow_id | Unknown |  |
| flow_name | Unknown |  |
| flow_version | Unknown |  |

### engagement_queues

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| cc_queue_id | Unknown |  |
| queue_name | Unknown |  |

### engagement_agent

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| id | Unknown | FK |
| display_name | Unknown |  |
| user_id | Unknown |  |

### engagement_event_skill

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| engagement_event_index | Unknown | PK, FK |
| engagement_id | Unknown | PK, FK |
| skill_category_id | Unknown |  |
| skill_category_name | Unknown |  |
| skill_id | Unknown |  |
| skill_name | Unknown |  |
| skill_proficiency_level | Unknown |  |

### engagement_event

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| transfer_to_user_id | Unknown | FK |
| user_id | Unknown | FK |
| accept_type | Unknown |  |
| cc_queue_id | Unknown |  |
| channel | Unknown |  |
| channel_source | Unknown |  |
| conference_type | Unknown |  |
| consumer_display_name | Unknown |  |
| consumer_id | Unknown |  |
| crm_call_status | Unknown |  |
| crm_type | Unknown |  |
| direction | Unknown |  |
| duration | Unknown |  |
| email_reply_bcc | Json |  |
| email_reply_cc | Json |  |
| email_reply_to | Json |  |
| event_type | Unknown |  |
| flow_id | Unknown |  |
| flow_name | Unknown |  |
| inbox_id | Unknown |  |
| inbox_name | Unknown |  |
| invitee | Unknown |  |
| invitee_type | Unknown |  |
| queue_name | Unknown |  |
| start_time | Unknown |  |
| supervisor_display_name | Unknown |  |
| supervisor_id | Unknown |  |
| transfer_to_cc_queue_id | Unknown |  |
| transfer_to_flow_id | Unknown |  |
| transfer_to_flow_name | Unknown |  |
| transfer_to_number | Unknown |  |
| transfer_to_queue_name | Unknown |  |
| transfer_to_user_display_name | Unknown |  |
| transfer_type | Unknown |  |
| upgraded_to_channel_type | Unknown |  |
| user_display_name | Unknown |  |

### engagement_disposition

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| id | Unknown | FK |
| disposition_id | Unknown |  |
| disposition_name | Unknown |  |

### engagement_notes

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| last_modified_time | Unknown |  |
| note | Unknown |  |
| note_id | Unknown |  |
| user_id | Unknown |  |

### engagement

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| channel_types | Unknown |  |
| direction | Unknown |  |
| duration | Unknown |  |
| end_time | Unknown |  |
| flow_duration | Unknown |  |
| handling_duration | Unknown |  |
| queue_wait_type | Unknown |  |
| start_time | Unknown |  |
| survey_id | Unknown |  |
| talk_duration | Unknown |  |
| transcript_url | Unknown |  |
| transfer_count | Unknown |  |
| voice_mail | Unknown |  |
| waiting_duration | Unknown |  |
| wrap_up_duration | Unknown |  |

## Relationships

- meeting_report_custom_key(meeting_report_uuid) → meeting_report(uuid)
- meeting_report_tracking(meeting_report_uuid) → meeting_report(uuid)
- meeting_report(uuid) → meeting(uuid)
- meeting(host_id) → users(id)
- event_survey_report_question_answer(event_id) → event_survey_report(event_id)
- event_survey_report_question_answer(event_survey_report_fivetran_id) → event_survey_report(_fivetran_id)
- event_survey_report(event_id) → event(id)
- account_parent_team(account_team_id) → account_team(id)
- event_attendance_report_ticket_question(event_id) → event_attendance_report_ticket(event_id)
- event_attendance_report_ticket_question(event_attendance_fivetran_id) → event_attendance_report_ticket(event_attendance_fivetran_id)
- event_attendance_report_ticket_question(event_attendance_report_ticket_index) → event_attendance_report_ticket(index)
- event_attendance_report_ticket(event_id) → event_attendance_report(event_id)
- event_attendance_report_ticket(event_attendance_fivetran_id) → event_attendance_report(_fivetran_id)
- event_attendance_report_session_attendance(event_id) → event_attendance_report(event_id)
- event_attendance_report_session_attendance(event_attendance_report_fivetran_id) → event_attendance_report(_fivetran_id)
- event_attendance_report(event_id) → event(id)
- user_meeting_report(host_id) → users(id)
- user_meeting_report(user_id) → users(id)
- webinar_participant(user_id) → users(id)
- webinar_participant(participant_user_id) → users(id)
- webinar_participant(webinar_uuid) → webinar(uuid)
- webinar_question_and_answer_question_detail(webinar_question_and_answer_id) → webinar_question_and_answer_question(webinar_question_and_answer_id)
- webinar_question_and_answer_question_detail(webinar_uuid) → webinar_question_and_answer_question(webinar_uuid)
- webinar_question_and_answer_question_detail(webinar_question_and_answer_question_index) → webinar_question_and_answer_question(index)
- webinar_question_and_answer_question(webinar_question_and_answer_id) → webinar_question_and_answer(id)
- webinar_question_and_answer_question(webinar_uuid) → webinar_question_and_answer(webinar_uuid)
- webinar_question_and_answer(webinar_uuid) → webinar(uuid)
- webinar_absentee(registrant_id) → webinar_registrant(user_id)
- webinar_absentee(email) → users(email)
- webinar_absentee(webinar_uuid) → webinar(uuid)
- webinar_panelist(user_id) → users(id)
- webinar_panelist(webinar_uuid) → webinar(uuid)
- event_registration_ticket_question(event_id) → event_registration_ticket(event_id)
- event_registration_ticket_question(event_registration_fivetran_id) → event_registration_ticket(event_registration_fivetran_id)
- event_registration_ticket_question(event_registration_index) → event_registration_ticket(index)
- event_registration_ticket(event_id) → event_registration(event_id)
- event_registration_ticket(event_registration_fivetran_id) → event_registration(_fivetran_id)
- event_registration(event_id) → event(id)
- disposition(modified_by) → users(id)
- webinar_poll_question(webinar_poll_id) → webinar_poll(id)
- webinar_poll_question(webinar_uuid) → webinar_poll(webinar_uuid)
- webinar_poll(webinar_uuid) → webinar(uuid)
- webinar_registrant_custom_question(webinar_uuid) → webinar_registrant(webinar_uuid)
- webinar_registrant_custom_question(user_id) → webinar_registrant(user_id)
- webinar_registrant(user_id) → users(id)
- webinar_registrant(email) → users(email)
- webinar_registrant(webinar_uuid) → webinar(uuid)
- phone_call_path(phone_call_history_id) → phone_call_history(id)
- webinar_tracking_source(webinar_uuid) → webinar(uuid)
- phone_call_history(group_id) → user_group(group_id)
- webinar(host_id) → users(id)
- user_group(user_id) → users(id)
- user_im_group(user_id) → users(id)
- user_custom_attribute(user_id) → users(id)
- webinar_report_custom_key(webinar_report_fivetran_id) → webinar_report(_fivetran_id)
- webinar_report_tracking(webinar_report_fivetran_id) → webinar_report(_fivetran_id)
- webinar_report(uuid) → webinar(uuid)
- meeting_participant(user_id) → users(id)
- meeting_participant(participant_user_id) → users(id)
- meeting_participant(user_meeting_report_uuid) → user_meeting_report(uuid)
- voice_historical_detail_report_channel(engagement_id) → voice_historical_detail_report(engagement_id)
- voice_historical_detail_report_flow(engagement_id) → voice_historical_detail_report(engagement_id)
- voice_historical_detail_report_queue(cc_queue_id) → voice_historical_queue_report(cc_queue_id)
- voice_historical_detail_report_queue(engagement_id) → voice_historical_detail_report(engagement_id)
- voice_historical_detail_report_agent(engagement_id) → voice_historical_detail_report(engagement_id)
- voice_historical_detail_report_required_skill(engagement_id) → voice_historical_detail_report(engagement_id)
- voice_historical_detail_report_optional_skill(engagement_id) → voice_historical_detail_report(engagement_id)
- voice_historical_detail_report_agent_skill(engagement_id) → voice_historical_detail_report(engagement_id)
- voice_historical_detail_report(disposition_id) → disposition(id)
- phone_sms_session_participant(phone_sms_session_id) → phone_sms_session(id)
- agent_status_history(user_id) → users(id)
- deal(owner_id) → users(id)
- messaging_agent_leg_report(engagement_id) → engagement(id)
- messaging_agent_leg_report(disposition_id) → disposition(id)
- messaging_agent_leg_report(cc_queue_id) → messaging_historical_queue_report(cc_queue_id)
- agent_time_sheet(user_id) → users(id)
- voice_agent_leg_report(engagement_id) → engagement(id)
- voice_agent_leg_report(disposition_id) → disposition(id)
- voice_agent_leg_report(cc_queue_id) → voice_historical_queue_report(cc_queue_id)
- conversation(deal_id) → deal(id)
- conversation(host_id) → users(id)
- email_historical_detail_report_channel(engagement_id) → email_historical_detail_report(engagement_id)
- email_historical_detail_report_flow(engagement_id) → email_historical_detail_report(engagement_id)
- email_historical_detail_report_queue(cc_queue_id) → email_historical_queue_report(cc_queue_id)
- email_historical_detail_report_queue(engagement_id) → email_historical_detail_report(engagement_id)
- email_historical_detail_report_agent(engagement_id) → email_historical_detail_report(engagement_id)
- email_historical_detail_report_required_skill(engagement_id) → email_historical_detail_report(engagement_id)
- email_historical_detail_report_optional_skill(engagement_id) → email_historical_detail_report(engagement_id)
- email_historical_detail_report_agent_skill(engagement_id) → email_historical_detail_report(engagement_id)
- email_historical_detail_report(disposition_id) → disposition(id)
- video_historical_detail_report_channel(engagement_id) → video_historical_detail_report(engagement_id)
- video_historical_detail_report_flow(engagement_id) → video_historical_detail_report(engagement_id)
- video_historical_detail_report_queue(cc_queue_id) → video_historical_queue_report(cc_queue_id)
- video_historical_detail_report_queue(engagement_id) → video_historical_detail_report(engagement_id)
- video_historical_detail_report_agent(engagement_id) → video_historical_detail_report(engagement_id)
- video_historical_detail_report_required_skill(engagement_id) → video_historical_detail_report(engagement_id)
- video_historical_detail_report_optional_skill(engagement_id) → video_historical_detail_report(engagement_id)
- video_historical_detail_report_agent_skill(engagement_id) → video_historical_detail_report(engagement_id)
- video_historical_detail_report(disposition_id) → disposition(id)
- messaging_historical_detail_report_channel(engagement_id) → messaging_historical_detail_report(engagement_id)
- messaging_historical_detail_report_flow(engagement_id) → messaging_historical_detail_report(engagement_id)
- messaging_historical_detail_report_queue(cc_queue_id) → messaging_historical_queue_report(cc_queue_id)
- messaging_historical_detail_report_queue(engagement_id) → messaging_historical_detail_report(engagement_id)
- messaging_historical_detail_report_agent(engagement_id) → messaging_historical_detail_report(engagement_id)
- messaging_historical_detail_report_required_skill(engagement_id) → messaging_historical_detail_report(engagement_id)
- messaging_historical_detail_report_optional_skill(engagement_id) → messaging_historical_detail_report(engagement_id)
- messaging_historical_detail_report_agent_skill(engagement_id) → messaging_historical_detail_report(engagement_id)
- messaging_historical_detail_report(disposition_id) → disposition(id)
- deal_activity(conversation_id) → conversation(id)
- deal_activity(host_id) → users(id)
- deal_activity(deal_id) → deal(id)
- conversation_scorecard_question(conversation_id) → conversation_scorecard(conversation_id)
- conversation_scorecard_question(conversation_scorecard_id) → conversation_scorecard(id)
- conversation_scorecard(conversation_id) → conversation(id)
- conversation_scorecard(user_id) → users(id)
- engagement_survey_result(survey_id) → engagement_survey(survey_id)
- engagement_survey_result(engagement_id) → engagement_survey(engagement_id)
- engagement_survey(engagement_id) → engagement(id)
- engagement_survey(queue_id) → engagement_queues(cc_queue_id)
- engagement_survey(flow_id) → engagement_flow(flow_id)
- engagement_channel(engagement_id) → engagement(id)
- engagement_consumer(engagement_id) → engagement(id)
- engagement_flow(engagement_id) → engagement(id)
- engagement_queues(engagement_id) → engagement(id)
- engagement_agent(id) → users(id)
- engagement_agent(engagement_id) → engagement(id)
- engagement_event_skill(engagement_id) → engagement_event(engagement_id)
- engagement_event_skill(engagement_event_index) → engagement_event(index)
- engagement_event(user_id) → users(id)
- engagement_event(transfer_to_user_id) → users(id)
- engagement_event(engagement_id) → engagement(id)
- engagement_disposition(id) → disposition(id)
- engagement_disposition(engagement_id) → engagement(id)
- engagement_notes(engagement_id) → engagement(id)
- engagement(id) → engagement(id)