ColumnTypeNotes
archivedBINARY
createdAtDATETIME
displayOrderWHOLE NUMBER
idTEXTUnique identifier
labelTEXT
ticket_pipeline_idWHOLE NUMBERForeign Key from HubSpotTicketPipelines 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