id 🔑
_fivetran_deleted
property_*
LEAD ⇱
Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
�id 🔑
property_*
CONTACT ⇱
deal_id 🔑�is_deleted�portal_id
deal_pipeline_id ➤ DEAL_PIPELINE
deal_pipeline_stage_id ➤ DEAL_PIPELINE_STAGE
owner_id ➤ OWNER�property_*
DEAL ⇱
category 🔑 ➤ ASSOCIATION_TYPE
company_id 🔑 ➤ COMPANY�deal_id 🔑 ➤ DEAL
type_id 🔑 ➤ ASSOCIATION_TYPE
DEAL_COMPANY ⇱
stage_id 🔑
pipeline_id ➤ DEAL_PIPELINE
active
closed_won
created_at
display_order
label
probability
updated_at
DEAL_PIPELINE_STAGE ⇱
id 🔑�created_at�created_by_id�filters_updated_at�list_version
name
object_type_id�processing_status�processing_type
updated_at
properties_*
CONTACT_LIST ⇱
category 🔑 ➤ ASSOCIATION_TYPE
contact_id 🔑 ➤ CONTACT�deal_id 🔑 ➤ DEAL
type_id 🔑 ➤ ASSOCIATION_TYPE
DEAL_CONTACT ⇱
owner_id 🔑
active_user_id�created_at
first_name
is_active
last_name
updated_at�user_id_including_inactive
OWNER ⇱
contact_id 🔑 ➤ CONTACT�contact_list_id 🔑 ➤ CONTACT_LIST�added_at
CONTACT_LIST_MEMBER ⇱
id 🔑�is_deleted�portal_id
property_*
COMPANY ⇱
deal_id 🔑 ➤ DEAL
_fivetran_start 🔑�name 🔑
timestamp �source
source_id �value
_fivetran_end
_fivetran_active
DEAL_PROPERTY_HISTORY ⇱
category 🔑 ➤ ASSOCIATION_TYPE
deal_id 🔑 ➤ DEAL�engagement_id 🔑 ➤ ENGAGEMENT
engagement_type 🔑 ➤ ENGAGEMENT
type_id 🔑 ➤ ASSOCIATION_TYPE
ENGAGEMENT_DEAL ⇱
pipeline_id 🔑
active
created_at
display_order
label
updated_at
DEAL_PIPELINE ⇱
company_id 🔑 ➤ COMPANY�_fivetran_start 🔑�name 🔑
timestamp �source
source_id�value
_fivetran_end
_fivetran_active
COMPANY_PROPERTY_HISTORY ⇱
contact_id 🔑 ➤ CONTACT�_fivetran_start 🔑�name 🔑
timestamp �source
source_id�value
_fivetran_end
_fivetran_active
CONTACT_PROPERTY_HISTORY ⇱
id 🔑
type 🔑�portal_id
ENGAGEMENT ⇱
category 🔑 ➤ ASSOCIATION_TYPE
company_id 🔑 ➤ COMPANY�engagement_id 🔑 ➤ ENGAGEMENT
engagement_type 🔑 ➤ ENGAGEMENT
type_id 🔑 ➤ ASSOCIATION_TYPE
ENGAGEMENT_COMPANY ⇱
category 🔑 ➤ ASSOCIATION_TYPE
contact_id 🔑 ➤ CONTACT�engagement_id 🔑 ➤ ENGAGEMENT�engagement_type 🔑 ➤ ENGAGEMENT
type_id 🔑 ➤ ASSOCIATION_TYPE
ENGAGEMENT_CONTACT ⇱
engagement_id 🔑 ➤ ENGAGEMENT
type ➤ ENGAGEMENT
_fivetran_deleted
properties_*
ENGAGEMENT_COMMUNICATION ⇱
id 🔑�_fivetran_deleted�portal_id
property_*
PRODUCT ⇱
product_id 🔑 ➤ PRODUCT �_fivetran_start 🔑�name 🔑
timestamp �value�source
source_id
_fivetran_end
_fivetran_active
PRODUCT_PROPERTY_HISTORY ⇱
line_item_id 🔑 ➤ LINE_ITEM �_fivetran_start 🔑�name 🔑
timestamp �value�source
source_id
_fivetran_end
_fivetran_active
LINE_ITEM_PROPERTY_HISTORY ⇱
id 🔑
product_id ➤ PRODUCT�_fivetran_deleted
property_*
LINE_ITEM ⇱
deal_id 🔑 ➤ DEAL�_fivetran_start 🔑
date_entered �value �source
source_id
_fivetran_end
_fivetran_active
DEAL_STAGE ⇱
For calculating `date_entered`, `date_exited` and `time_in` fields for a particular deal_stage refer to our documentation
_fivetran_id 🔑
hubspot_object 🔑
calculated
created_at
description
field_type
group_name
hubspot_defined
label
name
referenced_object_type
show_currency_symbol
type
updated_at
PROPERTY ⇱
label 🔑
property_id 🔑 ➤ PROPERTY
display_order
hidden
value
PROPERTY_OPTION ⇱
This is a metadata table containing property data for the following HubSpot objects:� - company
- contact
- deal
- line_item
- product
- ticket
- quote
Use the system column hubspot_object to track these objects.
category 🔑 ➤ ASSOCIATION_TYPE
from_id 🔑 ➤ CUSTOM_OBJECT
to_id 🔑 ➤ CUSTOM_OBJECT
type_id 🔑 ➤ ASSOCIATION_TYPE
[CUSTOM_OBJECT]_TO_[OBJECT]* ⇱
id 🔑
archived�archived_at�created_at
updated_at�property_*
[CUSTOM_OBJECT]* ⇱
* We create an association table to capture associations from one type of CUSTOM_OBJECT to another type and the same type, as well as associations between CUSTOM_OBJECTS and COMPANY, TICKET, DEAL, CONTACT, ENGAGEMENT, EMAIL, PRODUCT, and LINE_ITEM.
* We create a table for each custom object in customer’s Hubspot account.
owner_id🔑➤ OWNER
team_id 🔑➤ TEAM�is_team_primary
OWNER_TEAM ⇱
id 🔑�name
TEAM ⇱
team_id 🔑➤ TEAM�user_id 🔑 ➤ USER
is_secondary_user
TEAM_USER ⇱
id 🔑�primary_team_id ➤ TEAM�role_id ➤ ROLE
email�first_name�last_name
USERS ⇱
id 🔑
name
requires_billing_write
ROLE ⇱
category 🔑 ➤ ASSOCIATION_TYPE
company_id 🔑 ➤ COMPANY�contact_id 🔑 ➤ CONTACT
type_id 🔑 ➤ ASSOCIATION_TYPE
CONTACT_COMPANY ⇱
id 🔑
category 🔑
from_object_type
label
name
to_object_type
ASSOCIATION_TYPE ⇱
engagement_id 🔑 ➤ ENGAGEMENT
type ➤ ENGAGEMENT
_fivetran_deleted
properties_*
ENGAGEMENT_NOTE ⇱
engagement_id 🔑 ➤ ENGAGEMENT
type ➤ ENGAGEMENT
_fivetran_deleted
properties_*
engagement_id 🔑 ➤ ENGAGEMENT
type ➤ ENGAGEMENT
_fivetran_deleted
properties_*
ENGAGEMENT_EMAIL ⇱
engagement_id 🔑 ➤ ENGAGEMENT
type ➤ ENGAGEMENT
_fivetran_deleted
properties_*
ENGAGEMENT_CALL ⇱
engagement_id 🔑 ➤ ENGAGEMENT
type ➤ ENGAGEMENT
_fivetran_deleted
properties_*
ENGAGEMENT_POSTAL_MAIL ⇱
engagement_id 🔑 ➤ ENGAGEMENT
type ➤ ENGAGEMENT
_fivetran_deleted
properties_*
ENGAGEMENT_TASK ⇱
category 🔑 ➤ ASSOCIATION_TYPE
line_item_id 🔑 ➤ LINE_ITEM�deal_id 🔑 ➤ DEAL
type_id 🔑 ➤ ASSOCIATION_TYPE
LINE_ITEM_DEAL ⇱
id 🔑
is_deleted
property_*
QUOTE ⇱
quote_id 🔑 ➤ QUOTE�_fivetran_start 🔑�name 🔑
timestamp �value�source
source_id
_fivetran_end
_fivetran_active
QUOTE_PROPERTY_HISTORY ⇱
category 🔑 ➤ ASSOCIATION_TYPE
quote_id🔑 ➤ QUOTE�deal_id🔑 ➤ DEAL
type_id 🔑 ➤ ASSOCIATION_TYPE
QUOTE_DEAL ⇱
category 🔑 ➤ ASSOCIATION_TYPE
quote🔑 ➤ QUOTE�line_item_id🔑 ➤ LINE_ITEM
type_id 🔑 ➤ ASSOCIATION_TYPE
QUOTE_LINE_ITEM ⇱
category 🔑 ➤ ASSOCIATION_TYPE
company_id 🔑 ➤ COMPANY�quote_id🔑 ➤ QUOTE
type_id 🔑 ➤ ASSOCIATION_TYPE
QUOTE_COMPANY ⇱
category 🔑 ➤ ASSOCIATION_TYPE
quote_id🔑 ➤ QUOTE�contact_id🔑 ➤ CONTACT
type_id 🔑 ➤ ASSOCIATION_TYPE
QUOTE_CONTACT ⇱
id 🔑
type 🔑
object_id
object_type�occurred_at
property_*
EVENT ⇱
object_id and object_type refer to the corresponding CRM object.
from_company_id 🔑 ➤ COMPANY�to_company_id 🔑 ➤ COMPANY
type_id 🔑 ➤ ASSOCIATION_TYPE
category 🔑 ➤ ASSOCIATION_TYPE
COMPANY_COMPANY ⇱
category 🔑 ➤ ASSOCIATION_TYPE
from_contact_id 🔑 ➤ CONTACT�to_contact_id 🔑 ➤ CONTACT
type_id 🔑 ➤ ASSOCIATION_TYPE
CONTACT_CONTACT ⇱
category 🔑 ➤ ASSOCIATION_TYPE
from_deal_id 🔑 ➤ DEAL�to_deal_id 🔑 ➤ DEAL
type_id 🔑 ➤ ASSOCIATION_TYPE
DEAL_DEAL ⇱
id 🔑�archived
created_at
display_order
label
updated_at
LEAD_PIPELINE ⇱
id 🔑
pipeline_id ➤ LEAD_PIPELINE
archived
created_at
display_order
is_closed
label
lead_state
updated_at
write_permissions
LEAD_PIPELINE_STAGE ⇱
lead_id 🔑 ➤ LEAD
comapny_id 🔑 ➤ COMPANY�type_id🔑 ➤ ASSOCIATION_TYPE
category🔑
LEAD _COMPANY ⇱
lead_id 🔑 ➤ LEAD�name 🔑
_fivetran_start 🔑�timestamp
source
source_id�value
_fivetran_end
_fivetran_active
LEAD_PROPERTY_HISTORY ⇱
category 🔑 ➤ ASSOCIATION_TYPE
lead_id 🔑 ➤ LEAD
engagement_id 🔑 ➤ ENGAGEMENT
engagement_type 🔑 ➤ ENGAGEMENT
type_id ➤ ASSOCIATION_TYPE
ENGAGEMENT_LEAD ⇱
deal_id 🔑 ➤ DEAL
merged_deal_id 🔑 ➤ DEAL
MERGED_DEAL ⇱
lead_id 🔑 ➤ LEAD
contact_id 🔑 ➤ CONTACT�type_id🔑 ➤ ASSOCIATION_TYPE�category🔑
LEAD _CONTACT ⇱
id 🔑
type🔑 �created_at�created_user_id�combo_event_rules
description�labels_singular�labels_plural
name�object_type_id*�
CUSTOM_EVENT_DEFINITION ⇱
id 🔑
type 🔑 ➤ CUSTOM_EVENT_DEFINITION
object_id
object_type�occurred_at
property_*
CUSTOM_EVENT ⇱
custom_event_definition_id 🔑➤ CUSTOM_EVENT_DEFINITION
name 🔑
calculated
created_at
created_user_id
data_sensitivity
description
display_order
external_options
field_type
form_field
group_name
has_unique_value
hidden
label
type
updated_at
updated_user_id
modification_metadata_*
CUSTOM_EVENT_DEFINITION_PROPERTY ⇱
custom_event_definition_id 🔑➤ CUSTOM_EVENT_DEFINITION
id 🔑 �allows_custom_labels
cardinality
category
from_object_type
from_object_type_id
has_all_associated_objects
has_cascading_deletes
has_user_enforced_max_from_object_ids
has_user_enforced_max_to_object_ids
is_inverse_primary
is_primary
label
max_from_object_ids
max_to_object_ids
name
portal_unique_identifier
to_object_type
to_object_type_id
inverse_*
CUSTOM_EVENT_DEFINITION_ASSOCIATION ⇱
��custom_event_definition_id 🔑➤ CUSTOM_EVENT_DEFINITION�label 🔑
property_name 🔑 ➤ CUSTOM_EVENT_DEFINITION_PROPERTY_HISTORY
description
display_order
hidden
value
CUSTOM_EVENT_DEFINITION_PROPERTY_OPTION ⇱
id 🔑 ➤ [CUSTOM_OBJECT]
_fivetran_start 🔑�name 🔑
source
source_id
timestamp
value
_fivetran_active
_fivetran_end
[CUSTOM_OBJECT]_PROPERTY_HISTORY* ⇱
id 🔑�created_at�created_by_id�filters_updated_at�list_version
name
object_type_id�processing_status�processing_type
updated_at
properties_*
COMPANY_LIST ⇱
company_id 🔑 ➤ COMPANY�company_list_id 🔑 ➤ COMPANY_LIST�added_at
COMPANY_LIST_MEMBER ⇱