Zendesk schema and ERD

37 tables

Loading diagram…

user

string

organization_id

string

active

boolean

alias

string

chat_only

boolean

created_at

string

custom_role_id

string

default_group_id

string

details

string

user_tag

user_id

string

tag

string

brand

string

active

boolean

brand_url

string

created_at

string

default

boolean

has_help_center

boolean

help_center_state

string

host_mapping

string

is_deleted

boolean

brand_ticket_form

brand_id

string

ticket_form_id

string

ticket_form

string

active

boolean

agent_conditions

string

created_at

string

default

boolean

display_name

string

end_user_conditions

string

end_user_visible

boolean

in_all_brands

boolean

ticket_form_ticket_field

ticket_form_id

string

ticket_field_id

string

ticket_form_restricted_brand

ticket_form_id

string

restricted_brand_id

string

ticket

int

custom_status_id

string

group_id

string

organization_id

string

assignee_id

string

created_at

date

description

string

due_at

date

external_id

string

from_messaging_channel

boolean

has_incidents

boolean

priority

string

ticket_sharing_agreement

ticket_id

string

sharing_agreement_id

string

ticket_follower

ticket_id

string

follower_id

string

ticket_collaborator

ticket_id

string

collaborator_id

string

ticket_tag

ticket_id

string

tag

string

ticket_custom_field

ticket_id

string

custom_field_id

string

value

string

automation

string

active

boolean

default

boolean

position

int

raw_title

string

title

string

_weld_synced

date

automation_action

automation_id

string

field

string

value

string

automation_condition

automation_id

string

field

string

operator

string

condition_type

string

value

string

ticket_field

string

active

boolean

agent_description

string

collapsed_for_agents

boolean

created_at

string

creator_app_name

string

creator_user_id

string

description

string

editable_in_portal

boolean

system_ticket_field_option

ticket_field_id

string

name

string

value

string

custom_ticket_field_option

ticket_field_id

string

name

string

value

string

trigger

string

active

boolean

category_id

string

created_at

date

default

boolean

description

string

position

int

raw_title

string

title

string

updated_at

date

_weld_synced

date

trigger_action

trigger_id

string

field

string

value

string

trigger_condition

trigger_id

string

field

string

operator

string

condition_type

string

value

string

organization

string

group_id

string

created_at

string

details

string

external_id

string

name

string

notes

string

organization_fields

string

shared_comments

boolean

shared_tickets

boolean

updated_at

string

_weld_synced

date

organization_tag

organization_id

string

tag

string

organization_domain_name

organization_id

string

domain_name

string

macro

string

active

boolean

created_at

date

default

boolean

description

string

position

int

restriction

string

title

string

updated_at

date

_weld_synced

date

macro_action

macro_id

string

field

string

value

string

sharing_agreement

string

created_at

date

name

string

partner_name

string

status

string

type

string

updated_at

date

_weld_synced

date

group_membership

string

group_id

string

user_id

string

created_at

date

default

boolean

updated_at

date

_weld_synced

date

group

string

created_at

date

default

boolean

deleted

boolean

description

string

is_public

boolean

name

string

updated_at

date

_weld_synced

date

trigger_category

string

created_at

date

name

string

position

int

updated_at

date

_weld_synced

date

ticket_comment

string

ticket_id

string

audit_id

string

author_id

string

body

string

created_at

date

metadata_system_client

string

metadata_system_ip_address

string

metadata_system_latitude

double

metadata_system_location

string

ticket_activity

string

user_id

string

actor_id

string

actor_name

string

created_at

date

object

string

target

string

title

string

updated_at

date

user_name

string

verb

string

_weld_synced

date

ticket_audit

string

ticket_id

string

author_id

string

created_at

string

events

string

metadata

string

via

string

_weld_synced

date

organization_membership

string

organization_id

string

user_id

string

created_at

date

default

boolean

organization_name

string

updated_at

date

view_tickets

boolean

_weld_synced

date

custom_status

string

active

boolean

agent_label

string

created_at

string

default

boolean

description

string

end_user_description

string

end_user_label

string

raw_agent_label

string

ticket_metric

string

ticket_id

string

agent_wait_time_in_minutes_business

int

agent_wait_time_in_minutes_calendar

int

assigned_at

date

assignee_stations

int

assignee_updated_at

date

created_at

date

custom_status_updated_at

date

first_resolution_time_in_minutes_business

int