| Column | Data Type | Nullable | Default | Description / PK / Index |
| ProductID | int | not null | | Product identification number. Foreign key to Product.ProductID
PK_ProductCostHistory_ProductID_StartDate |
| StartDate | datetime | not null | | Product cost start date.
PK_ProductCostHistory_ProductID_StartDate |
| EndDate | datetime | null | | Product cost end date.
|
| StandardCost | money | not null | | Standard cost of the product.
|
| ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated.
|