Freshservice

Explore the interactive ERD

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	PKFK
`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	PKFK

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	PKFK
`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	PKFK

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	PKFK

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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK

project_task_type_field

Column	Type	Keys
`type_id`	Long	PK
`project_id`	Long	PKFK
`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	PKFK
`ticket_id`	Long	PKFK

ticket_tag

Column	Type	Keys
`tag_name`	String	PK
`ticket_id`	Long	PKFK

agent_role

Column	Type	Keys
`agent_id`	Long	PKFK
`role_id`	Long	PKFK

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	PKFK
`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	PKFK

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	PKFK
`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	PKFK
`user_id`	Long	PKFK

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	PKFK

project_version

Column	Type	Keys
`id`	Long	PK
`project_id`	Long	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`answer_text`	String
`question_text`	String

solution_folder_approval

Column	Type	Keys
`approval_type`	Int	PK
`approver_id`	Long	PKFK
`folder_id`	Long	PKFK

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	PKFK
`department_id`	Long	PKFK

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	PKFK
`created_at`	Instant
`description`	String
`name`	String
`updated_at`	Instant