product_dimension
This table describes all products sold by the department store chain.
This table describes all products sold by the department store chain.
| Column Name | Data Type | NULLs |
product_key |
INTEGER | No |
product_version |
INTEGER | No |
product_description |
VARCHAR(128) | Yes |
sku_number |
CHAR(32) | Yes |
category_description |
CHAR(32) | Yes |
department_description |
CHAR(32) | Yes |
package_type_description |
CHAR(32) | Yes |
package_size |
CHAR(32) | Yes |
fat_content |
INTEGER | Yes |
diet_type |
CHAR(32) | Yes |
weight |
INTEGER | Yes |
weight_units_of_measure |
CHAR(32) | Yes |
shelf_width |
INTEGER | Yes |
shelf_height |
INTEGER | Yes |
shelf_depth |
INTEGER | Yes |
product_price |
INTEGER | Yes |
product_cost |
INTEGER | Yes |
lowest_competitor_price |
INTEGER | Yes |
highest_competitor_price |
INTEGER | Yes |
average_competitor_price |
INTEGER | Yes |
discontinued_flag |
INTEGER | Yes |