Anomalies


Things that might not be 'quite right' about your database and schema

Columns whose name and type imply a relationship to another table's primary key

Child Column Implied Parent Column
asset.[bracket_type] sys_monitor_types.[type]
asset.[cash_safe_type] sys_monitor_types.[type]
asset.[cloud_type] sys_monitor_types.[type]
asset.[entry1_type] sys_monitor_types.[type]
asset.[entry2_type] sys_monitor_types.[type]
asset.[entry3_type] sys_monitor_types.[type]
asset.[floor_base_type] sys_monitor_types.[type]
asset.[floor_rr_type] sys_monitor_types.[type]
asset.[gfloor_boh_type] sys_monitor_types.[type]
asset.[gps_type] sys_monitor_types.[type]
asset.[grill_type] sys_monitor_types.[type]
asset.[hot_water_type] sys_monitor_types.[type]
asset.[metro_sign1_type] sys_monitor_types.[type]
asset.[metro_sign2_type] sys_monitor_types.[type]
asset.[metro_sign3_type] sys_monitor_types.[type]
asset.[metro_sign4_type] sys_monitor_types.[type]
asset.[mount_type] sys_monitor_types.[type]
asset.[sign_east_backer_type] sys_monitor_types.[type]
asset.[sign_east_type] sys_monitor_types.[type]
asset.[sign_north_backer_type] sys_monitor_types.[type]
asset.[sign_north_type] sys_monitor_types.[type]
asset.[sign_south_backer_type] sys_monitor_types.[type]
asset.[sign_south_type] sys_monitor_types.[type]
asset.[sign_west_backer_type] sys_monitor_types.[type]
asset.[sign_west_type] sys_monitor_types.[type]
asset.[sink_type] sys_monitor_types.[type]
asset.[thermostat_type] sys_monitor_types.[type]
block_group.[cbsa_id] t_dma.[ID]
blockgroup_model_forecast.[block_group_id] t_dma.[ID]
bulk_validation_line.[line_number] stores_non_branded.[number]
civil_sprint.[legacy_sprint_store_number] stores_non_branded.[number]
costar_key_leases.[crem_id] t_dma.[ID]
costar_key_leases_old.[crem_id] t_dma.[ID]
costar_key_leases_unfiltered.[crem_id] t_dma.[ID]
costar_lease_variables_old.[crem_id] t_dma.[ID]
costar_lease_variables_old.[zip_code] market_type_zip.[zip_code]
file_extract_job.[storage_type] sys_monitor_types.[type]
fos_all.[MSA_ID] t_dma.[ID]
fos_contact_rollup.[OrgLevel_Leader_Email] new_rsm.[email]
fos_old.[CHID] pico_contract_holder.[chid]
granite_master_tracker.[CIRCUITID] bandwave.[CIRCUITID]
intake.[assigned_type] sys_monitor_types.[type]
intake_request_type.[default_user_type] sys_monitor_types.[type]
new_costar.[crem_id] t_dma.[ID]
new_costar.[reference_id] t_dma.[ID]
noremodel.[tb_siteid] experience_hierarchy.[siteid]
notification_template.[type] sys_monitor_types.[type]
pico_dealer_list.[chid] pico_contract_holder.[chid]
pico_status_open_stores.[billing_circuit_id] t_dma.[ID]
picocell_status.[billing_circuit_id] t_dma.[ID]
plg_signature.[signature_type] sys_monitor_types.[type]
powerbi_entry.[dataset_id] t_dma.[ID]
powerbi_entry.[group_id] t_dma.[ID]
powerbi_entry.[powerbi_id] t_dma.[ID]
program_workflow_participant_type.[user_type] sys_monitor_types.[type]
project.[co_owner_type] sys_monitor_types.[type]
project.[com_tracker_id] t_dma.[ID]
project.[design_code] site_design_backup.[design_code]
project.[Facilities_Upgrade_Type] sys_monitor_types.[type]
project.[grade_prop_loc] site_accessory_tier.[loc]
project.[relo_question] temp_close_relo.[question]
project.[request_type] sys_monitor_types.[type]
project_extension.[landlord_type] sys_monitor_types.[type]
project_extension.[Termination_type] sys_monitor_types.[type]
project_extension.[tia_type] sys_monitor_types.[type]
project_extension.[truck_power_type] sys_monitor_types.[type]
project_extension.[truck_rr_type] sys_monitor_types.[type]
project_plg_required_signature.[signature_type] sys_monitor_types.[type]
punch_list_item.[number] stores_non_branded.[number]
remo_data.[store_id] t_dma.[ID]
site.[block_group_id] srem_blkgrp.[block_group_id]
site.[design_code] site_design_backup.[design_code]
site.[ikon_id] t_dma.[ID]
site.[pico_circuit_id] t_dma.[ID]
site.[sampson_code] site_sampson.[sampson_code]
site.[sign_type] sys_monitor_types.[type]
site_contract_holder.[sampson_code] site_sampson.[sampson_code]
site_design.[design_code] site_design_backup.[design_code]
site_extension.[dev_rep_loc] site_accessory_tier.[loc]
site_extension.[nr_sales_type] sys_monitor_types.[type]
site_extension.[nxt_dlr_opt_notice_dt] calendar_table.[dt]
site_extension.[owner_type] sys_monitor_types.[type]
site_extension.[relo_type] sys_monitor_types.[type]
site_extension.[smra_type] sys_monitor_types.[type]
site_extension.[tp_account_id] t_dma.[ID]
site_extension.[tp_door_code] metro_srs.[door_code]
site_extension.[tp_previous_record_id] t_dma.[ID]
sitepack_reason.[applicable_project_type] sys_monitor_types.[type]
sys_monitor_events.[type] sys_monitor_types.[type]
t_site_contract_holder.[contract_holder_id] t_dma.[ID]
t_site_contract_holders.[contract_holder_id] t_dma.[ID]
target_area.[block_group_id] srem_blkgrp.[block_group_id]
target_area_candidate.[index_number] stores_non_branded.[number]
target_area_document.[index_number] stores_non_branded.[number]
targetarea.[dmaid] dma.[ID]
targetarea.[msaid] msa_demographic.[msaid]
test_site_greg.[block_group_id] srem_blkgrp.[block_group_id]
test_site_greg.[design_code] site_design_backup.[design_code]
test_site_greg.[ikon_id] t_dma.[ID]
test_site_greg.[pico_circuit_id] t_dma.[ID]
test_site_greg.[sampson_code] site_sampson.[sampson_code]
test_site_greg.[sign_type] sys_monitor_types.[type]
test_site_greg.[status_code] site_status.[status_code]
test_site_greg.[Sublease_type] sys_monitor_types.[type]
test_site_greg.[type_code] site_type.[type_code]
vendor_task.[number] stores_non_branded.[number]
weekly_accessory_tier.[loc] site_accessory_tier.[loc]
workflow_participant_type.[user_type] sys_monitor_types.[type]
workflow_type.[vendor_quote_type] sys_monitor_types.[type]

Tables without indexes

Table
activity_log_action_bk_01aug25
activity_log_action_bk_15nov24
activity_log_action_test
acts_data111014
asset_action_bk_01aug25
asset_action_bk_15nov24
bandwave_circuit_data
bk_project_form_field_11sep25
brokernameimport
civil_sprint
combinedforimport
company7-13
costar_lease_variables
county_fixes
dre
emerg_closure
emerg_feed
eoy_2008_2014
eoy_2021
eoy_2022
eoy_2023
eoy_2024
file_action_bk_01aug25
file_action_bk_15nov24
fips_area_region_2
fos_dealer_contacts_bckp
fos_metro
fos_old
fos_unarchive_log
granite_master_tracker
greg
greg_hold_26apr24
greg_sample
greg_tmp_28feb23
ints
kpiorder
legal_action_bk_01aug25
legal_action_bk_15nov24
llcpa_rent_ext
locale_contact_update
market_type_old
metrolat
milestone_action_bk_01aug25
milestone_action_bk_15nov24
noremodel
notification_bk_25feb25
notification_scheduled_bk_01aug25
notification_scheduled_bk_15nov24
notification_scheduled_teset
ntm_forecast_metric_ext
open_date_log
open_date_weekly_report_dealer
ops_active
org_update_021220
palm_ship_rep
pico_status_open_store
picocell_status
pm_survey_data_r
pm_survey_data_s
pm_survey_questions
pm_survey_rating
pre_post_cann_monthly_0910am24june2024
pre_post_cann_monthly_bk
pre_post_cann_monthly_play
pre_post_cann_monthly_try
program_action_bk_01aug25
program_action_bk_15nov24
program_milestone_action_bk_01aug25
program_milestone_action_bk_15nov24
program_workflow_action_bk_01aug25
program_workflow_action_bk_15nov24
project_field_action_bk_01aug25
project_field_action_bk_15nov24
project_field_action_test_gk
project_field_bk_15nov24
project_form_action_bk_01aug25
project_form_action_bk_15nov24
project_form_bk_15nov24
project_milestone_task_id_60
project_milestone_update
project_support_033115
project_support_update
project_update_org
ps_update
punch_list_action_bk_01aug25
punch_list_action_bk_15nov24
rcd_document_type_lkup
rcd_im_node_lkup
report_cpu_per_day
report_db_connections_per_day
report_disk_available_per_day
report_hits_per_day
report_io_load_per_day
report_memory_per_day
report_rsp_avg_home_page_all
report_rsp_avg_home_page_day
report_rsp_avg_prj_photo_all
report_rsp_avg_prj_photo_day
report_rsp_avg_site_info_all
report_rsp_avg_site_info_day
report_rsp_avg_sppt_page_all
report_rsp_avg_sppt_page_day
reports_bk_04aug25
reports_bk_12mar25
reports_bk_15july25
reports_bk_15nov24
results
retail_leases
rsd_im_node_lkup
sap_sams
scheduled_action_bk_01aug25
scheduled_action_bk_15nov24
sd_finance_error_present
secondary_transport
site_file_action_bk_01aug25
site_file_action_bk_15nov24
site_org_update
site_pack_action_bk_01aug25
site_pack_action_bk_15nov24
site_temp_closure_capture
site_update
site_update_2
siteorg_test
siteorg_update
sitepack_update_acts
sitetest
srs_mbtm_proximity
sys_users_test
t_site_contract_holders_old
target_area_noteupdate
target_remo_counts
temp_closure_action_bk_01aug25
temp_closure_action_bk_15nov24
test_site_greg
tportal_dist_requests
user_update
users_roles
vendor_task_action_bk_01aug25
vendor_task_action_bk_15nov24
workflow_action_bk_01aug25
workflow_action_bk_15nov24

Tables that contain a single column

Table Column
greg_tmp_28feb23 id
ints i
noremodel tb_siteid
ops_active ops_role_user
sd_finance_error_present program_id

Columns whose default value is the word 'NULL' or 'null'

Table
Anomaly not detected