Sales.Store

Generated using SQL Data Dictionary demo version.

Table Sales.Store (701 rows)

Customers (resellers) of Adventure Works products.

	Column	Data Type	Identity	Nullable	Default
PK, FK	BusinessEntityID	int
Primary key. Foreign key to Customer.BusinessEntityID.
	Name	Name(nvarchar(50))
Name of the store.
FK	SalesPersonID	int		X
ID of the sales person assigned to the customer. Foreign key to SalesPerson.BusinessEntityID.
	Demographics	xml		X
Demographic informationg about the store such as the number of employees, annual sales and store type.
UK	rowguid	uniqueidentifier			newid()
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
	ModifiedDate	datetime			getdate()
Date and time the record was last updated.

Indexes:

PK_Store_BusinessEntityID
- (Primary Key)
- (Clustered)
Primary key (clustered) constraint
- BusinessEntityID

AK_Store_rowguid
- (Unique)
Unique nonclustered index. Used to support replication samples.
- rowguid

IX_Store_SalesPersonID
Nonclustered index.
- SalesPersonID

PXML_Store_Demographics
- (XML)
Primary XML index.
- Demographics

References:

Person.BusinessEntity
- BusinessEntityID

Sales.SalesPerson
- BusinessEntityID (SalesPersonID)

Referenced by:

Sales.Customer
- StoreID (BusinessEntityID)

Used by:

Function
dbo.ufnGetContactInformation
- BusinessEntityID
View
Sales.vStoreWithAddresses
- BusinessEntityID
- Name
View
Sales.vStoreWithContacts
- BusinessEntityID
- Name
View
Sales.vStoreWithDemographics
- BusinessEntityID
- Demographics
- Name