forecast/release_note/2026.09.03/20260903_dp.sql

-- 辐照度功率对比菜单权限
INSERT INTO "public"."sys_menu" (
    "menu_id", "menu_name", "parent_id", "order_num", "path", "component", "query",
    "route_name", "is_frame", "is_cache", "menu_type", "visible", "status", "perms",
    "icon", "create_by", "create_time", "update_by", "update_time", "remark"
)
SELECT
    2080, '辐照度功率对比', 2004, 9, 'irradiance-power-comparison', 'ufo/electricity/forecast/IrradiancePowerComparison', NULL,
    'IrradiancePowerComparison', 1, 0, 'C', '0', '0', 'data:irradiancePowerComparison:list',
    'BarChartOutlined', 'admin', '2026-08-31 00:00:00', '', NULL, ''
WHERE NOT EXISTS (
    SELECT 1 FROM sys_menu WHERE menu_name = '辐照度功率对比'
);


INSERT INTO "public"."sys_menu" (
    "menu_id", "menu_name", "parent_id", "order_num", "path", "component", "query",
    "route_name", "is_frame", "is_cache", "menu_type", "visible", "status", "perms",
    "icon", "create_by", "create_time", "update_by", "update_time", "remark"
)
SELECT
    2083, '短期预测功率', 2007, 9, 'powerForecastIssued', 'ufo/electricity/forecast/ShortTermPowerForecastIssued', NULL,
    'ShortTermPowerForecastIssued', 1, 0, 'C', '0', '0', 'power:powerForecastIssued:list',
    'chart', 'admin', '2026-08-31 00:00:00', '', NULL, ''
WHERE NOT EXISTS (
    SELECT 1 FROM sys_menu WHERE menu_name = '短期预测功率'
);

INSERT INTO "public"."sys_menu" (
    "menu_id", "menu_name", "parent_id", "order_num", "path", "component", "query",
    "route_name", "is_frame", "is_cache", "menu_type", "visible", "status", "perms",
    "icon", "create_by", "create_time", "update_by", "update_time", "remark"
)
SELECT
    2085, '短期预测功率修正', 2007, 11, 'shortTermPowerForecastCorrect', 'ufo/electricity/forecast/DataShortTermPowerForecastCorrect', NULL,
    'DataShortTermPowerForecastCorrect', 1, 0, 'C', '0', '0', 'power:powerForecastCorrect:list',
    'chart', 'admin', '2026-08-31 00:00:00', '', NULL, ''
WHERE NOT EXISTS (
    SELECT 1 FROM sys_menu WHERE menu_name = '短期预测功率修正'
);


INSERT INTO "public"."sys_menu" (
    "menu_id", "menu_name", "parent_id", "order_num", "path", "component", "query",
    "route_name", "is_frame", "is_cache", "menu_type", "visible", "status", "perms",
    "icon", "create_by", "create_time", "update_by", "update_time", "remark"
)
SELECT
    2086, '超短期预测功率修正', 2007, 12, 'superShortTermForecastCorrect', 'ufo/electricity/forecast/DataSuperShortTermForecastCorrect', NULL,
    'DataSuperShortTermForecastCorrect', 1, 0, 'C', '0', '0', 'supershort:dataSuperForecastCorrect:list',
    'chart', 'admin', '2026-08-31 00:00:00', '', NULL, ''
WHERE NOT EXISTS (
    SELECT 1 FROM sys_menu WHERE menu_name = '超短期预测功率修正'
);

INSERT INTO "public"."sys_menu" (
    "menu_id", "menu_name", "parent_id", "order_num", "path", "component", "query",
    "route_name", "is_frame", "is_cache", "menu_type", "visible", "status", "perms",
    "icon", "create_by", "create_time", "update_by", "update_time", "remark"
)
SELECT
    2084, '超短期预测功率', 2007, 10, 'superShortTermForecastIssued', 'ufo/electricity/forecast/DataSuperShortTermForecastIssued', NULL,
    'DataSuperShortTermForecastIssued', 1, 0, 'C', '0', '0', 'supershort:dataSuperForecastIssued:list',
    'chart', 'admin', '2026-08-31 00:00:00', '', NULL, ''
WHERE NOT EXISTS (
    SELECT 1 FROM sys_menu WHERE menu_name = '超短期预测功率'
);

-- 创建序列
CREATE SEQUENCE IF NOT EXISTS data_ultra_short_term_power_forecasting_id_seq;

DROP TABLE IF EXISTS data_ultra_short_term_power_forecasting;
-- 建表语句
CREATE TABLE data_ultra_short_term_power_forecasting (
    _id BIGINT NOT NULL DEFAULT nextval('data_ultra_short_term_power_forecasting_id_seq'::regclass),
    data_sourcegrab_id INTEGER NOT NULL,
    data_sourcegrab_pattern_name VARCHAR(255) NOT NULL,
    entity_id VARCHAR(255) NOT NULL,
    entity_type INTEGER NOT NULL,
    entity_name VARCHAR(255),
    create_time INTEGER NOT NULL,
    start_time INTEGER NOT NULL,
    forecast_time INTEGER NOT NULL,
    power VARCHAR(255),
    power15 VARCHAR(255),
    power30 VARCHAR(255),
    power45 VARCHAR(255),
    power60 VARCHAR(255),
    power75 VARCHAR(255),
    power90 VARCHAR(255),
    power105 VARCHAR(255),
    power120 VARCHAR(255),
    power135 VARCHAR(255),
    power150 VARCHAR(255),
    power165 VARCHAR(255),
    power180 VARCHAR(255),
    power195 VARCHAR(255),
    power210 VARCHAR(255),
    power225 VARCHAR(255),
    power240 VARCHAR(255),
    CONSTRAINT data_ultra_short_term_power_forecasting_pkey PRIMARY KEY (_id)
);

-- 表注释
COMMENT ON TABLE "public"."data_ultra_short_term_power_forecasting" IS '超短期功率预测数据表';

-- 字段注释
COMMENT ON COLUMN "public"."data_ultra_short_term_power_forecasting"."_id" IS '唯一标识';
COMMENT ON COLUMN "public"."data_ultra_short_term_power_forecasting"."data_sourcegrab_id" IS '数据源抓取ID';
COMMENT ON COLUMN "public"."data_ultra_short_term_power_forecasting"."data_sourcegrab_pattern_name" IS '数据抓取模式名称';
COMMENT ON COLUMN "public"."data_ultra_short_term_power_forecasting"."entity_id" IS '实体ID';
COMMENT ON COLUMN "public"."data_ultra_short_term_power_forecasting"."entity_type" IS '实体类型(场站/交易主体/省域)';
COMMENT ON COLUMN "public"."data_ultra_short_term_power_forecasting"."entity_name" IS '实体名称';
COMMENT ON COLUMN "public"."data_ultra_short_term_power_forecasting"."create_time" IS '创建时间';
COMMENT ON COLUMN "public"."data_ultra_short_term_power_forecasting"."start_time" IS '起报时间（日期）';
COMMENT ON COLUMN "public"."data_ultra_short_term_power_forecasting"."forecast_time" IS '起报时间（日期）';
COMMENT ON COLUMN "public"."data_ultra_short_term_power_forecasting"."power" IS '实发功率';
COMMENT ON COLUMN "public"."data_ultra_short_term_power_forecasting"."power15" IS 't+15min预测功率';
COMMENT ON COLUMN "public"."data_ultra_short_term_power_forecasting"."power30" IS 't+30min预测功率';
COMMENT ON COLUMN "public"."data_ultra_short_term_power_forecasting"."power45" IS 't+45min预测功率';
COMMENT ON COLUMN "public"."data_ultra_short_term_power_forecasting"."power60" IS 't+60min预测功率';
COMMENT ON COLUMN "public"."data_ultra_short_term_power_forecasting"."power75" IS 't+75min预测功率';
COMMENT ON COLUMN "public"."data_ultra_short_term_power_forecasting"."power90" IS 't+90min预测功率';
COMMENT ON COLUMN "public"."data_ultra_short_term_power_forecasting"."power105" IS 't+105min预测功率';
COMMENT ON COLUMN "public"."data_ultra_short_term_power_forecasting"."power120" IS 't+120min预测功率';
COMMENT ON COLUMN "public"."data_ultra_short_term_power_forecasting"."power135" IS 't+135min预测功率';
COMMENT ON COLUMN "public"."data_ultra_short_term_power_forecasting"."power150" IS 't+150min预测功率';
COMMENT ON COLUMN "public"."data_ultra_short_term_power_forecasting"."power165" IS 't+165min预测功率';
COMMENT ON COLUMN "public"."data_ultra_short_term_power_forecasting"."power180" IS 't+180min预测功率';
COMMENT ON COLUMN "public"."data_ultra_short_term_power_forecasting"."power195" IS 't+195min预测功率';
COMMENT ON COLUMN "public"."data_ultra_short_term_power_forecasting"."power210" IS 't+210min预测功率';
COMMENT ON COLUMN "public"."data_ultra_short_term_power_forecasting"."power225" IS 't+225min预测功率';
COMMENT ON COLUMN "public"."data_ultra_short_term_power_forecasting"."power240" IS 't+240min预测功率';