| | |
| | | `id` varchar(36) NOT NULL COMMENT 'id', |
| | | `info_type` varchar(10) NULL DEFAULT NULL COMMENT '信息类型(0:生产情况,1:能源发生,2:能源消耗)', |
| | | `ind_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '指标类型(prod_day,main,child)', |
| | | `data_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '数据类型(测点,指标)', |
| | | `point_no` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '测点编码', |
| | | `data_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '数据类型(测点,指标)', |
| | | `point_no` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '测点编码', |
| | | `ind_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '指标编码', |
| | | `ind_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '指标名称', |
| | | `ind_unit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '指标单位', |
| | |
| | | `rel_id` varchar(36) NULL DEFAULT NULL COMMENT '关联ID', |
| | | `name` varchar(20) NULL DEFAULT NULL COMMENT '图表名称', |
| | | `clock` varchar(20) NULL DEFAULT NULL COMMENT '查询时间', |
| | | `value_json` varchar(1000) NULL DEFAULT NULL COMMENT '值', |
| | | `data_type` varchar(20) DEFAULT NULL COMMENT '数据类型(测点,指标)', |
| | | `data_no` varchar(20) DEFAULT NULL COMMENT '数据编码', |
| | | `start_time` datetime COMMENT '开始时间', |
| | | `end_time` datetime COMMENT '结束时间', |
| | | `sort` int NULL DEFAULT NULL COMMENT '排序', |
| | | `create_date` datetime COMMENT '创建时间', |
| | | PRIMARY KEY (`id`) USING BTREE, |
| | |
| | | ( |
| | | `id` varchar(36) NOT NULL COMMENT 'id', |
| | | `rel_id` varchar(36) NULL DEFAULT NULL COMMENT '关联ID', |
| | | `title` varchar(20) NULL DEFAULT NULL COMMENT '标题', |
| | | `title` varchar(20) NULL DEFAULT NULL COMMENT '标题', |
| | | `clock` varchar(20) NULL DEFAULT NULL COMMENT '查询时间', |
| | | `ind_name` varchar(20) NULL DEFAULT NULL COMMENT '名称', |
| | | `ind_value` varchar(20) NULL DEFAULT NULL COMMENT '值', |
| | |
| | | -- ---------------------------- |
| | | -- 负荷移植-月最大需量,实测需量,有功功率 |
| | | -- ---------------------------- |
| | | CREATE TABLE `t_power_demand` ( |
| | | `id` varchar(36) NOT NULL COMMENT 'id', |
| | | `name` varchar(50) DEFAULT NULL COMMENT '机组名称', |
| | | `max_demand` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '月最大需量', |
| | | `cur_demand` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '实测需量', |
| | | `active_power` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '有功功率', |
| | | `sort` varchar(50) DEFAULT NULL COMMENT '排序', |
| | | PRIMARY KEY (`id`) |
| | | CREATE TABLE `t_power_demand` |
| | | ( |
| | | `id` varchar(36) NOT NULL COMMENT 'id', |
| | | `name` varchar(50) DEFAULT NULL COMMENT '机组名称', |
| | | `max_demand` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '月最大需量', |
| | | `cur_demand` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '实测需量', |
| | | `active_power` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '有功功率', |
| | | `sort` varchar(50) DEFAULT NULL COMMENT '排序', |
| | | PRIMARY KEY (`id`) |
| | | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='月最大需量,实测需量,有功功率'; |