ColumnTypeNotes
LabelTEXT
NameTEXT
ValueTEXT
archivedBINARY
createdAtDATETIME
ticket_idWHOLE NUMBERForeign Key from HubSpotTickets 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