v_stores_all


Columns

Column Type Size Nulls Auto Default Children Parents Comments
store_id INT 10 0
sap VARCHAR 4 √ null
status_code CHAR 4 √ null
site_status.status_code Implied Constraint R
status VARCHAR 50 √ null
name VARCHAR 50 √ null
address VARCHAR 70 √ null
address2 VARCHAR 35 √ null
city VARCHAR 30 √ null
state CHAR 2 √ null
zip VARCHAR 10 √ null
brand VARCHAR 40 √ null
intersection BINARY 0 √ null
county VARCHAR 50 √ null
dma VARCHAR 50 √ null
phone VARCHAR 10 √ null
fax VARCHAR 10 √ null
email VARCHAR 50 √ null
latitude DECIMAL 9,6 √ null
longitude DECIMAL 9,6 √ null
date_opened DATE 10 null
date_closed DATE 10 √ null
risk_status INT 10 √ 0
type_code CHAR 2 √ null
site_type.type_code Implied Constraint R
location_type VARCHAR 50 √ null
mall_id CHAR 6 √ null
channel_code VARCHAR 5 √ null
channel VARCHAR 50 √ null
hubspoke_id BINARY 0 √ null
sqft INT 10 √ null
relo_from INT 10 √ null
transaction_type_id INT 10 √ null
transaction_type VARCHAR 50 √ null
space_status_id INT 10 √ null
space_status VARCHAR 50 √ null
dealer_code VARCHAR 7 √ null
selling_point_name VARCHAR 60 √ null
contract_holder_id INT 10 √ null
contract_holder VARCHAR 50 √ null
scorecard_result VARCHAR 10 √ null
selling_point_id VARCHAR 15 √ null
design_code CHAR 2 √ null
site_design_backup.design_code Implied Constraint R
retail_sqft INT 10 √ null
price_per_foot DECIMAL 15,2 √ null
dimensions VARCHAR 10 √ null
sampson_code CHAR 3 √ null
site_sampson.sampson_code Implied Constraint R
turnover_condition_id INT 10 √ null
sign_criteria_available INT 10 √ null
visibility VARCHAR 255 √ null
visibility_ranking CHAR 1 √ null
access VARCHAR 255 √ null
access_ranking CHAR 1 √ null
signage VARCHAR 255 √ null
signage_ranking CHAR 1 √ null
parking VARCHAR 255 √ null
parking_ranking CHAR 1 √ null
traffic VARCHAR 255 √ null
traffic_ranking CHAR 1 √ null
overall_re_ranking CHAR 1 √ null
demographics_ranking CHAR 1 √ null
copernicus_grade VARCHAR 3 √ null
copernicus_ramp INT 10 √ null
copernicus_status CHAR 1 √ null
center_name VARCHAR 50 √ null
landlord VARCHAR 100 √ null
anchor_tenants VARCHAR 255 √ null
other_co_tenants VARCHAR 255 √ null
1_mile_pop INT 10 √ null
2_mile_pop INT 10 √ null
3_mile_pop INT 10 √ null
5_mile_pop INT 10 √ null
1_mile_daytime_pop INT 10 √ 0
2_mile_daytime_pop INT 10 √ 0
3_mile_daytime_pop INT 10 √ 0
5_mile_daytime_pop INT 10 √ 0
1_mile_hispanic_pop INT 10 √ 0
2_mile_hispanic_pop INT 10 √ 0
3_mile_hispanic_pop INT 10 √ 0
5_mile_hispanic_pop INT 10 √ 0
1_mile_white_pop INT 10 √ 0
2_mile_white_pop INT 10 √ 0
3_mile_white_pop INT 10 √ 0
5_mile_white_pop INT 10 √ 0
1_mile_black_pop INT 10 √ 0
2_mile_black_pop INT 10 √ 0
3_mile_black_pop INT 10 √ 0
5_mile_black_pop INT 10 √ 0
1_mile_asian_pop INT 10 √ 0
2_mile_asian_pop INT 10 √ 0
3_mile_asian_pop INT 10 √ 0
5_mile_asian_pop INT 10 √ 0
1_mile_median_age INT 10 √ 0
2_mile_median_age INT 10 √ 0
3_mile_median_age INT 10 √ 0
5_mile_median_age INT 10 √ 0
1_mile_median_household_inc INT 10 √ 0
2_mile_median_household_inc INT 10 √ 0
3_mile_median_household_inc INT 10 √ 0
5_mile_median_household_inc INT 10 √ 0
1_mile_blue_collar_occ INT 10 √ 0
2_mile_blue_collar_occ INT 10 √ 0
3_mile_blue_collar_occ INT 10 √ 0
5_mile_blue_collar_occ INT 10 √ 0
1_mile_bachelors_degree INT 10 √ 0
2_mile_bachelors_degree INT 10 √ 0
3_mile_bachelors_degree INT 10 √ 0
5_mile_bachelors_degree INT 10 √ 0
1_mile_total_households INT 10 √ 0
2_mile_total_households INT 10 √ 0
3_mile_total_households INT 10 √ 0
5_mile_total_households INT 10 √ 0
1_mile_pct_hh_with_2plus BINARY 0 √ null
2_mile_pct_hh_with_2plus BINARY 0 √ null
3_mile_pct_hh_with_2plus BINARY 0 √ null
5_mile_pct_hh_with_2plus BINARY 0 √ null
1_mile_avg_hh_size DECIMAL 19,6 √ 0.000000
2_mile_avg_hh_size DECIMAL 19,6 √ 0.000000
3_mile_avg_hh_size DECIMAL 19,6 √ 0.000000
5_mile_avg_hh_size DECIMAL 19,6 √ 0.000000
dead_date DATE 10 √ null
dead_reason_id INT 10 √ null
dead_reason VARCHAR 50 √ null
dead_notes VARCHAR 200 √ null
org_id INT 10 √ null
level3 VARCHAR 60 √ null
level2 VARCHAR 60 √ null
level1 VARCHAR 60 √ null
cap_robbery_index BINARY 0 √ null
company_code VARCHAR 7 √ null
cost_center_code VARCHAR 7 √ null
fixture_prm_id VARCHAR 15 √ null
fixture_vendor BINARY 0 √ null
flex_pay INT 10 √ 0
folder_filed INT 10 √ 0
hamilton_mti_tracking_num VARCHAR 100 √ null
hotspot_location INT 10 √ 0
initial_inventory_tracking_info VARCHAR 255 √ null
kiosk_showroom INT 10 √ 0
kiosk_type VARCHAR 100 √ null
lepa_mdf_per_location INT 10 √ null
loaner_program INT 10 √ 0
main_language_id INT 10 √ null
mdf_allocation_fixtures DECIMAL 15,2 √ null
mdf_allocation_signage DECIMAL 15,2 √ null
mdf_spent_fixtures DECIMAL 15,2 √ null
mdf_spent_signage DECIMAL 15,2 √ null
mdf_spent_total DECIMAL 15,2 √ null
merchandise_ranking CHAR 1 √ null
num_exterior_building_signs INT 10 √ null
num_live_handsets_requested INT 10 √ null
num_monument_pylon_signs INT 10 √ null
p900_printer BINARY 0 √ null
payment_vendor_id INT 10 √ null
phonesync_cellebrite_serial_num VARCHAR 50 √ null
pos_count INT 10 √ null
prepay_only INT 10 √ 0
project_status_id BINARY 0 √ null
relo_status_id VARCHAR 25 √ null
relo_type_id INT 10 √ null
rem_code VARCHAR 50 √ null
retailer_dealer_program_id BINARY 0 √ null
rrd_channel_id INT 10 √ null
rrd_tracking_num VARCHAR 255 √ null
rubbermaid_card_order_num INT 10 √ null
sap_security_role INT 10 √ 0
sap_security_ticket_num INT 10 √ null
security_company VARCHAR 50 √ null
sign_auditor VARCHAR 50 √ null
signage_prm_id VARCHAR 15 √ null
signage_vendor BINARY 0 √ null
sp_exclusivity_id INT 10 √ null
sp_primary_industry_id INT 10 √ null
staples_tracking INT 10 √ null
state_loc_code BINARY 0 √ null
status_call_num INT 10 √ null
storage_space_type_id INT 10 √ null
store_pinned INT 10 √ 0
store_security_package CHAR 1 √ null
t380_terminal VARCHAR 50 √ null
technology_package_id INT 10 √ null
telecheck_machine INT 10 √ null
till_fund_tracking VARCHAR 50 √ null
total_fixture_quote DECIMAL 15,2 √ null
total_mdf_allocation DECIMAL 15,2 √ null
total_sign_quote DECIMAL 15,2 √ null
treat_as_new BINARY 0 √ null
vender_brokerage_company VARCHAR 50 √ null
watson_code VARCHAR 15 √ null
on_hold INT 10 √ 0
hours_sun INT 10 √ 0
hours_mon INT 10 √ 0
hours_tue INT 10 √ 0
hours_wed INT 10 √ 0
hours_thu INT 10 √ 0
hours_fri INT 10 √ 0
hours_sat INT 10 √ 0
photo_a BINARY 0 √ null
photo_b BINARY 0 √ null
milestone_comments VARCHAR 2000 √ null
target_area_id INT 10 √ null
last_modified DATETIME 19 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views