Planhat

Explore the interactive ERD

Table & Field Reference

workspace

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	FK
`owner_id`	Unknown	FK
`external_id`	Unknown
`name`	Unknown
`source_id`	Unknown
`usage`	Json
`custom_`

churn_reason

Column	Type	Keys
`index`	Unknown	PK
`churn_id`	Unknown	PKFK
`reason`	Unknown

churn_product

Column	Type	Keys
`index`	Unknown	PK
`churn_id`	Unknown	PKFK
`product`	Unknown

churn

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	FK
`license_id`	Unknown	FK
`arr`	Unknown
`churn_date`	Instant
`comment`	Unknown
`currency`	Unknown
`last_updated`	Unknown
`replacement`	Unknown
`snoozed`	Unknown
`source_id`	Unknown
`value`	Unknown
`custom_`

project

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	FK
`arr`	Unknown
`currency`	Unknown
`end_date`	Unknown
`external_id`	Unknown
`mrr`	Unknown
`name`	Unknown
`nrr`	Unknown
`source_id`	Unknown
`start_date`	Unknown
`custom_`

objective

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	PKFK
`external_id`	Unknown
`health`	Unknown
`name`	Unknown
`source_id`	Unknown
`usage`	Json
`custom_`

company_csm_score_log

Column	Type	Keys
`index`	Unknown	PK
`company_id`	Unknown	PKFK
`date`	Unknown
`score`	Unknown

company_domain

Column	Type	Keys
`index`	Unknown	PK
`company_id`	Unknown	PKFK
`domain`	Unknown

company_tag

Column	Type	Keys
`index`	Unknown	PK
`company_id`	Unknown	PKFK
`tags`	Unknown

company

Column	Type	Keys
`id`	Unknown	PK
`co_owner`	Unknown	FK
`owner`	Unknown	FK
`address`	Unknown
`alerts`	Json
`arr`	Unknown
`arr_total`	Unknown
`auto_renew`	Unknown
`city`	Unknown
`collaborators`	Json
`country`	Unknown
`create_date`	Unknown
`created_at`	Unknown
`csm_score`	Unknown
`customer_from`	Unknown
`customer_to`	Unknown
`days_in_phase`	Unknown
`description`	Unknown
`documents`	Json
`external_id`	Unknown
`features`	Json
`followers`	Json
`h`	Unknown
`h_diff`	Unknown
`h_diff_date`	Unknown
`h_profile`	Unknown
`head_id`	Unknown
`last_performed_triggers`	Json
`last_renewal`	Unknown
`last_touch`	Unknown
`last_touch_by_type_catch_up`	Unknown
`last_touch_by_type_delivery_review`	Unknown
`last_touch_by_type_email`	Unknown
`last_touch_by_type_sales_handover`	Unknown
`last_touch_by_type_training`	Unknown
`last_touch_type`	Unknown
`last_updated`	Unknown
`licenses`	Json
`links`	Json
`mr`	Unknown
`mr_total`	Unknown
`mrr`	Unknown
`mrr_total`	Unknown
`name`	Unknown
`next_touch`	Unknown
`nrr_30`	Unknown
`nrr_total`	Unknown
`org_arr`	Unknown
`org_arr_total`	Unknown
`org_health_total`	Unknown
`org_level`	Unknown
`org_mrr`	Unknown
`org_mrr_total`	Unknown
`org_path`	Unknown
`org_root_id`	Unknown
`org_unit`	Unknown
`phase`	Unknown
`phase_since`	Unknown
`phone_primary`	Unknown
`products`	Json
`renewal_arr`	Unknown
`renewal_date`	Unknown
`renewal_days_from_now`	Unknown
`renewal_mrr`	Unknown
`sales`	Json
`shareable_enabled`	Unknown
`shareable_eu_ids`	Json
`shareable_sunits`	Unknown
`shareable_teams_fields`	Json
`slug`	Unknown
`source_id`	Unknown
`status`	Unknown
`sunits`	Json
`updated_at`	Instant
`usage`	Json
`web`	Unknown
`zip`	Unknown
`custom_`

conversation_user

Column	Type	Keys
`index`	Unknown	PK
`conversation_id`	Unknown	PKFK
`user_id`	Unknown	FK
`is_owner`	Unknown

conversation_end_user

Column	Type	Keys
`index`	Unknown	PK
`conversation_id`	Unknown	PKFK
`end_user_id`	Unknown	FK

conversation_time_bucket

Column	Type	Keys
`index`	Unknown	PK
`conversation_id`	Unknown	PKFK
`time_bucket`	Unknown

conversation_document

Column	Type	Keys
`index`	Unknown	PK
`conversation_id`	Unknown	PKFK
`document`	Unknown

conversation

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	FK
`task_id`	Unknown	FK
`activity_tags`	Json
`archived`	Unknown
`assignee_name`	Unknown
`auto_tags`	Json
`create_date`	Unknown
`created_at`	Unknown
`date`	Unknown
`day`	Unknown
`description`	Unknown
`email_template_ids`	Json
`followers`	Json
`has_attachment`	Unknown
`has_more`	Unknown
`history`	Unknown
`is_custom_type`	Unknown
`is_open`	Unknown
`is_seen`	Unknown
`number_of_part`	Unknown
`number_of_relevant_part`	Unknown
`out_date`	Unknown
`pinned`	Unknown
`sender`	Unknown
`snippet`	Unknown
`source`	Unknown
`starred`	Unknown
`subject`	Unknown
`tags`	Json
`type`	Unknown
`updated_at`	Instant
`waits_to_be_filtered`	Unknown
`custom_`

issue_company

Column	Type	Keys
`company_id`	Unknown	PKFK
`issue_id`	Unknown	PKFK

issue_end_user

Column	Type	Keys
`end_user_id`	Unknown	PKFK
`issue_id`	Unknown	PKFK

issue_conversation

Column	Type	Keys
`conversation_id`	Unknown	PKFK
`issue_id`	Unknown	PKFK

issue

Column	Type	Keys
`id`	Unknown	PK
`archived`	Unknown
`arr_combined`	Unknown
`company_matching_value`	Json
`created_at`	Unknown
`description`	Unknown
`mrr_combined`	Unknown
`source_id`	Unknown
`status`	Unknown
`title`	Unknown
`updated_at`	Instant
`custom_`

ticket_history

Column	Type	Keys
`index`	Unknown	PK
`ticket_id`	Unknown	PKFK
`status`	Unknown
`time`	Unknown

ticket_time_bucket

Column	Type	Keys
`index`	Unknown	PK
`ticket_id`	Unknown	PKFK
`time_bucket`	Unknown

ticket_end_user

Column	Type	Keys
`end_user_id`	Unknown	PKFK
`ticket_id`	Unknown	PKFK

ticket

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	FK
`activity_tags`	Json
`archived`	Unknown
`company_external_id`	Unknown
`create_date`	Unknown
`date`	Unknown
`days`	Unknown
`description`	Unknown
`domains`	Json
`email`	Unknown
`email_template_ids`	Json
`external_id`	Unknown
`in_date`	Unknown
`is_open`	Unknown
`pinned`	Unknown
`product`	Unknown
`sender`	Json
`severity`	Unknown
`snippet`	Unknown
`source`	Unknown
`source_id`	Unknown
`starred`	Unknown
`status`	Unknown
`sub_type`	Unknown
`subject`	Unknown
`tags`	Json
`time_spent`	Unknown
`title`	Unknown
`type`	Unknown
`update_date`	Instant
`url`	Unknown
`users`	Json
`waits_to_be_filtered`	Unknown
`custom_`

opportunity_stage_history

Column	Type	Keys
`index`	Unknown	PK
`opportunity_id`	Unknown	PKFK
`stage`	Unknown
`tos`	Unknown

opportunity

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	FK
`owner_id`	Unknown	FK
`arr`	Unknown
`close_date`	Unknown
`contract_length`	Unknown
`created_at`	Unknown
`currency`	Unknown
`deal_date`	Unknown
`external_id`	Unknown
`followers`	Json
`landing_date`	Unknown
`last_comment`	Unknown
`mrr`	Unknown
`nrr`	Unknown
`probability`	Unknown
`sales_stage`	Unknown
`source_id`	Unknown
`status`	Unknown
`title`	Unknown
`updated_at`	Instant
`custom_`

users_role

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	PKFK
`description`	Unknown
`name`	Unknown

users_poc

Column	Type	Keys
`index`	Unknown	PK
`user_id`	Unknown	PKFK
`poc`	Unknown

users_team

Column	Type	Keys
`team_id`	Unknown	PK
`user_id`	Unknown	PKFK

users_google_api_synced_label

Column	Type	Keys
`index`	Unknown	PK
`user_id`	Unknown	PKFK
`synced_label`	Unknown

users_google_calendar_api_synced_calendar

Column	Type	Keys
`index`	Unknown	PK
`user_id`	Unknown	PKFK
`synced_calendar`	Unknown

users

Column	Type	Keys
`id`	Unknown	PK
`account_access`	Unknown
`apply_permission`	Unknown
`arr`	Unknown
`arr_avg`	Unknown
`calendar_date_scope`	Unknown
`comments_sort`	Unknown
`compressed_view`	Unknown
`create_date`	Unknown
`created_at`	Unknown
`daily_digest`	Unknown
`default_meeting_length`	Unknown
`email`	Unknown
`email_signature_content`	Unknown
`email_signature_enabled`	Unknown
`first_name`	Unknown
`follower_update`	Unknown
`followers`	Json
`google_api_access_enabled`	Unknown
`google_api_sync_enabled`	Unknown
`google_api_sync_initial`	Unknown
`google_api_user_id`	Unknown
`google_calendar_api_access_enabled`	Unknown
`google_calendar_api_calendar_to_save`	Json
`google_calendar_api_sync_enabled`	Unknown
`google_calendar_api_sync_initial`	Unknown
`google_calendar_api_user_id`	Unknown
`health_avg`	Unknown
`health_avg_round`	Unknown
`health_count`	Unknown
`image_path`	Unknown
`image_spaces_key`	Unknown
`in_app_notification`	Unknown
`inactive`	Unknown
`intercom_admin_id`	Unknown
`invoices_sort`	Unknown
`is_exposed_as_sender_option`	Unknown
`is_hidden`	Unknown
`labels`	Json
`last_active_30`	Unknown
`last_active_7`	Unknown
`last_active_90`	Unknown
`last_daily_digest`	Unknown
`last_name`	Unknown
`last_touch_30`	Unknown
`last_touch_7`	Unknown
`last_touch_90`	Unknown
`last_visited_views`	Json
`last_visited_workspaces`	Json
`managers`	Json
`mrr`	Unknown
`mrr_avg`	Unknown
`ms_api_access_enabled`	Unknown
`ms_api_sync_enabled`	Unknown
`ms_api_sync_initial`	Unknown
`ms_api_synced_labels`	Json
`ms_calendar_api_access_enabled`	Unknown
`ms_calendar_api_calendar_to_save`	Json
`ms_calendar_api_sync_enabled`	Unknown
`ms_calendar_api_sync_initial`	Unknown
`ms_calendar_api_synced_calendars`	Json
`nick_name`	Unknown
`notifications_enabled`	Unknown
`nps_avg`	Unknown
`nps_count`	Unknown
`nr_open_task`	Unknown
`nr_overdue_task`	Unknown
`nr_tasks_due_14_day`	Unknown
`nr_tasks_due_30_day`	Unknown
`nr_tasks_due_7_day`	Unknown
`nr_tasks_due_90_day`	Unknown
`paying_customer_count`	Unknown
`permission`	Json
`play_log_disabled`	Unknown
`playlist_section`	Unknown
`preview_modal_width`	Unknown
`radar_one_line`	Unknown
`recent_open_shared_view`	Unknown
`removed`	Unknown
`rev_report_period_type`	Unknown
`revenue_share`	Unknown
`slack_id`	Unknown
`split_layout_disabled`	Unknown
`task_actions_pref_view_mode`	Unknown
`task_filter`	Unknown
`top_bar_pins`	Json
`two_factor_auth_enabled`	Unknown
`type`	Unknown
`tz_offset`	Unknown
`undefined`	Unknown
`updated_at`	Instant
`usage_metrics_from_b_q`	Unknown
`work_spaces_prefs`	Json
`ws_saved_pages`	Json
`custom_`
`table_group_collapsed_`

nps

Column	Type	Keys
`id`	Unknown	PK
`campaign_id`	Unknown	FK
`company_id`	Unknown	FK
`comment`	Unknown
`date`	Instant
`date_answered`	Unknown
`date_reminder_sent`	Unknown
`date_sent`	Unknown
`email`	Unknown
`nps`	Unknown
`nps_id`	Unknown
`score`	Unknown
`score_type`	Unknown
`sent`	Unknown
`source`	Unknown
`source_id`	Unknown
`custom_`

license

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	FK
`arr`	Unknown
`auto_renew`	Unknown
`auto_renewed`	Unknown
`created_at`	Unknown
`currency`	Unknown
`external_id`	Unknown
`fc_new_arr`	Unknown
`fc_new_arr_optimistic`	Unknown
`fc_new_arr_pessimistic`	Unknown
`fc_new_mrr`	Unknown
`fc_new_mrr_pessimistic`	Unknown
`fixed_period`	Unknown
`from_date`	Unknown
`invoice_cycle`	Unknown
`invoice_cycle_interval`	Unknown
`invoice_muted`	Unknown
`is_overdue`	Unknown
`issue`	Unknown
`length`	Unknown
`mrr`	Unknown
`notice_period`	Unknown
`notice_unit`	Unknown
`parent`	Unknown
`product`	Unknown
`renewal_arr`	Unknown
`renewal_date`	Unknown
`renewal_days_from_now`	Unknown
`renewal_mrr`	Unknown
`renewal_period`	Unknown
`renewal_status`	Unknown
`renewal_unit`	Unknown
`source_id`	Unknown
`status`	Unknown
`to_date`	Unknown
`to_date_included`	Unknown
`updated_at`	Instant
`value`	Unknown
`custom_`

sale

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	FK
`currency`	Unknown
`external_id`	Unknown
`product`	Unknown
`sales_date`	Unknown
`source_id`	Unknown
`value`	Unknown
`custom_`

task_end_user

Column	Type	Keys
`end_user_id`	Unknown	PKFK
`task_id`	Unknown	PKFK

task_user

Column	Type	Keys
`task_id`	Unknown	PKFK
`user_id`	Unknown	PKFK

task_activity_tag

Column	Type	Keys
`index`	Unknown	PK
`task_id`	Unknown	PKFK
`activity_tag`	Unknown

task

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	FK
`owner_id`	Unknown	FK
`action`	Unknown
`checklist`	Json
`created_at`	Unknown
`date_done`	Unknown
`description`	Unknown
`done_by`	Unknown
`end_time`	Unknown
`followers`	Json
`i_cal_u_id`	Unknown
`is_archived`	Unknown
`location`	Unknown
`main_type`	Unknown
`no_specific_time`	Unknown
`over_due_notified`	Unknown
`repeat`	Unknown
`repeat_day`	Unknown
`shared`	Unknown
`snippet`	Unknown
`source`	Unknown
`source_id`	Unknown
`source_parent_id`	Unknown
`source_url`	Unknown
`start_time`	Unknown
`status`	Unknown
`updated_at`	Instant
`custom_`

end_user_tag

Column	Type	Keys
`index`	Unknown	PK
`end_user_id`	Unknown	PKFK
`tags`	Unknown

end_user

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	FK
`beat_trend`	Unknown
`beats`	Unknown
`beats_total`	Unknown
`company_external_id`	Unknown
`convs_14`	Unknown
`convs_total`	Unknown
`create_date`	Unknown
`created_at`	Unknown
`description`	Unknown
`email`	Unknown
`email_md_5`	Unknown
`experience`	Unknown
`external_id`	Unknown
`featured`	Unknown
`first_name`	Unknown
`last_active`	Unknown
`last_name`	Unknown
`last_touch`	Unknown
`last_touch_by_type_design_call`	Unknown
`last_touch_by_type_email`	Unknown
`last_touch_by_type_kick_off`	Unknown
`last_touch_by_type_note`	Unknown
`last_touch_by_type_technical_call`	Unknown
`last_touch_by_type_technical_life_lesson`	Unknown
`last_touch_type`	Unknown
`last_updated`	Unknown
`name`	Unknown
`nps_sent`	Unknown
`nps_unsubscribed`	Unknown
`other_emails`	Json
`phone`	Unknown
`position`	Unknown
`related_end_users`	Json
`relevance`	Unknown
`relevance_rate`	Unknown
`shared_notifications_prefs_disabled`	Json
`shared_notifications_prefs_disabled_event`	Json
`shared_notifications_prefs_enabled`	Json
`source_id`	Unknown
`updated_at`	Instant
`custom_`

campaign

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	FK
`external_id`	Unknown
`name`	Unknown
`purpose`	Unknown
`source_id`	Unknown
`custom_`

invoice_line_item

Column	Type	Keys
`id`	Unknown	PK
`invoice_id`	Unknown	PKFK
`license_id`	Unknown	FK
`amount`	Unknown
`date_from`	Unknown
`date_to`	Unknown
`product`	Unknown

invoice

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	FK
`address_country`	Unknown
`amount_due`	Unknown
`amount_paid`	Unknown
`amount_total`	Unknown
`currency`	Unknown
`cycle`	Unknown
`date`	Instant
`due_date`	Unknown
`emails`	Json
`ext_id`	Unknown
`last_updated`	Unknown
`number`	Unknown
`paid_date`	Unknown
`product`	Unknown
`source_id`	Unknown
`status`	Unknown
`custom_`

asset

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	FK
`external_id`	Unknown
`name`	Unknown
`source_id`	Unknown
`custom_`