AdventureWorks
| Table Name: | Production.ProductListPriceHistory |
| Description: | Changes in the list price of a product over time. |
| Primary Keys: | ProductID StartDate |
| Field | Type | Defaults | Nulls? | Comments |
|---|---|---|---|---|
| ProductID | int | None | No | Product identification number. Foreign key to Product.ProductID |
| StartDate | datetime | None | No | List price start date. |
| EndDate | datetime | None | Yes | List price end date |
| ListPrice | money | None | No | Product list price. |
| ModifiedDate | datetime | (getdate()) | No | Date and time the record was last updated. |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_ProductListPriceHistory_ProductID_StartDate | Yes | Yes | ProductID StartDate |
| Check Constraint | Text |
|---|---|
| CK_ProductListPriceHistory_EndDate | ([EndDate]>=[StartDate] OR [EndDate] IS NULL) |
| CK_ProductListPriceHistory_ListPrice | ([ListPrice]>(0.00)) |
| Internal Foreign Key Constraint | Affected Field | Source Table |
|---|---|---|
| FK_ProductListPriceHistory_Product_ProductID | ProductID | Production.Product |