ColumnTypeNotes
contact_idWHOLE NUMBERForeign Key from HubSpotContacts table

deal_idWHOLE NUMBERForeign Key from HubSpotDeals 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