ColumnTypeNotes
LabelTEXT
NameTEXT
ValueTEXT
archivedBINARY
contact_idWHOLE NUMBERForeign Key from HubSpotContacts table
createdAtDATETIME
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