# Zendesk Support schema ERD

Table and field reference for the Fivetran Zendesk Support connector.

## Table & Field Reference

### ivr_menu_route_option

| Column | Type | Keys |
| --- | --- | --- |
| group_id | Long | PK, FK |
| ivr_menu_route_id | Long | PK, FK |

### user

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| custom_role_id | Long | FK |
| default_group_id | Long | FK |
| organization_id | Long | FK |
| active | Boolean |  |
| alias | String |  |
| authenticity_token | String |  |
| chat_only | Boolean |  |
| created_at | Instant |  |
| details | String |  |
| email | String |  |
| external_id | String |  |
| iana_time_zone | String |  |
| last_login_at | Instant |  |
| locale | String |  |
| locale_id | Long |  |
| moderator | Boolean |  |
| name | String |  |
| notes | String |  |
| only_private_comments | Boolean |  |
| phone | String |  |
| remote_photo_url | String |  |
| report_csv | Boolean |  |
| restricted_agent | Boolean |  |
| role | String |  |
| role_type | Int |  |
| shared | Boolean |  |
| shared_agent | Boolean |  |
| shared_phone_number | String |  |
| signature | String |  |
| suspended | Boolean |  |
| ticket_restriction | String |  |
| time_zone | String |  |
| two_factor_auth_enabled | Boolean |  |
| updated_at | Instant |  |
| url | String |  |
| verified | Boolean |  |

### agent_status_type_group

| Column | Type | Keys |
| --- | --- | --- |
| group_id | String | PK |
| agent_status_type_id | Long | PK, FK |

### line_categorised_greeting

| Column | Type | Keys |
| --- | --- | --- |
| category_id | String | PK, FK |
| greeting_id | String | PK, FK |
| line_id | Long | PK, FK |

### satisfaction_rating

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| assignee_id | Long | FK |
| group_id | Long | FK |
| requester_id | Long | FK |
| ticket_id | Long | FK |
| comment | String |  |
| created_at | Instant |  |
| reason | String |  |
| score | String |  |
| updated_at | Instant |  |
| url | String |  |

### ticket_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| active | Boolean |  |
| agent_description | String |  |
| collapsed_for_agents | Boolean |  |
| created_at | Instant |  |
| description | String |  |
| editable_in_portal | Boolean |  |
| key | String |  |
| position | Int |  |
| raw_description | String |  |
| raw_title | String |  |
| raw_title_in_portal | String |  |
| regexp_for_validation | String |  |
| relationship_target_type | String |  |
| removable | Boolean |  |
| required | Boolean |  |
| required_in_portal | Boolean |  |
| sub_type_id | Int |  |
| system | Boolean |  |
| tag | String |  |
| title | String |  |
| title_in_portal | String |  |
| type | String |  |
| updated_at | Instant |  |
| url | String |  |
| visible_in_portal | Boolean |  |

### daylight_time

| Column | Type | Keys |
| --- | --- | --- |
| time_zone | String | PK |
| year | Int | PK |
| daylight_end_utc | LocalDateTime |  |
| daylight_offset | Int |  |
| daylight_start_utc | LocalDateTime |  |

### csat_survey_closed_ended_option

| Column | Type | Keys |
| --- | --- | --- |
| option_id | String | PK |
| question_id | String | PK |
| survey_id | String | PK |
| survey_version | Long | PK |
| label_key | String |  |
| label_type | String |  |
| label_value | String |  |

### macro_action

| Column | Type | Keys |
| --- | --- | --- |
| field | String | PK |
| macro_id | Long | PK, FK |
| value | Json |  |

### user_subscription

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| followed_id | Long | FK |
| follower_id | Long | FK |

### ticket_field_option

| Column | Type | Keys |
| --- | --- | --- |
| value | String | PK |
| ticket_custom_field_id | Long | FK |
| default | Boolean |  |
| id | Long |  |
| name | String |  |

### ticket_tag_history

| Column | Type | Keys |
| --- | --- | --- |
| tag | String | PK |
| updated | Instant | PK |
| ticket_id | Long | PK, FK |
| user_id | Long | FK |
| tagged | Boolean |  |
| via_channel | String |  |
| via_source_from_address | String |  |
| via_source_from_id | Long |  |
| via_source_from_title | String |  |
| via_source_rel | String |  |
| via_source_to_address | String |  |
| via_source_to_name | String |  |

### ticket_email_cc

| Column | Type | Keys |
| --- | --- | --- |
| ticket_id | Long | PK, FK |
| user_id | Long | PK, FK |

### organization

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| group_id | Long | FK |
| created_at | Instant |  |
| details | String |  |
| external_id | String |  |
| name | String |  |
| notes | String |  |
| shared_comments | Boolean |  |
| shared_tickets | Boolean |  |
| updated_at | Instant |  |
| url | String |  |

### address

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| city | String |  |
| country_code | String |  |
| name | String |  |
| provider_reference | String |  |
| province | String |  |
| state | String |  |
| street | String |  |
| zip | String |  |

### ticket

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| assignee_id | Long | FK |
| brand_id | Long | FK |
| custom_status_id | Long | FK |
| forum_topic_id | Long | FK |
| group_id | Long | FK |
| organization_id | Long | FK |
| requester_id | Long | FK |
| submitter_id | Long | FK |
| allow_attachments | Boolean |  |
| allow_channelback | Boolean |  |
| created_at | Instant |  |
| description | String |  |
| due_at | Instant |  |
| external_id | String |  |
| followup_ids | Json |  |
| from_messaging_channel | Boolean |  |
| has_incidents | Boolean |  |
| is_public | Boolean |  |
| merged_ticket_ids | Json |  |
| priority | String |  |
| problem_id | Long |  |
| raw_subject | String |  |
| recipient | String |  |
| status | String |  |
| subject | String |  |
| support_type | String |  |
| ticket_form_id | Long |  |
| type | String |  |
| updated_at | Instant |  |
| url | String |  |
| via_channel | String |  |
| via_followup_source_id | Long |  |
| via_source_from_address | String |  |
| via_source_from_id | Long |  |
| via_source_from_title | String |  |
| via_source_rel | String |  |
| via_source_to_address | String |  |
| via_source_to_name | String |  |

### alert_recipient

| Column | Type | Keys |
| --- | --- | --- |
| ticket_alert_id | Long | PK, FK |
| user_id | Long | PK, FK |

### schedule

| Column | Type | Keys |
| --- | --- | --- |
| end_time | Int | PK |
| id | Long | PK |
| start_time | Int | PK |
| created_at | Instant |  |
| name | String |  |
| time_zone | String |  |

### trigger_action

| Column | Type | Keys |
| --- | --- | --- |
| field | String | PK |
| trigger_id | Long | PK, FK |
| value | Json |  |

### user_segment_organization

| Column | Type | Keys |
| --- | --- | --- |
| organization_id | Long | PK, FK |
| user_segment_id | Long | PK, FK |

### ticket_follower

| Column | Type | Keys |
| --- | --- | --- |
| ticket_id | Long | PK, FK |
| user_id | Long | PK, FK |

### automation_condition

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| automation_id | Long | PK, FK |
| condition_type | String |  |
| field | String |  |
| operator | String |  |
| value | Json |  |

### csat_survey_question

| Column | Type | Keys |
| --- | --- | --- |
| question_id | String | PK |
| survey_id | String | PK |
| survey_version | Long | PK |
| alias | String |  |
| headline_key | String |  |
| headline_type | String |  |
| headline_value | String |  |
| sub_type | String |  |
| type | String |  |

### content_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_at | Instant |  |
| name | String |  |
| updated_at | Instant |  |

### call_leg

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| agent_id | Long | FK |
| call_id | Long | FK |
| user_id | Long | FK |
| available_via | String |  |
| call_charge | String |  |
| completion_status | String |  |
| conference_from | Long |  |
| conference_time | Long |  |
| conference_to | Long |  |
| consultation_from | Long |  |
| consultation_time | Long |  |
| consultation_to | Long |  |
| created_at | Instant |  |
| duration | Long |  |
| forwarded_to | String |  |
| hold_time | Long |  |
| minutes_billed | Long |  |
| talk_time | Long |  |
| transferred_from | Long |  |
| transferred_to | Long |  |
| type | String |  |
| updated_at | Instant |  |
| wrap_up_time | Long |  |

### agent_condition

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| child_field_id | Long | FK |
| parent_field_id | Long | FK |
| ticket_form_id | Long | FK |
| is_required | Boolean |  |
| parent_field_type | String |  |
| required_on_statuses_type | String |  |
| value | String |  |

### ticket_form_restricted_brand

| Column | Type | Keys |
| --- | --- | --- |
| brand_id | Long | PK, FK |
| ticket_form_id | Long | PK, FK |

### greeting

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| category_id | Long | FK |
| active | Boolean |  |
| audio_name | String |  |
| audio_url | String |  |
| default_lang | Boolean |  |
| has_sub_settings | Boolean |  |
| name | String |  |
| pending | Boolean |  |
| system_default | Boolean |  |
| upload_id | Long |  |

### ticket_csat_survey

| Column | Type | Keys |
| --- | --- | --- |
| survey_response_id | String | PK |
| ticket_id | Long | PK, FK |
| survey_id | String | FK |
| survey_version | Long | FK |
| expires_at | Instant |  |
| responder_id | String |  |
| subject_zrns | Json |  |
| subjects | Json |  |
| survey_state | String |  |

### article_label_name

| Column | Type | Keys |
| --- | --- | --- |
| label_name | String | PK |
| article_id | Long | PK, FK |

### article_outdated_locale

| Column | Type | Keys |
| --- | --- | --- |
| outdated_locale | String | PK |
| article_id | Long | PK, FK |

### ticket_group_sla_policy

| Column | Type | Keys |
| --- | --- | --- |
| group_sla_policy_id | String | PK, FK |
| ticket_id | Long | PK, FK |
| group_policy_applied_at | Instant |  |

### time_zone

| Column | Type | Keys |
| --- | --- | --- |
| time_zone | String | PK |
| standard_offset | String |  |

### user_segment

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| built_in | Boolean |  |
| created_at | Instant |  |
| name | String |  |
| updated_at | Instant |  |
| user_type | String |  |

### greeting_ivr

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| greeting_id | String | PK, FK |

### ticket_field_history

| Column | Type | Keys |
| --- | --- | --- |
| field_name | String | PK |
| updated | Instant | PK |
| ticket_id | Long | PK, FK |
| user_id | Long | FK |
| value | String |  |
| via_channel | String |  |
| via_source_from_address | String |  |
| via_source_from_id | Long |  |
| via_source_from_title | String |  |
| via_source_rel | String |  |
| via_source_to_address | String |  |
| via_source_to_name | String |  |

### line

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| brand_id | Long | FK |
| ivr_id | Long | FK |
| schedule_id | Long | FK |
| call_recording_consent | String |  |
| country_code | String |  |
| created_at | Instant |  |
| default_group_id | Long |  |
| display_number | String |  |
| external | Boolean |  |
| failover_number | String |  |
| line_type | String |  |
| location | String |  |
| name | String |  |
| nickname | String |  |
| number | String |  |
| outbound_enabled | Boolean |  |
| outbound_number | String |  |
| priority | Long |  |
| recorded | Boolean |  |
| sms_enabled | Boolean |  |
| sms_group_id | Long |  |
| token | String |  |
| toll_free | Boolean |  |
| transcription | Boolean |  |
| voice_enabled | Boolean |  |
| capabilities_** |  |  |

### tweet_recipient

| Column | Type | Keys |
| --- | --- | --- |
| ticket_comment_id | Long | PK, FK |
| user_id | Long | PK, FK |

### ticket_comment_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| ticket_comment_id | Long | FK |
| _fivetran_file_path | String |  |
| content_type | String |  |
| content_url | String |  |
| deleted | Boolean |  |
| file_name | String |  |
| height | Long |  |
| inline | Boolean |  |
| malware_access_override | Boolean |  |
| malware_scan_result | String |  |
| mapped_content_url | String |  |
| size | Long |  |
| width | Long |  |

### ticket_schedule

| Column | Type | Keys |
| --- | --- | --- |
| created_at | Instant | PK |
| ticket_id | Long | PK, FK |
| schedule_id | Long | FK |

### organization_tag

| Column | Type | Keys |
| --- | --- | --- |
| tag | String | PK |
| organization_id | Long | PK, FK |

### ticket_sla_policy

| Column | Type | Keys |
| --- | --- | --- |
| policy_applied_at | Instant | PK |
| sla_policy_id | Long | PK, FK |
| ticket_id | Long | PK, FK |

### ticket_tag

| Column | Type | Keys |
| --- | --- | --- |
| tag | String | PK |
| ticket_id | Long | PK, FK |

### category

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_at | Instant |  |
| description | String |  |
| html_url | String |  |
| locale | String |  |
| name | String |  |
| outdated | Boolean |  |
| position | Long |  |
| source_locale | String |  |
| updated_at | Instant |  |
| url | String |  |

### ticket_link

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| ticket_id | Long | FK |
| created_at | Instant |  |
| issue_id | String |  |
| issue_key | String |  |
| updated_at | Instant |  |

### article_content_tag

| Column | Type | Keys |
| --- | --- | --- |
| article_id | Long | PK, FK |
| content_tag_id | String | PK, FK |

### ticket_chat

| Column | Type | Keys |
| --- | --- | --- |
| chat_id | String | PK |
| ticket_id | Long | FK |
| user_id | Long | FK |
| authenticated | Boolean |  |
| backend | String |  |
| channel | String |  |
| conversation_id | String |  |
| initiator | String |  |
| integration_id | String |  |
| tags | Json |  |
| visitor_id | String |  |
| webpath | Json |  |

### translation

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| body | String |  |
| created_at | Instant |  |
| created_by_id | Long |  |
| draft | Boolean |  |
| html_url | String |  |
| locale | String |  |
| outdated | Boolean |  |
| source_id | Long |  |
| source_type | String |  |
| title | String |  |
| updated_at | Instant |  |
| updated_by_id | Long |  |
| url | String |  |

### ticket_form_field

| Column | Type | Keys |
| --- | --- | --- |
| ticket_field_id | Long | PK, FK |
| ticket_form_id | Long | PK, FK |

### call_leg_quality_issue

| Column | Type | Keys |
| --- | --- | --- |
| issue | String | PK |
| call_leg_id | Long | PK, FK |

### greeting_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| name | String |  |

### ticket_comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| ticket_id | Long | FK |
| user_id | Long | FK |
| body | String |  |
| created | Instant |  |
| facebook_comment | Boolean |  |
| html_body | String |  |
| metadata | String |  |
| plain_body | String |  |
| public | Boolean |  |
| tweet | Boolean |  |
| via_channel | String |  |
| via_source_from_address | String |  |
| via_source_from_id | Long |  |
| via_source_from_title | String |  |
| via_source_rel | String |  |
| via_source_to_address | String |  |
| via_source_to_name | String |  |
| voice_comment | Boolean |  |

### user_segment_group

| Column | Type | Keys |
| --- | --- | --- |
| group_id | Long | PK, FK |
| user_segment_id | Long | PK, FK |

### group

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_at | Instant |  |
| default | Boolean |  |
| description | String |  |
| is_public | Boolean |  |
| name | String |  |
| updated_at | Instant |  |
| url | String |  |

### trigger_condition

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| trigger_id | Long | PK, FK |
| condition_type | String |  |
| field | String |  |
| operator | String |  |
| value | Json |  |

### agent_channel_history

| Column | Type | Keys |
| --- | --- | --- |
| channel | String | PK |
| agent_id | Long | PK, FK |
| updated_at | Instant |  |

### sla_policy_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| updated_at | Instant | PK |
| created_at | Instant |  |
| description | String |  |
| position | Long |  |
| title | String |  |

### custom_role

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_at | Instant |  |
| description | String |  |
| name | String |  |
| role_type | Long |  |
| updated_at | Instant |  |
| configuration_** |  |  |

### agent_status_history

| Column | Type | Keys |
| --- | --- | --- |
| channel | String | PK |
| agent_id | Long | PK, FK |
| new_state | String |  |
| previous_state | String |  |
| updated_at | Instant |  |

### agent_condition_required_status

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| agent_condition_id | String | FK |
| status | String |  |

### user_tag

| Column | Type | Keys |
| --- | --- | --- |
| tag | String | PK |
| user_id | Long | PK, FK |

### line_greeting

| Column | Type | Keys |
| --- | --- | --- |
| greeting_id | String | PK, FK |
| line_id | Long | PK, FK |
| is_default | Boolean |  |

### custom_object_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| active | Boolean |  |
| created_at | Instant |  |
| custom_field_options | Json |  |
| custom_object_key | String |  |
| description | String |  |
| field_tag | String |  |
| is_system | Boolean |  |
| key | String |  |
| position | Long |  |
| properties | Json |  |
| raw_description | String |  |
| raw_title | String |  |
| readonly | Boolean |  |
| regexp_for_validation | String |  |
| relationship_filter | Json |  |
| relationship_target_type | String |  |
| required | Boolean |  |
| title | String |  |
| type | String |  |
| updated_at | Instant |  |
| url | String |  |

### macro

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| active | Boolean |  |
| app_installation | Json |  |
| created_at | Instant |  |
| default | Boolean |  |
| description | String |  |
| permissions | Json |  |
| position | String |  |
| restriction | Json |  |
| title | String |  |
| updated_at | Instant |  |
| url | String |  |

### custom_object_record

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_at | Instant |  |
| created_by_user_id | String |  |
| custom_object_fields | Json |  |
| custom_object_key | String |  |
| external_id | String |  |
| name | String |  |
| photo | Json |  |
| updated_at | Instant |  |
| updated_by_user_id | String |  |
| url | String |  |

### ticket_side_conversation

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| ticket_id | Long | FK |
| created_at | Instant |  |
| state | String |  |
| state_updated_at | Instant |  |
| subject | String |  |

### ticket_side_conversation_event

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| side_conversation_id | String | PK |
| actor_user_id | Long | FK |
| message_from_user_id | Long | FK |
| actor_email | String |  |
| actor_msteams_channel_id | String |  |
| actor_name | String |  |
| actor_slack_channel_id | String |  |
| actor_slack_workspace_id | String |  |
| actor_support_agent_id | String |  |
| actor_support_group_id | String |  |
| created_at | Instant |  |
| type | String |  |
| updated_state | String |  |
| updated_subject | String |  |
| via | String |  |
| message_** |  |  |

### csat_survey_answer

| Column | Type | Keys |
| --- | --- | --- |
| question_id | String | PK, FK |
| survey_response_id | String | PK, FK |
| rating | Long | FK |
| selections_option_id | String | FK |
| created_at | Instant |  |
| rating_category | String |  |
| selections_type | String |  |
| type | String |  |
| updated_at | Instant |  |
| value | String |  |

### agent_unified_status_history

| Column | Type | Keys |
| --- | --- | --- |
| agent_id | Long | PK, FK |
| new_id | Long | FK |
| previous_id | Long | FK |
| new_reason | String |  |
| previous_reason | String |  |
| updated_at | Instant |  |

### suspended_ticket_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| suspended_ticket_id | Long | FK |
| _fivetran_file_path | String |  |
| content_type | String |  |
| content_url | String |  |
| deleted | Boolean |  |
| file_name | String |  |
| height | Long |  |
| inline | Boolean |  |
| malware_access_override | Boolean |  |
| malware_scan_result | String |  |
| mapped_content_url | String |  |
| size | Long |  |
| width | Long |  |

### sla_policy_metric_history

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| sla_policy_id | Long | PK, FK |
| sla_policy_updated_at | Instant | PK, FK |
| business_hours | Boolean |  |
| metric | String |  |
| priority | String |  |
| target | Long |  |

### brand

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| active | Boolean |  |
| brand_url | String |  |
| default | Boolean |  |
| has_help_center | Boolean |  |
| help_center_state | String |  |
| name | String |  |
| subdomain | String |  |
| url | String |  |
| logo_** |  |  |

### audit_log

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| actor_id | Long | FK |
| action | String |  |
| change_description | String |  |
| created_at | Instant |  |
| source_id | Long |  |
| source_label | String |  |
| source_type | String |  |

### domain_name

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| organization_id | Long | PK, FK |
| domain_name | String |  |

### agent_max_capacity_history

| Column | Type | Keys |
| --- | --- | --- |
| channel | String | PK |
| agent_id | Long | PK, FK |
| current | Long |  |
| previous | Long |  |
| updated_at | Instant |  |

### line_group

| Column | Type | Keys |
| --- | --- | --- |
| group_id | String | PK, FK |
| line_id | Long | PK, FK |

### user_segment_tag

| Column | Type | Keys |
| --- | --- | --- |
| is_or_tag | Boolean | PK |
| tag | String | PK |
| user_segment_id | Long | PK, FK |

### section

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| category_id | Long | FK |
| created_at | Instant |  |
| description | String |  |
| html_url | String |  |
| locale | String |  |
| name | String |  |
| outdated | Boolean |  |
| parent_section_id | Long |  |
| position | Long |  |
| sorting | String |  |
| source_locale | String |  |
| theme_template | String |  |
| updated_at | Instant |  |
| url | String |  |

### automation_action

| Column | Type | Keys |
| --- | --- | --- |
| field | String | PK |
| automation_id | Long | PK, FK |
| value | Json |  |

### post_content_tag

| Column | Type | Keys |
| --- | --- | --- |
| content_tag_id | String | PK, FK |
| post_id | Long | PK, FK |

### badge_category

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| brand_id | String |  |
| created_at | Instant |  |
| name | String |  |
| slug | String |  |
| updated_at | Instant |  |

### post

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| updated_at | Instant | PK |
| author_id | Long | FK |
| topic_id | Long | FK |
| closed | Boolean |  |
| comment_count | Int |  |
| created_at | Instant |  |
| details | String |  |
| featured | Boolean |  |
| follower_count | Int |  |
| html_url | String |  |
| pinned | Boolean |  |
| status | String |  |
| title | String |  |
| url | String |  |
| vote_count | Int |  |
| vote_sum | Int |  |

### call_metric

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| agent_id | Long | FK |
| call_group_id | Long | FK |
| phone_number_id | Long | FK |
| ticket_id | Long | FK |
| call_charge | String |  |
| call_recording_consent | String |  |
| call_recording_consent_action | String |  |
| call_recording_consent_keypress | String |  |
| callback | Boolean |  |
| callback_source | String |  |
| completion_status | String |  |
| consultation_time | Long |  |
| created_at | Instant |  |
| customer_requested_voicemail | Boolean |  |
| default_group | Boolean |  |
| direction | String |  |
| duration | Long |  |
| exceeded_queue_wait_time | Boolean |  |
| hold_time | Long |  |
| ivr_action | String |  |
| ivr_destination_group_name | String |  |
| ivr_hops | Long |  |
| ivr_routed_to | String |  |
| ivr_time_spent | Long |  |
| minutes_billed | Long |  |
| not_recording_time | Long |  |
| outside_business_hours | Boolean |  |
| overflowed | Boolean |  |
| overflowed_to | String |  |
| phone_number | String |  |
| quality_issues | Json |  |
| recording_control_interactions | Int |  |
| recording_time | Long |  |
| talk_time | Long |  |
| time_to_answer | Long |  |
| updated_at | Instant |  |
| voicemail | Boolean |  |
| wait_time | Long |  |
| wrap_up_time | Long |  |

### user_segment_added_user

| Column | Type | Keys |
| --- | --- | --- |
| user_id | Long | PK, FK |
| user_segment_id | Long | PK, FK |

### organization_member

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| organization_id | Long | FK |
| user_id | Long | FK |

### ivr

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| name | String |  |

### ticket_alert

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| ticket_id | Long | FK |
| user_id | Long | FK |
| body | String |  |
| created | Instant |  |
| resource | String |  |
| subject | String |  |
| type | String |  |
| via_channel | String |  |
| via_source_from_address | String |  |
| via_source_from_id | Long |  |
| via_source_from_title | String |  |
| via_source_rel | String |  |
| via_source_to_address | String |  |
| via_source_to_name | String |  |

### forum_topic

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| community_id | Long |  |
| created_at | Instant |  |
| description | String |  |
| follower_count | Long |  |
| html_url | String |  |
| manageable_by | String |  |
| name | String |  |
| position | Long |  |
| updated_at | Instant |  |
| url | String |  |
| user_segment_id | Long |  |

### group_member

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| group_id | Long | FK |
| user_id | Long | FK |
| created_at | Instant |  |
| updated_at | Instant |  |

### ticket_attribute

| Column | Type | Keys |
| --- | --- | --- |
| attribute_name | String | PK |
| value | String | PK |
| ticket_id | Long | PK, FK |

### user_vote

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| user_id | Long | FK |
| created_at | Instant |  |
| item_id | Long |  |
| item_type | String |  |
| updated_at | Instant |  |
| value | Long |  |

### csat_survey_rating_option

| Column | Type | Keys |
| --- | --- | --- |
| rating | Long | PK |
| question_id | String | PK, FK |
| survey_id | String | PK, FK |
| survey_version | Long | PK, FK |
| emoji_type | String |  |
| emoji_value | String |  |
| label_key | String |  |
| label_type | String |  |
| label_value | String |  |

### group_sla_policy_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_at | Instant |  |
| description | String |  |
| position | Long |  |
| title | String |  |
| updated_at | Instant |  |

### agent_status_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| channels_messaging | String |  |
| channels_support | String |  |
| channels_talk | String |  |
| description | String |  |
| name | String |  |
| updated_at | Instant |  |

### ticket_collaborator

| Column | Type | Keys |
| --- | --- | --- |
| ticket_id | Long | PK, FK |
| user_id | Long | PK, FK |

### ticket_form_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| updated_at | Instant | PK |
| active | Boolean |  |
| created_at | Instant |  |
| default | Boolean |  |
| display_name | String |  |
| end_user_visible | Boolean |  |
| in_all_brands | Boolean |  |
| name | String |  |
| position | Long |  |
| raw_display_name | String |  |
| raw_name | String |  |
| url | String |  |

### ticket_chat_event

| Column | Type | Keys |
| --- | --- | --- |
| created_at | Instant | PK |
| chat_id | String | PK, FK |
| actor_id | String |  |
| chat_index | Long |  |
| external_message_id | String |  |
| filename | String |  |
| is_history_context | Boolean |  |
| message | String |  |
| message_id | String |  |
| message_source | String |  |
| mime_type | String |  |
| original_message | Json |  |
| original_message_type | String |  |
| parent_message_id | String |  |
| reason | String |  |
| size | Long |  |
| status | String |  |
| status_updated_at | Instant |  |
| type | String |  |
| url | String |  |

### suspended_ticket

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| author_id | Long | FK |
| brand_id | Long | FK |
| ticket_id | Long | FK |
| author_email | String |  |
| author_name | String |  |
| cause | String |  |
| cause_id | Long |  |
| content | String |  |
| created_at | Instant |  |
| message_id | String |  |
| recipient | String |  |
| subject | String |  |
| updated_at | Instant |  |
| url | String |  |
| via_channel | String |  |
| via_source_from_address | String |  |
| via_source_from_id | Long |  |
| via_source_from_title | String |  |
| via_source_rel | String |  |
| via_source_to_address | String |  |
| via_source_to_name | String |  |

### agent_attribute

| Column | Type | Keys |
| --- | --- | --- |
| attribute_name | String | PK |
| value | String | PK |
| agent_id | Long | PK, FK |

### user_identity

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| user_id | Long | FK |
| created_at | Instant |  |
| deliverable_state | String |  |
| is_primary | Boolean |  |
| type | String |  |
| undeliverable_count | Long |  |
| updated_at | Instant |  |
| url | String |  |
| value | String |  |
| verification_method | String |  |
| verified | Boolean |  |
| verified_at | Instant |  |

### end_user_condition

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| child_field_id | Long | FK |
| parent_field_id | Long | FK |
| ticket_form_id | Long | FK |
| is_required | Boolean |  |
| parent_field_type | String |  |
| value | String |  |

### locale

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| updated_at | Instant | PK |
| created_at | Instant |  |
| default | Boolean |  |
| locale | String |  |
| name | String |  |
| native_name | String |  |
| presentation_name | String |  |
| rtl | Boolean |  |
| url | String |  |

### trigger

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| active | Boolean |  |
| app_installation | Json |  |
| category_id | String |  |
| created_at | Instant |  |
| default | Boolean |  |
| description | String |  |
| permissions | Json |  |
| position | String |  |
| raw_title | String |  |
| title | String |  |
| updated_at | Instant |  |
| url | String |  |

### badge_assignment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| badge_id | String | FK |
| created_at | Instant |  |
| user_id | String |  |

### ticket_macro_reference

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| ticket_id | Long | FK |
| user_id | Long | FK |
| created | Instant |  |
| macro_deleted | Boolean |  |
| macro_id | String |  |
| macro_title | String |  |
| via_channel | String |  |
| via_source_from_address | String |  |
| via_source_from_id | Long |  |
| via_source_from_title | String |  |
| via_source_rel | String |  |
| via_source_to_address | String |  |
| via_source_to_name | String |  |

### ticket_custom_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| ticket_custom_field_id | Long | FK |
| active | Boolean |  |
| agent_label | String |  |
| created_at | String |  |
| default | Boolean |  |
| description | String |  |
| end_user_description | String |  |
| end_user_label | String |  |
| status_category | String |  |
| updated_at | String |  |

### content_subscription

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| user_id | Long | FK |
| content_id | Long |  |
| content_type | String |  |
| created_at | Instant |  |
| include_comments | Boolean |  |
| locale | String |  |
| source_locale | String |  |
| updated_at | Instant |  |
| url | String |  |

### schedule_holiday

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| schedule_id | Long | PK, FK |
| end_date | String |  |
| name | String |  |
| start_date | String |  |

### badge

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| badge_category_id | String | FK |
| created_at | Instant |  |
| description | String |  |
| icon_url | String |  |
| name | String |  |
| updated_at | Instant |  |

### article

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| author_id | Long | FK |
| permission_group_id | Long | FK |
| body | String |  |
| comments_disabled | Boolean |  |
| created_at | Instant |  |
| draft | Boolean |  |
| edited_at | Instant |  |
| html_url | String |  |
| locale | String |  |
| name | String |  |
| outdated | Boolean |  |
| position | Int |  |
| promoted | Boolean |  |
| section_id | String |  |
| source_locale | String |  |
| title | String |  |
| updated_at | Instant |  |
| url | String |  |
| user_segment_id | Long |  |
| user_segment_ids | Json |  |
| vote_count | Int |  |
| vote_sum | Int |  |

### ivr_menu_route

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| ivr_menu_id | Long | FK |
| action | String |  |
| greeting | String |  |
| keypress | String |  |
| option_text | String |  |
| options_** |  |  |

### post_comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| updated_at | Instant | PK |
| author_id | Long | FK |
| post_id | Long | FK |
| body | String |  |
| created_at | Instant |  |
| html_url | String |  |
| official | Boolean |  |
| url | String |  |
| vote_count | Int |  |
| vote_sum | Int |  |

### group_sla_policy_metric_history

| Column | Type | Keys |
| --- | --- | --- |
| metric | String | PK |
| priority | String | PK |
| group_sla_policy_id | String | PK, FK |
| business_hours | Boolean |  |
| target | Long |  |

### ivr_menu

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| ivr_id | Long | PK, FK |
| greeting_id | Long | FK |
| name | String |  |
| system_default | Boolean |  |

### skip_ticket_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| updated_at | Instant | PK |
| ticket_id | Long | FK |
| user_id | Long | FK |
| created_at | Instant |  |
| reason | String |  |

### automation

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| active | Boolean |  |
| app_installation | Json |  |
| created_at | Instant |  |
| default | Boolean |  |
| permissions | Json |  |
| position | String |  |
| raw_title | String |  |
| title | String |  |
| updated_at | Instant |  |

### ticket_side_conversation_recipient

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| ticket_side_conversation_event_id | String | FK |
| user_id | Long | FK |
| email | String |  |
| msteams_channel_id | String |  |
| name | String |  |
| slack_channel_id | String |  |
| slack_workspace_id | String |  |
| support_agent_id | String |  |
| support_group_id | String |  |

### article_comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| author_id | Long | FK |
| non_author_editor_id | Long | FK |
| source_id | Long | FK |
| body | String |  |
| created_at | Instant |  |
| html_url | String |  |
| locale | String |  |
| non_author_updated_at | Instant |  |
| official | Boolean |  |
| source_type | String |  |
| updated_at | Instant |  |
| url | String |  |
| vote_count | Long |  |
| vote_sum | Long |  |

## Relationships

- ivr_menu_route_option(ivr_menu_route_id) → ivr_menu_route(id)
- ivr_menu_route_option(group_id) → group(id)
- user(custom_role_id) → custom_role(id)
- user(default_group_id) → group(id)
- user(organization_id) → organization(id)
- agent_status_type_group(agent_status_type_id) → agent_status_type(id)
- line_categorised_greeting(category_id) → greeting_category(id)
- line_categorised_greeting(line_id) → line(id)
- line_categorised_greeting(greeting_id) → greeting(id)
- satisfaction_rating(assignee_id) → user(id)
- satisfaction_rating(group_id) → group(id)
- satisfaction_rating(requester_id) → user(id)
- satisfaction_rating(ticket_id) → ticket(id)
- macro_action(macro_id) → macro(id)
- user_subscription(followed_id) → user(id)
- user_subscription(follower_id) → user(id)
- ticket_field_option(ticket_custom_field_id) → ticket_custom_field(id)
- ticket_tag_history(ticket_id) → ticket(id)
- ticket_tag_history(user_id) → user(id)
- ticket_email_cc(ticket_id) → ticket(id)
- ticket_email_cc(user_id) → user(id)
- organization(group_id) → group(id)
- ticket(assignee_id) → user(id)
- ticket(brand_id) → brand(id)
- ticket(forum_topic_id) → forum_topic(id)
- ticket(organization_id) → organization(id)
- ticket(requester_id) → user(id)
- ticket(submitter_id) → user(id)
- ticket(group_id) → group(id)
- ticket(custom_status_id) → ticket_custom_status(id)
- alert_recipient(user_id) → user(id)
- alert_recipient(ticket_alert_id) → ticket_alert(id)
- trigger_action(trigger_id) → trigger(id)
- user_segment_organization(user_segment_id) → user_segment(id)
- user_segment_organization(organization_id) → organization(id)
- ticket_follower(ticket_id) → ticket(id)
- ticket_follower(user_id) → user(id)
- automation_condition(automation_id) → automation(id)
- call_leg(agent_id) → user(id)
- call_leg(call_id) → call_metric(id)
- call_leg(user_id) → user(id)
- agent_condition(parent_field_id) → ticket_custom_field(id)
- agent_condition(ticket_form_id) → ticket_form_history(id)
- agent_condition(child_field_id) → ticket_custom_field(id)
- ticket_form_restricted_brand(ticket_form_id) → ticket_form_history(id)
- ticket_form_restricted_brand(brand_id) → brand(id)
- greeting(category_id) → greeting_category(id)
- ticket_csat_survey(ticket_id) → ticket(id)
- ticket_csat_survey(survey_id) → csat_survey_question(survey_id)
- ticket_csat_survey(survey_version) → csat_survey_question(survey_id)
- article_label_name(article_id) → article(id)
- article_outdated_locale(article_id) → article(id)
- ticket_group_sla_policy(ticket_id) → ticket(id)
- ticket_group_sla_policy(group_sla_policy_id) → group_sla_policy_history(id)
- greeting_ivr(greeting_id) → greeting(id)
- ticket_field_history(ticket_id) → ticket(id)
- ticket_field_history(user_id) → user(id)
- line(brand_id) → brand(id)
- line(ivr_id) → ivr(id)
- line(schedule_id) → schedule(id)
- tweet_recipient(ticket_comment_id) → ticket_comment(id)
- tweet_recipient(user_id) → user(id)
- ticket_comment_attachment(ticket_comment_id) → ticket_comment(id)
- ticket_schedule(ticket_id) → ticket(id)
- ticket_schedule(schedule_id) → schedule(id)
- organization_tag(organization_id) → organization(id)
- ticket_sla_policy(ticket_id) → ticket(id)
- ticket_sla_policy(sla_policy_id) → sla_policy_history(id)
- ticket_tag(ticket_id) → ticket(id)
- ticket_link(ticket_id) → ticket(id)
- article_content_tag(article_id) → article(id)
- article_content_tag(content_tag_id) → content_tag(id)
- ticket_chat(ticket_id) → ticket(id)
- ticket_chat(user_id) → user(id)
- ticket_form_field(ticket_form_id) → ticket_form_history(id)
- ticket_form_field(ticket_field_id) → ticket_custom_field(id)
- call_leg_quality_issue(call_leg_id) → call_leg(id)
- ticket_comment(ticket_id) → ticket(id)
- ticket_comment(user_id) → user(id)
- user_segment_group(user_segment_id) → user_segment(id)
- user_segment_group(group_id) → group(id)
- trigger_condition(trigger_id) → trigger(id)
- agent_channel_history(agent_id) → user(id)
- agent_status_history(agent_id) → user(id)
- agent_condition_required_status(agent_condition_id) → agent_condition(_fivetran_id)
- user_tag(user_id) → user(id)
- line_greeting(greeting_id) → greeting(id)
- line_greeting(line_id) → line(id)
- ticket_side_conversation(ticket_id) → ticket(id)
- ticket_side_conversation_event(actor_user_id) → user(id)
- ticket_side_conversation_event(message_from_user_id) → user(id)
- csat_survey_answer(question_id) → csat_survey_question(survey_id)
- csat_survey_answer(survey_response_id) → ticket_csat_survey(ticket_id)
- csat_survey_answer(selections_option_id) → csat_survey_closed_ended_option(survey_id)
- csat_survey_answer(rating) → csat_survey_rating_option(survey_id)
- agent_unified_status_history(agent_id) → user(id)
- agent_unified_status_history(new_id) → agent_status_type(id)
- agent_unified_status_history(previous_id) → agent_status_type(id)
- suspended_ticket_attachment(suspended_ticket_id) → suspended_ticket(id)
- sla_policy_metric_history(sla_policy_id) → sla_policy_history(id)
- sla_policy_metric_history(sla_policy_updated_at) → sla_policy_history(id)
- audit_log(actor_id) → user(id)
- domain_name(organization_id) → organization(id)
- agent_max_capacity_history(agent_id) → user(id)
- line_group(group_id) → group(id)
- line_group(line_id) → line(id)
- user_segment_tag(user_segment_id) → user_segment(id)
- section(category_id) → category(id)
- automation_action(automation_id) → automation(id)
- post_content_tag(post_id) → post(id)
- post_content_tag(content_tag_id) → content_tag(id)
- post(topic_id) → forum_topic(id)
- post(author_id) → user(id)
- call_metric(ticket_id) → ticket(id)
- call_metric(agent_id) → user(id)
- call_metric(call_group_id) → group(id)
- call_metric(phone_number_id) → line(id)
- user_segment_added_user(user_segment_id) → user_segment(id)
- user_segment_added_user(user_id) → user(id)
- organization_member(user_id) → user(id)
- organization_member(organization_id) → organization(id)
- ticket_alert(ticket_id) → ticket(id)
- ticket_alert(user_id) → user(id)
- group_member(user_id) → user(id)
- group_member(group_id) → group(id)
- ticket_attribute(ticket_id) → ticket(id)
- user_vote(user_id) → user(id)
- csat_survey_rating_option(survey_id) → csat_survey_question(survey_id)
- csat_survey_rating_option(survey_version) → csat_survey_question(survey_id)
- csat_survey_rating_option(question_id) → csat_survey_question(survey_id)
- ticket_collaborator(ticket_id) → ticket(id)
- ticket_collaborator(user_id) → user(id)
- ticket_chat_event(chat_id) → ticket_chat(chat_id)
- suspended_ticket(brand_id) → brand(id)
- suspended_ticket(ticket_id) → ticket(id)
- suspended_ticket(author_id) → user(id)
- agent_attribute(agent_id) → user(id)
- user_identity(user_id) → user(id)
- end_user_condition(parent_field_id) → ticket_custom_field(id)
- end_user_condition(ticket_form_id) → ticket_form_history(id)
- end_user_condition(child_field_id) → ticket_custom_field(id)
- badge_assignment(badge_id) → badge(id)
- ticket_macro_reference(ticket_id) → ticket(id)
- ticket_macro_reference(user_id) → user(id)
- ticket_custom_status(ticket_custom_field_id) → ticket_custom_field(id)
- content_subscription(user_id) → user(id)
- schedule_holiday(schedule_id) → schedule(id)
- badge(badge_category_id) → badge_category(id)
- article(author_id) → user(id)
- article(permission_group_id) → group(id)
- ivr_menu_route(ivr_menu_id) → ivr_menu(id)
- post_comment(post_id) → post(id)
- post_comment(author_id) → user(id)
- group_sla_policy_metric_history(group_sla_policy_id) → group_sla_policy_history(id)
- ivr_menu(ivr_id) → ivr(id)
- ivr_menu(greeting_id) → greeting(id)
- skip_ticket_history(ticket_id) → ticket(id)
- skip_ticket_history(user_id) → user(id)
- ticket_side_conversation_recipient(user_id) → user(id)
- ticket_side_conversation_recipient(ticket_side_conversation_event_id) → ticket_side_conversation_event(id)
- article_comment(author_id) → user(id)
- article_comment(source_id) → article(id)
- article_comment(non_author_editor_id) → user(id)