site


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
asset_schedule.site_id FK7A00270692D2B99F R
asset_warranty.site_id FKC17E956B92D2B99F R
closest_competitor.site_id closest_competitor_ibfk_1 R
dealer_request.site_id FK_6vk6apfsdke1b4peshpm3vg92 R
demographic.site_id demographic_ibfk_1 R
iterative_note.site_id FK_1rbchtfwnf0ikagy7g1r88vpg R
ivueit_survey_request.site_id FK_survey_request_site_id R
manual_task.store_id fk_manual_task_site_idx R
project.site_id FK_dtydefwc4byv5kfrx2hbh4bgc R
project_field_pending_change_request.site_id FK_project_field_pending_change_site R
project_log.site_id FKC7FFE91E92D2B99F R
project_message.site_id FK_project_messge_site R
proximity.site_id proximity_ibfk_1 R
site_contact.site_id FK7C28732892D2B99F R
site_data.id FK_site_data_site C
site_fixtures.site_id FK143DD98292D2B99F R
site_folder.site_id FK9581CC6692D2B99F R
site_geocoding_data.site_id FK_r5lpqse06eo5tm60d9sn5ufrr R
site_item.site_id FKE031C90B92D2B99F R
site_reverse_geocoding_data.site_id FK_nqcd5x6eaxc48f62g1cn6wsnm R
site_support.site_id FKD4E3CED792D2B99F R
site_temp_closure.site_id FK_rah6hfp1ceaq9two3soq6rqgl R
warranty_log.site_id FK_dx6xb8auqdcnx3x4h3e4td8bs R
sap VARCHAR 4 √ null
status_code CHAR 4 √ null
site_status.status_code FK_dhsqtbvphnwwjlp3ch7y57iwh R
name VARCHAR 50 √ 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 FK_3bauynt93kvbdf94e4yud4opi R
mall_id CHAR 6 √ null
channel_code VARCHAR 5 √ null
site_channel.channel_code FK35DF47353BF280 R
contract_holder_id INT 10 √ null
site_contract_holder.contract_holder_id FK_6u67gre7a58mhug4vrc57jolh R
transaction_type_id INT 10 √ null
site_transaction_type.id FK_nkh33tq23qmkqt4ub742jxyom R
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
project.id FK_2wtpkmhjialxvhfvg3hbcb5da R
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
legal_lease_entities.id FK_emy8k04nyd6wf0dtmudap9ufi R
version BIGINT 19 √ 1
close_reason_id INT 10 √ null
site_closure_reason.id FK_agoj59n9fmf143n32we9kluuc R
bilingual_collateral INT 10 √ 3
fixture_template_id BIGINT 19 √ null
fixture_templates.id FK_86gbf7pver21drcga9ycsba7i R
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
site_brand.id FK_site_site_brand R
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
asset_schedule.id FK_ek7j9lif1jxhl6cpow03wslu5 R
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
cbsa_name VARCHAR 160 √ 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
cbsa_id INT 10 √ 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 VARCHAR 7 √ 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
sublease_type.id FK_51hh7krapcdkfxc03h4upb2tk 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
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
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
exceptions VARCHAR 20 √ null
site_design_id INT 10 √ null
confidential_closure BIT 1 b'0'
hidden INT 10 √ null
visibility_group_id INT 10 √ null
site_visibility_group.id FK_nq0y3s90v1212ber41obay71f R
spec INT 10 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
channel_code Performance Asc channel_code
design_code Performance Asc design_code
FK35DF471D78AEA2 Performance Asc close_reason_id
FK35DF47353BF280 Performance Asc channel_code
FK35DF47371A9D90 Performance Asc last_modified_project_id
FK35DF473BC330D7 Performance Asc legal_entity_id
FK35DF473CE55FC6 Performance Asc fixture_template_id
FK35DF476284F41D Performance Asc contract_holder_id
FK35DF4778FAA95B Performance Asc asset_schedule_id
FK35DF47969CD684 Performance Asc org_id
FK35DF4796D169B8 Performance Asc type_code
FK35DF47D82C21B8 Performance Asc status_code
FK35DF47DA4EA0EB Performance Asc transaction_type_id
FK_51hh7krapcdkfxc03h4upb2tk Performance Asc Sublease_type
FK_nq0y3s90v1212ber41obay71f Performance Asc visibility_group_id
FK_site_site_brand Performance Asc brand_id
idx_dma Performance Asc dma_id
idx_fips Performance Asc fips
idx_site Performance Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc id + door_id + longitude + latitude + name + brand_id + channel_code + sap
IX_site_rem_code Performance Asc rem_code
name Must be unique Asc name
sampson_code Performance Asc sampson_code
sap Performance Asc sap
status_code Performance Asc/Asc/Asc status_code + id + sap

Relationships

Close relationships within degrees of separation