ColumnTypeNotes
addressTEXT
archivedBINARY
cityTEXT
countryTEXT
createdAtDATETIME
firstnameTEXT
hs_lead_statusTEXTLead Status
hubspot_owner_idWHOLE NUMBERForeign Key from HubSpotOwners table
hubspot_team_idWHOLE NUMBERForeign Key from HubSpotTeams table
idWHOLE NUMBERunique identifier
industryTEXT
jobtitleTEXT
lastnameTEXT
salutationTEXT
stateTEXT
updatedAtDATETIME
zipTEXT
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