store_dimension

This table contains information about each brick-and-mortar store within the retail chain.

Column Name Data Type NULLs
store_key
INTEGER No
store_name
VARCHAR(64) Yes
store_number
INTEGER Yes
store_address
VARCHAR(256) Yes
store_city
VARCHAR(64) Yes
store_state
CHAR(2) Yes
store_region
VARCHAR(64) Yes
floor_plan_type
VARCHAR(32) Yes
photo_processing_type
VARCHAR(32) Yes
financial_service_type
VARCHAR(32) Yes
selling_square_footage
INTEGER Yes
total_square_footage
INTEGER Yes
first_open_date
DATE Yes
last_remodel_date
DATE Yes
number_of_employees
INTEGER Yes
annual_shrinkage
INTEGER Yes
foot_traffic
INTEGER Yes
monthly_rent_cost
INTEGER Yes