products
Everything sold at a register: menu items and merchandise. One row is one product.
- One row is
- one product
- Columns
- 8
- Rows in Sample
- 367
- Rows in Standard
- 367
- Rows in Full
- 367
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 | Unique id for the row. | |
| product_name | text | Name. | |
| department | text | Food & Beverage or Merchandise, as classified today. | Food & Beverage; Merchandise |
| category_code | integer | Current category code. | 1100 to 2500 |
| category_name | text | Current category name. | Apparel & Headwear; Beer, Wine & Spirits; Beverages; Desserts & Sweets; Entrees; Home & Gifts; Kids Meals; Sides & Starters; Souvenirs & Collectibles; Sporting Goods; Toys & Plush |
| legacy_category_code | text | The code the old register system used for this product. | FB-ALC; FB-APP; FB-DES; FB-ENT; FB-KID; FB-NAB; FB-SNK; MR-APP; MR-CND; MR-HOM; MR-JWL; MR-PIN; MR-SOU; MR-SPT; MR-TOY |
| supplier_id | integer | Links to suppliers. | |
| introduced_date | date | Date first sold. Empty means sold since before 2018. Can be empty. | 2021-05-21 to 2022-11-01 |
How it connects
This table points to
- supplier_id matches suppliers.supplier_id
- legacy_category_code matches category_code_map.legacy_category_code
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.
| product_id | product_name | department | category_code | category_name | legacy_category_code | supplier_id | introduced_date |
|---|---|---|---|---|---|---|---|
| 10001 | Grilled Gulf Snapper | Food & Beverage | 1100 | Entrees | FB-ENT | 4 | |
| 10002 | Blackened Redfish | Food & Beverage | 1100 | Entrees | FB-ENT | 4 | |
| 10003 | Shrimp and Grits | Food & Beverage | 1100 | Entrees | FB-ENT | 4 | |
| 10004 | Seared Scallops | Food & Beverage | 1100 | Entrees | FB-ENT | 4 | |
| 10005 | Lobster Linguine | Food & Beverage | 1100 | Entrees | FB-ENT | 4 |