AdventureWorks

Basic Index   Expanded Index

Table Name:Sales.SpecialOfferProduct
Description:Cross-reference table mapping products to special offer discounts.
Primary Keys:SpecialOfferID
ProductID
FieldTypeDefaultsNulls?Comments
SpecialOfferIDintNoneNoPrimary key for SpecialOfferProduct records.
ProductIDintNoneNoProduct identification number. Foreign key to Product.ProductID.
rowguiduniqueidentifier(newid())NoROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDatedatetime(getdate())NoDate and time the record was last updated.

IndexClustered?Unique?Fields
PK_SpecialOfferProduct_SpecialOfferID_ProductIDYesYesSpecialOfferID
ProductID
AK_SpecialOfferProduct_rowguidNoYesrowguid
IX_SpecialOfferProduct_ProductIDNoNoProductID

No check constraints
Internal Foreign Key ConstraintAffected FieldSource Table
FK_SpecialOfferProduct_Product_ProductIDProductIDProduction.Product
FK_SpecialOfferProduct_SpecialOffer_SpecialOfferIDSpecialOfferIDSales.SpecialOffer

Primary Key as Foreign Key ConstraintAffected TableAffected Field
FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductIDSales.SalesOrderDetailProductID
FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductIDSales.SalesOrderDetailSpecialOfferID

No triggers