From 38598f5560a7b4afd9da9e4c0755de6fdf9e2fff Mon Sep 17 00:00:00 2001
From: 潘志宝 <979469083@qq.com>
Date: 星期日, 13 四月 2025 19:00:26 +0800
Subject: [PATCH] 负荷移植建议与方案,增加当前时刻
---
ansteel-biz/db/mysql.sql | 15 +++++++++------
1 files changed, 9 insertions(+), 6 deletions(-)
diff --git a/ansteel-biz/db/mysql.sql b/ansteel-biz/db/mysql.sql
index 27196ad..a5e08f4 100644
--- a/ansteel-biz/db/mysql.sql
+++ b/ansteel-biz/db/mysql.sql
@@ -279,7 +279,7 @@
`remark` varchar(50) NULL DEFAULT NULL COMMENT '备注',
`sort` int NULL DEFAULT NULL COMMENT '排序',
PRIMARY KEY (`id`) USING BTREE,
- UNIQUE INDEX `uk_name` varchar(50) NULL DEFAULT NULL COMMENT '名称'
+ UNIQUE INDEX `uk_name` (`name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT '电力功率因数管控功率因数主表';
-- ----------------------------
@@ -344,11 +344,10 @@
`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 '指标名称',
- `info_type` 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 '实际值',
- `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
@@ -370,8 +369,9 @@
`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 '实际值',
- `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 '焦化工序主子工序指标';
@@ -386,7 +386,9 @@
`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_content` 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 '焦化工序趋势分析';
@@ -399,6 +401,7 @@
`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(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