Sort through frog_uhm views/tables for migration to Lonoa

[kathrynparadis]

• Create view/table connection diagram of current frog_uhm database
• Define the purpose of each view
• Determine views/tables that are no longer necessary
• Revise view/table connection diagram to show only views/diragrams to migrate to Lonoa
• Check each "view cascade" and see if there is a way to shorten the cascade by combining or removing views (less dependencies = better management of views and tables)

[kathrynparadis]

I originally attempted to create the diagram in MySQL Workbench, but there was no way to show a connection between views, only between tables (since the connections in MySQL Workbench are based on columns not whole tables, and views don't show the columns in the diagram in MySQL Workbench.)

Since MySQL Workbench didn't work out, I used Gimp to pull all the diagram pieces out of MySQL workbench so that I could use them in Draw.io

This is the final version of the frog_uhm map:

[kathrynparadis]

(UNFINISHED)

Public Tables:

• building
• egauge
• egauge_5min_avg_trailing
• egauge_rejects
• egauge_test
• egauge_test_rejects
  • I don't have access to this table (Owner = Eileen)
• frog1_extra_events
• frog2_extra_events
• kevins_meter
  • I don't have access to this table (Owner = Eileen)
• model_data
• model_end_uses
• model_pv_production
• model_scenarios
• occupancy_samples
  • I don't have access to this table (Owner = Eileen)
• pmv_ip
  • I don't have access to this table (Owner = Eileen)
• query_test
• reading
• reading_old
• reading_outliers
• reading_temp
  • I don't have access to this table (Owner = Eileen)
• schedule_effective_empty
  • I don't have access to this table (Owner = Eileen)
• schedule_min
• schedule_min_copy1
• schedule_min2
  • I don't have access to this table (Owner = Eileen)
• schedule_spring_2018
  • I don't have access to this table (Owner = Eileen)
• sensor_info
• solar_edge_pv
• variable_info_old
• webctrl_bulk_trend_test
• webctrl_bulk_trend_test_two

Public Views:

• calc-other-inst-power
• co2_difference_hrly
• conference-data-6mo
• dashbd_indoor_envir_weather_sched
• dashbd_indoor_env_weather_sched_hrly
  • I don't have access to this view (Owner = Eileen)
• dashbd_indoorenv_sched
• dashbd_indoorenv_weather_no_sched
• dashbd_indoorenv_weather_no_sched_min
  • I don't have access to this view (Owner = Eileen)
• dashbd_indoorenv_weather_no_sched_max
  • I don't have access to this view (Owner = Eileen)
• dashbd_indoorenv_weather_no_sched_avg
  • I don't have access to this view (Owner = Eileen)
• dashbd_indoorenv_weather_sched_hrly
• dashbd_indoorenv_weatherstation
• dashbd_indoorenv_weatherstation_hrly
• dashbd-indoorenv-sched-testweathercombine
• dashboard-with-indoor-envir
• dates_kevins_meter
• dates_reading
• dates-pmv
• egauge_5min_avg_view1
• eguage_5min_avg_view2
• frog-2_temp_CO2_weather_AC
  • I don't have access to this view (Owner = Eileen)
• frog-1_temp_CO2_weather_AC
  • I don't have access to this view (Owner = Eileen)
• indoor_environmental_sensors
  • I don't have access to this view (Owner = Eileen)
• meter-comparison-1minute
• meter-egauge-minute
• meter-kevin-minute
• meter-kevin-seconds
• model_as_columns_view
• model_data_view
• model_whole_bldg_kwh_view
• power-readings-all
• power-readings-only
• schedule_hr
• single_line_CO2_temp_weather_ac_fans
• single_line_CO2_temp_weather_ac_runtime_fans
• view_weather
• view_weather_only
• view-as-columns-all-power
• view-data-comfort-analysis
• view-egauges
• view-indoor-envir
• view-readings-as-columns
• view-schooldays-by-day
• view-whole-bldg-both-recent
• whole_bldg_egauge_vs_wbctrl

Kat Views:

• dashboard-fans_and_outdoor_lights
• dashboard-hvac
• dashboard-indoor_lights
• dashboard-plugloads
• dashboard-pv
• dashboard-pv-positive
• dashboard-pv-pos-whole-building-net
• dashboard-readings-neg
• dashboard-union_individual
• dashboard-union_of_views
• dashboard-whole-building-net
• dashboard-whole-building-use

[kathrynparadis]

This is the diagram of views to be moved to Lonoa from FrogUHM: