Zoho Desk
Explore the interactive ERD
Table & Field Reference
contact
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
account_id | Unknown | FK |
layout_id | Unknown | FK |
owner_id | Unknown | FK |
city | Unknown | |
country | Unknown | |
created_time | Instant | |
customer_happiness_bad_percentage | Unknown | |
customer_happiness_good_percentage | Unknown | |
customer_happiness_ok_percentage | Unknown | |
description | Unknown | |
email | Unknown | |
facebook | Unknown | |
first_name | Unknown | |
is_anonymous | Unknown | |
is_end_user | Unknown | |
is_spam | Unknown | |
last_name | Unknown | |
mobile | Unknown | |
modified_time | Instant | |
phone | Unknown | |
photo_url | Unknown | |
secondary_email | Unknown | |
state | Unknown | |
street | Unknown | |
title | Unknown | |
twitter | Unknown | |
type | Unknown | |
web_url | Unknown | |
zip | Unknown | |
zoho_crm_contact | Unknown | |
custom_** |
groups
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
creator_id | Unknown | FK |
modifier_id | Unknown | FK |
count | Unknown | |
created_time | Instant | |
description | Unknown | |
help_center_id | Unknown | |
logo_url | Unknown | |
modified_time | Instant | |
name | Unknown | |
status | Unknown |
layout_profile
| Column | Type | Keys |
|---|---|---|
layout_id | Unknown | PK |
profile_id | Unknown | PKFK |
layout
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by_id | Unknown | FK |
department_id | Unknown | FK |
modified_by_id | Unknown | FK |
created_time | Unknown | |
has_logo | Unknown | |
is_default_layout | Unknown | |
is_standard_layout | Unknown | |
layout_desc | Unknown | |
layout_display_name | Unknown | |
layout_name | Unknown | |
modified_time | Unknown | |
module | Unknown | |
photo_url | Unknown | |
skip_dept_access_validation | Unknown | |
status | Unknown |
account
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
layout_id | Unknown | FK |
owner_id | Unknown | FK |
annual_revenue | Unknown | |
city | Unknown | |
code | Unknown | |
country | Unknown | |
created_time | Instant | |
customer_happiness_bad_percentage | Unknown | |
customer_happiness_good_percentage | Unknown | |
customer_happiness_ok_percentage | Unknown | |
description | Unknown | |
email | Unknown | |
fax | Unknown | |
industry | Unknown | |
modified_time | Instant | |
name | Unknown | |
phone | Unknown | |
state | Unknown | |
street | Unknown | |
web_url | Unknown | |
website | Unknown | |
zoho_crm_account | Unknown | |
custom_** |
product_department
| Column | Type | Keys |
|---|---|---|
department_id | Unknown | PKFK |
product_id | Unknown | PKFK |
product
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by_id | Unknown | FK |
layout_id | Unknown | FK |
modified_by_id | Unknown | FK |
owner_id | Unknown | FK |
category | Unknown | |
code | Unknown | |
created_time | Instant | |
description | Unknown | |
manufacturer | Unknown | |
modified_time | Instant | |
name | Unknown | |
unit_price | Unknown | |
custom_** |
ticket_approval
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
approver_id | Unknown | FK |
requester_id | Unknown | FK |
ticket_id | Unknown | FK |
description | Unknown | |
processed_time | Unknown | |
requested_time | Unknown | |
status | Unknown | |
subject | Unknown |
label
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
creator_id | Unknown | FK |
modifier_id | Unknown | FK |
count | Unknown | |
created_time | Instant | |
help_center_id | Unknown | |
logo_url | Unknown | |
modified_time | Instant | |
name | Unknown | |
preferences_bg_color | Unknown | |
preferences_shape | Unknown | |
preferences_text_color | Unknown |
task
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
assignee_id | Unknown | FK |
call_id | Unknown | FK |
contact_id | Unknown | FK |
creator_id | Unknown | FK |
department_id | Unknown | FK |
layout_id | Unknown | FK |
modified_by_id | Unknown | FK |
owner_id | Unknown | FK |
product_id | Unknown | FK |
team_id | Unknown | FK |
ticket_id | Unknown | FK |
activity_time | Unknown | |
category | Unknown | |
completed_time | Unknown | |
created_time | Instant | |
due_date | Unknown | |
is_commented | Unknown | |
is_spam | Unknown | |
is_trashed | Unknown | |
modified_time | Instant | |
priority | Unknown | |
status | Unknown | |
status_type | Unknown | |
subject | Unknown | |
web_url | Unknown | |
custom_** |
ticket_follower
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
ticket_id | Unknown | FK |
email | Unknown | |
first_name | Unknown | |
following | Unknown | |
last_name | Unknown | |
photo_url | Unknown |
department
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agent_id | Unknown | FK |
chat_status | Unknown | |
created_time | Unknown | |
description | Unknown | |
has_logo | Unknown | |
is_assign_to_team_enabled | Unknown | |
is_default | Unknown | |
is_enabled | Unknown | |
is_visible_in_customer_portal | Unknown | |
name | Unknown | |
name_in_customer_portal | Unknown | |
sanitized_name | Unknown |
module
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
api_key | Unknown | |
display_label | Unknown | |
is_enabled | Unknown | |
name_field | Unknown | |
plural_label | Unknown | |
singular_label | Unknown |
channel_content_type
| Column | Type | Keys |
|---|---|---|
content_type | Unknown | PK |
channel_id | Unknown | PKFK |
channel
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
department_id | Unknown | FK |
accepts_replie | Unknown | |
app_name | Unknown | |
external_id | Unknown | |
mapped_integration | Unknown | |
name | Unknown | |
photo_url | Unknown | |
reply_config_accepts_attachment | Unknown | |
reply_config_include_quoted_message | Unknown | |
reply_config_update_record | Unknown | |
type | Unknown |
users
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
label_id | Unknown | FK |
email_address | Unknown | |
last_accessed_time | Unknown | |
name | Unknown | |
photo_url | Unknown | |
status | Unknown | |
type | Unknown |
contact_time_entry_owner
| Column | Type | Keys |
|---|---|---|
contact_time_entry_id | Unknown | PKFK |
owner_id | Unknown | PKFK |
contact_time_entry
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agent_id | Unknown | FK |
contact_id | Unknown | FK |
created_by_id | Unknown | FK |
department_id | Unknown | FK |
layout_id | Unknown | FK |
owner_id | Unknown | FK |
request_id | Unknown | FK |
task_id | Unknown | FK |
additional_cost | Unknown | |
agent_cost_per_hour | Unknown | |
billing_type | Unknown | |
created_time | Instant | |
description | Unknown | |
executed_time | Unknown | |
fixed_cost | Unknown | |
hours_spent | Unknown | |
invoice_id | Unknown | |
is_billable | Unknown | |
is_trashed | Unknown | |
minutes_spent | Unknown | |
mode | Unknown | |
request_charge_type | Unknown | |
seconds_spent | Unknown | |
total_cost | Unknown | |
custom_** |
call
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
assignee_id | Unknown | FK |
contact_id | Unknown | FK |
creator_id | Unknown | FK |
department_id | Unknown | FK |
owner_id | Unknown | FK |
ticket_id | Unknown | FK |
activity_type | Unknown | |
category | Unknown | |
completed_time | Unknown | |
contact | Unknown | |
created_time | Instant | |
direction | Unknown | |
due_date | Unknown | |
is_commented | Unknown | |
is_spam | Unknown | |
priority | Unknown | |
start_time | Unknown | |
status | Unknown | |
subject | Unknown | |
team | Unknown | |
web_url | Unknown | |
custom_** |
agent_time_entry_owner
| Column | Type | Keys |
|---|---|---|
agent_time_entry_id | Unknown | PKFK |
owner_id | Unknown | PKFK |
agent_time_entry
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agent_id | Unknown | FK |
created_by_id | Unknown | FK |
creator_id | Unknown | FK |
department_id | Unknown | FK |
layout_id | Unknown | FK |
owner_id | Unknown | FK |
request_id | Unknown | FK |
task_id | Unknown | FK |
additional_cost | Unknown | |
agent_cost_per_hour | Unknown | |
billing_type | Unknown | |
created_time | Instant | |
description | Unknown | |
executed_time | Unknown | |
fixed_cost | Unknown | |
hours_spent | Unknown | |
invoice_id | Unknown | |
is_billable | Unknown | |
is_trashed | Unknown | |
minutes_spent | Unknown | |
mode | Unknown | |
request_charge_type | Unknown | |
seconds_spent | Unknown | |
total_cost | Unknown | |
custom_** |
contract_notification_agent
| Column | Type | Keys |
|---|---|---|
agent_id | Unknown | PKFK |
contract_id | Unknown | PKFK |
contract
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
account_id | Unknown | FK |
created_by_id | Unknown | FK |
department_id | Unknown | FK |
modified_by_id | Unknown | FK |
owner_id | Unknown | FK |
product_id | Unknown | FK |
created_time | Unknown | |
description | Unknown | |
end_date | Unknown | |
modified_time | Instant | |
name | Unknown | |
notify_before | Unknown | |
notify_on | Unknown | |
number | Unknown | |
sla_id | Unknown | |
sla_name | Unknown | |
start_date | Unknown | |
status | Unknown | |
custom_** |
agent_associated_department
| Column | Type | Keys |
|---|---|---|
agent_id | Unknown | PKFK |
associated_department_id | Unknown | PKFK |
agent_channel
| Column | Type | Keys |
|---|---|---|
agent_id | Unknown | PKFK |
channel_id | Unknown | PKFK |
agent
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
profile_id | Unknown | FK |
role_id | Unknown | FK |
about_info | Unknown | |
country_code | Unknown | |
email_id | Unknown | |
extn | Unknown | |
first_name | Unknown | |
is_confirmed | Unknown | |
lang_code | Unknown | |
last_name | Unknown | |
mobile | Unknown | |
name | Unknown | |
phone | Unknown | |
photo_url | Unknown | |
role_permission_type | Unknown | |
status | Unknown | |
time_zone | Unknown | |
zuid | Unknown |
organization
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
alias | Unknown | |
city | Unknown | |
company_name | Unknown | |
country | Unknown | |
currency_code | Unknown | |
currency_locale | Unknown | |
currency_symbol | Unknown | |
description | Unknown | |
edition | Unknown | |
employee_count | Unknown | |
favicon_url | Unknown | |
fax | Unknown | |
is_admin_in_org | Unknown | |
is_default | Unknown | |
logo_url | Unknown | |
mobile | Unknown | |
phone_number | Unknown | |
portal_name | Unknown | |
portal_url | Unknown | |
primary_contact | Unknown | |
state | Unknown | |
street | Unknown | |
website | Unknown | |
zip | Unknown | |
custom_** |
immediate_sub_role
| Column | Type | Keys |
|---|---|---|
role_id | Unknown | PKFK |
sub_role_id | Unknown | PKFK |
role
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
reports_to | Unknown | FK |
description | Unknown | |
is_default | Unknown | |
is_visible | Unknown | |
name | Unknown | |
share_data_with_peers | Unknown |
profile
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
defaults | Unknown | |
description | Unknown | |
is_visible | Unknown | |
name | Unknown | |
type | Unknown |
ticket_time_entry_owner
| Column | Type | Keys |
|---|---|---|
owner_id | Unknown | PKFK |
ticket_time_entry_id | Unknown | PKFK |
ticket_time_entry
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agent_id | Unknown | FK |
created_by_id | Unknown | FK |
department_id | Unknown | FK |
layout_id | Unknown | FK |
owner_id | Unknown | FK |
request_id | Unknown | FK |
ticket_id | Unknown | FK |
additional_cost | Unknown | |
agent_cost_per_hour | Unknown | |
billing_type | Unknown | |
created_time | Instant | |
description | Unknown | |
executed_time | Unknown | |
fixed_cost | Unknown | |
hours_spent | Unknown | |
invoice_id | Unknown | |
is_billable | Unknown | |
is_trashed | Unknown | |
minutes_spent | Unknown | |
mode | Unknown | |
request_charge_type | Unknown | |
seconds_spent | Unknown | |
total_cost | Unknown | |
custom_** |
account_time_entry_owner
| Column | Type | Keys |
|---|---|---|
account_time_entry_id | Unknown | PKFK |
owner_id | Unknown | PKFK |
account_time_entry
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
account_id | Unknown | FK |
agent_id | Unknown | FK |
created_by_id | Unknown | FK |
department_id | Unknown | FK |
layout_id | Unknown | FK |
owner_id | Unknown | FK |
request_id | Unknown | FK |
task_id | Unknown | FK |
additional_cost | Unknown | |
agent_cost_per_hour | Unknown | |
billing_type | Unknown | |
created_time | Instant | |
description | Unknown | |
executed_time | Unknown | |
fixed_cost | Unknown | |
hours_spent | Unknown | |
invoice_id | Unknown | |
is_billable | Unknown | |
is_trashed | Unknown | |
minutes_spent | Unknown | |
mode | Unknown | |
request_charge_type | Unknown | |
seconds_spent | Unknown | |
total_cost | Unknown | |
custom_** |
ticket_comment_attachment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
ticket_comment_id | Unknown | PKFK |
href | Unknown | |
name | Unknown | |
size | Unknown |
ticket_comment_mention
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
ticket_comment_id | Unknown | PKFK |
email | Unknown | |
first_name | Unknown | |
last_name | Unknown | |
length | Unknown | |
name | Unknown | |
offsets | Unknown | |
photo_url | Unknown | |
type | Unknown | |
zuid | Unknown |
ticket_comment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agent_id | Unknown | FK |
ticket_id | Unknown | FK |
commented_time | Unknown | |
content | Unknown | |
content_type | Unknown | |
is_public | Unknown | |
modified_time | Unknown |
ticket_shared_department
| Column | Type | Keys |
|---|---|---|
department_id | Unknown | PKFK |
ticket_id | Unknown | PKFK |
ticket_secondary_contact
| Column | Type | Keys |
|---|---|---|
contact_id | Unknown | PKFK |
ticket_id | Unknown | PKFK |
ticket_entity_skill
| Column | Type | Keys |
|---|---|---|
skill_id | Unknown | PK |
ticket_id | Unknown | PKFK |
ticket
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
account_id | Unknown | FK |
agent_id | Unknown | FK |
channel_id | Unknown | FK |
contact_id | Unknown | FK |
created_by_id | Unknown | FK |
department_id | Unknown | FK |
last_thread_channel_id | Unknown | FK |
layout_id | Unknown | FK |
modified_by_id | Unknown | FK |
product_id | Unknown | FK |
team_id | Unknown | FK |
category | Unknown | |
classification | Unknown | |
closed_time | Unknown | |
created_time | Instant | |
customer_response_time | Unknown | |
description | Unknown | |
due_date | Unknown | |
email | Unknown | |
is_archived | Unknown | |
is_escalated | Unknown | |
is_over_due | Unknown | |
is_read | Unknown | |
is_spam | Unknown | |
languages | Unknown | |
modified_time | Instant | |
number | Unknown | |
onhold_time | Unknown | |
phone | Unknown | |
priority | Unknown | |
resolution | Unknown | |
response_due_date | Unknown | |
sentiment | Unknown | |
sla_id | Unknown | |
source_app_name | Unknown | |
source_app_photo_url | Unknown | |
source_ext_id | Unknown | |
source_permanent_link | Unknown | |
source_type | Unknown | |
status | Unknown | |
status_type | Unknown | |
sub_category | Unknown | |
subject | Unknown | |
web_url | Unknown | |
custom_** |
team_derived_agent
| Column | Type | Keys |
|---|---|---|
derived_agent_id | Unknown | PKFK |
team_id | Unknown | PKFK |
team_agent
| Column | Type | Keys |
|---|---|---|
agent_id | Unknown | PKFK |
team_id | Unknown | PKFK |
team_role
| Column | Type | Keys |
|---|---|---|
role_id | Unknown | PKFK |
team_id | Unknown | PKFK |
team_role_with_subordinate
| Column | Type | Keys |
|---|---|---|
subordinate | Unknown | PK |
team_id | Unknown | PKFK |
team_sub_team
| Column | Type | Keys |
|---|---|---|
sub_team_id | Unknown | PKFK |
team_id | Unknown | PKFK |
team
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
department_id | Unknown | FK |
description | Unknown | |
logo_url | Unknown | |
name | Unknown |
task_time_entry_owner
| Column | Type | Keys |
|---|---|---|
owner_id | Unknown | PKFK |
task_time_entry_id | Unknown | PKFK |
task_time_entry
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agent_id | Unknown | FK |
created_by_id | Unknown | FK |
department_id | Unknown | FK |
layout_id | Unknown | FK |
owner_id | Unknown | FK |
request_id | Unknown | FK |
task_id | Unknown | FK |
additional_cost | Unknown | |
agent_cost_per_hour | Unknown | |
billing_type | Unknown | |
created_time | Instant | |
description | Unknown | |
executed_time | Unknown | |
fixed_cost | Unknown | |
hours_spent | Unknown | |
invoice_id | Unknown | |
is_billable | Unknown | |
is_trashed | Unknown | |
minutes_spent | Unknown | |
mode | Unknown | |
request_charge_type | Unknown | |
seconds_spent | Unknown | |
total_cost | Unknown | |
custom_** |