Production.ProductListPriceHistory
Documentation | AdventureWorks |
Schema | Production |
Name | ProductListPriceHistory |
Module | Manufacturing |
Changes in the list price of a product over time.
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | ProductID | int | Production.Product | Product identification number. Foreign key to Product.ProductID | ||||
Product identification number. Foreign key to Product.ProductID References: Production.Product |
||||||||
2 | StartDate | datetime | List price start date. | |||||
List price start date. |
||||||||
3 | EndDate | datetime | List price end date | |||||
List price end date |
||||||||
4 | ListPrice | money | Product list price. | |||||
Product list price. |
||||||||
5 | ModifiedDate | datetime | Default: getdate() | Date and time the record was last updated. | ||||
Date and time the record was last updated. Default: getdate() |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
Production.ProductListPriceHistory | Production.Product | Production.ProductListPriceHistory.ProductID = Production.Product.ProductID | FK_ProductListPriceHistory_Product_ProductID Foreign key constraint referencing Product.ProductID. |
|
Production.ProductListPriceHistory.ProductID = Production.Product.ProductID Name: FK_ProductListPriceHistory_Product_ProductIDForeign key constraint referencing Product.ProductID. |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PK_ProductListPriceHistory_ProductID_StartDate | ProductID, StartDate | Primary key (clustered) constraint | |
Primary key (clustered) constraint |
Uses
Name |
---|
Production.ProductListPriceHistory
|
Used by
Name |
---|
Production.ProductListPriceHistory
|
Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56