29 lines
1.6 KiB
SQL
29 lines
1.6 KiB
SQL
-- =============================================================
|
||
-- V042 – Energy flow decomposition (7 directional flows per 15min)
|
||
-- Plní se v ems.fn_fill_audit_interval (prioritní alokace per minuta).
|
||
-- =============================================================
|
||
|
||
ALTER TABLE ems.audit_interval
|
||
ADD COLUMN IF NOT EXISTS flow_pv_to_load_wh NUMERIC(10,1),
|
||
ADD COLUMN IF NOT EXISTS flow_pv_to_batt_wh NUMERIC(10,1),
|
||
ADD COLUMN IF NOT EXISTS flow_pv_to_grid_wh NUMERIC(10,1),
|
||
ADD COLUMN IF NOT EXISTS flow_batt_to_load_wh NUMERIC(10,1),
|
||
ADD COLUMN IF NOT EXISTS flow_batt_to_grid_wh NUMERIC(10,1),
|
||
ADD COLUMN IF NOT EXISTS flow_grid_to_load_wh NUMERIC(10,1),
|
||
ADD COLUMN IF NOT EXISTS flow_grid_to_batt_wh NUMERIC(10,1);
|
||
|
||
COMMENT ON COLUMN ems.audit_interval.flow_pv_to_load_wh IS
|
||
'Modelovaný tok FVE → spotřeba (Wh/slot). Per-minutová prioritní alokace: PV nejdřív load.';
|
||
COMMENT ON COLUMN ems.audit_interval.flow_pv_to_batt_wh IS
|
||
'Modelovaný tok FVE → nabíjení baterie (Wh/slot).';
|
||
COMMENT ON COLUMN ems.audit_interval.flow_pv_to_grid_wh IS
|
||
'Modelovaný tok FVE → export do sítě (Wh/slot).';
|
||
COMMENT ON COLUMN ems.audit_interval.flow_batt_to_load_wh IS
|
||
'Modelovaný tok vybití baterie → spotřeba (Wh/slot).';
|
||
COMMENT ON COLUMN ems.audit_interval.flow_batt_to_grid_wh IS
|
||
'Modelovaný tok vybití baterie → export (Wh/slot).';
|
||
COMMENT ON COLUMN ems.audit_interval.flow_grid_to_load_wh IS
|
||
'Modelovaný tok import ze sítě → spotřeba (Wh/slot).';
|
||
COMMENT ON COLUMN ems.audit_interval.flow_grid_to_batt_wh IS
|
||
'Modelovaný tok import ze sítě → nabíjení baterie (Wh/slot).';
|