AdventureWorks
| Table Name: | Sales.SpecialOfferProduct |
| Description: | Cross-reference table mapping products to special offer discounts. |
| Primary Keys: | SpecialOfferID ProductID |
| Field | Type | Defaults | Nulls? | Comments |
|---|---|---|---|---|
| SpecialOfferID | int | None | No | Primary key for SpecialOfferProduct records. |
| ProductID | int | None | No | Product identification number. Foreign key to Product.ProductID. |
| rowguid | uniqueidentifier | (newid()) | No | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| ModifiedDate | datetime | (getdate()) | No | Date and time the record was last updated. |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_SpecialOfferProduct_SpecialOfferID_ProductID | Yes | Yes | SpecialOfferID ProductID |
| AK_SpecialOfferProduct_rowguid | No | Yes | rowguid |
| IX_SpecialOfferProduct_ProductID | No | No | ProductID |
| Internal Foreign Key Constraint | Affected Field | Source Table |
|---|---|---|
| FK_SpecialOfferProduct_Product_ProductID | ProductID | Production.Product |
| FK_SpecialOfferProduct_SpecialOffer_SpecialOfferID | SpecialOfferID | Sales.SpecialOffer |
| Primary Key as Foreign Key Constraint | Affected Table | Affected Field |
|---|---|---|
| FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID | Sales.SalesOrderDetail | ProductID |
| FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID | Sales.SalesOrderDetail | SpecialOfferID |