Zendesk Support

Explore the interactive ERD

Table & Field Reference

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

ticket_form_restricted_brand

Column	Type	Keys
`brand_id`	Long	PKFK
`ticket_form_id`	Long	PKFK

user_segment_organization

Column	Type	Keys
`organization_id`	Long	PKFK
`user_segment_id`	Long	PKFK

ticket_tag

Column	Type	Keys
`tag`	String	PK
`ticket_id`	Long	PKFK

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

group_sla_policy_metric_history

Column	Type	Keys
`metric`	String	PK
`priority`	String	PK
`group_sla_policy_id`	String	PKFK
`business_hours`	Boolean
`target`	Long

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

content_tag

Column	Type	Keys
`id`	String	PK
`created_at`	Instant
`name`	String
`updated_at`	Instant

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

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

call_leg_quality_issue

Column	Type	Keys
`issue`	String	PK
`call_leg_id`	Long	PKFK

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

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

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

domain_name

Column	Type	Keys
`index`	Int	PK
`organization_id`	Long	PKFK
`domain_name`	String

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

group

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

badge_category

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

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

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

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_collaborator

Column	Type	Keys
`ticket_id`	Long	PKFK
`user_id`	Long	PKFK

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_`

agent_max_capacity_history

Column	Type	Keys
`channel`	String	PK
`agent_id`	Long	PKFK
`current`	Long
`previous`	Long
`updated_at`	Instant

group_member

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

ticket_csat_survey

Column	Type	Keys
`survey_response_id`	String	PK
`ticket_id`	Long	PKFK
`survey_id`	String	FK
`survey_version`	Long	FK
`expires_at`	Instant
`responder_id`	String
`subject_zrns`	Json
`subjects`	Json
`survey_state`	String

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

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

alert_recipient

Column	Type	Keys
`ticket_alert_id`	Long	PKFK
`user_id`	Long	PKFK

agent_status_history

Column	Type	Keys
`channel`	String	PK
`agent_id`	Long	PKFK
`new_state`	String
`previous_state`	String
`updated_at`	Instant

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

post_content_tag

Column	Type	Keys
`content_tag_id`	String	PKFK
`post_id`	Long	PKFK

csat_survey_rating_option

Column	Type	Keys
`rating`	Long	PK
`question_id`	String	PKFK
`survey_id`	String	PKFK
`survey_version`	Long	PKFK
`emoji_type`	String
`emoji_value`	String
`label_key`	String
`label_type`	String
`label_value`	String

user_segment_group

Column	Type	Keys
`group_id`	Long	PKFK
`user_segment_id`	Long	PKFK

ticket_link

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

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

group_sla_policy_history

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

agent_condition_required_status

Column	Type	Keys
`_fivetran_id`	String	PK
`agent_condition_id`	String	FK
`status`	String

user_subscription

Column	Type	Keys
`id`	Long	PK
`followed_id`	Long	FK
`follower_id`	Long	FK

ivr_menu

Column	Type	Keys
`id`	Long	PK
`ivr_id`	Long	PKFK
`greeting_id`	Long	FK
`name`	String
`system_default`	Boolean

ticket_chat_event

Column	Type	Keys
`created_at`	Instant	PK
`chat_id`	String	PKFK
`actor_id`	String	FK
`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

ticket_follower

Column	Type	Keys
`ticket_id`	Long	PKFK
`user_id`	Long	PKFK

user_tag

Column	Type	Keys
`tag`	String	PK
`user_id`	Long	PKFK

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

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

organization_member

Column	Type	Keys
`id`	Long	PK
`organization_id`	Long	FK
`user_id`	Long	FK

schedule

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

user_segment_tag

Column	Type	Keys
`is_or_tag`	Boolean	PK
`tag`	String	PK
`user_segment_id`	Long	PKFK

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

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

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

custom_role

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`description`	String
`name`	String
`role_type`	Long
`updated_at`	Instant
`configuration_`

ticket_field_option

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

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

user_segment_added_user

Column	Type	Keys
`user_id`	Long	PKFK
`user_segment_id`	Long	PKFK

agent_channel_history

Column	Type	Keys
`channel`	String	PK
`agent_id`	Long	PKFK
`updated_at`	Instant

sla_policy_metric_history

Column	Type	Keys
`index`	Int	PK
`sla_policy_id`	Long	PKFK
`sla_policy_updated_at`	Instant	PKFK
`business_hours`	Boolean
`metric`	String
`priority`	String
`target`	Long

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

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

ticket_form_field

Column	Type	Keys
`ticket_field_id`	Long	PKFK
`ticket_form_id`	Long	PKFK

greeting_category

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

ticket_email_cc

Column	Type	Keys
`ticket_id`	Long	PKFK
`user_id`	Long	PKFK

ticket_side_conversation

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

schedule_holiday

Column	Type	Keys
`id`	Long	PK
`schedule_id`	Long	PKFK
`end_date`	String
`name`	String
`start_date`	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

line_group

Column	Type	Keys
`group_id`	String	PKFK
`line_id`	Long	PKFK

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
`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

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

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
`vote_count`	Int
`vote_sum`	Int

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

ivr_menu_route

Column	Type	Keys
`id`	Long	PK
`ivr_menu_id`	Long	FK
`action`	String
`greeting`	String
`keypress`	String
`option_text`	String
`options_`

automation_condition

Column	Type	Keys
`_fivetran_id`	String	PK
`automation_id`	Long	PKFK
`condition_type`	String
`field`	String
`operator`	String
`value`	Json

automation_action

Column	Type	Keys
`field`	String	PK
`automation_id`	Long	PKFK
`value`	Json

user_segment

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

ivr_menu_route_option

Column	Type	Keys
`group_id`	Long	PKFK
`ivr_menu_route_id`	Long	PKFK

organization_tag

Column	Type	Keys
`tag`	String	PK
`organization_id`	Long	PKFK

agent_attribute

Column	Type	Keys
`attribute_name`	String	PK
`value`	String	PK
`agent_id`	Long	PKFK

article_outdated_locale

Column	Type	Keys
`outdated_locale`	String	PK
`article_id`	Long	PKFK

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_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

csat_survey_answer

Column	Type	Keys
`question_id`	String	PKFK
`survey_response_id`	String	PKFK
`rating`	Long	FK
`selections_option_id`	String	FK
`created_at`	Instant
`rating_category`	String
`selections_type`	String
`type`	String
`updated_at`	Instant
`value`	String

ticket_sla_policy

Column	Type	Keys
`policy_applied_at`	Instant	PK
`sla_policy_id`	Long	PKFK
`ticket_id`	Long	PKFK

daylight_time

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

ticket_schedule

Column	Type	Keys
`created_at`	Instant	PK
`ticket_id`	Long	PKFK
`schedule_id`	Long	FK

agent_status_type_group

Column	Type	Keys
`agent_status_type_id`	Long	PKFK
`group_id`	String	PKFK

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

time_zone

Column	Type	Keys
`time_zone`	String	PK
`standard_offset`	String

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

agent_unified_status_history

Column	Type	Keys
`agent_id`	Long	PKFK
`new_id`	Long	FK
`previous_id`	Long	FK
`new_reason`	String
`previous_reason`	String
`updated_at`	Instant

article_label_name

Column	Type	Keys
`label_name`	String	PK
`article_id`	Long	PKFK

ticket_group_sla_policy

Column	Type	Keys
`group_sla_policy_id`	String	PKFK
`ticket_id`	Long	PKFK
`group_policy_applied_at`	Instant

tweet_recipient

Column	Type	Keys
`ticket_comment_id`	Long	PKFK
`user_id`	Long	PKFK

sla_policy_history

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

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

ivr

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

line_categorised_greeting

Column	Type	Keys
`category_id`	String	PKFK
`greeting_id`	String	PKFK
`line_id`	Long	PKFK

article_content_tag

Column	Type	Keys
`article_id`	Long	PKFK
`content_tag_id`	String	PKFK

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_`

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

greeting_ivr

Column	Type	Keys
`id`	Long	PK
`greeting_id`	String	PKFK

trigger_action

Column	Type	Keys
`field`	String	PK
`trigger_id`	Long	PKFK
`value`	Json

macro_action

Column	Type	Keys
`field`	String	PK
`macro_id`	Long	PKFK
`value`	Json

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

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

trigger_condition

Column	Type	Keys
`_fivetran_id`	String	PK
`trigger_id`	Long	PKFK
`condition_type`	String
`field`	String
`operator`	String
`value`	Json

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_`

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

line_greeting

Column	Type	Keys
`greeting_id`	String	PKFK
`line_id`	Long	PKFK
`is_default`	Boolean

ticket_attribute

Column	Type	Keys
`attribute_name`	String	PK
`value`	String	PK
`ticket_id`	Long	PKFK

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

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

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

badge_assignment

Column	Type	Keys
`id`	String	PK
`badge_id`	String	FK
`user_id`	String	FK
`created_at`	Instant

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

ticket_field_history

Column	Type	Keys
`field_name`	String	PK
`updated`	Instant	PK
`ticket_id`	Long	PKFK
`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

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

ticket_tag_history

Column	Type	Keys
`tag`	String	PK
`updated`	Instant	PK
`ticket_id`	Long	PKFK
`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