Sales.vStoreWithDemographics

View: 'Sales.vStoreWithDemographics', Stores (names and addresses) that sell Adventure Works Cycles products to consumers.

Field Name	Type and Size
CustomerID	int NOT NULL
Name	Name NOT NULL
ContactType	Name NOT NULL
Title	nvarchar(8) NULL
FirstName	Name NOT NULL
MiddleName	Name NULL
LastName	Name NOT NULL
Suffix	nvarchar(10) NULL
Phone	Phone NULL
EmailAddress	nvarchar(50) NULL
EmailPromotion	int NOT NULL
AddressType	Name NOT NULL
AddressLine1	nvarchar(60) NOT NULL
AddressLine2	nvarchar(60) NULL
City	nvarchar(30) NOT NULL
StateProvinceName	Name NOT NULL
PostalCode	nvarchar(15) NOT NULL
CountryRegionName	Name NOT NULL
AnnualSales	money(19,4) NULL
AnnualRevenue	money(19,4) NULL
BankName	nvarchar(50) NULL
BusinessType	nvarchar(5) NULL
YearOpened	int NULL
Specialty	nvarchar(50) NULL
SquareFeet	int NULL
Brands	nvarchar(30) NULL
Internet	nvarchar(30) NULL
NumberEmployees	int NULL