Sales.SpecialOfferProduct - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	Sales
Name	SpecialOfferProduct
Module	Sales

Cross-reference table mapping products to special offer discounts.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		SpecialOfferID	int			Sales.SpecialOffer	Primary key for SpecialOfferProduct records.
Primary key for SpecialOfferProduct records. References: Sales.SpecialOffer
	2		ProductID	int			Production.Product	Product identification number. Foreign key to Product.ProductID.
Product identification number. Foreign key to Product.ProductID. References: Production.Product
	3		rowguid	uniqueidentifier		Default: newid()		ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. Default: newid()
	4		ModifiedDate	datetime		Default: getdate()		Date and time the record was last updated.
Date and time the record was last updated. Default: getdate()

Relations

Foreign table		Primary table	Join	Title / Name / Description
Sales.SpecialOfferProduct		Production.Product	Sales.SpecialOfferProduct.ProductID = Production.Product.ProductID	FK_SpecialOfferProduct_Product_ProductID Foreign key constraint referencing Product.ProductID.
Sales.SpecialOfferProduct.ProductID = Production.Product.ProductID Name: FK_SpecialOfferProduct_Product_ProductID Foreign key constraint referencing Product.ProductID.
Sales.SpecialOfferProduct		Sales.SpecialOffer	Sales.SpecialOfferProduct.SpecialOfferID = Sales.SpecialOffer.SpecialOfferID	FK_SpecialOfferProduct_SpecialOffer_SpecialOfferID Foreign key constraint referencing SpecialOffer.SpecialOfferID.
Sales.SpecialOfferProduct.SpecialOfferID = Sales.SpecialOffer.SpecialOfferID Name: FK_SpecialOfferProduct_SpecialOffer_SpecialOfferID Foreign key constraint referencing SpecialOffer.SpecialOfferID.
Sales.SalesOrderDetail		Sales.SpecialOfferProduct	Sales.SalesOrderDetail.SpecialOfferID = Sales.SpecialOfferProduct.SpecialOfferID Sales.SalesOrderDetail.ProductID = Sales.SpecialOfferProduct.ProductID	FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID Foreign key constraint referencing SpecialOfferProduct.SpecialOfferIDProductID.
Sales.SalesOrderDetail.SpecialOfferID = Sales.SpecialOfferProduct.SpecialOfferID Sales.SalesOrderDetail.ProductID = Sales.SpecialOfferProduct.ProductID Name: FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID Foreign key constraint referencing SpecialOfferProduct.SpecialOfferIDProductID.

Unique keys

	Key name	Columns	Description
	PK_SpecialOfferProduct_SpecialOfferID_ProductID	SpecialOfferID, ProductID	Primary key (clustered) constraint
Primary key (clustered) constraint
	AK_SpecialOfferProduct_rowguid	rowguid	Unique nonclustered index. Used to support replication samples.
Unique nonclustered index. Used to support replication samples.

Uses

Name
Sales.SpecialOfferProduct
Production.Product
Sales.SpecialOffer

Used by

Name
Sales.SpecialOfferProduct
Sales.SalesOrderDetail

Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56