Sales.SpecialOfferProduct (table)

From dbscript Online Help
Revision as of 23:06, 2 February 2010 by Bot (talk | contribs)
Jump to: navigation, search

wikibot

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


Columns

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

Primary Key

Primary Key Columns
PK_SpecialOfferProduct_SpecialOfferID_ProductID SpecialOfferID, ProductID

Indexes

Index Type Columns
AK_SpecialOfferProduct_rowguid Unique rowguid
IX_SpecialOfferProduct_ProductID ProductID

Foreign Keys

Relation Column Referenced Column
Production.Product ProductID ProductID
Sales.SpecialOffer SpecialOfferID SpecialOfferID

Detail Tables

Detail Table Column Referencing Column
Sales.SalesOrderDetail SpecialOfferID SpecialOfferID
Sales.SalesOrderDetail SpecialOfferID SpecialOfferID

References

Dependency Type Object Type Referenced Object
Schema Schema Sales


automatically generated

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.


Relation Column Referenced Column
Production.Product ProductID ProductID
Sales.SpecialOffer SpecialOfferID SpecialOfferID


Detail Table Column Referencing Column
Sales.SalesOrderDetail SpecialOfferID SpecialOfferID
Sales.SalesOrderDetail SpecialOfferID SpecialOfferID


Dependency Type Object Type Referenced Object
Schema Schema Sales