inventory_items
What the resort keeps in stock: ingredients, and goods bought for resale. One row is one stock item.
- One row is
- one stock item
- Columns
- 7
- Rows in Sample
- 154
- Rows in Standard
- 154
- Rows in Full
- 154
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 |
|---|---|---|---|
| item_idkey | integer | Unique id for the row. | |
| item_name | text | Name. | |
| supplier_id | integer | Links to suppliers. | |
| item_type | text | Ingredient, or resale for goods sold as bought. | ingredient; resale |
| unit_of_measure | text | Unit quantities are counted in. | bottle; box; case; dozen; each; gal; keg; lb |
| is_perishable | true/false | True when it spoils. | |
| unit_cost_2018 | decimal | Cost per unit in 2018 dollars. Cost in later years is on purchase_order_lines. | 0.7 to 128 |
How it connects
This table points to
- supplier_id matches suppliers.supplier_id
Tables that point here
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| item_id | item_name | supplier_id | item_type | unit_of_measure | is_perishable | unit_cost_2018 |
|---|---|---|---|---|---|---|
| 5001 | Turkey legs | 1 | ingredient | lb | true | 3.1 |
| 5002 | Chicken, breast and thigh | 1 | ingredient | lb | true | 2.9 |
| 5003 | Beef, steaks and ground | 1 | ingredient | lb | true | 7.8 |
| 5004 | Pork, shoulder and ribs | 1 | ingredient | lb | true | 3.6 |
| 5005 | Pasta and noodles | 1 | ingredient | lb | false | 1.4 |