CustomerID|int|4|10|0|no
Name|Name|100|||no
ContactType|Name|100|||no
Title|nvarchar|16|||yes
FirstName|Name|100|||no
MiddleName|Name|100|||yes
LastName|Name|100|||no
Suffix|nvarchar|20|||yes
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
Demographics|xml|-1|||yes
AdditionalContactInfo|xml|-1|||yes
AnnualSales|money|8|19|4|yes
AnnualRevenue|money|8|19|4|yes
BankName|nvarchar|100|||yes
BusinessType|nvarchar|10|||yes
YearOpened|int|4|10|0|yes
Specialty|nvarchar|100|||yes
SquareFeet|int|4|10|0|yes
Brands|nvarchar|60|||yes
Internet|nvarchar|60|||yes
NumberEmployees|int|4|10|0|yes