Store Table (AdventureWorks)
Contains the customers, the resellers, of Adventure Works products.
Store Table Definition
The Store table is contained in the Sales schema.
Column |
Data type |
Nullability |
Description |
|---|---|---|---|
CustomerID |
int |
Not null |
Primary key. Foreign key to Customer.CustomerID. |
Name |
Name (user-defined type) nvarchar(50) |
Not null |
Name of the store. |
SalesPersonID |
int |
Null |
ID of the Adventure Works sales representative responsible for selling products to the store. Foreign key to SalesPerson.SalesPersonID. |
Demographics |
xml |
Null |
Demographic information about the store such as the number of employees, annual sales and store type. For more information, see About the Store.Demographics xml Column. |
rowguid |
uniqueidentifier |
Not null |
ROWGUIDCOL number uniquely identifying the row. Used to support a merge replication sample. |
ModifiedDate |
datetime |
Not Null |
Date and time the row was last updated. |