Production.ProductCostHistory
Documentation | AdventureWorks |
Schema | Production |
Name | ProductCostHistory |
Module | Manufacturing |
Changes in the cost 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 | Product cost start date. | |||||
Product cost start date. |
||||||||
3 | EndDate | datetime | Product cost end date. | |||||
Product cost end date. |
||||||||
4 | StandardCost | money | Standard cost of the product. | |||||
Standard cost of the product. |
||||||||
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.ProductCostHistory | Production.Product | Production.ProductCostHistory.ProductID = Production.Product.ProductID | FK_ProductCostHistory_Product_ProductID Foreign key constraint referencing Product.ProductID. |
|
Production.ProductCostHistory.ProductID = Production.Product.ProductID Name: FK_ProductCostHistory_Product_ProductIDForeign key constraint referencing Product.ProductID. |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PK_ProductCostHistory_ProductID_StartDate | ProductID, StartDate | Primary key (clustered) constraint | |
Primary key (clustered) constraint |
Uses
Name |
---|
Production.ProductCostHistory
|
Used by
Name |
---|
Production.ProductCostHistory
|
Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56