removes live_data, which have not been used for a while now, due to being replaced by latest data.
removes most daily_data columns, since they are not being used
Before merging we should keep a backup of daily_data with a command like: pg_dump -h localhost -p 54321 -U postgres -W -t public.daily_data > ~/dump_daily_data.sql
satelliteTemperature is the main reason daily_data is still used.
I suggest we remove alerts from time_series and leave them to daily_data, since they are composite values and semantically they "litter" time_series
In summary this PR:
Before merging we should keep a backup of
daily_data
with a command like:pg_dump -h localhost -p 54321 -U postgres -W -t public.daily_data > ~/dump_daily_data.sql
satelliteTemperature
is the main reasondaily_data
is still used.I suggest we remove alerts from
time_series
and leave them todaily_data
, since they are composite values and semantically they "litter"time_series
resolves https://github.com/aqualinkorg/aqualink-app/issues/926