HubSpot schema and ERD

47 tables

Loading diagram…

call

company

contact

course

deal

engagement

feedback_submissions

leads

line_item

owner

pipeline

submission

team

ticket

account_details

account_type

string

additional_currencies

array

company_currency

string

data_hosting_location

string

portal_id

long

time_zone

string

ui_domain

string

utc_offset

string

utc_offset_milliseconds

long

_weld_synced

date

audit_log

string

category

string

sub_category

string

action

string

target_object_id

string

occurred_at

date

acting_user_user_id

double

acting_user_user_email

string

_weld_synced

date

call_dispositions

string

label

string

_weld_synced

date

call

105

call_id

string

created_at

date

updated_at

date

archived

boolean

archived_at

date

object_write_trace_id

string

properties_hs_activity_type

string

properties_hs_all_accessible_team_ids

string

properties_hs_all_assigned_business_unit_ids

string

call_association

from_id

string

to_id

string

to_object_type

string

type_id

string

category

string

label

string

_weld_synced

date

company

134

company_id

long

properties_about_us

string

properties_closedate_timestamp_earliest_value_a_2_a_17_e_6_e

date

properties_facebookfans

double

properties_first_contact_createdate_timestamp_earliest_value_78_b_50_eea

date

properties_first_conversion_date

date

properties_first_conversion_date_timestamp_earliest_value_61_f_58_f_2_c

date

properties_first_conversion_event_name

string

properties_first_conversion_event_name_timestamp_earliest_value_68_ddae_0_a

date

company_association

from_id

string

to_id

string

to_object_type

string

type_id

string

category

string

label

string

_weld_synced

date

company_property_history

company_id

long

property

string

value

string

timestamp

date

source_type

string

updated_by_user_id

string

_weld_synced

date

contact_property_history

contact_id

long

property

string

value

string

timestamp

date

source_type

string

updated_by_user_id

string

_weld_synced

date

contact

244

contact_id

long

properties_company_size

string

properties_date_of_birth

string

properties_days_to_close

double

properties_degree

string

properties_field_of_study

string

properties_first_conversion_date

date

properties_first_conversion_event_name

string

properties_first_deal_created_date

date

contact_association

from_id

string

to_id

string

to_object_type

string

type_id

string

category

string

label

string

_weld_synced

date

conversation

conversation_id

string

conversations_thread_id

string

created_at

date

created_by

string

updated_at

date

text

string

rich_text

string

senders

string

recipients

string

course

course_id

string

properties_hs_all_accessible_team_ids

string

properties_hs_all_assigned_business_unit_ids

string

properties_hs_all_owner_ids

string

properties_hs_all_team_ids

string

properties_hs_course_description

string

properties_hs_course_id

string

properties_hs_course_name

string

properties_hs_created_by_user_id

string

course_association

from_id

string

to_id

string

to_object_type

string

type_id

string

category

string

label

string

_weld_synced

date

deal_property_history

deal_id

long

property

string

value

string

timestamp

date

source_type

string

updated_by_user_id

string

_weld_synced

date

deal

deal_id

long

properties_amount

double

properties_amount_in_home_currency

double

properties_closed_lost_reason

string

properties_closed_won_reason

string

properties_closedate

date

properties_createdate

date

properties_days_to_close

string

properties_deal_currency_code

string

deal_association

from_id

string

to_id

string

to_object_type

string

type_id

string

category

string

label

string

_weld_synced

date

email_event

email_event_id

string

app_name

string

drop_message

string

drop_reason

string

attempt

double

created

date

recipient

string

sent_by_id

string

sent_by_created

date

engagement

engagement_id

long

owner_id

int

portal_id

int

active

boolean

gdpr_deleted

boolean

created_by

string

created_at

date

last_updated

date

modified_by

int

type

string

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

_weld_synced

date

feedback_submissions

feedback_submissions_id

long

properties_hs_createdate

date

properties_hs_lastmodifieddate

date

properties_hs_object_id

long

created_at

date

updated_at

date

archived

boolean

_weld_synced

date

feedback_submission_association

from_id

string

to_id

string

to_object_type

string

type_id

string

category

string

label

string

_weld_synced

date

form

portal_id

double

guid

string

name

string

action

string

method

string

css_class

string

redirect

string

submit_text

string

leads

leads_id

string

properties_hs_all_accessible_team_ids

string

properties_hs_all_assigned_business_unit_ids

string

properties_hs_all_owner_ids

string

properties_hs_all_team_ids

string

properties_hs_created_by_user_id

string

properties_hs_createdate

date

properties_hs_last_activity_date

date

properties_hs_lastmodifieddate

date

lead_association

from_id

string

to_id

string

to_object_type

string

type_id

string

category

string

label

string

_weld_synced

date

line_item_property_history

line_item_id

long

property

string

value

string

timestamp

date

source_type

string

updated_by_user_id

string

_weld_synced

date

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_amount

double

properties_createdate

date

properties_description

string

properties_discount

double

properties_hs_acv

double

properties_hs_all_accessible_team_ids

string

properties_hs_all_assigned_business_unit_ids

string

properties_hs_arr

double

line_item_association

from_id

string

to_id

string

to_object_type

string

type_id

string

category

string

label

string

_weld_synced

date

list

list_id

double

list_version

double

created_at

date

updated_at

date

filters_updated_at

date

processing_status

string

created_by_id

double

updated_by_id

double

processing_type

string

marketing_email_v3

marketing_email_id

string

active_domain

string

all_email_campaign_ids

string

archived

boolean

business_unit_id

string

content_template_path

string

content_widgets_primary_rich_text_module_body_html

string

content_widgets_preview_text_body_value

string

owner

owner_id

string

user_id

int

string

first_name

string

last_name

string

created_at

date

updated_at

date

archived

boolean

_weld_synced

date

owner_team

team_id

long

owner_id

long

name

string

primary

boolean

_weld_synced

date

pipeline

pipeline_id

string

label

string

display_order

int

type

enum

stages

string

created_at

date

updated_at

date

archived

boolean

_weld_synced

date

pipeline_stage

pipeline_id

string

stage_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

_weld_synced

date

product_property_history

product_id

long

property

string

value

string

timestamp

date

source_type

string

updated_by_user_id

string

_weld_synced

date

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_all_accessible_team_ids

long

properties_hs_all_assigned_business_unit_ids

long

properties_hs_all_owner_ids

long

properties_hs_all_team_ids

long

properties_hs_avatar_filemanager_key

string

properties_hs_cost_of_goods_sold

double

properties_hs_createdate

date

properties_hs_discount_percentage

double

property

group_name

string

object_type

string

hidden

boolean

hubspot_defined

boolean

show_currency_symbol

boolean

modification_metadata

string

name

string

display_order

int

submission

form_guid

string

conversion_id

string

submitted_at

date

page_url

string

_weld_synced

date

submission_value

form_guid

string

conversion_id

string

name

string

object_type_id

string

value

string

_weld_synced

date

subscription

subscription_id

long

portal_id

long

active

boolean

description

string

name

string

_weld_synced

date

subscription_change

subscription_id

long

normalized_email_id

string

timestamp

date

change

string

change_type

string

caused_by_event_id

string

portal_id

long

recipient

string

_weld_synced

date

team

team_id

string

name

string

_weld_synced

date

team_user

team_id

string

user_id

string

is_secondary_user

boolean

_weld_synced

date

ticket_property_history

tickets_id

long

property

string

value

string

timestamp

date

source_type

string

updated_by_user_id

string

_weld_synced

date

ticket

ticket_id

long

properties_closed_date

date

properties_created_by

double

properties_createdate

date

properties_first_agent_reply_date

date

properties_hs_all_assigned_business_unit_ids

string

properties_hs_conversations_originating_message_id

string

properties_hs_conversations_originating_thread_id

double

properties_hs_created_by_user_id

double

ticket_association

from_id

string

to_id

string

to_object_type

string

type_id

string

category

string

label

string

_weld_synced

date

user

user_id

string

role_id

string

primary_team_id

string

secondary_team_ids

string

super_admin

boolean

archived

boolean

_weld_synced

date