Tables | SQL 2005 Adventure Works OLTP |
Cross-reference table mapping products to special offer discounts.
Columns
Name Data type Nullable Description SpecialOfferID int No Primary key for SpecialOfferProduct records. ProductID int No Product identification number. Foreign key to Product.ProductID. rowguid uniqueidentifier No Default value: NEWID()
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.ModifiedDate datetime No Default value: GETDATE()
Date and time the record was last updated.
Constraints
Name Type Columns Description DF_SpecialOfferProduct_rowguid DEFAULT rowguid Value: NEWID()
Default constraint value of NEWID()DF_SpecialOfferProduct_ModifiedDate DEFAULT ModifiedDate Value: GETDATE()
Default constraint value of GETDATE()PK_SpecialOfferProduct_SpecialOfferID_ProductID PRIMARY KEY SpecialOfferID
ProductIDClustered index created by a primary key constraint. FK_SpecialOfferProduct_Product_ProductID FOREIGN KEY ProductID Reference table: Production.Product
Foreign key constraint referencing Product.ProductID.FK_SpecialOfferProduct_SpecialOffer_SpecialOfferID FOREIGN KEY SpecialOfferID Reference table: Sales.SpecialOffer
Foreign key constraint referencing SpecialOffer.SpecialOfferID.
Indices
Name Description AK_SpecialOfferProduct_rowguid Unique nonclustered index.Used to support replication samples. IX_SpecialOfferProduct_ProductID Nonclustered index.
Triggers
Name Description Sales.uSpecialOfferProduct AFTER UPDATE trigger setting the ModifiedDate column in the SpecialOfferProduct table to the current date.
Linked tables
Name Description Sales.SalesOrderDetail Individual products associated with a specific sales order. See SalesOrderHeader.
Modified by
Name Description Sales.uSpecialOfferProduct AFTER UPDATE trigger setting the ModifiedDate column in the SpecialOfferProduct table to the current date.
Applies to
Tables | User