Difference between revisions of "Sales.SpecialOfferProduct (table)"

Revision as of 07:00, 30 November 2009

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.

Dependency Type	Object Type	Referenced Object
Schema	Schema	Sales

@@ Line 89: / Line 89: @@
 | Sales.SpecialOfferProduct
 |- valign="top"
 | '''Description
 | Cross-reference table mapping products to special offer discounts.
 |-
 |}