| | |
| | | key uk_p_code (p_code), |
| | | UNIQUE key uk_node_code (node_code) |
| | | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='电力下拉关系表'; |
| | | |
| | | |
| | | -- ---------------------------- |
| | | -- 煤气预测析配置 |
| | | -- ---------------------------- |
| | | DROP TABLE IF EXISTS `t_gas_pred_conf`; |
| | | CREATE TABLE `t_gas_pred_conf` |
| | | ( |
| | | `id` varchar(36) NOT NULL COMMENT 'id', |
| | | `chart_code` varchar(50) NULL DEFAULT NULL COMMENT '预测图编号', |
| | | `user_type` varchar(50) NULL DEFAULT NULL COMMENT '用户类型(发生,消耗)', |
| | | `item_no` varchar(50) NULL DEFAULT NULL COMMENT '预测项编号', |
| | | `item_name` varchar(50) NULL DEFAULT NULL COMMENT '预测项名称', |
| | | `out_key` varchar(50) NULL DEFAULT NULL COMMENT '预测项输出key', |
| | | `out_name` 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 '煤气预测析配置'; |