Sales.SpecialOfferProduct (table)

wikibot

Table

Sales.SpecialOfferProduct

Column	Data Type	Nullable	Default	PK	Index
SpecialOfferID	int	not null		PK_SpecialOfferProduct_SpecialOfferID_ProductID
ProductID	int	not null		PK_SpecialOfferProduct_SpecialOfferID_ProductID	IX_SpecialOfferProduct_ProductID
rowguid	uniqueidentifier	not null	(newid())		AK_SpecialOfferProduct_rowguid
ModifiedDate	datetime	not null	(getdate())

Table	Sales.SpecialOfferProduct
Description	Cross-reference table mapping products to special offer discounts.

Column	Data Type	Nullable	Default	Description / PK / Index
SpecialOfferID	int	not null		Primary key for SpecialOfferProduct records. PK_SpecialOfferProduct_SpecialOfferID_ProductID
ProductID	int	not null		Product identification number. Foreign key to Product.ProductID. PK_SpecialOfferProduct_SpecialOfferID_ProductIDIX_SpecialOfferProduct_ProductID
rowguid	uniqueidentifier	not null	(NEWID())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. AK_SpecialOfferProduct_rowguid
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.