Generated using SQL Data Dictionary demo version.
Changes in the list price 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 | |||
List price start date. | |||||
EndDate | datetime | X | |||
List price end date | |||||
ListPrice | money | ||||
Product list price. | |||||
ModifiedDate | datetime | getdate() | |||
Date and time the record was last updated. |
Primary key (clustered) constraint