|
|
|
|
|
|
The Product Dimension table describes all products sold by the grocery chain since its beginning. Typically, individual stores only carry a subset of the products. The generated data file contains data for 60,000 products by default.
Column Name |
Data Type |
Example |
Product_Key |
integer |
1 |
Product_Description |
varchar(128) |
Seafood Product 1 |
SKU_Number |
char(32) |
SKU-#1 |
Category_Description |
char(32) |
Food |
Department_Description |
char(32) |
Seafood |
Package_Type_Description |
char(32) |
Box |
Package_Size |
char(32) |
18 ox |
Fat_Content |
integer |
89 |
Diet_Type |
char(32) |
South Beach |
Weight |
integer |
50 |
Weight_Units_of_Measure |
char(32) |
gram |
Shelf_Width |
integer |
2 |
Shelf_Height |
integer |
4 |
Shelf_Depth |
integer |
4 |