ColumnTypeNotes
contact_idWHOLE NUMBERForeign Key from HubSpotContacts table
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