Tables
ERD
61 tables
Expand all
Collapse all
pipeline
8 columns
pipeline_stages
11 columns
order
5 columns
order_contact
3 columns
office
5 columns
office_company
3 columns
office_licence
3 columns
office_contact
3 columns
office_deal
3 columns
office_ticket
3 columns
ticket
5 columns
ticket_contact
3 columns
ticket_company
3 columns
ticket_deal
3 columns
ticket_engagement
3 columns
engagement
25 columns
engagement_meeting
10 columns
deal
5 columns
deal_company
3 columns
deal_contact
3 columns
deal_engagement
3 columns
deal_line_item
3 columns
deal_ticket
3 columns
owner
8 columns
teams
4 columns
service_subscription
5 columns
service_subscription_contact
3 columns
line_item
17 columns
line_item_deal
3 columns
delivery_address
5 columns
delivery_address_company
3 columns
licence
5 columns
licence_office
3 columns
licence_company
3 columns
licence_deal
3 columns
licence_contact
3 columns
company
5 columns
company_deal
3 columns
company_company
3 columns
company_contact
3 columns
company_engagement
3 columns
company_ticket
3 columns
contact
4 columns
contact_company
3 columns
contact_deal
3 columns
contact_engagement
3 columns
subscription_change
8 columns
email_event
39 columns
form
47 columns
property
24 columns
line_item_property_history
6 columns
contact_list
24 columns
ticket_property_history
6 columns
marketing_email
101 columns
contact_property_history
6 columns
subscription
5 columns
deal_property_history
6 columns
product_property_history
6 columns
form_submission
10 columns
company_property_history
6 columns
product
23 columns
Loading diagram…
pipeline
pipeline
pipeline_id
string
label
string
display_order
int
type
enum
stages
string
created_at
date
updated_at
date
archived
boolean
pipeline_stages
stage_id
string
pipeline_id
string
label
string
display_order
int
metadata_isClosed
boolean
metadata_ticketState
string
metadata_probability
double
created_at
date
updated_at
date
archived
boolean
internal_write_only
boolean
order
order
order_id
long
created_at
date
updated_at
date
archived
boolean
properties_*
string
order_contact
order_id
long
contact_id
long
type
string
office
office
office_id
long
created_at
date
updated_at
date
archived
boolean
properties_*
string
office_company
office_id
long
company_id
long
type
string
office_licence
office_id
long
licence_id
long
type
string
office_contact
office_id
long
contact_id
long
type
string
office_deal
office_id
long
deal_id
long
type
string
office_ticket
office_id
long
ticket_id
long
type
string
ticket
ticket
ticket_id
long
created_at
long
updated_at
long
archived
boolean
properties_*
string
ticket_contact
contact_id
long
ticket_id
long
type
string
ticket_company
company_id
long
ticket_id
long
type
string
ticket_deal
deal_id
long
ticket_id
long
type
string
ticket_engagement
ticket_id
long
engagement_id
long
type
string
engagement
engagement
engagement_id
long
portal_id
int
owner_id
int
active
boolean
gdpr_deleted
boolean
created_by
date
last_updated
date
modified_by
int
type
string
uid
string
activity_type
string
timestamp
date
body_preview
string
body_preview_html
string
body_preview_is_truncated
boolean
metadata
string
all_accessible_team_ids
array
queue_membership_ids
array
contact_ids
array
company_ids
array
deal_ids
array
workflow_ids
array
ticket_ids
array
content_ids
array
quote_ids
array
engagement_meeting
engagement_id
long
body
string
start_time
date
end_time
date
title
string
internal_meeting_notes
string
attendee_owner_ids
string
meeting_outcome
string
pre_meeting_prospect_reminders
string
source
string
deal
deal
deal_id
long
properties_*
string
created_at
long
updated_at
long
archived
boolean
deal_company
deal_id
long
company_id
long
type
string
deal_contact
contact_id
long
deal_id
long
type
string
deal_engagement
deal_id
long
engagement_id
long
type
string
deal_line_item
deal_id
long
line_item_id
long
type
string
deal_ticket
deal_id
long
ticket_id
long
type
string
owner
owner
owner_id
string
user_id
int
email
string
first_name
string
last_name
string
created_at
date
updated_at
date
archived
boolean
teams
team_id
long
owner_id
long
name
string
primary
boolean
service_subscription
service_subscription
service_subscription_id
long
created_at
date
updated_at
date
archived
boolean
properties_*
string
service_subscription_contact
service_subscription_id
long
contact_id
long
type
string
line_item
line_item
line_item_id
long
properties_hs_created_by_user_id
long
properties_hs_external_id
long
properties_hs_object_id
long
properties_hs_product_id
long
properties_hs_updated_by_user_id
long
properties_hs_variant_id
long
properties_hs_object_source_id
string
properties_hs_object_source_user_id
double
properties_hubspot_owner_id
string
properties_hubspot_team_id
string
properties_ip_sync_extension_external_source_account_id
string
properties_ip_sync_extension_external_source_app_id
string
created_at
date
updated_at
date
archived
boolean
properties_*
string
line_item_deal
deal_id
long
line_item_id
long
type
string
delivery_address
delivery_address
delivery_address_id
long
created_at
long
updated_at
long
archived
boolean
properties_*
string
delivery_address_company
delivery_address_id
long
company_id
long
type
string
licence
licence
licence_id
long
created_at
date
updated_at
date
archived
boolean
properties_*
string
licence_office
licence_id
long
office_id
long
type
string
licence_company
licence_id
long
company_id
long
type
string
licence_deal
licence_id
long
deal_id
long
type
string
licence_contact
licence_id
long
contact_id
long
type
string
company
company
company_id
long
created_at
long
updated_at
long
archived
boolean
properties_*
string
company_deal
deal_id
long
company_id
long
type
string
company_company
parent_id
long
child_id
long
type
string
company_contact
company_id
long
contact_id
long
type
string
company_engagement
company_id
long
engagement_id
long
type
string
company_ticket
company_id
long
ticket_id
long
type
string
contact
contact
contact_id
long
created_at
long
updated_at
long
properties_*
string
contact_company
company_id
long
contact_id
long
type
string
contact_deal
contact_id
long
deal_id
long
type
string
contact_engagement
contact_id
long
engagement_id
long
type
string
subscription_change
portal_id
long
subscription_id
long
normalized_email_id
string
caused_by_event_id
string
timestamp
date
recipient
string
change
string
change_type
string
email_event
email_event_id
string
sent_by_id
string
smtp_id
string
portal_id
string
app_id
string
email_campaign_id
string
email_campaign_group_id
string
obsoleted_by_id
string
app_name
string
drop_message
string
drop_reason
string
attempt
double
created
date
recipient
string
sent_by_created
date
type
string
response
string
category
string
status
string
obsoleted_by_created
date
subject
string
cc
string
bcc
string
reply_to
string
from
string
browser_name
string
browser_family
string
browser_producer
string
browser_producer_url
string
browser_type
string
browser_url
string
browser_version
string
device_type
string
duration
double
user_agent
string
location_country
string
location_state
string
location_city
string
filtered_event
boolean
form
portal_id
double
follow_up_id
string
lead_nurturing_campaign_id
string
tms_id
string
parent_id
double
kickback_email_workflow_id
double
business_unit_id
double
guid
string
name
string
action
string
method
string
css_class
string
redirect
string
submit_text
string
notify_recipients
string
form_field_groups
string
created_at
double
updated_at
double
performable_html
string
migrated_from
string
ignore_current_values
boolean
deletable
boolean
inline_message
string
captcha_enabled
boolean
campaign_guid
string
cloneable
boolean
editable
boolean
form_type
string
deleted_at
double
theme_name
string
style
string
is_published
boolean
publish_at
double
unpublish_at
double
published_at
double
kickback_emails_json
string
custom_uid
string
create_marketable_contact
boolean
edit_version
double
thank_you_message_json
string
theme_color
string
always_create_new_company
boolean
internal_updated_at
double
portable_key
string
payment_session_template_ids
string
selected_external_options
string
meta_data
string
property
created_user_id
string
updated_user_id
string
group_name
string
object_type
string
hidden
boolean
hubspot_defined
boolean
show_currency_symbol
boolean
modification_metadata
string
name
string
display_order
int
options
string
label
string
has_unique_value
boolean
type
string
field_type
string
description
string
referenced_object_type
string
calculated
boolean
external_options
boolean
form_field
boolean
created_at
date
updated_at
date
archived_at
date
archived
boolean
line_item_property_history
line_item_id
long
updated_by_user_id
string
property
string
value
string
timestamp
date
source_type
string
contact_list
portal_id
double
list_id
double
internal_list_id
double
author_id
double
meta_data_parent_folder_id
string
created_at
date
updated_at
date
name
string
list_type
string
filters
string
meta_data_size
double
meta_data_last_size_change_at
date
meta_data_processing
string
meta_data_last_processing_state_change_at
date
meta_data_error
string
meta_data_list_references_count
string
archived
boolean
team_ids
string
dynamic
boolean
description
string
ils_filter_branch
string
internal
boolean
limit_exempt
boolean
deleteable
boolean
ticket_property_history
tickets_id
long
updated_by_user_id
string
property
string
value
string
timestamp
date
source_type
string
marketing_email
marketing_email_id
double
analytics_page_id
double
can_spam_settings_id
double
category_id
double
created_by_id
double
email_campaign_group_id
double
feedback_survey_id
string
portal_id
double
primary_email_campaign_id
double
published_by_id
double
updated_by_id
double
last_edit_session_id
double
last_edit_update_id
double
ab
boolean
ab_hours_to_wait
double
ab_sample_size_default
string
ab_sampling_default
string
ab_success_metric
string
ab_test_percentage
double
ab_variation
boolean
absolute_url
string
all_email_campaign_ids
string
analytics_page_type
string
archived
boolean
archived_in_dashboard
boolean
audience_access
string
author
string
author_name
string
blog_rss_settings
string
content_access_rule_ids
string
content_access_rule_types
string
content_type_category
double
create_page
boolean
created
double
current_state
string
currently_published
boolean
custom_reply_to
string
custom_reply_to_enabled
boolean
domain
string
email_body
string
email_note
string
email_template_mode
string
email_type
string
freeze_date
double
from_name
string
has_content_access_rules
boolean
html_title
string
is_graymail_suppression_enabled
boolean
is_published
boolean
is_recipient_fatigue_suppression_enabled
boolean
language
string
layout_sections
string
live_domain
string
mailing_lists_excluded
string
mailing_lists_included
string
max_rss_entries
double
meta_description
string
name
string
page_expiry_enabled
boolean
page_redirected
boolean
past_mab_experiment_ids
string
preview_key
string
primary_rich_text_module_html
string
processing_status
string
publish_date
double
published_at
double
published_by_email
string
published_by_name
string
published_url
string
reply_to
string
resolved_domain
string
rss_email_by_text
string
rss_email_click_through_text
string
rss_email_comment_text
string
rss_email_entry_template_enabled
boolean
rss_email_image_max_width
double
rss_email_url
string
scrubs_subscription_links
boolean
sections
string
security_state
string
slug
string
smart_email_fields
string
state
string
subcategory
string
subject
string
subscription
double
subscription_name
string
team_perms
string
template_path
string
transactional
boolean
translations
string
unpublished_at
double
updated
double
url
string
use_rss_headline_as_subject
boolean
user_perms
string
vids_excluded
string
vids_included
string
visible_to_all
boolean
emailbody_plaintext
string
publish_immediately
boolean
contact_property_history
contact_id
long
updated_by_user_id
string
property
string
value
string
timestamp
date
source_type
string
subscription
subscription_id
long
portal_id
long
active
boolean
description
string
name
string
deal_property_history
deal_id
long
updated_by_user_id
string
property
string
value
string
timestamp
date
source_type
string
product_property_history
product_id
long
updated_by_user_id
string
property
string
value
string
timestamp
date
source_type
string
form_submission
form_id
string
conversion_id
string
contact_id
long
portal_id
long
timestamp
date
page_url
string
page_title
string
title
string
form_type
string
meta_data
string
company_property_history
company_id
long
updated_by_user_id
string
property
string
value
string
timestamp
date
source_type
string
product
product_id
long
properties_hs_created_by_user_id
long
properties_hs_folder_id
long
properties_hs_object_id
long
properties_hs_updated_by_user_id
long
properties_hubspot_owner_id
string
properties_hubspot_team_id
string
properties_hs_object_source_id
string
properties_hs_object_source_user_id
double
properties_product_id
string
properties_amount
double
properties_createdate
date
properties_description
string
properties_discount
double
properties_hubspot_owner_assigneddate
string
properties_name
string
properties_price
double
properties_quantity
string
properties_recurringbillingfrequency
string
properties_tax
string
created_at
date
updated_at
date
archived
boolean
Table
Sub table
Press enter or space to select a node. You can then use the arrow keys to move the node around. Press delete to remove it and escape to cancel.
Press enter or space to select an edge. You can then press delete to remove it or escape to cancel.