Sales.SpecialOfferProduct (table)

From dbscript Online Help
Jump to: navigation, search

wikibot[edit]

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

Columns[edit]

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[edit]

Primary Key Columns
PK_SpecialOfferProduct_SpecialOfferID_ProductID SpecialOfferID, ProductID

Indexes[edit]

Index Type Columns
AK_SpecialOfferProduct_rowguid Unique rowguid
IX_SpecialOfferProduct_ProductID ProductID

Foreign Keys[edit]

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

Detail Tables[edit]

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

References[edit]

Dependency Type Object Type Referenced Object
Schema Schema Sales


automatically generated[edit]

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