Sales SpecialOfferProduct (table)

wikibot

TableSales.SpecialOfferProduct
DescriptionCross-reference table mapping products to special offer discounts.

Columns

ColumnData TypeNullableDefaultDescription
SpecialOfferIDintnot null Primary key for SpecialOfferProduct records.
ProductIDintnot null Product identification number. Foreign key to Product.ProductID.
rowguiduniqueidentifiernot null(newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.

Primary Key

Primary KeyColumns
PK_SpecialOfferProduct_SpecialOfferID_ProductIDSpecialOfferID, ProductID

Indexes

IndexTypeColumns
AK_SpecialOfferProduct_rowguidUniquerowguid
IX_SpecialOfferProduct_ProductID ProductID

Foreign Keys

RelationColumnReferenced Column
Production.ProductProductIDProductID
Sales.SpecialOfferSpecialOfferIDSpecialOfferID

Detail Tables

Detail TableColumnReferencing Column
Sales.SalesOrderDetailSpecialOfferIDSpecialOfferID
Sales.SalesOrderDetailSpecialOfferIDSpecialOfferID

References

Dependency TypeObject TypeReferenced Object
SchemaSchemaSales