AdventureWorks
| View Name: | Sales.vStoreWithDemographics |
| Description: | Stores (names and addresses) that sell Adventure Works Cycles products to consumers. |
| Field | Type | Nulls? |
|---|---|---|
| CustomerID | int | No |
| Name | nvarchar (50) | No |
| ContactType | nvarchar (50) | No |
| Title | nvarchar (8) | Yes |
| FirstName | nvarchar (50) | No |
| MiddleName | nvarchar (50) | Yes |
| LastName | nvarchar (50) | No |
| Suffix | nvarchar (10) | Yes |
| Phone | nvarchar (25) | Yes |
| EmailAddress | nvarchar (50) | Yes |
| EmailPromotion | int | No |
| AddressType | nvarchar (50) | No |
| AddressLine1 | nvarchar (60) | No |
| AddressLine2 | nvarchar (60) | Yes |
| City | nvarchar (30) | No |
| StateProvinceName | nvarchar (50) | No |
| PostalCode | nvarchar (15) | No |
| CountryRegionName | nvarchar (50) | No |
| AnnualSales | money | Yes |
| AnnualRevenue | money | Yes |
| BankName | nvarchar (50) | Yes |
| BusinessType | nvarchar (5) | Yes |
| YearOpened | int | Yes |
| Specialty | nvarchar (50) | Yes |
| SquareFeet | int | Yes |
| Brands | nvarchar (30) | Yes |
| Internet | nvarchar (30) | Yes |
| NumberEmployees | int | Yes |