From 634d18758efbd8616d03945da447cc242c880491 Mon Sep 17 00:00:00 2001 From: 潘志宝 <979469083@qq.com> Date: 星期二, 15 四月 2025 09:54:08 +0800 Subject: [PATCH] 功率因数-发电机组实时状态 --- ansteel-biz/db/mysql.sql | 200 +++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 199 insertions(+), 1 deletions(-) diff --git a/ansteel-biz/db/mysql.sql b/ansteel-biz/db/mysql.sql index a943f56..3f91b0e 100644 --- a/ansteel-biz/db/mysql.sql +++ b/ansteel-biz/db/mysql.sql @@ -226,4 +226,202 @@ CREATE INDEX IDX_QRTZ_FT_J_G ON QRTZ_FIRED_TRIGGERS (SCHED_NAME, JOB_NAME, JOB_GROUP); CREATE INDEX IDX_QRTZ_FT_JG ON QRTZ_FIRED_TRIGGERS (SCHED_NAME, JOB_GROUP); CREATE INDEX IDX_QRTZ_FT_T_G ON QRTZ_FIRED_TRIGGERS (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP); -CREATE INDEX IDX_QRTZ_FT_TG ON QRTZ_FIRED_TRIGGERS (SCHED_NAME, TRIGGER_GROUP); \ No newline at end of file +CREATE INDEX IDX_QRTZ_FT_TG ON QRTZ_FIRED_TRIGGERS (SCHED_NAME, TRIGGER_GROUP); + + +-- ---------------------------- +-- 电力功率因数-电网拓扑 +-- ---------------------------- +DROP TABLE IF EXISTS `t_power_net_factor`; +CREATE TABLE `t_power_net_factor` ( + `id` varchar(36) NOT NULL COMMENT 'id', + `group_name` varchar(50) NULL DEFAULT NULL COMMENT '分组名称', + `node_name` varchar(50) NULL DEFAULT NULL COMMENT '节点名称', + `cur_p` varchar(50) NULL DEFAULT NULL COMMENT '当前有功', + `cur_q` varchar(50) NULL DEFAULT NULL COMMENT '当前无功', + `cur_cos` varchar(50) NULL DEFAULT NULL COMMENT '当前功率因数', + `pre_p` varchar(50) NULL DEFAULT NULL COMMENT '预测有功', + `pre_q` varchar(50) NULL DEFAULT NULL COMMENT '预测无功', + `pre_cos` varchar(50) NULL DEFAULT NULL COMMENT '预测功率因数', + `item_id` varchar(50) NULL DEFAULT NULL COMMENT '预测项ID', + `out_id` varchar(50) NULL DEFAULT NULL COMMENT '预测项输出ID', + `limit_h` decimal(6, 3) NULL DEFAULT NULL COMMENT '上限', + `limit_l` decimal(6, 3) NULL DEFAULT NULL COMMENT '下限', + `status` int DEFAULT 0 COMMENT '是否超限(0:正常，1：超限)', + `sort` int NULL DEFAULT NULL COMMENT '排序', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT '电力功率因数电网拓扑'; + +-- ---------------------------- +-- 电力功率因数-发电机组实时状态 +-- ---------------------------- +DROP TABLE IF EXISTS `t_power_gen_status`; +CREATE TABLE `t_power_gen_status` ( + `id` varchar(36) NOT NULL COMMENT 'id', + `name` varchar(50) NULL DEFAULT NULL COMMENT '机组名称', + `cur_p` varchar(50) NULL DEFAULT NULL COMMENT '当前有功', + `cur_q` varchar(50) NULL DEFAULT NULL COMMENT '当前无功', + `cur_cos` varchar(50) NULL DEFAULT NULL COMMENT '当前功率因数', + `limit_h` decimal(6, 3) NULL DEFAULT NULL COMMENT '上限', + `limit_l` decimal(6, 3) NULL DEFAULT NULL COMMENT '下限', + `status` int DEFAULT 0 COMMENT '是否超限(0:正常，1：超限)', + `sort` int NULL DEFAULT NULL COMMENT '排序', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT '电力功率因数发电机组实时状态'; + +-- ---------------------------- +-- 电力功率因数-电容器投运状态 +-- ---------------------------- +DROP TABLE IF EXISTS `t_power_capacitor_status`; +CREATE TABLE `t_power_capacitor_status` ( + `id` varchar(36) NOT NULL COMMENT 'id', + `name` varchar(50) NULL DEFAULT NULL COMMENT '电容器名称', + `main_count` varchar(50) NULL DEFAULT NULL COMMENT '主变数量', + `main_point` varchar(500) NULL DEFAULT NULL COMMENT '主变测点编码', + `child_count` varchar(50) NULL DEFAULT NULL COMMENT '下属数量', + `child_point` varchar(500) NULL DEFAULT NULL COMMENT '下属测点编码', + `on_count` varchar(500) NULL DEFAULT NULL COMMENT '投运数量', + `remark` varchar(50) NULL DEFAULT NULL COMMENT '备注', + `sort` int NULL DEFAULT NULL COMMENT '排序', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT '电力功率因数电容器投运状态'; + +-- ---------------------------- +-- 电力功率因数-管控功率因数主表 +-- ---------------------------- +DROP TABLE IF EXISTS `t_power_control_main`; +CREATE TABLE `t_power_control_main` ( + `id` varchar(36) NOT NULL COMMENT 'id', + `name` varchar(50) NULL DEFAULT NULL COMMENT '名称', + `remark` varchar(50) NULL DEFAULT NULL COMMENT '备注', + `sort` int NULL DEFAULT NULL COMMENT '排序', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `uk_name` (`name`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT '电力功率因数管控功率因数主表'; + +ALTER TABLE `t_power_control_main` ADD COLUMN `limit_h` decimal(6, 4) NULL DEFAULT NULL COMMENT '上限', +ALTER TABLE `t_power_control_main` ADD COLUMN `limit_l` decimal(6, 4) NULL DEFAULT NULL COMMENT '下限', + + -- ---------------------------- +-- 电力功率因数-管控功率因数从表 +-- ---------------------------- +DROP TABLE IF EXISTS `t_power_control_det`; +CREATE TABLE `t_power_control_det` ( + `id` varchar(36) NOT NULL COMMENT 'id', + `control_id` varchar(36) NOT NULL COMMENT '主表ID', + `name` varchar(50) NULL DEFAULT NULL COMMENT '名称', + `point` varchar(50) NULL DEFAULT NULL COMMENT '测点', + `limit_l` decimal(6, 3) NULL DEFAULT NULL COMMENT '下限', + `status` int DEFAULT 0 COMMENT '是否超限(0:正常，1：超限)', + `sort` int NULL DEFAULT NULL COMMENT '排序', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT '电力功率因数管控功率因数从表'; + + +-- ---------------------------- +-- 焦化工序-工序指标配置 +-- ---------------------------- +DROP TABLE IF EXISTS `t_coking_process_conf`; +CREATE TABLE `t_coking_process_conf` ( + `id` varchar(36) NOT NULL COMMENT 'id', + `info_type` varchar(10) NULL DEFAULT NULL COMMENT '信息类型（0：生产情况，1：能源发生，2：能源消耗）', + `ind_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '指标类型（prod_day,main,child）', + `ind_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '指标编码', + `ind_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '指标名称', + `ind_unit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '指标单位', + `remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', + `ext1` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '拓展字段1', + `ext2` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '拓展字段2', + `ext3` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '拓展字段3', + `ext4` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '拓展字段4', + `ext5` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '拓展字段5', + `sort` int NULL DEFAULT NULL COMMENT '排序', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT '焦化工序工序指标配置'; + +-- ---------------------------- +-- 焦化工序-日生产信息 +-- ---------------------------- +DROP TABLE IF EXISTS `t_coking_prod_day`; +CREATE TABLE `t_coking_prod_day` ( + `id` varchar(36) NOT NULL COMMENT 'id', + `clock` varchar(20) NULL DEFAULT NULL COMMENT '查询时间', + `info_type` varchar(10) NULL DEFAULT NULL COMMENT '信息类型（0：生产情况，1：能源发生，2：能源消耗）', + `ind_name` varchar(50) NULL DEFAULT NULL COMMENT '数据名称', + `ind_unit` varchar(50) NULL DEFAULT NULL COMMENT '数据单位', + `ind_value` varchar(50) NULL DEFAULT NULL COMMENT '数据值', + `sort` int NULL DEFAULT NULL COMMENT '排序', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT '焦化工序日生产信息'; + +-- ---------------------------- +-- 焦化工序-主工序指标历史 +-- ---------------------------- +DROP TABLE IF EXISTS `t_coking_process_main`; +CREATE TABLE `t_coking_process_main` ( + `id` varchar(36) NOT NULL COMMENT 'id', + `category` varchar(20) NULL DEFAULT NULL COMMENT '类别（日：day,班：class）', + `clock` varchar(20) NULL DEFAULT NULL COMMENT '查询时间', + `info_type` varchar(10) NULL DEFAULT NULL COMMENT '信息类型（0：生产情况，1：能源发生，2：能源消耗）', + `ind_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '指标名称', + `avg_value` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '历史平均', + `theory_value` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '理论值', + `actual_value` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '实际值', + `stand_value` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '基准值', + `real_value` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '实时数据', + `sort` int NULL DEFAULT NULL COMMENT '排序', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT '焦化工序主工序指标历史'; + + +-- ---------------------------- +-- 焦化工序-子工序指标 +-- ---------------------------- +DROP TABLE IF EXISTS `t_coking_process_child`; +CREATE TABLE `t_coking_process_child` ( + `id` varchar(36) NOT NULL COMMENT 'id', + `category` varchar(20) NULL DEFAULT NULL COMMENT '类别（日：day,班：class）', + `clock` varchar(20) NULL DEFAULT NULL COMMENT '查询时间', + `info_type` varchar(10) NULL DEFAULT NULL COMMENT '信息类型（0：生产情况，1：能源发生，2：能源消耗）', + `ind_type` varchar(20) NOT NULL COMMENT '类型', + `ind_main` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '重点管控指标', + `ind_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '指标名称', + `avg_value` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '历史平均', + `theory_value` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '理论值', + `actual_value` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '实际值', + `stand_value` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '基准值', + `real_value` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '实时数据', + `sort` int NULL DEFAULT NULL COMMENT '排序', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT '焦化工序主子工序指标'; + + +-- ---------------------------- +-- 焦化工序-趋势分析 +-- ---------------------------- +DROP TABLE IF EXISTS `t_coking_analy_trend`; +CREATE TABLE `t_coking_analy_trend` ( + `id` varchar(36) NOT NULL COMMENT 'id', + `analy_type` varchar(20) NULL DEFAULT NULL COMMENT '分析类型', + `analy_title` varchar(20) NULL DEFAULT NULL COMMENT '分析标题', + `analy_date` varchar(20) NULL DEFAULT NULL COMMENT '分析日期', + `analy_class` varchar(20) NULL DEFAULT NULL COMMENT '分析班次', + `analy_value` varchar(20) NULL DEFAULT NULL COMMENT '分析值', + `analy_content` varchar(100) NULL DEFAULT NULL COMMENT '内容', + `sort` int NULL DEFAULT NULL COMMENT '排序', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT '焦化工序趋势分析'; + +-- ---------------------------- +-- 焦化工序-指标分析 +-- ---------------------------- +DROP TABLE IF EXISTS `t_coking_analy_ind`; +CREATE TABLE `t_coking_analy_ind` ( + `id` varchar(36) NOT NULL COMMENT 'id', + `analy_type` varchar(20) NULL DEFAULT NULL COMMENT '分析类型', + `analy_date` varchar(20) NULL DEFAULT NULL COMMENT '分析日期', + `analy_class` varchar(20) NULL DEFAULT NULL COMMENT '分析班次', + `analy_content` varchar(100) NULL DEFAULT NULL COMMENT '内容', + `sort` int NULL DEFAULT NULL COMMENT '排序', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT '焦化工序指标分析'; -- Gitblit v1.9.3