Share via


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.