From 5463776154568a3d19c2f537e89f57bc3c7bca02 Mon Sep 17 00:00:00 2001 From: 潘志宝 <979469083@qq.com> Date: 星期日, 27 四月 2025 08:57:13 +0800 Subject: [PATCH] 偏差值接口文档修改 --- ansteel-biz/db/mysql.sql | 19 +++++++++++++++++++ 1 files changed, 19 insertions(+), 0 deletions(-) diff --git a/ansteel-biz/db/mysql.sql b/ansteel-biz/db/mysql.sql index 6d4f6fb..e8a5f86 100644 --- a/ansteel-biz/db/mysql.sql +++ b/ansteel-biz/db/mysql.sql @@ -287,6 +287,25 @@ ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT '电力功率因数电容器投运状态'; -- ---------------------------- +-- 电力功率因数-电容器投运详情 +-- ---------------------------- +DROP TABLE IF EXISTS `t_power_capacitor_det`; +CREATE TABLE `t_power_capacitor_det` +( + `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`; -- Gitblit v1.9.3