Sales.SpecialOfferProduct

Table: 'Sales.SpecialOfferProduct'

4 fields. 40 bytes.

Cross-reference table mapping products to special offer discounts.

Field Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
SpecialOfferID	int				Not null	Primary key for SpecialOfferProduct records.
ProductID	int				Not null	Product identification number. Foreign key to Product.ProductID.
rowguid	uniqueidentifier			newid()	Not null	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate	datetime			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Sales.SpecialOfferProduct'

Primary Key Name	Field Names
PK_SpecialOfferProduct_SpecialOfferID_ProductID	SpecialOfferID, ProductID

Foreign keys for table 'Sales.SpecialOfferProduct', 2 items

Foreign	Primary	Key Name
SpecialOfferProduct.ProductID	Product.ProductID	FK_SpecialOfferProduct_Product_ProductID
SpecialOfferProduct.SpecialOfferID	SpecialOffer.SpecialOfferID	FK_SpecialOfferProduct_SpecialOffer_SpecialOfferID

Indexes for table 'Sales.SpecialOfferProduct', 3 items

Index Name	Description	Clustered	Unique	Fields
PK_SpecialOfferProduct_SpecialOfferID_ProductID	Clustered index created by a primary key constraint.	Yes	Yes	SpecialOfferID, ProductID
AK_SpecialOfferProduct_rowguid	Unique nonclustered index. Used to support replication samples.	No	Yes	rowguid
IX_SpecialOfferProduct_ProductID	Nonclustered index.	No	No	ProductID

Triggers for table 'Sales.SpecialOfferProduct', 1 item

Name	Description	Type	Enabled
uSpecialOfferProduct	AFTER UPDATE trigger setting the ModifiedDate column in the SpecialOfferProduct table to the current date.	after Update	Yes

Dependencies for table 'Sales.SpecialOfferProduct', 1 item

Object Name	Type	Field Name
Sales.uSpecialOfferProduct	trigger	N/A