Generated using SQL Data Dictionary demo version.
Changes in the cost of a product over time.
Column | Data Type | Identity | Nullable | Default | |
---|---|---|---|---|---|
PK, FK | ProductID | int | |||
Product identification number. Foreign key to Product.ProductID | |||||
PK | StartDate | datetime | |||
Product cost start date. | |||||
EndDate | datetime | X | |||
Product cost end date. | |||||
StandardCost | money | ||||
Standard cost of the product. | |||||
ModifiedDate | datetime | getdate() | |||
Date and time the record was last updated. |
Primary key (clustered) constraint