product_prices
Price history for each product. One row is one price for one product over a date range.
- One row is
- one price for one product over a date range
- Columns
- 4
- Rows in Sample
- 2,569
- Rows in Standard
- 2,569
- Rows in Full
- 2,569
This table describes the company, not individual guests, so it is identical in all three sizes.
Columns
| Column | Type | What it holds | Values or range |
|---|---|---|---|
| product_idkey | integer | The item sold to guests. Links to products. | |
| effective_fromkey | date | First day at this price. | |
| effective_to | date | Last day at this price. Empty means current. Can be empty. | 2019-01-31 to 2025-01-31 |
| price | decimal | Menu or shelf price in dollars. | 3.25 to 144.99 |
How it connects
This table points to
- product_id matches products.product_id
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| product_id | effective_from | effective_to | price |
|---|---|---|---|
| 10001 | 2018-01-01 | 2019-01-31 | 32 |
| 10001 | 2019-02-01 | 2020-01-31 | 32.5 |
| 10001 | 2020-02-01 | 2021-01-31 | 33.25 |
| 10001 | 2021-02-01 | 2022-01-31 | 35.5 |
| 10001 | 2022-02-01 | 2023-01-31 | 36.5 |