SalesPersonID|int|4|10|0|no
Title|nvarchar|16|||yes
FirstName|Name|100|||no
MiddleName|Name|100|||yes
LastName|Name|100|||no
Suffix|nvarchar|20|||yes
JobTitle|nvarchar|100|||no
Phone|Phone|50|||yes
EmailAddress|nvarchar|100|||yes
EmailPromotion|int|4|10|0|yes
AddressLine1|nvarchar|120|||no
AddressLine2|nvarchar|120|||yes
City|nvarchar|60|||no
StateProvinceName|Name|100|||no
PostalCode|nvarchar|30|||no
CountryRegionName|Name|100|||no
TerritoryName|Name|100|||yes
TerritoryGroup|nvarchar|100|||yes
SalesQuota|money|8|19|4|yes
SalesYTD|money|8|19|4|no
SalesLastYear|money|8|19|4|no