ColumnTypeNotes
amountDECIMAL

archivedBINARY
closedateDATETIME
company_idWHOLE NUMBERForeign Key from HubSpotCompanies table
createdAtDATETIME
dealnameTEXT
dealstageTEXTForeign Key from HubSpotDealPipelineStages table
dealtypeTEXT
hs_priorityTEXT
hubspot_owner_idWHOLE NUMBERForeign Key from HubSpotOwners table
hubspot_team_idWHOLE NUMBERForeign Key from HubSpotTeams table
idWHOLE NUMBERunique identifier
pipelineTEXTForeign Key from HubSpotOwners table
updatedAtDATETIME
LastTugDateWHOLE NUMBERThe date the information was last pulled from HubSpot to Tugger in the format YYYYMMDD
DeletedBINARYFlag to indicate if the row has been deleted from HubSpot