Zendesk schema and ERD

43 tables

Loading diagram…

automation

brand

macro

organization

ticket

ticket_comment

ticket_field

ticket_form

ticket_side_conversation

ticket_side_conversation_event

trigger

user

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

_weld_synced

date

automation_condition

automation_id

string

field

string

operator

string

condition_type

string

value

string

_weld_synced

date

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

_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

group

string

created_at

date

default

boolean

deleted

boolean

description

string

is_public

boolean

name

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

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

_weld_synced

date

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

_weld_synced

date

organization_domain_name

organization_id

string

domain_name

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

sharing_agreement

string

created_at

date

name

string

partner_name

string

status

string

type

string

updated_at

date

_weld_synced

date

ticket

string

brand_id

string

custom_status_id

string

group_id

string

macro_id

double

organization_id

string

ticket_form_id

double

allow_attachments

boolean

allow_channelback

boolean

assignee_email

string

assignee_id

string

attribute_value_ids

string

collaborator_ids

string

created_at

date

description

string

ticket_sharing_agreement

ticket_id

string

sharing_agreement_id

string

_weld_synced

date

ticket_follower

ticket_id

string

follower_id

string

_weld_synced

date

ticket_collaborator

ticket_id

string

collaborator_id

string

_weld_synced

date

ticket_tag

ticket_id

string

tag

string

_weld_synced

date

ticket_custom_field

ticket_id

string

custom_field_id

string

value

string

_weld_synced

date

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

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

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_comment_attachment

long

ticket_id

long

ticket_comment_id

long

content_type

string

content_url

string

deleted

boolean

file_name

string

height

double

inline

boolean

malware_access_override

boolean

malware_scan_result

string

mapped_content_url

string

size

double

width

double

_weld_synced

date

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

_weld_synced

date

custom_ticket_field_option

ticket_field_id

string

name

string

value

string

_weld_synced

date

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

_weld_synced

date

ticket_form_restricted_brand

ticket_form_id

string

restricted_brand_id

string

_weld_synced

date

ticket_side_conversation

string

ticket_id

string

created_at

date

message_added_at

date

preview_text

string

state

string

state_updated_at

date

subject

string

updated_at

date

url

string

_weld_synced

date

ticket_side_conversation_external_id

ticket_side_conversation_id

string

key

string

external_id

string

_weld_synced

date

ticket_side_conversation_participant

ticket_side_conversation_id

string

user_id

string

index

int

string

name

string

_weld_synced

date

ticket_side_conversation_event

string

side_conversation_id

string

type

string

via

string

created_at

date

actor_email

string

actor_name

string

actor_user_id

string

message_body

string

ticket_side_conversation_event_message_to

ticket_side_conversation_event_id

string

user_id

string

index

int

string

name

string

_weld_synced

date

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

_weld_synced

date

trigger_condition

trigger_id

string

field

string

operator

string

condition_type

string

value

string

_weld_synced

date

trigger_category

string

created_at

date

name

string

position

int

updated_at

date

_weld_synced

date

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

_weld_synced

date