ColumnTypeNotes
archivedBINARY
closed_dateDATETIME
company_idWHOLE NUMBERForeign Key from HubSpotCompanies table
createdAtDATETIME
hs_pipeline_stageTEXTForeign Key from HubSpotTicketPipelineStages table
hs_pipelineTEXTForeign Key from HubSpotPipelines table
hs_ticket_priorityTEXT
hubspot_owner_idWHOLE NUMBERForeign Key from HubSpotOwners table
idWHOLE NUMBERUnique identifier
subjectTEXT
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