product_dimension

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