test_site_greg


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 0
sap VARCHAR 4 √ null
status_code CHAR 4 √ null
site_status.status_code Implied Constraint R
name VARCHAR 100 √ null
address VARCHAR 70 √ null
address2 VARCHAR 35 √ null
city VARCHAR 30 √ null
state CHAR 2 √ null
zip VARCHAR 10 √ null
county VARCHAR 50 √ null
dma VARCHAR 50 √ null
dma_id INT 10 √ null
phone VARCHAR 10 √ null
fax VARCHAR 10 √ null
email VARCHAR 50 √ null
latitude DECIMAL 9,6 √ null
longitude DECIMAL 9,6 √ null
type_code CHAR 2 √ null
site_type.type_code Implied Constraint R
mall_id CHAR 6 √ null
channel_code VARCHAR 5 √ null
contract_holder_id INT 10 √ null
transaction_type_id INT 10 √ null
sqft INT 10 √ null
relo_from INT 10 √ null
date_opened DATE 10 null
date_closed DATE 10 √ null
selling_point_name VARCHAR 60 √ null
dealer_code VARCHAR 7 √ 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
dimensions VARCHAR 10 √ null
sampson_code CHAR 3 √ null
site_sampson.sampson_code Implied Constraint R
copernicus_grade VARCHAR 3 √ null
copernicus_ramp INT 10 √ null
copernicus_status CHAR 1 √ null
center_name VARCHAR 50 √ null
org_id INT 10 √ null
company_code VARCHAR 7 √ null
cost_center_code VARCHAR 7 √ null
rem_code VARCHAR 50 √ null
watson_code VARCHAR 15 √ null
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
last_modified DATETIME 19 √ null
target_area_id INT 10 √ null
bill_pay_kiosk INT 10 √ null
last_modified_project_id INT 10 √ null
timezone VARCHAR 50 √ null
blade INT 10 √ null
directional INT 10 √ null
directory INT 10 √ null
monument INT 10 √ null
pylon INT 10 √ null
sign_colors INT 10 √ null
sign_size INT 10 √ null
sign_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
window_wrap INT 10 √ null
legal_entity_id INT 10 √ null
version BIGINT 19 √ 1
close_reason_id INT 10 √ null
bilingual_collateral INT 10 √ 3
fixture_template_id BIGINT 19 √ null
qmi INT 10 √ null
sap_parent VARCHAR 4 √ null
eng_equip BIT 1 √ null
printer_bw INT 10 √ null
adt BIT 1 √ null
temp_close BIT 1 √ null
ikon_id VARCHAR 50 √ null
t_dma.ID Implied Constraint R
environ_system TEXT 65535 √ null
printer_color INT 10 √ null
monitor_15 INT 10 √ null
printer_brand VARCHAR 35 √ null
music_id INT 10 √ null
monitor_17 INT 10 √ null
mti BIT 1 √ null
bpk_wide INT 10 √ null
traffic_counter INT 10 √ null
bathroom VARCHAR 50 √ null
boh VARCHAR 500 √ null
dark_construction BIT 1 √ null
bpk_slim INT 10 √ null
telecheck_serial TEXT 65535 √ null
tills INT 10 √ null
loc_code VARCHAR 6 √ null
key_master VARCHAR 50 √ null
brand_id INT 10 1
fips VARCHAR 5 √ null
district_id INT 10 √ null
upload_speed VARCHAR 50 √ null
download_speed VARCHAR 50 √ null
samsung BIT 1 √ null
conversion_date DATE 10 √ null
liberty BIT 1 √ null
tier_one BIT 1 √ null
dealer_code_gsm VARCHAR 7 √ null
sales_point VARCHAR 50 √ null
mall_owner_id INT 10 √ null
sign_percent INT 10 √ null
apple_id INT 10 √ null
sqft_lease INT 10 √ null
special_use INT 10 √ null
alarm_company VARCHAR 50 √ null
storage_remote BIT 1 √ null
storage_remote_capacity VARCHAR 50 √ null
ceiling VARCHAR 20 √ null
ceiling_variation BIT 1 √ null
ceiling_type_id INT 10 √ null
ceiling_type_boh_id INT 10 √ null
power_pole BIT 1 √ null
panel_location INT 10 √ null
boh_lock INT 10 √ null
asset_schedule_id BIGINT 19 √ null
sign_repurpose INT 10 √ null
door_id INT 10 √ null
tbar INT 10 √ null
shipping_notes TEXT 65535 √ null
facility_renewal_notes TEXT 65535 √ null
flagship BIT 1 b'0'
default_gw VARCHAR 50 √ null
broadband INT 10 √ null
training_site BIT 1 √ b'0'
st1000 BIT 1 √ b'0'
st150 BIT 1 √ b'0'
retail_probe BIT 1 √ b'0'
playnetwork BIT 1 √ b'0'
dealer_code_univision VARCHAR 7 √ null
risk_tier INT 10 √ null
cap_robbery_index INT 10 √ null
bank INT 10 √ null
vault VARCHAR 100 √ null
flip BIT 1 √ null
original_dealer_code VARCHAR 7 √ null
POS_Name VARCHAR 50 √ null
phone_add TEXT 65535 √ null
phone_ba VARCHAR 25 √ null
circuit_ids TEXT 65535 √ null
voip BIT 1 √ null
alert_structural TEXT 65535 √ null
alert_construction TEXT 65535 √ null
alert_landlord TEXT 65535 √ null
alert_permit TEXT 65535 √ null
alert_signage TEXT 65535 √ null
power_data_solution_id INT 10 √ null
dealer_code_mpcs VARCHAR 8 √ null
shred_bin_size INT 10 √ null
shred_bin_frequency INT 10 √ null
core_drill BIT 1 √ null
raceway BIT 1 √ null
trench BIT 1 √ null
conf_rm BIT 1 √ null
basement BIT 1 √ null
train_rm INT 10 √ null
office BIT 1 √ null
ll_responsibilities TEXT 65535 √ null
site_contact_notes TEXT 65535 √ null
dealer_id_metropcs INT 10 √ null
sap_relocation VARCHAR 4 √ null
sap_closure VARCHAR 4 √ null
hispanic_designation INT 10 √ null
tyco_equip VARCHAR 50 √ null
dup_rem BIT 1 √ null
restroom_signage INT 10 √ null
link_process VARCHAR 200 √ null
link_tcommunity VARCHAR 200 √ null
sde_name VARCHAR 50 √ null
dealer_package INT 10 √ null
signal_strength VARCHAR 5 √ null
barricade_graphics BIT 1 √ null
sap_dealer VARCHAR 4 √ null
pico_decision INT 10 √ null
pico_isp VARCHAR 100 √ null
mapper_prospect_id INT 10 √ null
pico_eng_dec BIT 1 √ null
pico_dec_dealer INT 10 √ null
pico_circuit_id VARCHAR 50 √ null
t_dma.ID Implied Constraint R
pico_modem_mac VARCHAR 50 √ null
pico_bandwidth VARCHAR 50 √ null
pico_recommend INT 10 √ null
pico_lte INT 10 √ null
pico_gsm INT 10 √ null
pico_uc_sol VARCHAR 50 √ null
pico_note TEXT 65535 √ null
pico_mnc BIT 1 √ null
pico_tpr_funds BIT 1 √ null
pico_program VARCHAR 50 √ null
nokia_req BIT 1 √ null
region_repeater_pay BIT 1 √ null
dealer_base_rent DECIMAL 15,2 √ null
dealer_lease_expiration DATE 10 √ null
pico_rfd_approved BIT 1 √ null
circuit_survey INT 10 √ null
lec INT 10 √ null
lte_survey BIT 1 √ null
pico_initiator VARCHAR 50 √ null
pico_crnum VARCHAR 8 √ null
ach_payments INT 10 √ null
electronic_signature INT 10 √ null
rack VARCHAR 50 √ null
switch BIT 1 √ null
second_circuit BIT 1 √ null
sign_comp INT 10 √ null
layer3_delay_reason INT 10 √ null
layer3_notes TEXT 65535 √ null
live_tv BIT 1 √ null
demo_loop BIT 1 √ null
density_class VARCHAR 40 √ null
market_density VARCHAR 40 √ null
market_category_last VARCHAR 40 √ null
market_category_current VARCHAR 40 √ null
market_category_future VARCHAR 40 √ null
msa_name VARCHAR 80 √ null
county_fips VARCHAR 40 √ null
engineering_region VARCHAR 40 √ null
engineering_market VARCHAR 40 √ null
city_code VARCHAR 40 √ null
block_group_id VARCHAR 40 √ null
srem_blkgrp.block_group_id Implied Constraint R
msa_id INT 10 √ null
closest_att_corp_dist DECIMAL 6,2 √ null
closest_att_dealer_dist DECIMAL 6,2 √ null
closest_t_mobile_corp_dist DECIMAL 6,2 √ null
closest_t_mobile_dealer_dist DECIMAL 6,2 √ null
closest_verizon_corp_dist DECIMAL 6,2 √ null
closest_verizon_dealer_dist DECIMAL 6,2 √ null
2nd_circuit_ordered DATE 10 √ null
2nd_circuit_installed DATE 10 √ null
2nd_circuit_exception INT 10 √ null
2nd_circ_install BIT 1 √ null
L3_Cable_Sched_Date DATE 10 √ null
L3_Cable_Complete_Date DATE 10 √ null
L3_data_cable_count INT 10 √ null
tv_type VARCHAR 50 √ null
center_monument BIT 1 √ null
center_pylon BIT 1 √ null
sap_hub VARCHAR 4 √ null
layer3_id VARCHAR 20 √ null
L3_RT_Complete BIT 1 √ null
l3_rt_delay_reason INT 10 √ null
l3_rt_correct_date DATE 10 √ null
l3_conv_install_date DATE 10 √ null
dealer_month_to_month BIT 1 √ null
dealer_owned_lease BIT 1 √ null
sap_hub_relo VARCHAR 4 √ null
next_early_term_notice DATE 10 √ null
relo_request INT 10 √ null
strategy_options INT 10 √ null
lease_det_notes TEXT 65535 √ null
ren_term_req VARCHAR 150 √ null
experience BIT 1 √ null
high_slt_visibility BIT 1 √ b'0'
renewal_status_notes TEXT 65535 √ null
sprint_id INT 10 √ null
sprint_sap VARCHAR 4 √ null
sprint_location_id VARCHAR 7 √ null
sprint_treasury_id INT 10 √ null
pos_tech_stack INT 10 1
Sublease_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
Sublessee_Name VARCHAR 150 √ null
Sl_enddate DATE 10 √ null
device_repair INT 10 √ null
spnt_email VARCHAR 50 √ null
Recycle_Prg BIT 1 √ null
sl_sq_ft VARCHAR 6 √ null
sl_Occupied BIT 1 √ null
SL_nxt_renewal_opt_dtd DATE 10 √ null
Curr_SL_lease_end_date DATE 10 √ null
SL_Num_Renewals INT 10 √ null
Sl_renewal_term_yrs INT 10 √ null
Company VARCHAR 50 √ null
orig_open DATE 10 √ null
RT_Site_notes TEXT 65535 √ null
BB_survey_permitted VARCHAR 10 √ null
des_trng_loc VARCHAR 50 √ null
trainer_name VARCHAR 50 √ null
trainer_pnum VARCHAR 50 √ null
seat_cap VARCHAR 50 √ null
closest_t_mobile_store_1 INT 10 √ null
closest_t_mobile_store_2 INT 10 √ null
closest_t_mobile_store_3 INT 10 √ null
closest_t_mobile_store_4 INT 10 √ null
closest_t_mobile_store_5 INT 10 √ null
closest_t_mobile_store_1_dist DECIMAL 6,2 √ null
closest_t_mobile_store_2_dist DECIMAL 6,2 √ null
closest_t_mobile_store_3_dist DECIMAL 6,2 √ null
closest_t_mobile_store_4_dist DECIMAL 6,2 √ null
closest_t_mobile_store_5_dist DECIMAL 6,2 √ null
city_class VARCHAR 40 √ null
REMO_HC INT 10 √ null
msap INT 10 √ null
prev_door_id INT 10 √ null
dealer_name_mtmo VARCHAR 50 √ null
sub_deal_name_mtmo VARCHAR 50 √ null
metro_area VARCHAR 50 √ null
metro_market VARCHAR 50 √ null
mid_vsmc VARCHAR 25 √ null
mid_amex VARCHAR 15 √ null
mid_discover VARCHAR 15 √ null
courier_service_price DECIMAL 15,2 √ null
post_size VARCHAR 70 √ null
courier_holiday_price DECIMAL 15,2 √ null
courier_lead_time VARCHAR 5 √ null
courier_branch VARCHAR 50 √ null
bank_branch_address TEXT 65535 √ null
courier_sub VARCHAR 25 √ null
closest_t_mobile_corp INT 10 √ null
closest_t_mobile_dealer INT 10 √ null
treasury_site_notes TEXT 65535 √ null
metro_region VARCHAR 50 √ null
TMO_owned_lease BIT 1 √ null
cour_serv_days INT 10 √ null
cour_serv_time VARCHAR 20 √ null
courier_id INT 10 √ null
Major_landlord VARCHAR 150 √ null
Leadership_Laptop VARCHAR 50 √ null
agent_code VARCHAR 8 √ null
asi_number VARCHAR 50 √ null
fact_id VARCHAR 6 √ null
affiliate INT 10 √ 4
freely_trans_right BIT 1 √ null
sprint_id_original INT 10 √ null
covid_status_notif VARCHAR 10 √ null
closest_metro_store_1 INT 10 √ null
closest_metro_store_2 INT 10 √ null
closest_metro_store_3 INT 10 √ null
closest_metro_store_4 INT 10 √ null
closest_metro_store_5 INT 10 √ null
closest_metro_dealer INT 10 √ null
closest_metro_corp INT 10 √ null
closest_metro_store_1_dist DECIMAL 6,2 √ null
closest_metro_store_2_dist DECIMAL 6,2 √ null
closest_metro_store_3_dist DECIMAL 6,2 √ null
closest_metro_store_4_dist DECIMAL 6,2 √ null
closest_metro_store_5_dist DECIMAL 6,2 √ null
closest_metro_dealer_dist DECIMAL 6,2 √ null
closest_metro_corp_dist DECIMAL 6,2 √ null
exceptions VARCHAR 20 √ null
closest_uscellular_corp_dist DECIMAL 6,2 √ null
closest_uscellular_dealer_dist DECIMAL 6,2 √ null
site_design_id INT 10 √ null
closest_boost_dealer_dist DECIMAL 6,2 √ null
closest_cricket_dealer_dist DECIMAL 6,2 √ null
confidential_closure BIT 1 b'0'
hidden INT 10 √ null
visibility_group_id INT 10 √ null
spec INT 10 0

Relationships

Close relationships within degrees of separation