From dd1ba0fac25de2328ed6b92bfe5c82a7822572d7 Mon Sep 17 00:00:00 2001
From: dengzedong <dengzedong@email>
Date: 星期二, 27 五月 2025 09:01:29 +0800
Subject: [PATCH] RunBatTask 峰谷平耗电量关联 峰谷平时段表
---
ansteel-biz/db/mysql.sql | 15 +++++++++++++++
1 files changed, 15 insertions(+), 0 deletions(-)
diff --git a/ansteel-biz/db/mysql.sql b/ansteel-biz/db/mysql.sql
index cc986b0..e8502d2 100644
--- a/ansteel-biz/db/mysql.sql
+++ b/ansteel-biz/db/mysql.sql
@@ -868,3 +868,18 @@
PRIMARY KEY (`id`) USING BTREE,
key idx_main_id (main_id)
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT '峰谷平电价时段表';
+
+-- ----------------------------
+-- 峰谷平累计计算配置
+-- ----------------------------
+CREATE TABLE `t_peak_valley_flat` (
+ `id` varchar(36) NOT NULL COMMENT 'id',
+ `name` varchar(36) DEFAULT NULL COMMENT '名称',
+ `type` varchar(36) DEFAULT NULL COMMENT '类型（peak/vallay/flat）',
+ `point_no` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '下发测点编码_日_占比',
+ `point_no_month` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '下发测点编码_月_占比',
+ `point_no_total` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '下发测点编码_日_峰/谷耗电量',
+ `power_no` varchar(36) DEFAULT NULL COMMENT '功率点位',
+ `create_time` datetime DEFAULT NULL COMMENT '创建时间',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='峰谷平累计计算配置';
--
Gitblit v1.9.3