Sort through frog_uhm views/tables for migration to Lonoa

kathrynparadis commented 5 years ago

[x] Create view/table connection diagram of current frog_uhm database
[ ] Define the purpose of each view
[x] Determine views/tables that are no longer necessary
[x] 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 commented 5 years ago

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 commented 5 years ago

(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 commented 5 years ago

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

frog_uhm_map_migration

erdl / lonoa