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