From d7c626bbb83393550b63678a49d73a9ba44b1c85 Mon Sep 17 00:00:00 2001
From: zss <zss@example.com>
Date: 星期二, 10 三月 2026 13:16:58 +0800
Subject: [PATCH] 能耗管理的能源类型+能耗抄表明细
---
doc/宁夏-中盛建材.sql | 33 ++++++++++++++++++++++++++++++++-
1 files changed, 32 insertions(+), 1 deletions(-)
diff --git "a/doc/\345\256\201\345\244\217-\344\270\255\347\233\233\345\273\272\346\235\220.sql" "b/doc/\345\256\201\345\244\217-\344\270\255\347\233\233\345\273\272\346\235\220.sql"
index ee0341f..3407354 100644
--- "a/doc/\345\256\201\345\244\217-\344\270\255\347\233\233\345\273\272\346\235\220.sql"
+++ "b/doc/\345\256\201\345\244\217-\344\270\255\347\233\233\345\273\272\346\235\220.sql"
@@ -31,4 +31,35 @@
PRIMARY KEY (`id`),
KEY `idx_form_instance_id` (`form_instance_id`)
) ENGINE = INNODB
- DEFAULT CHARSET = utf8mb4 COMMENT = '閿�鍞敓浜ч渶姹�';
\ No newline at end of file
+ DEFAULT CHARSET = utf8mb4 COMMENT = '閿�鍞敓浜ч渶姹�';
+
+CREATE TABLE `product-inventory-management-zsjc`.`energy` (
+ `id` int NOT NULL AUTO_INCREMENT,
+ `energy_tyep` varchar(255) NULL COMMENT '鑳芥簮绫诲瀷',
+ `energy_name` varchar(255) NULL COMMENT '鑳芥簮鍚嶇О',
+ `unit` varchar(255) NULL COMMENT '鍗曚綅',
+ `unit_price` decimal(10, 2) NULL COMMENT '鍗曚环',
+ `remark` varchar(255) NULL COMMENT '澶囨敞',
+ `create_time` datetime(0) NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+ `update_time` datetime(0) NULL DEFAULT NULL COMMENT '鏇存柊鏃堕棿',
+ `create_user` bigint NULL DEFAULT NULL COMMENT '鍒涘缓鑰�',
+ `update_user` bigint NULL DEFAULT NULL COMMENT '鏇存柊鑰�',
+ PRIMARY KEY (`id`)
+ ) COMMENT = '鑳芥簮绫诲瀷';
+
+CREATE TABLE `product-inventory-management-zsjc`.`energy_consumption_detail` (
+ `id` int NOT NULL AUTO_INCREMENT,
+ `energy_id` int NULL COMMENT '澶栨鍏宠仈鑳芥簮绫诲瀷id',
+ `type` varchar(255) NULL COMMENT '鍔炲叕/鐢熶骇',
+ `meter_reading_location` varchar(255) NULL COMMENT '鎶勮〃浣嶇疆',
+ `meter_reading_date` date NULL COMMENT '鎶勮〃鏃ユ湡',
+ `start_code` decimal(10, 2) NULL COMMENT '璧风爜',
+ `stop_code` decimal(10, 2) NULL COMMENT '姝㈢爜',
+ `dosage` decimal(10, 2) NULL COMMENT '鐢ㄩ噺',
+ `remark` varchar(255) NULL COMMENT '澶囨敞',
+ `create_time` datetime(0) NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+ `update_time` datetime(0) NULL DEFAULT NULL COMMENT '鏇存柊鏃堕棿',
+ `create_user` bigint NULL DEFAULT NULL COMMENT '鍒涘缓鑰�',
+ `update_user` bigint NULL DEFAULT NULL COMMENT '鏇存柊鑰�',
+ PRIMARY KEY (`id`)
+ ) COMMENT = '鑳芥簮绫诲瀷-鑳借�楁妱琛ㄦ槑缁�';
--
Gitblit v1.9.3