forecast/release_note/20260924/20260924_中期预报表.sql

CREATE SEQUENCE IF NOT EXISTS "public"."data_medium_term_power_forecast_raw__id_seq";

DROP TABLE IF EXISTS "public"."data_medium_term_power_forecast_raw";
CREATE TABLE "public"."data_medium_term_power_forecast_raw" (
  "_id" integer NOT NULL DEFAULT nextval(
    'data_medium_term_power_forecast_raw__id_seq'::regclass
  ),
  "latitude" character varying(255),
  "longitude" character varying(255),
  "data_org_type" character varying(255) NOT NULL,
  "data_type" integer NOT NULL,
  "business_process_type" integer NOT NULL,
  "data_source" integer NOT NULL,
  "data_sourcegrab_id" integer NOT NULL,
  "data_sourcegrab_pattern_name" character varying(255) NOT NULL,
  "data_model_id" integer NOT NULL,
  "data_model_name" character varying(255) NOT NULL,
  "source_id" integer NOT NULL,
  "source_name" character varying(255) NOT NULL,
  "entity_id" character varying(255) NOT NULL,
  "entity_type" character varying(255) NOT NULL,
  "create_time" integer NOT NULL,
  "start_time" integer NOT NULL,
  "forecast_time" integer NOT NULL,
  "pre_days" integer NOT NULL,
  "lead_time" integer NOT NULL,
  "station_id" bigint,
  "station_name" character varying(255),
  "subject_id" integer,
  "subject_name" character varying(255),
  "machine_id" character varying(255),
  "machine_name" character varying(255),
  "analyze_his_id" integer,
  "archive_record_id" integer,
  "power" character varying(255)
);

COMMENT ON TABLE "public"."data_medium_term_power_forecast_raw" IS '中期功率原始数据表';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_raw"."_id" IS '唯一标识';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_raw"."latitude" IS '经度';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_raw"."longitude" IS '纬度';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_raw"."data_org_type" IS '数据种类:单点时间序列';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_raw"."data_type" IS '数据类型:短期气象';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_raw"."business_process_type" IS '数据业务类型:原始';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_raw"."data_source" IS '数据来源';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_raw"."data_sourcegrab_id" IS '数据源抓取ID';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_raw"."data_sourcegrab_pattern_name" IS '数据抓取模式名称';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_raw"."data_model_id" IS '数据模型ID';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_raw"."data_model_name" IS '数据模型名称';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_raw"."source_id" IS '数据源ID';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_raw"."source_name" IS '数据源名称';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_raw"."entity_id" IS '实体ID';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_raw"."entity_type" IS '实体类型';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_raw"."create_time" IS '创建时间';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_raw"."start_time" IS '起报时间';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_raw"."forecast_time" IS '预测时间';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_raw"."pre_days" IS '预报天数';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_raw"."lead_time" IS '预报时效';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_raw"."station_id" IS '场站ID';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_raw"."station_name" IS '场站名称';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_raw"."subject_id" IS '交易主题ID';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_raw"."subject_name" IS '交易主题名称';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_raw"."machine_id" IS '风机ID';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_raw"."machine_name" IS '风机名称';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_raw"."analyze_his_id" IS '文件解析ID:文件解析时存在';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_raw"."archive_record_id" IS '文件归档ID:文件解析时存在';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_raw"."power" IS '预测功率';

CREATE SEQUENCE IF NOT EXISTS "public"."data_medium_term_power_forecast_issued__id_seq";

DROP TABLE IF EXISTS "public"."data_medium_term_power_forecast_issued";
CREATE TABLE "public"."data_medium_term_power_forecast_issued" (
  "_id" integer NOT NULL DEFAULT nextval(
    'data_medium_term_power_forecast_issued__id_seq'::regclass
  ),
  "data_sourcegrab_id" integer NOT NULL,
  "data_sourcegrab_pattern_name" character varying(255) NOT NULL,
  "entity_id" character varying(255) NOT NULL,
  "entity_type" integer NOT NULL,
  "entity_name" character varying(255),
  "create_time" integer NOT NULL,
  "start_time" integer NOT NULL,
  "forecast_time" integer NOT NULL,
  "predays" integer NOT NULL,
  "power" character varying(255)
);

COMMENT ON TABLE "public"."data_medium_term_power_forecast_issued" IS '中期功率下发数据表';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_issued"."_id" IS '唯一标识';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_issued"."data_sourcegrab_id" IS '数据源抓取ID';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_issued"."data_sourcegrab_pattern_name" IS '数据抓取模式名称';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_issued"."entity_id" IS '实体ID';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_issued"."entity_type" IS '实体类型';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_issued"."entity_name" IS '实体名称';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_issued"."create_time" IS '创建时间';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_issued"."start_time" IS '起报时间';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_issued"."forecast_time" IS '预测时间';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_issued"."predays" IS '预报天数';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_issued"."power" IS '预测功率';


CREATE SEQUENCE IF NOT EXISTS "public"."data_medium_term_power_forecast_correct__id_seq";
DROP TABLE IF EXISTS "public"."data_medium_term_power_forecast_correct";
CREATE TABLE "public"."data_medium_term_power_forecast_correct" (
  "_id" integer NOT NULL DEFAULT nextval(
    'data_medium_term_power_forecast_correct__id_seq'::regclass
  ),
  "data_sourcegrab_id" integer NOT NULL,
  "data_sourcegrab_pattern_name" character varying(255) NOT NULL,
  "entity_id" character varying(255) NOT NULL,
  "entity_type" integer NOT NULL,
  "entity_name" character varying(255),
  "create_time" integer NOT NULL,
  "start_time" integer NOT NULL,
  "forecast_time" integer NOT NULL,
  "predays" integer NOT NULL,
  "power" character varying(255)
);

COMMENT ON TABLE "public"."data_medium_term_power_forecast_correct" IS '中期功率修正数据表';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_correct"."_id" IS '唯一标识';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_correct"."data_sourcegrab_id" IS '数据源抓取ID';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_correct"."data_sourcegrab_pattern_name" IS '数据抓取模式名称';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_correct"."entity_id" IS '实体ID';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_correct"."entity_type" IS '实体类型';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_correct"."entity_name" IS '实体名称';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_correct"."create_time" IS '创建时间';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_correct"."start_time" IS '起报时间';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_correct"."forecast_time" IS '预测时间';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_correct"."predays" IS '预报天数';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_correct"."power" IS '预测功率';


CREATE SEQUENCE IF NOT EXISTS "public"."data_medium_term_power_forecast_report__id_seq";
DROP TABLE IF EXISTS "public"."data_medium_term_power_forecast_report";
CREATE TABLE "public"."data_medium_term_power_forecast_report" (
  "_id" integer NOT NULL DEFAULT nextval(
    'data_medium_term_power_forecast_report__id_seq'::regclass
  ),
  "data_sourcegrab_id" integer NOT NULL,
  "data_sourcegrab_pattern_name" character varying(255) NOT NULL,
  "entity_id" character varying(255) NOT NULL,
  "entity_type" integer NOT NULL,
  "entity_name" character varying(255),
  "create_time" integer NOT NULL,
  "start_time" integer NOT NULL,
  "forecast_time" integer NOT NULL,
  "predays" integer NOT NULL,
  "power" character varying(255)
);

COMMENT ON TABLE "public"."data_medium_term_power_forecast_report" IS '中期功率上报数据表';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_report"."_id" IS '唯一标识';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_report"."data_sourcegrab_id" IS '数据源抓取ID';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_report"."data_sourcegrab_pattern_name" IS '数据抓取模式名称';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_report"."entity_id" IS '实体ID';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_report"."entity_type" IS '实体类型';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_report"."entity_name" IS '实体名称';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_report"."create_time" IS '创建时间';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_report"."start_time" IS '起报时间';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_report"."forecast_time" IS '预测时间';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_report"."predays" IS '预报天数';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_report"."power" IS '预测功率';


CREATE SEQUENCE IF NOT EXISTS "public"."data_medium_term_power_forecast_back__id_seq";
DROP TABLE IF EXISTS "public"."data_medium_term_power_forecast_back";
CREATE TABLE "public"."data_medium_term_power_forecast_back" (
  "_id" integer NOT NULL DEFAULT nextval(
    'data_medium_term_power_forecast_back__id_seq'::regclass
  ),
  "data_sourcegrab_id" integer NOT NULL,
  "data_sourcegrab_pattern_name" character varying(255) NOT NULL,
  "entity_id" character varying(255) NOT NULL,
  "entity_type" integer NOT NULL,
  "entity_name" character varying(255),
  "create_time" integer NOT NULL,
  "start_time" integer NOT NULL,
  "forecast_time" integer NOT NULL,
  "predays" integer NOT NULL,
  "power" character varying(255)
);

COMMENT ON TABLE "public"."data_medium_term_power_forecast_back" IS '中期功率回传数据表';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_back"."_id" IS '唯一标识';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_back"."data_sourcegrab_id" IS '数据源抓取ID';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_back"."data_sourcegrab_pattern_name" IS '数据抓取模式名称';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_back"."entity_id" IS '实体ID';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_back"."entity_type" IS '实体类型';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_back"."entity_name" IS '实体名称';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_back"."create_time" IS '创建时间';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_back"."start_time" IS '起报时间';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_back"."forecast_time" IS '预测时间';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_back"."predays" IS '预报天数';

COMMENT ON COLUMN "public"."data_medium_term_power_forecast_back"."power" IS '预测功率';