product_ingredients
The recipe: how much of each stock item one sale of a product uses. One row is one stock item in one product.
- One row is
- one stock item in one product
- Columns
- 3
- Rows in Sample
- 643
- Rows in Standard
- 643
- Rows in Full
- 643
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. | |
| item_idkey | integer | The stock item. Links to inventory_items. | |
| quantity_per_unit | decimal | Units of the stock item used per unit of product sold. | 0 to 6.22 |
How it connects
This table points to
- product_id matches products.product_id
- item_id matches inventory_items.item_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 | item_id | quantity_per_unit |
|---|---|---|
| 10001 | 5022 | 0.71 |
| 10001 | 5009 | 0.04 |
| 10001 | 5047 | 0.8 |
| 10002 | 5023 | 0.76 |
| 10002 | 5009 | 0.04 |