From c84806dc721cedbfd12ff513c05b17ba88b679dd Mon Sep 17 00:00:00 2001 From: 潘志宝 <979469083@qq.com> Date: 星期三, 14 五月 2025 15:26:35 +0800 Subject: [PATCH] 极值点处理类 --- iailab-module-data/iailab-module-data-biz/db/mysql/tenant.sql | 14 +++++++++++++- 1 files changed, 13 insertions(+), 1 deletions(-) diff --git a/iailab-module-data/iailab-module-data-biz/db/mysql/tenant.sql b/iailab-module-data/iailab-module-data-biz/db/mysql/tenant.sql index 7ca3548..c1a8778 100644 --- a/iailab-module-data/iailab-module-data-biz/db/mysql/tenant.sql +++ b/iailab-module-data/iailab-module-data-biz/db/mysql/tenant.sql @@ -445,4 +445,16 @@ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='定时归档设置表'; ALTER TABLE `t_da_cumulate_point` ADD COLUMN `cumulate_unit` varchar(10) DEFAULT 'min' COMMENT '累计单位'; -ALTER TABLE `t_da_cumulate_point` ADD COLUMN `is_cumu_neg` tinyint(1) DEFAULT 0 COMMENT '是否累计负数'; \ No newline at end of file +ALTER TABLE `t_da_cumulate_point` ADD COLUMN `is_cumu_neg` tinyint(1) DEFAULT 0 COMMENT '是否累计负数'; + + +CREATE TABLE t_da_extremal_point( + `id` VARCHAR(36) NOT NULL COMMENT 'ID' , + `point_id` VARCHAR(36) COMMENT '测点ID' , + `moment_point` VARCHAR(36) COMMENT '瞬时测点' , + `length` int COMMENT '统计长度', + `extremal_unit` varchar(10) DEFAULT 'min' COMMENT '统计单位', + `extremal_type` int NOT NULL COMMENT '极值类型（1:最大值，2：最小值）', + PRIMARY KEY (id) USING BTREE, + UNIQUE KEY `uk_point_id` (`point_id`) USING BTREE +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT = '实时极值点表'; \ No newline at end of file -- Gitblit v1.9.3