HubSpot

Explore the interactive ERD

Table & Field Reference

order_quote

Column	Type	Keys
`category`	String	PKFK
`order_id`	Long	PKFK
`quote_id`	Long	PKFK
`type_id`	Long	PKFK

owner

Column	Type	Keys
`owner_id`	Long	PK
`active_user_id`	Long
`created_at`	Instant
`email`	String
`first_name`	String
`is_active`	Boolean
`last_name`	String
`updated_at`	Instant
`user_id_including_inactive`	Long

marketing_event

Column	Type	Keys
`id`	Long	PK
`app_id`	String
`app_name`	String
`attendees`	Long
`cancellations`	Long
`created_at`	Instant
`end_date_time`	Instant
`event_cancelled`	Boolean
`event_completed`	Boolean
`event_description`	String
`event_name`	String
`event_organizer`	String
`event_status`	String
`event_type`	String
`event_url`	String
`external_event_id`	String
`no_shows`	Long
`registrants`	Long
`start_date_time`	Instant
`updated_at`	Instant

payment_company

Column	Type	Keys
`category`	String	PKFK
`company_id`	Long	PKFK
`payment_id`	Long	PKFK
`type_id`	Long	PKFK

subscription_invoice

Column	Type	Keys
`category`	String	PKFK
`invoice_id`	Long	PKFK
`subscription_id`	Long	PKFK
`type_id`	Long	PKFK

deal_property_history

Column	Type	Keys
`name`	String	PK
`deal_id`	Long	PKFK
`source`	String
`source_id`	String
`timestamp`	Instant
`value`	String

company_list_member

Column	Type	Keys
`company_id`	Long	PKFK
`company_list_id`	Long	PKFK
`added_at`	Instant

marketing_campaign_contact

Column	Type	Keys
`contact_type`	String	PK
`campaign_id`	String	PKFK
`contact_id`	String	PKFK

service_deal

Column	Type	Keys
`category`	String	PKFK
`deal_id`	Long	PKFK
`service_id`	Long	PKFK
`type_id`	Long	PKFK

order_deal

Column	Type	Keys
`category`	String	PKFK
`deal_id`	Long	PKFK
`order_id`	Long	PKFK
`type_id`	Long	PKFK

order_pipeline_stage

Column	Type	Keys
`id`	String	PK
`pipeline_id`	String	FK
`archived`	Boolean
`created_at`	Instant
`display_order`	Int
`is_closed`	Boolean
`label`	String
`updated_at`	Instant
`write_permissions`	String

order_ticket

Column	Type	Keys
`category`	String	PKFK
`order_id`	Long	PKFK
`ticket_id`	Long	PKFK
`type_id`	Long	PKFK

activity_login

Column	Type	Keys
`id`	String	PK
`user_id`	Long	FK
`country_code`	String
`email`	String
`ip_address`	String
`location`	String
`login_at`	Instant
`login_succeeded`	Boolean
`region_code`	String
`user_agent`	String

discount_quote

Column	Type	Keys
`category`	String	PKFK
`discount_id`	Long	PKFK
`quote_id`	Long	PKFK
`type_id`	Long	PKFK

feedback_submission

Column	Type	Keys
`id`	Long	PK

payment

Column	Type	Keys
`id`	Long	PK

subscription_deal

Column	Type	Keys
`category`	String	PKFK
`deal_id`	Long	PKFK
`subscription_id`	Long	PKFK
`type_id`	Long	PKFK

email_event_suppressed

Column	Type	Keys
`id`	String	PKFK
`bcc`	Json
`cc`	Json
`email_campaign_group_id`	String
`from`	String
`reply_to`	Json
`subject`	String

order_engagement

Column	Type	Keys
`category`	String	PKFK
`engagement_id`	Long	PKFK
`engagement_type`	String	PKFK
`order_id`	Long	PKFK
`type_id`	Long	PKFK

engagement_property_history

Column	Type	Keys
`name`	String	PK
`engagement_id`	Long	PKFK
`engagement_type`	String	PKFK
`source`	String
`source_id`	String
`timestamp`	Instant
`value`	String

order_company

Column	Type	Keys
`category`	String	PKFK
`company_id`	Long	PKFK
`order_id`	Long	PKFK
`type_id`	Long	PKFK

invoice_contact

Column	Type	Keys
`category`	String	PKFK
`contact_id`	Long	PKFK
`invoice_id`	Long	PKFK
`type_id`	Long	PKFK

quote_company

Column	Type	Keys
`category`	String	PKFK
`company_id`	Long	PKFK
`quote_id`	Long	PKFK
`type_id`	Long	PKFK

conversation_message_recipient

Column	Type	Keys
`_fivetran_id`	String	PK
`actor_id`	String	FK
`message_id`	String	FK
`thread_id`	String	FK
`delivery_identifier_type`	String
`delivery_identifier_value`	String
`name`	String
`recipient_field`	String

marketing_email

Column	Type	Keys
`id`	Long	PK
`campaign`	String	FK
`subscription_id`	Long	FK
`ab_sample_size_default`	String
`ab_sampling_default`	String
`ab_status`	String
`ab_success_metric`	String
`ab_test_percentage`	Long
`active_domain`	String
`archived`	Boolean
`business_unit_id`	String
`campaign_name`	String
`campaign_utm`	String
`cloned_from`	String
`created_at`	Instant
`created_by_id`	String
`custom_reply_to`	String
`deleted_at`	Instant
`feedback_survey_id`	String
`folder_id`	Long
`folder_id_v_2`	Long
`from_name`	String
`hours_to_wait`	Long
`is_ab`	Boolean
`is_ab_variation`	Boolean
`is_published`	Boolean
`is_transactional`	Boolean
`jitter_send_time`	Boolean
`language`	String
`limit_send_frequency`	Boolean
`name`	String
`office_location_id`	String
`preferences_group_id`	String
`publish_date`	Instant
`published_at`	Instant
`published_by_email`	String
`published_by_id`	String
`published_by_name`	String
`reply_to`	String
`send_on_publish`	Boolean
`state`	String
`subcategory`	String
`subject`	String
`subscription_name`	String
`suppress_graymail`	Boolean
`test_id`	String
`type`	String
`updated_at`	Instant
`updated_by_id`	String
`rss_data_`
`webversion_`

lead

Column	Type	Keys
`id`	Long	PK

tax_property_history

Column	Type	Keys
`name`	String	PK
`tax_id`	Long	PKFK
`source`	String
`source_id`	String
`timestamp`	Instant
`value`	String

service_pipeline_stage

Column	Type	Keys
`id`	String	PK
`pipeline_id`	String	FK
`archived`	Boolean
`created_at`	Instant
`display_order`	Int
`is_closed`	Boolean
`label`	String
`updated_at`	Instant
`write_permissions`	String

cart_task

Column	Type	Keys
`task_id`	Long	PK
`cart_id`	Long	PKFK
`category`	String	PKFK
`type_id`	Long	PKFK

company

Column	Type	Keys
`id`	Long	PK
`is_deleted`	Boolean
`portal_id`	Long

ticket_contact

Column	Type	Keys
`category`	String	PKFK
`contact_id`	Long	PKFK
`ticket_id`	Long	PKFK
`type_id`	Long	PKFK

service_contact

Column	Type	Keys
`category`	String	PKFK
`contact_id`	Long	PKFK
`service_id`	Long	PKFK
`type_id`	Long	PKFK

feedback_submission_ticket

Column	Type	Keys
`category`	String	PKFK
`feedback_submission_id`	Long	PKFK
`ticket_id`	Long	PKFK
`type_id`	Long	PKFK

ticket_pipeline_stage

Column	Type	Keys
`stage_id`	String	PK
`pipeline_id`	String	FK
`created_at`	Instant
`display_order`	Int
`is_closed`	Boolean
`label`	String
`ticket_state`	String
`updated_at`	Instant
`write_permissions`	String

tax_quote

Column	Type	Keys
`category`	String	PKFK
`quote_id`	Long	PKFK
`tax_id`	Long	PKFK
`type_id`	Long	PKFK

invoice_line_item

Column	Type	Keys
`category`	String	PKFK
`invoice_id`	Long	PKFK
`line_item_id`	Long	PKFK
`type_id`	Long	PKFK

cart_line_item

Column	Type	Keys
`cart_id`	Long	PKFK
`category`	String	PKFK
`line_item_id`	Long	PKFK
`type_id`	Long	PKFK

payment_contact

Column	Type	Keys
`category`	String	PKFK
`contact_id`	Long	PKFK
`payment_id`	Long	PKFK
`type_id`	Long	PKFK

email_event_sent

Column	Type	Keys
`id`	String	PKFK
`bcc`	Json
`cc`	Json
`from`	String
`reply_to`	Json
`subject`	String

email_event_deferred

Column	Type	Keys
`id`	String	PKFK
`attempt`	Long
`response`	String

lead_pipeline

Column	Type	Keys
`pipeline_id`	String	PK
`archived`	Boolean
`created_at`	Instant
`display_order`	Int
`label`	String
`updated_at`	Instant

listing_property_history

Column	Type	Keys
`name`	String	PK
`listing_id`	Long	PKFK
`source`	String
`source_id`	String
`timestamp`	Instant
`value`	String

contact_company

Column	Type	Keys
`category`	String	PKFK
`company_id`	Long	PKFK
`contact_id`	Long	PKFK
`type_id`	Long	PKFK

engagement_lead

Column	Type	Keys
`category`	String	PKFK
`engagement_id`	Long	PKFK
`engagement_type`	String	PKFK
`lead_id`	Long	PKFK
`type_id`	Long	PKFK

cart_order

Column	Type	Keys
`order_id`	Long	PK
`cart_id`	Long	PKFK
`category`	String	PKFK
`type_id`	Long	PKFK

engagement

Column	Type	Keys
`id`	Long	PK
`type`	String	PK
`portal_id`	Long

invoice

Column	Type	Keys
`id`	Long	PK

email_subscription_change

Column	Type	Keys
`_fivetran_id`	String	PK
`caused_by_event_id`	String	FK
`email_subscription_id`	Long	FK
`change`	String
`change_type`	String
`portal_id`	Long
`recipient`	String
`source`	String
`timestamp`	Instant

lead_contact

Column	Type	Keys
`category`	String	PKFK
`contact_id`	Long	PKFK
`lead_id`	Long	PKFK
`type_id`	Long	PKFK

goal_property_history

Column	Type	Keys
`name`	String	PK
`goal_id`	Long	PKFK
`source`	String
`source_id`	String
`timestamp`	Instant
`value`	String

email_event_print

Column	Type	Keys
`id`	String	PKFK
`browser`	Json
`ip_address`	String
`location`	Json
`user_agent`	String

cart_contact

Column	Type	Keys
`cart_id`	Long	PKFK
`category`	String	PKFK
`contact_id`	Long	PKFK
`type_id`	Long	PKFK

email_event_status_change

Column	Type	Keys
`id`	String	PKFK
`bounced`	Boolean
`portal_subscription_status`	String
`requested_by`	String
`source`	String
`subscriptions`	Json

conversation_channel

Column	Type	Keys
`id`	String	PK
`name`	String

payment_invoice

Column	Type	Keys
`category`	String	PKFK
`invoice_id`	Long	PKFK
`payment_id`	Long	PKFK
`type_id`	Long	PKFK

subscription_company

Column	Type	Keys
`category`	String	PKFK
`company_id`	Long	PKFK
`subscription_id`	Long	PKFK
`type_id`	Long	PKFK

geolocation_analytics_overall_report

Column	Type	Keys
`breakdown`	String	PK
`bounce_rate`	Double
`bounces`	Long
`contacts`	Long
`contacts_per_pageview`	Double
`leads`	Long
`leads_per_view`	Double
`new_visitor_session_rate`	Double
`pageviews_minus_exits`	Long
`pageviews_per_session`	Double
`raw_views`	Long
`returning_visits`	Long
`session_to_contact_rate`	Double
`standard_views`	Long
`time`	Long
`time_per_session`	Double
`visitors`	Long
`visits`	Long

quote_property_history

Column	Type	Keys
`name`	String	PK
`quote_id`	Long	PKFK
`source`	String
`source_id`	String
`timestamp`	Instant
`value`	String

contact_property_history

Column	Type	Keys
`name`	String	PK
`contact_id`	Long	PKFK
`source`	String
`source_id`	String
`timestamp`	Instant
`value`	String

form

Column	Type	Keys
`guid`	String	PK
`action`	String
`created_at`	Instant
`css_class`	String
`follow_up_id`	String
`form_type`	String
`lead_nurturing_campaign_id`	String
`method`	String
`name`	String
`notify_recipients`	String
`portal_id`	Int
`redirect`	String
`submit_text`	String
`updated_at`	Instant

discount

Column	Type	Keys
`id`	Long	PK

marketing_email_campaign

Column	Type	Keys
`campaign_id`	Long	PKFK
`marketing_email_id`	Long	PKFK

marketing_campaign_spend_item

Column	Type	Keys
`id`	String	PK
`campaign_id`	String	PKFK
`amount`	Double
`created_at`	Long
`description`	String
`name`	String
`spend_total`	Double
`updated_at`	Long

ticket_engagement

Column	Type	Keys
`category`	String	PKFK
`engagement_id`	Long	PKFK
`engagement_type`	String	PKFK
`ticket_id`	Long	PKFK
`type_id`	Long	PKFK

lead_pipeline_stage

Column	Type	Keys
`stage_id`	String	PK
`pipeline_id`	String	FK
`archived`	Boolean
`created_at`	Instant
`display_order`	Int
`is_closed`	Boolean
`label`	String
`lead_state`	String
`updated_at`	Instant
`write_permissions`	String

email_event_delivered

Column	Type	Keys
`id`	String	PKFK
`response`	String
`smtp_id`	String

subscription_payment

Column	Type	Keys
`category`	String	PKFK
`payment_id`	Long	PKFK
`subscription_id`	Long	PKFK
`type_id`	Long	PKFK

service

Column	Type	Keys
`id`	Long	PK

fee

Column	Type	Keys
`id`	Long	PK

ticket

Column	Type	Keys
`id`	Long	PK
`portal_id`	Long

product

Column	Type	Keys
`id`	Long	PK
`portal_id`	Long

marketing_email_contact

Column	Type	Keys
`contact_id`	Long	PKFK
`marketing_email_id`	Long	PKFK
`is_contact_included`	Boolean

fee_quote

Column	Type	Keys
`category`	String	PKFK
`fee_id`	Long	PKFK
`quote_id`	Long	PKFK
`type_id`	Long	PKFK

submission_response

Column	Type	Keys
`field_name`	String	PK
`field_value`	String	PK
`object_type_id`	String	PK
`conversion_id`	String	PKFK
`form_id`	String	PKFK
`page_url`	String
`submitted_at`	Long

email_event_dropped

Column	Type	Keys
`id`	String	PKFK
`bcc`	Json
`cc`	Json
`drop_message`	String
`drop_reason`	String
`from`	String
`reply_to`	Json
`subject`	String

payment_deal

Column	Type	Keys
`category`	String	PKFK
`deal_id`	Long	PKFK
`payment_id`	Long	PKFK
`type_id`	Long	PKFK

property_option

Column	Type	Keys
`label`	String	PK
`hubspot_object`	String	PKFK
`name`	String	PKFK
`description`	String
`display_order`	Int
`hidden`	Boolean
`value`	String

conversation_inbox

Column	Type	Keys
`id`	String	PK
`active`	Boolean
`created_at`	Instant
`name`	String
`type`	String
`updated_at`	Instant

feedback_submission_property_history

Column	Type	Keys
`name`	String	PK
`feedback_submission_id`	Long	PKFK
`source`	String
`source_id`	String
`timestamp`	Instant
`value`	String

company_company

Column	Type	Keys
`category`	String	PKFK
`from_company_id`	Long	PKFK
`to_company_id`	Long	PKFK
`type_id`	Long	PKFK

goal

Column	Type	Keys
`id`	Long	PK

discount_payment

Column	Type	Keys
`category`	String	PKFK
`discount_id`	Long	PKFK
`payment_id`	Long	PKFK
`type_id`	Long	PKFK

lead_property_history

Column	Type	Keys
`name`	String	PK
`lead_id`	Long	PKFK
`source`	String
`source_id`	String
`timestamp`	Instant
`value`	String

engagement_goal

Column	Type	Keys
`category`	String	PKFK
`engagement_id`	Long	PKFK
`engagement_type`	String	PKFK
`goal_id`	Long	PKFK
`type_id`	Long	PKFK

quote_line_item

Column	Type	Keys
`category`	String	PKFK
`line_item_id`	Long	PKFK
`quote_id`	Long	PKFK
`type_id`	Long	PKFK

custom_event_definition_association

Column	Type	Keys
`id`	Long	PK
`custom_event_definition_id`	String	PKFK
`allows_custom_labels`	Boolean
`cardinality`	String
`category`	String
`from_object_type`	String
`from_object_type_id`	String
`has_all_associated_objects`	Boolean
`has_cascading_deletes`	Boolean
`has_user_enforced_max_from_object_ids`	Boolean
`has_user_enforced_max_to_object_ids`	Boolean
`hidden`	Boolean
`inverse_allows_custom_labels`	Boolean
`inverse_cardinality`	String
`inverse_has_all_associated_objects`	Boolean
`inverse_id`	Long
`inverse_label`	String
`inverse_name`	String
`is_inverse_primary`	Boolean
`is_primary`	Boolean
`label`	String
`max_from_object_ids`	Long
`max_to_object_ids`	Long
`name`	String
`portal_unique_identifier`	String
`to_object_type`	String
`to_object_type_id`	String

ticket_company

Column	Type	Keys
`category`	String	PKFK
`company_id`	Long	PKFK
`ticket_id`	Long	PKFK
`type_id`	Long	PKFK

sources_analytics_overall_report

Column	Type	Keys
`breakdown`	String	PK
`bounce_rate`	Double
`bounces`	Long
`contact_to_customer_rate`	Double
`contacts`	Long
`contacts_per_pageview`	Double
`customers`	Long
`leads`	Long
`leads_per_view`	Double
`marketing_qualified_leads`	Long
`new_visitor_session_rate`	Double
`opportunities`	Long
`pageviews_minus_exits`	Long
`pageviews_per_session`	Double
`raw_views`	Long
`returning_visits`	Long
`sales_qualified_leads`	Long
`session_to_contact_rate`	Double
`standard_views`	Long
`subscribers`	Long
`time`	Long
`time_per_session`	Double
`visitors`	Long
`visits`	Long

invoice_ticket

Column	Type	Keys
`category`	String	PKFK
`invoice_id`	Long	PKFK
`ticket_id`	Long	PKFK
`type_id`	Long	PKFK

deal

Column	Type	Keys
`deal_id`	Long	PK
`is_deleted`	Boolean
`portal_id`	Long

fee_invoice

Column	Type	Keys
`category`	String	PKFK
`fee_id`	Long	PKFK
`invoice_id`	Long	PKFK
`type_id`	Long	PKFK

email_event_forward

Column	Type	Keys
`id`	String	PKFK
`browser`	Json
`ip_address`	String
`location`	Json
`user_agent`	String

merged_deal

Column	Type	Keys
`deal_id`	Long	PKFK
`merged_deal_id`	Long	PKFK

tax

Column	Type	Keys
`id`	Long	PK

cart_discount

Column	Type	Keys
`cart_id`	Long	PKFK
`category`	String	PKFK
`discount_id`	Long	PKFK
`type_id`	Long	PKFK

order_contact

Column	Type	Keys
`category`	String	PKFK
`contact_id`	Long	PKFK
`order_id`	Long	PKFK
`type_id`	Long	PKFK

discount_line_item

Column	Type	Keys
`category`	String	PKFK
`discount_id`	Long	PKFK
`line_item_id`	Long	PKFK
`type_id`	Long	PKFK

cart

Column	Type	Keys
`id`	Long	PK

tax_payment

Column	Type	Keys
`category`	String	PKFK
`payment_id`	Long	PKFK
`tax_id`	Long	PKFK
`type_id`	Long	PKFK

subscription_line_item

Column	Type	Keys
`category`	String	PKFK
`line_item_id`	Long	PKFK
`subscription_id`	Long	PKFK
`type_id`	Long	PKFK

service_property_history

Column	Type	Keys
`name`	String	PK
`service_id`	Long	PKFK
`source`	String
`source_id`	String
`timestamp`	Instant
`value`	String

users

Column	Type	Keys
`id`	Long	PK
`primary_team_id`	Long	FK
`role_id`	Long	FK
`email`	String
`first_name`	String
`last_name`	String

subscription_feedback_submission

Column	Type	Keys
`category`	String	PKFK
`feedback_submission_id`	Long	PKFK
`subscription_id`	Long	PKFK
`type_id`	Long	PKFK

deal_split

Column	Type	Keys
`id`	String	PK
`deal_id`	Long	PKFK
`owner_id`	Long	FK
`archived`	Boolean
`created_at`	Instant
`deal_split_percentage`	Double
`updated_at`	Instant

conversation_message_sender

Column	Type	Keys
`_fivetran_id`	String	PK
`actor_id`	String	FK
`message_id`	String	FK
`thread_id`	String	FK
`delivery_identifier_type`	String
`delivery_identifier_value`	String
`name`	String
`sender_field`	String

discount_order

Column	Type	Keys
`order_id`	Long	PK
`category`	String	PKFK
`discount_id`	Long	PKFK
`type_id`	Long	PKFK

marketing_event_custom_property

Column	Type	Keys
`name`	String	PK
`marketing_event_id`	Long	PKFK
`value`	String

order_payment

Column	Type	Keys
`category`	String	PKFK
`order_id`	Long	PKFK
`payment_id`	Long	PKFK
`type_id`	Long	PKFK

marketing_campaign_asset

Column	Type	Keys
`asset_type`	String	PK
`id`	String	PK
`campaign_id`	String	PKFK
`name`	String

contact

Column	Type	Keys
`id`	Long	PK
`is_deleted`	Boolean

sessions_analytics_overall_report

Column	Type	Keys
`breakdown`	String	PK
`desktop`	Long
`direct_traffic`	Long
`email_marketing`	Long
`mobile`	Long
`other_campaigns`	Long
`paid_search`	Long
`social_media`	Long

subscription_contact

Column	Type	Keys
`category`	String	PKFK
`contact_id`	Long	PKFK
`subscription_id`	Long	PKFK
`type_id`	Long	PKFK

cart_quote

Column	Type	Keys
`cart_id`	Long	PKFK
`category`	String	PKFK
`quote_id`	Long	PKFK
`type_id`	Long	PKFK

deal_pipeline_stage

Column	Type	Keys
`stage_id`	String	PK
`pipeline_id`	String	FK
`created_at`	Instant
`display_order`	Int
`is_closed`	Boolean
`label`	String
`probability`	Double
`updated_at`	Instant
`write_permissions`	String

role

Column	Type	Keys
`id`	Long	PK
`name`	String
`requires_billing_write`	Boolean

email_event_open

Column	Type	Keys
`id`	String	PKFK
`browser`	Json
`duration`	String
`ip_address`	String
`location`	Json
`user_agent`	String

custom_event_definition

Column	Type	Keys
`id`	String	PK
`type`	String	PK
`combo_event_rules`	Json
`created_at`	Instant
`created_user_id`	Long
`labels_plural`	String
`labels_singular`	String
`name`	String
`object_type_id`	String

email_campaign

Column	Type	Keys
`id`	Long	PK
`app_id`	Long
`app_name`	String
`content_id`	Long
`name`	String
`num_included`	Int
`num_queued`	Int
`sub_type`	String
`subject`	String
`type`	String

quote_contact

Column	Type	Keys
`category`	String	PKFK
`contact_id`	Long	PKFK
`quote_id`	Long	PKFK
`type_id`	Long	PKFK

product_property_history

Column	Type	Keys
`name`	String	PK
`product_id`	Long	PKFK
`source`	String
`source_id`	String
`timestamp`	Instant
`value`	String

ticket_deal

Column	Type	Keys
`category`	String	PKFK
`deal_id`	Long	PKFK
`ticket_id`	Long	PKFK
`type_id`	Long	PKFK

subscription

Column	Type	Keys
`id`	Long	PK

ticket_property_history

Column	Type	Keys
`name`	String	PK
`ticket_id`	Long	PKFK
`source`	String
`source_id`	String
`timestamp_instant`	Instant
`value`	String

team

Column	Type	Keys
`id`	Long	PK
`name`	String

payment_line_item

Column	Type	Keys
`category`	String	PKFK
`line_item_id`	Long	PKFK
`payment_id`	Long	PKFK
`type_id`	Long	PKFK

discount_property_history

Column	Type	Keys
`name`	String	PK
`discount_id`	Long	PKFK
`source`	String
`source_id`	String
`timestamp`	Instant
`value`	String

ticket_ticket

Column	Type	Keys
`category`	String	PKFK
`from_ticket_id`	Long	PKFK
`to_ticket_id`	Long	PKFK
`type_id`	Long	PKFK

team_user

Column	Type	Keys
`team_id`	Long	PKFK
`user_id`	Long	PKFK
`is_secondary_user`	Boolean

audit_log

Column	Type	Keys
`id`	String	PK
`acting_user_id`	Long	FK
`action`	String
`category`	String
`occurred_at`	Instant
`sub_category`	String
`target_object_id`	String

service_engagement

Column	Type	Keys
`category`	String	PKFK
`engagement_id`	Long	PKFK
`engagement_type`	String	PKFK
`service_id`	Long	PKFK
`type_id`	Long	PKFK

contact_list_member

Column	Type	Keys
`contact_id`	Long	PKFK
`contact_list_id`	Long	PKFK
`added_at`	Instant

conversation_thread

Column	Type	Keys
`id`	String	PK
`associated_contact_id`	String	FK
`associated_ticket_id`	String	FK
`inbox_id`	String	FK
`original_channel_account_id`	String	FK
`original_channel_id`	String	FK
`assigned_to`	String
`closed_at`	Instant
`created_at`	Instant
`latest_message_received_timestamp`	Instant
`latest_message_sent_timestamp`	Instant
`latest_message_timestamp`	Instant
`spam`	String
`status`	String

marketing_campaign

Column	Type	Keys
`id`	String	PK
`created_at`	Instant
`hs_audience`	String
`hs_budget_items_sum_amount`	Double
`hs_campaign_status`	String
`hs_color_hex`	String
`hs_created_by_user_id`	String
`hs_currency_code`	String
`hs_end_date`	String
`hs_name`	String
`hs_notes`	String
`hs_object_id`	String
`hs_owner`	String
`hs_spend_items_sum_amount`	Double
`hs_start_date`	String
`updated_at`	Instant

discount_deal

Column	Type	Keys
`category`	String	PKFK
`deal_id`	Long	PKFK
`discount_id`	Long	PKFK
`type_id`	Long	PKFK

goal_contact

Column	Type	Keys
`category`	String	PKFK
`contact_id`	Long	PKFK
`goal_id`	Long	PKFK
`type_id`	Long	PKFK

association_type

Column	Type	Keys
`category`	String	PK
`id`	Long	PK
`from_object_type`	String
`label`	String
`name`	String
`to_object_type`	String

custom_event

Column	Type	Keys
`id`	String	PK
`type`	String	PKFK
`object_id`	String
`object_type`	String
`occurred_at`	Instant

company_property_history

Column	Type	Keys
`name`	String	PK
`company_id`	Long	PKFK
`source`	String
`source_id`	String
`timestamp`	Instant
`value`	String

listing

Column	Type	Keys
`id`	Long	PK

cart_ticket

Column	Type	Keys
`cart_id`	Long	PKFK
`category`	String	PKFK
`ticket_id`	Long	PKFK
`type_id`	Long	PKFK

conversation_message_history

Column	Type	Keys
`id`	String	PK
`thread_id`	String	PKFK
`channel_account_id`	String	FK
`channel_id`	String	FK
`from_inbox_id`	String	FK
`to_inbox_id`	String	FK
`assigned_from`	String
`assigned_to`	String
`client_type`	String
`created_at`	Instant
`created_by`	String
`direction`	String
`in_reply_to_id`	String
`new_status`	String
`rich_text`	String
`status_type`	String
`subject`	String
`text`	String
`truncation_status`	String
`type`	String
`updated_at`	Instant

quote_deal

Column	Type	Keys
`category`	String	PKFK
`deal_id`	Long	PKFK
`quote_id`	Long	PKFK
`type_id`	Long	PKFK

order

Column	Type	Keys
`id`	Long	PK

deal_stage

Column	Type	Keys
`deal_id`	Long	PKFK
`date_entered`	Instant
`source`	String
`source_id`	String
`value`	String

engagement_contact

Column	Type	Keys
`category`	String	PKFK
`contact_id`	Long	PKFK
`engagement_id`	Long	PKFK
`engagement_type`	String	PKFK
`type_id`	Long	PKFK

subscription_order

Column	Type	Keys
`order_id`	Long	PK
`category`	String	PKFK
`subscription_id`	Long	PKFK
`type_id`	Long	PKFK

line_item_property_history

Column	Type	Keys
`name`	String	PK
`line_item_id`	Long	PKFK
`source`	String
`source_id`	String
`timestamp`	Instant
`value`	String

deal_deal

Column	Type	Keys
`category`	String	PKFK
`from_deal_id`	Long	PKFK
`to_deal_id`	Long	PKFK
`type_id`	Long	PKFK

invoice_deal

Column	Type	Keys
`category`	String	PKFK
`deal_id`	Long	PKFK
`invoice_id`	Long	PKFK
`type_id`	Long	PKFK

contact_form_submission

Column	Type	Keys
`timestamp`	Instant	PK
`contact_id`	Long	PKFK
`form_id`	String	PKFK
`page_id`	String
`portal_id`	Long

conversation_channel_account

Column	Type	Keys
`id`	String	PK
`channel_id`	String	FK
`inbox_id`	String	FK
`active`	Boolean
`authorized`	Boolean
`created_at`	Instant
`delivery_identifier_type`	String
`delivery_identifier_value`	String
`name`	String

order_feedback_submission

Column	Type	Keys
`category`	String	PKFK
`feedback_submission_id`	Long	PKFK
`order_id`	Long	PKFK
`type_id`	Long	PKFK

contact_contact

Column	Type	Keys
`category`	String	PKFK
`from_contact_id`	Long	PKFK
`to_contact_id`	Long	PKFK
`type_id`	Long	PKFK

ticket_pipeline

Column	Type	Keys
`pipeline_id`	String	PK
`created_at`	Instant
`display_order`	Int
`label`	String
`updated_at`	Instant

email_event_bounce

Column	Type	Keys
`id`	String	PKFK
`category`	String
`response`	String
`status`	String

invoice_property_history

Column	Type	Keys
`name`	String	PK
`invoice_id`	Long	PKFK
`source`	String
`source_id`	String
`timestamp`	Instant
`value`	String

marketing_event_list

Column	Type	Keys
`id`	String	PK
`marketing_event_id`	Long	PKFK
`created_by_id`	String	FK
`created_at`	Instant
`deleted_at`	Instant
`filters_updated_at`	Instant
`list_version`	Long
`name`	String
`object_type_id`	String
`processing_status`	String
`processing_type`	String
`size`	Long
`updated_at`	Instant
`updated_by_id`	String

email_event_spam_report

Column	Type	Keys
`id`	String	PKFK
`ip_address`	String
`user_agent`	String

custom_event_definition_property_option

Column	Type	Keys
`label`	String	PK
`custom_event_definition_id`	String	PKFK
`property_name`	String	PKFK
`description`	String
`display_order`	Int
`hidden`	Boolean
`value`	String

activity_security

Column	Type	Keys
`id`	String	PK
`user_id`	Long	FK
`acting_user`	String
`country_code`	String
`created_at`	Instant
`info_url`	String
`ip_address`	String
`location`	String
`object_id`	String
`region_code`	String
`type`	String

owner_team

Column	Type	Keys
`owner_id`	Long	PKFK
`team_id`	Long	PKFK
`is_team_primary`	Boolean

deal_contact

Column	Type	Keys
`category`	String	PKFK
`contact_id`	Long	PKFK
`deal_id`	Long	PKFK
`type_id`	Long	PKFK

email_event_click

Column	Type	Keys
`id`	String	PKFK
`browser`	Json
`ip_address`	String
`location`	Json
`referer`	String
`url`	String
`user_agent`	String

subscription_property_history

Column	Type	Keys
`name`	String	PK
`subscription_id`	Long	PKFK
`source`	String
`source_id`	String
`timestamp`	Instant
`value`	String

lead_company

Column	Type	Keys
`category`	String	PKFK
`company_id`	Long	PKFK
`lead_id`	Long	PKFK
`type_id`	Long	PKFK

line_item_deal

Column	Type	Keys
`category`	String	PKFK
`deal_id`	Long	PKFK
`line_item_id`	Long	PKFK
`type_id`	Long	PKFK

order_pipeline

Column	Type	Keys
`id`	String	PK
`archived`	Boolean
`created_at`	Instant
`display_order`	Int
`label`	String
`updated_at`	Instant

marketing_campaign_budget_item

Column	Type	Keys
`id`	String	PK
`campaign_id`	String	PKFK
`amount`	Double
`budget_total`	Double
`created_at`	Long
`currency_code`	String
`description`	String
`name`	String
`remaining_budget`	Double
`updated_at`	Long

order_invoice

Column	Type	Keys
`category`	String	PKFK
`invoice_id`	Long	PKFK
`order_id`	Long	PKFK
`type_id`	Long	PKFK

feedback_submission_contact

Column	Type	Keys
`category`	String	PKFK
`contact_id`	Long	PKFK
`feedback_submission_id`	Long	PKFK
`type_id`	Long	PKFK

event

Column	Type	Keys
`id`	String	PK
`type`	String	PK
`object_id`	String
`object_type`	String
`occurred_at`	Instant

goal_company

Column	Type	Keys
`category`	String	PKFK
`company_id`	Long	PKFK
`goal_id`	Long	PKFK
`type_id`	Long	PKFK

subscription_quote

Column	Type	Keys
`category`	String	PKFK
`quote_id`	Long	PKFK
`subscription_id`	Long	PKFK
`type_id`	Long	PKFK

goal_deal

Column	Type	Keys
`category`	String	PKFK
`deal_id`	Long	PKFK
`goal_id`	Long	PKFK
`type_id`	Long	PKFK

order_property_history

Column	Type	Keys
`name`	String	PK
`order_id`	Long	PKFK
`source`	String
`source_id`	String
`timestamp`	Instant
`value`	String

invoice_company

Column	Type	Keys
`category`	String	PKFK
`company_id`	Long	PKFK
`invoice_id`	Long	PKFK
`type_id`	Long	PKFK

payment_property_history

Column	Type	Keys
`name`	String	PK
`payment_id`	Long	PKFK
`source`	String
`source_id`	String
`timestamp`	Instant
`value`	String

subscription_ticket

Column	Type	Keys
`category`	String	PKFK
`subscription_id`	Long	PKFK
`ticket_id`	Long	PKFK
`type_id`	Long	PKFK

discount_invoice

Column	Type	Keys
`category`	String	PKFK
`discount_id`	Long	PKFK
`invoice_id`	Long	PKFK
`type_id`	Long	PKFK

line_item

Column	Type	Keys
`id`	Long	PK
`product_id`	Long	FK

deal_company

Column	Type	Keys
`category`	String	PKFK
`company_id`	Long	PKFK
`deal_id`	Long	PKFK
`type_id`	Long	PKFK

email_event

Column	Type	Keys
`id`	String	PK
`email_campaign_id`	Long	FK
`app_id`	Long
`caused_by_created`	Instant
`caused_by_id`	String
`created`	Instant
`filtered_event`	Boolean
`obsoleted_by_created`	Instant
`obsoleted_by_id`	String
`portal_id`	Long
`recipient`	String
`sent_by_created`	Instant
`sent_by_id`	String
`type`	String

fee_payment

Column	Type	Keys
`category`	String	PKFK
`fee_id`	Long	PKFK
`payment_id`	Long	PKFK
`type_id`	Long	PKFK

service_pipeline

Column	Type	Keys
`id`	String	PK
`archived`	Boolean
`created_at`	Instant
`display_order`	Int
`label`	String
`updated_at`	Instant

marketing_event_participant

Column	Type	Keys
`id`	String	PK
`marketing_event_id`	String	PKFK
`contact_id`	String	FK
`created_at`	Instant
`properties_`

order_line_item

Column	Type	Keys
`category`	String	PKFK
`line_item_id`	Long	PKFK
`order_id`	Long	PKFK
`type_id`	Long	PKFK

quote

Column	Type	Keys
`id`	Long	PK

company_list

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`created_by_id`	String
`filters_updated_at`	Instant
`list_version`	Long
`name`	String
`object_type_id`	String
`processing_status`	String
`processing_type`	String
`updated_at`	Instant

service_ticket

Column	Type	Keys
`category`	String	PKFK
`service_id`	Long	PKFK
`ticket_id`	Long	PKFK
`type_id`	Long	PKFK

engagement_deal

Column	Type	Keys
`category`	String	PKFK
`deal_id`	Long	PKFK
`engagement_id`	Long	PKFK
`engagement_type`	String	PKFK
`type_id`	Long	PKFK

conversation_actor

Column	Type	Keys
`id`	String	PK
`avatar`	String
`email`	String
`name`	String
`type`	String

tax_invoice

Column	Type	Keys
`category`	String	PKFK
`invoice_id`	Long	PKFK
`tax_id`	Long	PKFK
`type_id`	Long	PKFK

deal_pipeline

Column	Type	Keys
`pipeline_id`	String	PK
`created_at`	Instant
`display_order`	Int
`label`	String
`updated_at`	Instant

fee_property_history

Column	Type	Keys
`name`	String	PK
`fee_id`	Long	PKFK
`source`	String
`source_id`	String
`timestamp`	Instant
`value`	String

custom_event_definition_property

Column	Type	Keys
`name`	String	PK
`custom_event_definition_id`	String	PKFK
`calculated`	Boolean
`created_at`	Instant
`created_user_id`	Long
`data_sensitivity`	String
`description`	String
`display_order`	Int
`external_options`	Boolean
`field_type`	String
`form_field`	Boolean
`group_name`	String
`has_unique_value`	Boolean
`hidden`	Boolean
`label`	String
`modification_metadata_archivable`	Boolean
`modification_metadata_read_only_definition`	Boolean
`modification_metadata_read_only_value`	Boolean
`type`	String
`updated_at`	Instant
`updated_user_id`	Long

contact_list

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`created_by_id`	String
`filters_updated_at`	Instant
`list_version`	Long
`name`	String
`object_type_id`	String
`processing_status`	String
`processing_type`	String
`updated_at`	Instant

engagement_company

Column	Type	Keys
`category`	String	PKFK
`company_id`	Long	PKFK
`engagement_id`	Long	PKFK
`engagement_type`	String	PKFK
`type_id`	Long	PKFK

property

Column	Type	Keys
`hubspot_object`	String	PK
`name`	String	PK
`archived`	Boolean
`archived_at`	Instant
`calculated`	Boolean
`calculation_formula`	String
`created_at`	Instant
`description`	String
`field_type`	String
`group_name`	String
`has_unique_value`	Boolean
`hubspot_defined`	Boolean
`label`	String
`referenced_object_type`	String
`show_currency_symbol`	Boolean
`type`	String
`updated_at`	Instant
`updated_user_id`	String
`modification_metadata_`

email_subscription

Column	Type	Keys
`id`	Long	PK
`active`	Boolean
`description`	String
`name`	String
`portal_id`	Long

utm_analytics_overall_report

Column	Type	Keys
`breakdown`	String	PK
`utm_type`	String	PK
`bounce_rate`	Double
`bounces`	Long
`new_visitor_session_rate`	Double
`pageviews_minus_exits`	Long
`pageviews_per_session`	Double
`raw_views`	Long
`returning_visits`	Long
`standard_views`	Long
`time`	Long
`time_per_session`	Double
`visitors`	Long
`visits`	Long

lead_deal

Column	Type	Keys
`category`	String	PKFK
`deal_id`	Long	PKFK
`lead_id`	Long	PKFK
`type_id`	Long	PKFK

cart_property_history

Column	Type	Keys
`name`	String	PK
`cart_id`	Long	PKFK
`source`	String
`source_id`	String
`timestamp`	Instant
`value`	String

payment_quote

Column	Type	Keys
`category`	String	PKFK
`payment_id`	Long	PKFK
`quote_id`	Long	PKFK
`type_id`	Long	PKFK

service_company

Column	Type	Keys
`category`	String	PKFK
`company_id`	Long	PKFK
`service_id`	Long	PKFK
`type_id`	Long	PKFK

goal_ticket

Column	Type	Keys
`category`	String	PKFK
`goal_id`	Long	PKFK
`ticket_id`	Long	PKFK
`type_id`	Long	PKFK

marketing_email_contact_list

Column	Type	Keys
`contact_list_id`	Long	PKFK
`marketing_email_id`	Long	PKFK
`is_mailing_list_included`	Boolean