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