HubSpot

Table - HubSpotDealPipelineStages
ColumnTypeNotes archived BINARY createdAt DATETIME deal_pipeline_id TEXT Foreign Key from DealPipelines table displayOrder WHOLE ...
Fri, 17 Jun, 2022 at 3:19 PM
Table - HubSpotDealProperties
ColumnTypeNotes Label TEXT Name TEXT Value TEXT archived BINARY createdAt DATETIME deal_id WHOLE NUMBER Foreign Key from HubSpot...
Fri, 17 Jun, 2022 at 3:22 PM
Table - HubSpotDeals
ColumnTypeNotes amount DECIMAL archived BINARY closedate DATETIME company_id WHOLE NUMBER Foreign Key from HubSpotCompanies tab...
Fri, 17 Jun, 2022 at 3:24 PM
Table - HubSpotDealStageChanges
This is a custom table created within Tugger. This table is used to track changes in stages for deals. Tugger monitors changes to the hs_date_entered_...
Fri, 17 Jun, 2022 at 3:30 PM
Table - HubSpotLineItemProperties
ColumnTypeNotes Label TEXT Name TEXT Value TEXT archived BINARY createdAt DATETIME line_item_id WHOLE NUMBER Foreign K...
Fri, 17 Jun, 2022 at 3:31 PM
Table - HubSpotLineItems
ColumnTypeNotes archived BINARY createdAt DATETIME deal_id WHOLE NUMBER Foreign Key from HubSpotDeals table discount decimal(18, ...
Fri, 17 Jun, 2022 at 3:33 PM
Table - HubSpotOwners
Note: A HubSpotOwner is a HubSpot user. ColumnTypeNotes archived BINARY createdAt DATETIME email TEXT firstName TEXT id WHOLE ...
Fri, 17 Jun, 2022 at 3:35 PM
Table - HubSpotOwnerTeamMaps
ColumnTypeNotes owner_id WHOLE NUMBER Foreign Key from HubSpotOwners table primary BINARY team_id WHOLE NUMBER Foreign Key from HubSpo...
Fri, 17 Jun, 2022 at 3:35 PM
Table - HubSpotProductProperties
ColumnTypeNotes Label TEXT Name TEXT Value TEXT archived BINARY createdAt DATETIME product_id WHOLE NUMBER Foreign Key...
Fri, 17 Jun, 2022 at 3:36 PM
Table - HubSpotProducts
ColumnTypeNotes archived BINARY createdAt DATETIME description TEXT hs_cost_of_goods_sold decimal(18, hs_recurring_billing_period TE...
Fri, 17 Jun, 2022 at 3:37 PM