Freshdesk schema and ERD

59 tables

Loading diagram…

agent

automation

company

discussion_category

portal

satisfaction_rating

sla_policy

survey

ticket

ticket_conversation

account

account_id

string

organisation_id

string

organisation_name

string

account_name

string

account_domain

string

bundle_id

string

hipaa_compliant

boolean

total_agents_full_time

int

total_agents_occasional

int

agent

string

org_agent_id

string

deactivated

boolean

available

boolean

available_since

date

occasional

boolean

ticket_scope

int

type

string

last_active_at

date

agent_role

role_id

string

agent_id

string

index

int

_weld_synced

date

agent_skill

agent_id

string

skill_id

string

index

int

_weld_synced

date

agent_contribution_group

agent_id

string

contribution_group_id

string

index

int

_weld_synced

date

agent_org_contribution_group

agent_id

string

org_contribution_group_id

string

index

int

_weld_synced

date

agent_org_group

agent_id

string

org_group_id

string

index

int

_weld_synced

date

agent_group

group_id

string

agent_id

string

index

int

_weld_synced

date

agent_availability

agent_id

string

channel

string

index

int

available

boolean

available_since

date

_weld_synced

date

automation

string

automation_type_id

string

name

string

position

int

active

boolean

performer_type

string

operator

string

outdated

boolean

last_updated_by

string

affected_tickets_count

int

automation_performer_member

automation_id

string

member_id

string

index

int

_weld_synced

date

automation_condition

automation_id

string

name

string

match_type

string

_weld_synced

date

automation_condition_property

automation_id

string

automation_condition_name

string

resource_type

string

field_name

string

operator

string

value

string

business_hours_id

string

case_senstive

boolean

nested_fields_level_field_name

string

automation_action

automation_id

string

field_name

string

value

string

email_to

double

email_body

string

api_key

string

auth_header_username

string

auth_header_password

string

custom_headers_value

string

automation_event

automation_id

string

field_name

string

from

string

value

string

from_nested_field_level_field_name

string

from_nested_field_level_value

string

to_nested_field_level_field_name

string

to_nested_field_level_value

string

_weld_synced

date

automation_type

string

name

string

_weld_synced

date

business_hour

string

name

string

is_default

boolean

description

string

business_hours_monday_start_time

string

business_hours_monday_end_time

string

business_hours_tuesday_start_time

string

business_hours_tuesday_end_time

string

business_hours_wednesday_start_time

string

company

string

name

string

description

string

note

string

created_at

date

updated_at

date

health_score

string

account_tier

string

renewal_date

date

industry

string

org_company_id

string

_weld_synced

date

company_domain

company_id

string

domain

string

index

int

_weld_synced

date

contact

string

company_id

string

active

boolean

address

string

description

string

job_title

string

language

string

mobile

string

name

string

discussion_category

string

name

string

description

string

created_at

date

updated_at

date

_weld_synced

date

discussion_forum

string

name

string

description

string

position

string

forum_category_id

string

forum_type

int

forum_visibility

int

topics_count

int

comments_count

int

_weld_synced

date

discussion_topic

string

title

string

forum_id

string

user_id

string

locked

boolean

published

boolean

stamp_type

int

replied_by

string

user_votes

int

discussion_comment

string

topic_id

string

created_at

date

updated_at

date

user_id

string

forum_id

string

answer

boolean

published

boolean

spam

boolean

trash

boolean

body

string

body_text

string

_weld_synced

date

email_config

string

product_id

string

group_id

string

name

string

to_email

string

reply_email

string

primary_role

boolean

active

boolean

created_at

date

updated_at

date

_weld_synced

date

group

string

business_hour_id

string

name

string

description

string

escalate_to

string

unassigned_for

string

group_type

string

created_at

date

updated_at

date

auto_ticket_assign

int

agent_availability_status

boolean

_weld_synced

date

portal

string

product_id

string

name

string

portal_url

string

main_portal

boolean

ssl_enabled

boolean

preferences_bg_color

string

preferences_header_color

string

preferences_tab_color

string

preferences_personalized_articles

boolean

portal_solution_category

portal_id

string

solution_category_id

string

index

int

_weld_synced

date

portal_forum_moderator

portal_id

string

moderator_id

string

index

int

_weld_synced

date

portal_forum_category

portal_id

string

category_id

string

index

int

_weld_synced

date

portal_ticket_form

ticket_form_id

string

portal_id

string

index

int

_weld_synced

date

product

string

name

string

description

string

primary_email

string

created_at

date

updated_at

date

default

boolean

_weld_synced

date

role

string

name

string

description

string

default

boolean

created_at

date

updated_at

date

agent_type

int

_weld_synced

date

satisfaction_rating

string

survey_id

string

agent_id

string

group_id

string

ticket_id

string

user_id

string

feedback

string

created_at

date

updated_at

date

_weld_synced

date

satisfaction_rating_value

satisfaction_rating_id

string

survey_question_id

string

value

int

_weld_synced

date

sla_policy

string

name

string

description

string

active

boolean

is_default

boolean

position

int

created_at

date

updated_at

date

_weld_synced

date

sla_policy_target

sla_policy_id

string

priority

string

respond_within

int

resolve_within

int

business_hours

boolean

escalation_enabled

boolean

_weld_synced

date

sla_policy_applicable_to

sla_policy_id

string

type

string

value

string

_weld_synced

date

sla_policy_escalation_resolution

sla_policy_id

string

agent_id

string

level

string

escalation_time

int

_weld_synced

date

sla_policy_escalation_response

sla_policy_id

string

agent_id

string

escalation_time

int

_weld_synced

date

sla_policy_escalation_next_response

sla_policy_id

string

agent_id

string

escalation_time

int

_weld_synced

date

sla_policy_escalation_reminder_response

sla_policy_id

string

agent_id

string

escalation_time

int

_weld_synced

date

sla_policy_escalation_reminder_resolution

sla_policy_id

string

agent_id

string

escalation_time

int

_weld_synced

date

sla_policy_escalation_reminder_next_response

sla_policy_id

string

agent_id

string

escalation_time

int

_weld_synced

date

survey

string

title

string

active

boolean

created_at

date

updated_at

date

_weld_synced

date

survey_question

string

survey_id

string

label

string

accepted_ratings

string

default

boolean

_weld_synced

date

ticket

string

email_config_id

string

group_id

string

company_id

string

product_id

string

custom_fields_cf_reference_number

string

fr_escalated

boolean

spam

boolean

priority

int

requester_id

string

responder_id

string

source

int

status

int

ticket_to_email

ticket_id

string

index

int

_weld_synced

date

ticket_cc_email

ticket_id

string

index

int

_weld_synced

date

ticket_fwd_email

ticket_id

string

index

int

_weld_synced

date

ticket_reply_cc_email

ticket_id

string

index

int

_weld_synced

date

ticket_ticket_cc_email

ticket_id

string

index

int

_weld_synced

date

ticket_tag

ticket_id

string

tag

string

index

int

_weld_synced

date

ticket_conversation

string

automation_id

string

automation_type_id

string

ticket_id

string

body

string

body_text

string

incoming

boolean

private

boolean

user_id

string

support_email

string

source

int