# Zoho Desk schema ERD

Table and field reference for the Fivetran Zoho Desk connector.

## 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 | PK, FK |

### 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 | PK, FK |
| product_id | Unknown | PK, FK |

### 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 | PK, FK |

### 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 | PK, FK |
| owner_id | Unknown | PK, FK |

### 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 | PK, FK |
| owner_id | Unknown | PK, FK |

### 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 | PK, FK |
| contract_id | Unknown | PK, FK |

### 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 | PK, FK |
| associated_department_id | Unknown | PK, FK |

### agent_channel

| Column | Type | Keys |
| --- | --- | --- |
| agent_id | Unknown | PK, FK |
| channel_id | Unknown | PK, FK |

### 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 | PK, FK |
| sub_role_id | Unknown | PK, FK |

### 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 | PK, FK |
| ticket_time_entry_id | Unknown | PK, FK |

### 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 | PK, FK |
| owner_id | Unknown | PK, FK |

### 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 | PK, FK |
| href | Unknown |  |
| name | Unknown |  |
| size | Unknown |  |

### ticket_comment_mention

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| ticket_comment_id | Unknown | PK, FK |
| 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 | PK, FK |
| ticket_id | Unknown | PK, FK |

### ticket_secondary_contact

| Column | Type | Keys |
| --- | --- | --- |
| contact_id | Unknown | PK, FK |
| ticket_id | Unknown | PK, FK |

### ticket_entity_skill

| Column | Type | Keys |
| --- | --- | --- |
| skill_id | Unknown | PK |
| ticket_id | Unknown | PK, FK |

### 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 | PK, FK |
| team_id | Unknown | PK, FK |

### team_agent

| Column | Type | Keys |
| --- | --- | --- |
| agent_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |

### team_role

| Column | Type | Keys |
| --- | --- | --- |
| role_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |

### team_role_with_subordinate

| Column | Type | Keys |
| --- | --- | --- |
| subordinate | Unknown | PK |
| team_id | Unknown | PK, FK |

### team_sub_team

| Column | Type | Keys |
| --- | --- | --- |
| sub_team_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |

### 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 | PK, FK |
| task_time_entry_id | Unknown | PK, FK |

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

## Relationships

- contact(layout_id) → layout(id)
- contact(owner_id) → agent(id)
- contact(account_id) → account(id)
- groups(modifier_id) → users(id)
- groups(creator_id) → users(id)
- layout_profile(profile_id) → profile(id)
- layout(department_id) → department(id)
- layout(modified_by_id) → agent(id)
- layout(created_by_id) → agent(id)
- account(layout_id) → layout(id)
- account(owner_id) → agent(id)
- product_department(department_id) → department(id)
- product_department(product_id) → product(id)
- product(modified_by_id) → agent(id)
- product(layout_id) → layout(id)
- product(owner_id) → agent(id)
- product(created_by_id) → agent(id)
- ticket_approval(approver_id) → agent(id)
- ticket_approval(requester_id) → agent(id)
- ticket_approval(ticket_id) → ticket(id)
- label(modifier_id) → users(id)
- label(creator_id) → users(id)
- task(department_id) → department(id)
- task(team_id) → team(id)
- task(modified_by_id) → agent(id)
- task(layout_id) → layout(id)
- task(owner_id) → agent(id)
- task(assignee_id) → agent(id)
- task(ticket_id) → ticket(id)
- task(call_id) → call(id)
- task(creator_id) → agent(id)
- task(contact_id) → contact(id)
- task(product_id) → product(id)
- ticket_follower(ticket_id) → ticket(id)
- department(agent_id) → agent(id)
- channel_content_type(channel_id) → channel(id)
- channel(department_id) → department(id)
- users(label_id) → label(id)
- contact_time_entry_owner(owner_id) → agent(id)
- contact_time_entry_owner(contact_time_entry_id) → contact_time_entry(id)
- contact_time_entry(request_id) → task(id)
- contact_time_entry(task_id) → task(id)
- contact_time_entry(department_id) → department(id)
- contact_time_entry(layout_id) → layout(id)
- contact_time_entry(owner_id) → agent(id)
- contact_time_entry(created_by_id) → agent(id)
- contact_time_entry(agent_id) → agent(id)
- contact_time_entry(contact_id) → contact(id)
- call(department_id) → department(id)
- call(owner_id) → agent(id)
- call(assignee_id) → agent(id)
- call(ticket_id) → ticket(id)
- call(creator_id) → agent(id)
- call(contact_id) → contact(id)
- agent_time_entry_owner(owner_id) → agent(id)
- agent_time_entry_owner(agent_time_entry_id) → agent_time_entry(id)
- agent_time_entry(request_id) → task(id)
- agent_time_entry(task_id) → task(id)
- agent_time_entry(department_id) → department(id)
- agent_time_entry(layout_id) → layout(id)
- agent_time_entry(owner_id) → agent(id)
- agent_time_entry(created_by_id) → agent(id)
- agent_time_entry(creator_id) → agent(id)
- agent_time_entry(agent_id) → agent(id)
- contract_notification_agent(agent_id) → agent(id)
- contract_notification_agent(contract_id) → contract(id)
- contract(product_id) → product(id)
- contract(department_id) → department(id)
- contract(modified_by_id) → agent(id)
- contract(owner_id) → agent(id)
- contract(created_by_id) → agent(id)
- contract(account_id) → account(id)
- agent_associated_department(associated_department_id) → department(id)
- agent_associated_department(agent_id) → agent(id)
- agent_channel(channel_id) → channel(id)
- agent_channel(agent_id) → agent(id)
- agent(profile_id) → profile(id)
- agent(role_id) → role(id)
- immediate_sub_role(sub_role_id) → role(id)
- immediate_sub_role(role_id) → role(id)
- role(reports_to) → role(id)
- ticket_time_entry_owner(owner_id) → agent(id)
- ticket_time_entry_owner(ticket_time_entry_id) → ticket_time_entry(id)
- ticket_time_entry(request_id) → ticket(id)
- ticket_time_entry(department_id) → department(id)
- ticket_time_entry(layout_id) → layout(id)
- ticket_time_entry(owner_id) → agent(id)
- ticket_time_entry(created_by_id) → agent(id)
- ticket_time_entry(agent_id) → agent(id)
- ticket_time_entry(ticket_id) → ticket(id)
- account_time_entry_owner(owner_id) → agent(id)
- account_time_entry_owner(account_time_entry_id) → account_time_entry(id)
- account_time_entry(request_id) → task(id)
- account_time_entry(task_id) → task(id)
- account_time_entry(department_id) → department(id)
- account_time_entry(layout_id) → layout(id)
- account_time_entry(owner_id) → agent(id)
- account_time_entry(created_by_id) → agent(id)
- account_time_entry(agent_id) → agent(id)
- account_time_entry(account_id) → account(id)
- ticket_comment_attachment(ticket_comment_id) → ticket_comment(id)
- ticket_comment_mention(ticket_comment_id) → ticket_comment(id)
- ticket_comment(agent_id) → agent(id)
- ticket_comment(ticket_id) → ticket(id)
- ticket_shared_department(department_id) → department(id)
- ticket_shared_department(ticket_id) → ticket(id)
- ticket_secondary_contact(contact_id) → contact(id)
- ticket_secondary_contact(ticket_id) → ticket(id)
- ticket_entity_skill(ticket_id) → ticket(id)
- ticket(product_id) → product(id)
- ticket(channel_id) → channel(id)
- ticket(department_id) → department(id)
- ticket(team_id) → team(id)
- ticket(modified_by_id) → agent(id)
- ticket(layout_id) → layout(id)
- ticket(created_by_id) → agent(id)
- ticket(agent_id) → agent(id)
- ticket(last_thread_channel_id) → channel(id)
- ticket(account_id) → agent(id)
- ticket(contact_id) → contact(id)
- team_derived_agent(derived_agent_id) → agent(id)
- team_derived_agent(team_id) → team(id)
- team_agent(agent_id) → agent(id)
- team_agent(team_id) → team(id)
- team_role(role_id) → role(id)
- team_role(team_id) → team(id)
- team_role_with_subordinate(team_id) → team(id)
- team_sub_team(sub_team_id) → team(id)
- team_sub_team(team_id) → team(id)
- team(department_id) → department(id)
- task_time_entry_owner(owner_id) → agent(id)
- task_time_entry_owner(task_time_entry_id) → task_time_entry(id)
- task_time_entry(request_id) → task(id)
- task_time_entry(task_id) → task(id)
- task_time_entry(department_id) → department(id)
- task_time_entry(layout_id) → layout(id)
- task_time_entry(owner_id) → agent(id)
- task_time_entry(created_by_id) → agent(id)
- task_time_entry(agent_id) → agent(id)