ColumnTypeNotes
CreatedAtDATETIME
UpdatedAtDATETIME
address2TEXT
addressTEXT
archivedBINARY
cityTEXT
countryTEXT
domainTEXT
hs_lead_statusTEXT
hubspot_owner_idWHOLE NUMBERForeign Key from HubSpotOwners table
hubspot_team_idWHOLE NUMBERForeign Key from HubSpotTeams table
idWHOLE NUMBERUnique identifier
industryTEXT
nameTEXT
stateTEXT
typeTEXT
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