| | |
| | | ) 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`; |