# Freshservice schema ERD

Table and field reference for the Fivetran Freshservice connector.

## Table & Field Reference

### project_task

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| assignee_id | Long | FK |
| parent_id | Long | FK |
| priority_id | Long | FK |
| project_id | Long | FK |
| reporter_id | Long | FK |
| sprint_id | Long | FK |
| status_id | Long | FK |
| type_id | Long | FK |
| version_id | Long | FK |
| created_at | Instant |  |
| display_key | String |  |
| end_date | Instant |  |
| planned_duration | String |  |
| planned_effort | String |  |
| planned_end_date | Instant |  |
| planned_start_date | Instant |  |
| start_date | Instant |  |
| story_points | Long |  |
| title | String |  |
| updated_at | Instant |  |

### project_membership

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| project_id | Long | PK, FK |
| user_id | Long | FK |
| access_type | Long |  |
| created_at | Instant |  |
| manage_settings | Boolean |  |
| project_manager | Boolean |  |
| updated_at | Instant |  |

### notify_email

| Column | Type | Keys |
| --- | --- | --- |
| email | String | PK |
| parent_entity_id | Long | PK |
| parent_entity_type | String | PK |

### solution_folder_relation_id

| Column | Type | Keys |
| --- | --- | --- |
| entity_id | Long | PK |
| relation_type | String | PK |
| folder_id | Long | PK, FK |

### business_hour

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_at | Instant |  |
| description | String |  |
| name | String |  |
| updated_at | Instant |  |

### contract_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_at | Instant |  |
| description | String |  |
| is_default | Boolean |  |
| name | String |  |
| needs_approval | Boolean |  |
| updated_at | Instant |  |

### project_task_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| project_id | Long | PK, FK |
| category_code | Long |  |
| created_at | Instant |  |
| description | String |  |
| name | String |  |
| updated_at | Instant |  |

### department

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| head_user_id | Long | FK |
| prime_user_id | Long | FK |
| created_at | Instant |  |
| description | String |  |
| name | String |  |
| note | String |  |
| updated_at | Instant |  |

### location

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| parent_location_id | Long | FK |
| primary_contact_id | Long | FK |
| created_at | Instant |  |
| email | String |  |
| name | String |  |
| phone | String |  |
| updated_at | Instant |  |
| address_** |  |  |

### department_domain

| Column | Type | Keys |
| --- | --- | --- |
| domain | String | PK |
| department_id | Long | PK, FK |

### note

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| parent_entity_id | Long | PK |
| parent_entity_type | String | PK |
| user_id | Long | FK |
| body | String |  |
| body_text | String |  |
| from_email | String |  |

### solution_folder

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| category_id | Long | FK |
| created_at | Instant |  |
| default_folder | Boolean |  |
| description | String |  |
| name | String |  |
| position | Int |  |
| updated_at | Instant |  |
| visibility | Int |  |

### task

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| agent_id | Long | FK |
| group_id | Long | FK |
| closed_at | Instant |  |
| created_at | Instant |  |
| description | String |  |
| due_date | Instant |  |
| parent_object_id | Long |  |
| parent_object_type | String |  |
| status | Int |  |
| title | String |  |
| updated_at | Instant |  |

### time_entry

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| agent_id | Long | FK |
| task_id | Long | FK |
| billable | Boolean |  |
| created_at | Instant |  |
| executed_at | Instant |  |
| note | String |  |
| parent_entity_id | Long |  |
| parent_entity_type | String |  |
| start_time | Instant |  |
| time_spent | String |  |
| timer_running | Boolean |  |
| updated_at | Instant |  |

### software_relationship

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_at | Instant |  |
| primary_id | Long |  |
| primary_type | String |  |
| relationship_type_id | Long |  |
| secondary_id | Long |  |
| secondary_type | String |  |
| updated_at | Instant |  |

### ticket

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| department_id | Long | FK |
| group_id | Long | FK |
| requested_for_id | Long | FK |
| requester_id | Long | FK |
| responder_id | Long | FK |
| approval_status | Int |  |
| approval_status_name | String |  |
| association_type | Int |  |
| category | String |  |
| created_at | Instant |  |
| description | String |  |
| description_text | String |  |
| due_by | Instant |  |
| fr_due_by | Instant |  |
| is_escalated | Boolean |  |
| item_category | String |  |
| priority | String |  |
| source | String |  |
| spam | Boolean |  |
| stats_closed_at | Instant |  |
| stats_first_responded_at | Instant |  |
| stats_resolved_at | Instant |  |
| status | String |  |
| sub_category | String |  |
| subject | String |  |
| type | String |  |
| updated_at | Instant |  |
| workspace_id | Int |  |

### announcement_email

| Column | Type | Keys |
| --- | --- | --- |
| email | String | PK |
| announcement_id | Long | PK, FK |

### software_user

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| license_id | Long | FK |
| software_id | Long | FK |
| user_id | Long | FK |
| allocated_date | Instant |  |
| created_at | Instant |  |
| first_used | Instant |  |
| last_used | Instant |  |
| updated_at | Instant |  |

### contract

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| approver_id | Long | FK |
| contract_type_id | Long | FK |
| delegatee_id | Long | FK |
| future_contract_id | Long | FK |
| requester_id | Long | FK |
| software_id | Long | FK |
| vendor_id | Long | FK |
| visible_to_id | Long | FK |
| auto_renew | Boolean |  |
| billing_cycle | String |  |
| contract_number | String |  |
| cost | Float |  |
| created_at | Instant |  |
| description | String |  |
| end_date | Instant |  |
| expiry_notified | Boolean |  |
| has_associated_assets | Boolean |  |
| has_attachments | Boolean |  |
| license_key | String |  |
| license_type | String |  |
| name | String |  |
| notify_before | Int |  |
| notify_expiry | Boolean |  |
| start_date | Instant |  |
| status | String |  |
| updated_at | Instant |  |

### problem

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| agent_id | Long | FK |
| department_id | Long | FK |
| group_id | Long | FK |
| requester_id | Long | FK |
| category | String |  |
| created_at | Instant |  |
| description | String |  |
| description_text | String |  |
| due_by | Instant |  |
| impact | Int |  |
| item_category | String |  |
| known_error | Boolean |  |
| priority | Int |  |
| status | Int |  |
| sub_category | String |  |
| updated_at | Instant |  |

### role

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_at | Instant |  |
| default | Boolean |  |
| description | String |  |
| name | String |  |
| updated_at | Instant |  |

### project_task_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| project_id | Long | PK, FK |
| created_at | Instant |  |
| description | String |  |
| name | String |  |
| updated_at | Instant |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| asset_type_id | Long | FK |
| created_at | Instant |  |
| depreciation_type_id | Long |  |
| description | String |  |
| description_text | String |  |
| manufacturer | String |  |
| mode_of_procurement | String |  |
| name | String |  |
| status | String |  |
| updated_at | Instant |  |

### project_sprint

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| project_id | Long | PK, FK |
| created_at | Instant |  |
| goal | String |  |
| planned_end_date | Instant |  |
| planned_start_date | Instant |  |
| state | Long |  |
| title | String |  |
| updated_at | Instant |  |

### conversation

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| ticket_id | Long | PK, FK |
| user_id | Long | FK |
| body | String |  |
| body_text | String |  |
| created_at | Instant |  |
| from_email | String |  |
| incoming | Boolean |  |
| private | Boolean |  |
| source | Long |  |
| support_email | String |  |
| updated_at | Instant |  |

### ticket_approval

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| ticket_id | Long | PK, FK |
| approver_id | Long | FK |
| user_id | Long | FK |
| approval_group_id | Long |  |
| approval_group_name | String |  |
| approval_status_id | Long |  |
| approval_status_name | String |  |
| approval_type | Int |  |
| approver_name | String |  |
| created_at | Instant |  |
| delegatee_id | Long |  |
| delegatee_name | String |  |
| latest_remark | String |  |
| level | Int |  |
| updated_at | Instant |  |
| user_name | String |  |

### announcement_relation

| Column | Type | Keys |
| --- | --- | --- |
| entity_id | Long | PK |
| relation_type | String | PK |
| announcement_id | Long | PK, FK |

### project_task_type_field

| Column | Type | Keys |
| --- | --- | --- |
| type_id | Long | PK |
| project_id | Long | PK, FK |
| choices | Json |  |
| created_at | Instant |  |
| default | Boolean |  |
| label | String |  |
| mandatory | Boolean |  |
| name | String |  |
| type | String |  |
| updated_at | Instant |  |

### related_ticket

| Column | Type | Keys |
| --- | --- | --- |
| child_id | Long | PK, FK |
| ticket_id | Long | PK, FK |

### ticket_tag

| Column | Type | Keys |
| --- | --- | --- |
| tag_name | String | PK |
| ticket_id | Long | PK, FK |

### agent_role

| Column | Type | Keys |
| --- | --- | --- |
| agent_id | Long | PK, FK |
| role_id | Long | PK, FK |

### software

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| managed_by_id | Long | FK |
| publisher_id | Long | FK |
| application_type | String |  |
| category | String |  |
| created_at | Instant |  |
| description | String |  |
| installation_count | Long |  |
| name | String |  |
| notes | String |  |
| status | String |  |
| updated_at | Instant |  |
| user_count | Long |  |

### contract_item_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| contract_id | Long | PK, FK |
| comments | String |  |
| cost | Float |  |
| count | String |  |
| created_at | Instant |  |
| item_name | String |  |
| pricing_model | String |  |
| updated_at | Instant |  |

### service_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| category_id | Long | FK |
| ci_type_id | Long | FK |
| product_id | Long | FK |
| allow_attachments | Boolean |  |
| allow_quantity | Boolean |  |
| botified | Boolean |  |
| configs | Json |  |
| cost_visibility | Boolean |  |
| create_child | Boolean |  |
| created_at | Instant |  |
| delivery_time | Int |  |
| delivery_time_visibility | Boolean |  |
| display_id | Long |  |
| group_visibility | Int |  |
| icon_name | String |  |
| is_bundle | Boolean |  |
| item_type | Int |  |
| name | String |  |
| quantity | Int |  |
| updated_at | Instant |  |
| visibility | Int |  |

### ticket_email

| Column | Type | Keys |
| --- | --- | --- |
| email | String | PK |
| type | String | PK |
| ticket_id | Long | PK, FK |

### associated_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| parent_entity_id | Long | PK |
| parent_entity_type | String | PK |
| attachment_url | String |  |
| canonical_url | String |  |
| content_type | String |  |
| created_at | Instant |  |
| name | String |  |
| size | Long |  |
| updated_at | Instant |  |

### purchase_order_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| order_id | Long | PK, FK |
| item_id | Long | FK |
| cost | Float |  |
| created_at | Instant |  |
| description | String |  |
| item_name | String |  |
| item_type | Int |  |
| quantity | Long |  |
| received | Long |  |
| tax_percentage | Float |  |
| total_cost | Float |  |
| updated_at | Instant |  |

### service_user

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| location_id | Long | FK |
| reporting_manager_id | Long | FK |
| active | Boolean |  |
| address | String |  |
| blocked | Boolean |  |
| created_at | Instant |  |
| first_name | String |  |
| is_agent | Boolean |  |
| job_title | String |  |
| language | String |  |
| last_active_at | Instant |  |
| last_login_at | Instant |  |
| last_name | String |  |
| mobile_phone_number | String |  |
| occasional | Boolean |  |
| primary_email | String |  |
| signature | String |  |
| time_zone | String |  |
| updated_at | Instant |  |
| vip_user | Boolean |  |
| work_phone_number | String |  |

### user_group

| Column | Type | Keys |
| --- | --- | --- |
| type | String | PK |
| group_id | Long | PK, FK |
| user_id | Long | PK, FK |

### software_installation

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| department_id | Long | FK |
| installation_machine_id | Long | FK |
| software_id | Long | FK |
| user_id | Long | FK |
| created_at | Instant |  |
| installation_date | Instant |  |
| installation_path | String |  |
| updated_at | Instant |  |
| version | String |  |

### solution_article_feature

| Column | Type | Keys |
| --- | --- | --- |
| type | String | PK |
| value | String | PK |
| article_id | Long | PK, FK |

### project_version

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| project_id | Long | PK, FK |
| owner_id | Long | FK |
| created_at | Instant |  |
| description | String |  |
| due_date | Instant |  |
| name | String |  |
| start_date | Instant |  |
| status_code | Long |  |
| updated_at | Instant |  |

### workspace

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| created_at | Instant |  |
| description | String |  |
| is_primary | Boolean |  |
| name | String |  |
| restricted | Boolean |  |
| state | String |  |
| template_name | String |  |
| updated_at | Instant |  |

### purchase_order

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_by | Long | FK |
| department_id | Long | FK |
| vendor_id | Long | FK |
| billing_address | String |  |
| billing_same_as_shipping | Boolean |  |
| created_at | Instant |  |
| discount_percentage | Long |  |
| expected_delivery_date | Instant |  |
| name | String |  |
| po_number | String |  |
| shipping_address | String |  |
| shipping_cost | Long |  |
| status | Long |  |
| tax_percentage | Long |  |
| updated_at | Instant |  |
| vendor_details | String |  |
| currency_** |  |  |

### service_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| business_hour_id | Long | FK |
| escalate_to | Long | FK |
| workspace_id | Int | FK |
| approval_required | Boolean |  |
| auto_ticket_assign | Boolean |  |
| created_at | Instant |  |
| description | String |  |
| is_requester_group | Boolean |  |
| name | String |  |
| type | String |  |
| unassigned_for | String |  |
| updated_at | Instant |  |

### solution_article

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| category_id | Long | FK |
| folder_id | Long | FK |
| modified_by | Long | FK |
| user_id | Long | FK |
| approval_status | Long |  |
| article_type | Int |  |
| created_at | Instant |  |
| description | String |  |
| description_text | String |  |
| inserted_into_tickets | Int |  |
| modified_at | Instant |  |
| position | Int |  |
| review_date | Instant |  |
| status | Int |  |
| thumbs_down | Int |  |
| thumbs_up | Int |  |
| title | String |  |
| updated_at | Instant |  |
| url | String |  |
| views | Int |  |

### associated_asset

| Column | Type | Keys |
| --- | --- | --- |
| asset_display_id | Long | PK |
| parent_entity_id | Long | PK |
| parent_entity_type | String | PK |

### csat_response

| Column | Type | Keys |
| --- | --- | --- |
| ticket_id | Long | PK, FK |
| created_at | Instant |  |
| id | Long |  |
| overall_rating | Int |  |
| overall_rating_text | String |  |
| primary_question | String |  |
| updated_at | Instant |  |

### vendor

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| primary_contact_id | Long | FK |
| contact_name | String |  |
| created_at | Instant |  |
| description | String |  |
| email | String |  |
| mobile | String |  |
| name | String |  |
| phone | String |  |
| updated_at | Instant |  |
| address_** |  |  |

### project

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| group_id | Long | FK |
| manager_id | Long | FK |
| archived | Boolean |  |
| closed_at | Instant |  |
| created_at | Instant |  |
| description | String |  |
| end_date | LocalDate |  |
| key | String |  |
| name | String |  |
| priority_code | Long |  |
| project_type | String |  |
| sprint_duration | Long |  |
| start_date | LocalDate |  |
| status_code | Long |  |
| updated_at | Instant |  |
| visibility | Long |  |

### asset_component

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| asset_id | Long | PK, FK |
| component_data | Json |  |
| component_type | String |  |
| created_at | Instant |  |
| updated_at | Instant |  |

### ticket_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| ticket_id | Long | FK |
| cost_per_request | Double |  |
| created_at | Instant |  |
| delivery_time | Int |  |
| is_parent | Boolean |  |
| loaned | Boolean |  |
| quantity | Int |  |
| remarks | String |  |
| service_item_id | Long |  |
| stage | Int |  |
| updated_at | Instant |  |

### csat_survey_response

| Column | Type | Keys |
| --- | --- | --- |
| answer_index | Int | PK |
| question_index | Int | PK |
| ticket_id | Long | PK, FK |
| answer_text | String |  |
| question_text | String |  |

### solution_folder_approval

| Column | Type | Keys |
| --- | --- | --- |
| approval_type | Int | PK |
| approver_id | Long | PK, FK |
| folder_id | Long | PK, FK |

### release

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| agent_id | Long | FK |
| department_id | Long | FK |
| group_id | Long | FK |
| requester_id | Long | FK |
| approval_status | Int |  |
| category | String |  |
| created_at | Instant |  |
| description | String |  |
| description_text | String |  |
| due_by | Instant |  |
| impact | Int |  |
| item_category | String |  |
| known_error | Boolean |  |
| planned_end_date | Instant |  |
| planned_start_date | Instant |  |
| priority | Int |  |
| release_type | Int |  |
| risk | Int |  |
| status | Int |  |
| sub_category | String |  |
| subject | String |  |
| updated_at | Instant |  |
| work_end_date | Instant |  |
| work_start_date | Instant |  |

### software_license

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| software_id | Long | FK |
| contract_id | String |  |
| created_time | Instant |  |
| updated_time | Instant |  |

### solution_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_at | Instant |  |
| default_category | Boolean |  |
| description | String |  |
| name | String |  |
| position | Int |  |
| updated_at | Instant |  |

### agent_department

| Column | Type | Keys |
| --- | --- | --- |
| agent_id | Long | PK, FK |
| department_id | Long | PK, FK |

### asset

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| agent_id | Long | FK |
| asset_type_id | Long | FK |
| department_id | Long | FK |
| group_id | Long | FK |
| location_id | Long | FK |
| user_id | Long | FK |
| asset_tag | String |  |
| assigned_on | Instant |  |
| author_type | String |  |
| created_at | Instant |  |
| description | String |  |
| display_id | Long |  |
| impact | String |  |
| name | String |  |
| updated_at | Instant |  |
| usage_type | String |  |

### associated_change

| Column | Type | Keys |
| --- | --- | --- |
| change_id | Long | PK |
| release_id | Long | PK |

### change

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| agent_id | Long | FK |
| department_id | Long | FK |
| group_id | Long | FK |
| requester_id | Long | FK |
| approval_status | Int |  |
| category | String |  |
| change_type | Int |  |
| created_at | Instant |  |
| description | String |  |
| description_text | String |  |
| due_by | Instant |  |
| impact | Int |  |
| item_category | String |  |
| known_error | Boolean |  |
| planned_end_date | Instant |  |
| planned_start_date | Instant |  |
| priority | Int |  |
| risk | Int |  |
| status | Int |  |
| sub_category | String |  |
| subject | String |  |
| updated_at | Instant |  |

### asset_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| parent_asset_type_id | Long | FK |
| created_at | Instant |  |
| description | String |  |
| name | String |  |
| updated_at | Instant |  |
| visible | Boolean |  |

### service_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_at | Instant |  |
| description | String |  |
| name | String |  |
| position | Int |  |
| updated_at | Instant |  |

### announcement

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_by | Long | FK |
| body | String |  |
| body_html | String |  |
| created_at | Instant |  |
| is_read | Boolean |  |
| send_email | Boolean |  |
| state | String |  |
| title | String |  |
| updated_at | Instant |  |
| visibility | String |  |
| visible_from | Instant |  |
| visible_till | Instant |  |

### project_task_priority

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| project_id | Long | PK, FK |
| created_at | Instant |  |
| description | String |  |
| name | String |  |
| updated_at | Instant |  |

## Relationships

- project_task(project_id) → project(id)
- project_task(status_id) → project_task_status(id)
- project_task(type_id) → project_task_type(id)
- project_task(assignee_id) → service_user(id)
- project_task(priority_id) → project_task_priority(id)
- project_task(reporter_id) → service_user(id)
- project_task(sprint_id) → project_sprint(id)
- project_task(version_id) → project_version(id)
- project_task(parent_id) → project_task(id)
- project_membership(project_id) → project(id)
- project_membership(user_id) → service_user(id)
- solution_folder_relation_id(folder_id) → solution_folder(id)
- project_task_status(project_id) → project(id)
- department(head_user_id) → service_user(id)
- department(prime_user_id) → service_user(id)
- location(parent_location_id) → location(id)
- location(primary_contact_id) → service_user(id)
- department_domain(department_id) → department(id)
- note(user_id) → service_user(id)
- solution_folder(category_id) → solution_category(id)
- task(group_id) → service_group(id)
- task(agent_id) → service_user(id)
- time_entry(agent_id) → service_user(id)
- time_entry(task_id) → task(id)
- ticket(requester_id) → service_user(id)
- ticket(responder_id) → service_user(id)
- ticket(department_id) → department(id)
- ticket(group_id) → service_group(id)
- ticket(requested_for_id) → service_user(id)
- announcement_email(announcement_id) → announcement(id)
- software_user(software_id) → software(id)
- software_user(user_id) → service_user(id)
- software_user(license_id) → contract(id)
- contract(vendor_id) → vendor(id)
- contract(approver_id) → service_user(id)
- contract(requester_id) → service_user(id)
- contract(delegatee_id) → service_user(id)
- contract(future_contract_id) → contract(id)
- contract(visible_to_id) → service_group(id)
- contract(contract_type_id) → contract_type(id)
- contract(software_id) → software(id)
- problem(requester_id) → service_user(id)
- problem(agent_id) → service_user(id)
- problem(department_id) → department(id)
- problem(group_id) → service_group(id)
- project_task_type(project_id) → project(id)
- product(asset_type_id) → asset_type(id)
- project_sprint(project_id) → project(id)
- conversation(ticket_id) → ticket(id)
- conversation(user_id) → service_user(id)
- ticket_approval(ticket_id) → ticket(id)
- ticket_approval(approver_id) → service_user(id)
- ticket_approval(user_id) → service_user(id)
- announcement_relation(announcement_id) → announcement(id)
- project_task_type_field(project_id) → project(id)
- related_ticket(ticket_id) → ticket(id)
- related_ticket(child_id) → ticket(id)
- ticket_tag(ticket_id) → ticket(id)
- agent_role(agent_id) → service_user(id)
- agent_role(role_id) → role(id)
- software(publisher_id) → vendor(id)
- software(managed_by_id) → service_user(id)
- contract_item_detail(contract_id) → contract(id)
- service_item(category_id) → service_category(id)
- service_item(product_id) → product(id)
- service_item(ci_type_id) → asset_type(id)
- ticket_email(ticket_id) → ticket(id)
- purchase_order_item(order_id) → purchase_order(id)
- purchase_order_item(item_id) → product(id)
- service_user(reporting_manager_id) → service_user(id)
- service_user(location_id) → location(id)
- user_group(user_id) → service_user(id)
- user_group(group_id) → service_group(id)
- software_installation(software_id) → software(id)
- software_installation(user_id) → service_user(id)
- software_installation(department_id) → department(id)
- software_installation(installation_machine_id) → asset(id)
- solution_article_feature(article_id) → solution_article(id)
- project_version(project_id) → project(id)
- project_version(owner_id) → service_user(id)
- purchase_order(department_id) → department(id)
- purchase_order(vendor_id) → vendor(id)
- purchase_order(created_by) → service_user(id)
- service_group(escalate_to) → service_user(id)
- service_group(business_hour_id) → business_hour(id)
- service_group(workspace_id) → workspace(id)
- solution_article(folder_id) → solution_folder(id)
- solution_article(category_id) → solution_category(id)
- solution_article(user_id) → service_user(id)
- solution_article(modified_by) → service_user(id)
- csat_response(ticket_id) → ticket(id)
- vendor(primary_contact_id) → service_user(id)
- project(group_id) → service_group(id)
- project(manager_id) → service_user(id)
- asset_component(asset_id) → asset(id)
- ticket_item(ticket_id) → ticket(id)
- csat_survey_response(ticket_id) → csat_response(ticket_id)
- solution_folder_approval(folder_id) → solution_folder(id)
- solution_folder_approval(approver_id) → service_user(id)
- release(requester_id) → service_user(id)
- release(agent_id) → service_user(id)
- release(department_id) → department(id)
- release(group_id) → service_group(id)
- software_license(software_id) → software(id)
- agent_department(agent_id) → service_user(id)
- agent_department(department_id) → department(id)
- asset(user_id) → service_user(id)
- asset(department_id) → department(id)
- asset(agent_id) → service_user(id)
- asset(group_id) → service_group(id)
- asset(asset_type_id) → asset_type(id)
- asset(location_id) → location(id)
- change(requester_id) → service_user(id)
- change(agent_id) → service_user(id)
- change(department_id) → department(id)
- change(group_id) → service_group(id)
- asset_type(parent_asset_type_id) → asset_type(id)
- announcement(created_by) → service_user(id)
- project_task_priority(project_id) → project(id)