store_dimension
This table contains information about each brick-and-mortar store within the retail chain.
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 |