magnusandClaude Opus 4.7
da20691d2b
Each hourly row now carries the N1 time-of-use tariff (øre/kWh × 10 to match the DKK/MWh unit of price_dkk) and the combined consumer price (spot + tariff). Existing rows are backfilled in the migration with a CASE expression mirroring tariffs/tariff-for-hour; new writes compute it in the controller. API response exposes both fields. Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>
4 lines
92 B
SQL
4 lines
92 B
SQL
ALTER TABLE elprice DROP COLUMN total_dkk;
|
|
--;;
|
|
ALTER TABLE elprice DROP COLUMN tariff_dkk;
|