site_extension


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
sprint_bank VARCHAR 20 √ null
sprint_bank_sub_acct VARCHAR 50 √ null
sprint_vault VARCHAR 100 √ null
sprint_courier_branch VARCHAR 100 √ null
sprint_courier_lead VARCHAR 5 √ null
sprint_courier_sub VARCHAR 25 √ null
sprint_courier_days VARCHAR 20 √ null
national_retailer BIT 1 √ null
dev_rep_loc VARCHAR 10 √ null
site_accessory_tier.loc Implied Constraint R
sprint_mid_amex VARCHAR 25 √ null
sprint_mid_discover VARCHAR 25 √ null
sprint_mid_vsmc VARCHAR 25 √ null
sprint_deposit_ticket VARCHAR 50 √ null
deposit_ticket VARCHAR 50 √ null
met_ll_data TEXT 65535 √ null
sprint_bank_branch TEXT 65535 √ null
lur_rent_notes TEXT 65535 √ null
lur_rent_obtained BIT 1 √ null
lur_rent_tia_free_rent_notes TEXT 65535 √ null
lur_rent_tia_free_rent_obtained BIT 1 √ null
lur_parking_pylon BIT 1 √ null
lur_parking_pylon_obtained BIT 1 √ null
lur_parking_pylon_have BIT 1 √ null
lur_parking_pylon_need BIT 1 √ null
lur_permit_use_obtained BIT 1 √ null
lur_rt_have BIT 1 √ null
lur_rt_need BIT 1 √ null
lur_rt_obtained BIT 1 √ null
lur_esign_have BIT 1 √ null
lur_esign_need BIT 1 √ null
lur_esign_obtained BIT 1 √ null
lur_tradename_have BIT 1 √ null
lur_tradename_need BIT 1 √ null
lur_tradename_obtained BIT 1 √ null
lur_relocationright_have BIT 1 √ null
lur_relocationright_need BIT 1 √ null
lur_relocationright_obtained BIT 1 √ null
lur_rightoffirstrefusal_have BIT 1 √ null
lur_rightoffirstrefusal_need BIT 1 √ null
lur_rightoffirstrefusal_obtained BIT 1 √ null
lur_ach_have BIT 1 √ null
lur_ach_need BIT 1 √ null
lur_ach_obtained BIT 1 √ null
lur_terminationrights_have BIT 1 √ null
lur_terminationrights_need BIT 1 √ null
lur_terminationrights_obtained BIT 1 √ null
lur_godark_have BIT 1 √ null
lur_godark_need BIT 1 √ null
lur_godark_obtained BIT 1 √ null
lur_exclusivity_have BIT 1 √ null
lur_exclusivity_need BIT 1 √ null
lur_exclusivity_obtained BIT 1 √ null
lur_assignmentlanguage_have BIT 1 √ null
lur_assignmentlanguage_need BIT 1 √ null
lur_assignmentlanguage_obtained BIT 1 √ null
lur_term_notes TEXT 65535 √ null
dep_slp_req_sprint BIT 1 √ null
mailstop VARCHAR 50 √ null
lur_term_obtained BIT 1 √ null
optimization_closure1 VARCHAR 50 √ null
optimization_closure3 VARCHAR 50 √ null
optimization_closure4 VARCHAR 50 √ null
optimization_closure5 VARCHAR 50 √ null
optimization_closure2 VARCHAR 50 √ null
vendor_id INT 10 √ null
arms_loc_id INT 10 √ null
business_unit VARCHAR 4 √ null
operating_unit INT 10 √ null
screen_repair BIT 1 √ null
geocode VARCHAR 200 √ null
rms_instance INT 10 √ null
infocell_region VARCHAR 50 √ null
infocell_id VARCHAR 2 √ null
scid TEXT 65535 √ null
location_ba_id INT 10 √ null
channel_o_code INT 10 √ null
ipop_store_num INT 10 √ null
ipop_store_id INT 10 √ null
site_strategy VARCHAR 5 √ null
dep_slp_req BIT 1 √ null
tp_previous_record_id VARCHAR 50 √ null
t_dma.ID Implied Constraint R
tp_ida_market VARCHAR 50 √ null
tp_door_code VARCHAR 50 √ null
metro_srs.door_code Implied Constraint R
tp_dealer VARCHAR 50 √ null
tp_cost_center VARCHAR 50 √ null
tp_account_id VARCHAR 50 √ null
t_dma.ID Implied Constraint R
tp_status VARCHAR 50 √ null
tp_ida_market_type VARCHAR 50 √ null
tp_lease_expiration_date DATE 10 √ null
tp_ending_rent VARCHAR 50 √ null
tp_location_desc VARCHAR 50 √ null
tp_lead_record_type VARCHAR 50 √ null
tp_targeted_open_date DATE 10 √ null
tp_change_ownership VARCHAR 50 √ null
tp_relo_effective_date DATE 10 √ null
tp_termination_date DATE 10 √ null
tp_reason_termination VARCHAR 50 √ null
tp_suspension_start_date DATE 10 √ null
tp_suspension_end_date DATE 10 √ null
tp_reason_suspension VARCHAR 50 √ null
tp_last_day_sale VARCHAR 50 √ null
tp_apple_active VARCHAR 50 √ null
tp_dswc_active VARCHAR 50 √ null
tp_broadtech VARCHAR 50 √ null
tp_lease_type VARCHAR 50 √ null
tp_lease_renewal_terms VARCHAR 50 √ null
tp_affiliate VARCHAR 50 √ null
tp_temp_change_request_info VARCHAR 50 √ null
Sec_alm_num VARCHAR 30 √ null
Fire_alm_num VARCHAR 30 √ null
prop_dlr_ls_end_date DATE 10 √ null
rural_mkt_goal BIT 1 b'0'
plan_rec INT 10 √ null
ssr_tab_1 BIT 1 √ null
sis_match_id INT 10 √ null
tp_sub_dealer VARCHAR 50 √ null
tp_owner VARCHAR 50 √ null
eight_hundred_mhz_equip BIT 1 √ null
Eng_review_date DATE 10 √ null
tp_ds_contact VARCHAR 50 √ null
tp_ds_email VARCHAR 50 √ null
SPT_COST_CTR INT 10 √ null
Ded_Janitorial_vendor VARCHAR 50 √ null
janitorial_tier VARCHAR 50 √ 1
Zip_Code_Density_Class VARCHAR 50 √ null
trailer_home_hub VARCHAR 50 √ null
market_type VARCHAR 20 √ null
site_lockbox_code VARCHAR 50 √ null
target_remo_count INT 10 √ null
perm_air_scrubber VARCHAR 4 √ null
perm_temp_cooler VARCHAR 4 √ null
Ded_Jan_Ven_eMail VARCHAR 50 √ null
water_systems VARCHAR 50 √ null
dealer_req_remo BIT 1 √ null
dlr_rem_req_comp DATE 10 √ null
Ref_Retro_Req BIT 1 √ null
flr_care DATE 10 √ null
smra_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
Arc_cont VARCHAR 50 √ null
Arch_email VARCHAR 50 √ null
Arch_ptn_num VARCHAR 50 √ null
Former_aff INT 10 √ null
nxt_dlr_opt_notice_dt DATE 10 √ null
calendar_table.dt Implied Constraint R
Mkt_type_at_app VARCHAR 50 √ null
display_name VARCHAR 100 √ null
cnnct_w_rtl BIT 1 b'0'
market_type_name VARCHAR 128 √ null
heat_cool BIT 1 √ b'0'
5G_onsite BIT 1 √ null
2nd_circuit BIT 1 √ null
relo_type_req INT 10 √ null
relo_priority VARCHAR 50 √ null
actionable_realestate VARCHAR 50 √ null
relo_dest_siteid VARCHAR 50 √ null
relo_loi_status VARCHAR 50 √ null
relo_project_status VARCHAR 50 √ null
pro_open_date DATE 10 √ null
relo_exp_notes TEXT 65535 √ null
new_relo_priority INT 10 √ null
relo_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
lease_type_storeinfo VARCHAR 50 √ null
ems_type_scope VARCHAR 50 √ null
ems_type VARCHAR 50 √ null
tp_edge_id INT 10 √ null
sap_change BIT 1 √ null
inbldg_cvge_soln_need VARCHAR 50 √ null
inbldg_cvge_soln_install VARCHAR 50 √ null
site_op_model INT 10 2
ta_present_cor BIT 1 √ null
ta_present_tpr BIT 1 √ null
ta_present_mbtm BIT 1 √ null
ta_present_ar BIT 1 √ null
nr_sales_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
nr_store_num VARCHAR 5 √ null
nr_dealer_code VARCHAR 7 √ null
aruba_host VARCHAR 50 √ null
aruba_ip VARCHAR 50 √ null
tint_window BIT 1 √ null
relocation_reason INT 10 √ null
gap_relo BIT 1 b'0'
AW_Hub BIT 1 √ null
AR_Lite BIT 1 √ null
mobile_vin VARCHAR 50 √ null
lan_rack_code INT 10 √ null
mob_tech_str BIT 1 √ null
fire_sprink_req BIT 1 √ null
fire_alarm_req BIT 1 √ null
cfius1 BIT 1 √ null
cfius2 BIT 1 √ null
cfius3 BIT 1 √ null
training_room_request INT 10 √ null
req_seat_cap INT 10 √ null
usps_add_val INT 10 √ null
lease_term_option_type VARCHAR 50 √ null
rtl_format INT 10 √ null
owner_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
mbtm_inc_pop DECIMAL 9,6 √ null
real_estate_tracking_notes TEXT 65535 √ null
mgr_office BIT 1 √ null
dedicated_inv_room VARCHAR 50 √ null
entrance_doors VARCHAR 50 √ null
privacy_pod_attribute BIT 1 √ null
rr_public INT 10 √ null
rr_private INT 10 √ null
mtg_room BIT 1 √ null
fut_rtl_format INT 10 √ 7
acct_manage_comm_date DATE 10 √ null
legal_sub_type VARCHAR 50 √ null
land_paid_via INT 10 √ null
ap_tet_sec_r VARCHAR 80 √ null
ems_therm VARCHAR 50 √ null
ems_light VARCHAR 50 √ null
str_demo_ban INT 10 √ 0
rpsrrs INT 10 √ null
csci INT 10 √ null
sfs INT 10 √ null
air_scrub BIT 1 √ null
fut_rtl_format_year VARCHAR 50 √ null
dem_sec_mk_md VARCHAR 255 √ null
dem_sec_color VARCHAR 50 √ null
watch_sec_mk_md VARCHAR 50 √ null
fz_and_txc BIT 1 √ null
d_all_c BIT 1 √ null
op_laun_phase VARCHAR 50 √ null
requested_template_id BIGINT 19 √ null
bank_branch_phone VARCHAR 100 √ null
exp_training BIT 1 √ null
exp_sys_installed BIT 1 √ null
exp_project_complete BIT 1 √ null
exp_training_date DATE 10 √ null
ivueit_notes TEXT 65535 √ null
ivueit_album VARCHAR 20 √ null
ll_contact_survey BIT 1 √ null
TMO_owned_loc BIT 1 b'0'
drainjet_sys VARCHAR 50 √ null
exp_prjid INT 10 √ null
exp_launch_date DATE 10 √ null
exp_store_prj BIT 1 √ null
fire_ala_mon VARCHAR 50 √ null
fire_ala_pan_code VARCHAR 50 √ null
fire_ala_mon_co VARCHAR 50 √ null
water_source VARCHAR 50 √ null
land_resp VARCHAR 50 √ null
snow_rem_resp VARCHAR 50 √ null
no_restroom VARCHAR 50 √ null
pots_as VARCHAR 50 √ null
trailer_ship VARCHAR 200 √ null
bank_branch_zip VARCHAR 10 √ null
exp_target_area_id INT 10 √ null
ceiling_color VARCHAR 50 √ null
air_scrub_det VARCHAR 60 √ null
num_thin_clients INT 10 √ null
shopper_trak_id VARCHAR 10 √ null
mobile_tech_select BIT 1 √ null
warehouse INT 10 √ null
ap_inventory_safe_keypad_types VARCHAR 150 √ null
ap_inventory_safe_location VARCHAR 20 √ null
ap_inventory_safe_door_count VARCHAR 100 √ null
ap_inventory_safe_shelf_count VARCHAR 100 √ null
ap_entry_security_type VARCHAR 20 √ null
ap_rolldown_gate_type VARCHAR 10 √ null
ap_rear_door_peep_hole VARCHAR 10 √ null
ap_sales_floor_peep_hole VARCHAR 10 √ null
ap_backdoor_push_bar_type VARCHAR 20 √ null
ap_frontdoor_lock_type VARCHAR 30 √ null
ap_sales_floor_lock_type VARCHAR 50 √ null
ap_store_exit_count VARCHAR 10 √ null
ap_inventory_door_lock_type VARCHAR 80 √ null
ap_boh_camera_count VARCHAR 5 √ null
ap_foh_camera_count VARCHAR 5 √ null
ap_inventory_room_camera VARCHAR 5 √ null
ap_height_strip_camera_type VARCHAR 30 √ null
ap_public_view_monitor VARCHAR 5 √ null
ap_camera_types VARCHAR 200 √ null
ap_holdup_button_count_foh VARCHAR 10 √ null
ap_holdup_button_count_boh VARCHAR 10 √ null
ap_qmi_cabinet_count VARCHAR 10 √ null
ap_motion_detector_count VARCHAR 10 √ null
ap_cash_safe VARCHAR 50 √ null
ap_inventory_safe VARCHAR 150 √ null
ap_inventory_safe_count VARCHAR 5 √ null
ap_device_demo VARCHAR 500 √ null
ap_wearable_demo_security VARCHAR 500 √ null
ap_demo_security_color VARCHAR 10 √ null
till_fund_amount INT 10 √ null
change_fund_amount INT 10 √ null
chg_fund_exception TEXT 65535 √ null
mobile_truck_rights VARCHAR 300 √ null
us_cellular_id VARCHAR 7 √ null
z_exp_launch_date DATE 10 √ null
uscc_treasury_id VARCHAR 6 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
ix_Ded_Janitorial_vendor Performance Asc Ded_Janitorial_vendor
ix_janitorial_tier Performance Asc janitorial_tier
IX_site_survey_template_id Performance Asc requested_template_id

Relationships

Close relationships within degrees of separation