|
|
|
|
|
|
The Store Dimension table describes all the stores in the chain. The generated data file contains data for 250 stores by default.
Column Name |
Data Type |
Example |
Store_Key |
integer |
1 |
Store_Name |
varchar(64) |
Store1 |
Store_Number |
integer |
1 |
Store_Street_Address |
varchar(256) |
3, Main St |
Store_City |
varchar(64) |
Concord |
Store_State |
char(2) |
CA |
Store_Region |
varchar(64) |
West |
Floor_Plan_Type |
varchar(32) |
Plan1 |
Photo_Processing_Type |
varchar(32) |
Premium |
Financial_Service_Type |
varchar(32) |
None |
Selling_Square_Footage |
integer |
100 |
Total_Square_Footage |
integer |
2000 |
First_Open_Date |
date |
3-1-2004 |
Last_Remodel_Date |
date |
null |