From 8546dfc55df24663d18137c83bf490c15b8d46da Mon Sep 17 00:00:00 2001
From: zss <zss@example.com>
Date: 星期三, 11 三月 2026 13:03:03 +0800
Subject: [PATCH] 能耗管理的统计
---
doc/宁夏-中盛建材.sql | 28 ++++++++++++++--------------
1 files changed, 14 insertions(+), 14 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 0c8b704..ba7e338 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"
@@ -3,44 +3,32 @@
CREATE TABLE production_plan
(
id BIGINT PRIMARY KEY AUTO_INCREMENT COMMENT '涓婚敭',
-
form_instance_id VARCHAR(64) COMMENT '琛ㄥ崟瀹炰緥ID',
serial_no VARCHAR(50) COMMENT '娴佹按鍙�',
-
apply_no VARCHAR(100) COMMENT '鐢宠鍗曠紪鍙�',
customer_name VARCHAR(200) COMMENT '瀹㈡埛鍚嶇О',
-
material_code VARCHAR(100) COMMENT '鐗╂枡缂栫爜',
product_name VARCHAR(200) COMMENT '浜у搧鍚嶇О',
product_spec VARCHAR(200) COMMENT '浜у搧瑙勬牸',
-
length INT COMMENT '闀�',
width INT COMMENT '瀹�',
height INT COMMENT '楂�',
-
quantity INT COMMENT '鍧楁暟',
+ total_count INT COMMENT '姝ゆ缁熻鏁伴噺',
volume DECIMAL(10, 4) COMMENT '鏂规暟',
-
strength VARCHAR(50) COMMENT '寮哄害',
-
start_date DATETIME COMMENT '寮�濮嬫棩鏈�',
end_date DATETIME COMMENT '缁撴潫鏃ユ湡',
-
submitter VARCHAR(100) COMMENT '鎻愪氦浜�',
submit_org VARCHAR(200) COMMENT '鎻愪氦浜虹粍缁�',
-
remark_one TEXT COMMENT '澶囨敞1',
remark_two TEXT COMMENT '澶囨敞2',
-
creator_name VARCHAR(100) COMMENT '鍒涘缓浜�',
modifier_name VARCHAR(100) COMMENT '淇敼浜�',
-
form_created_time DATETIME COMMENT '琛ㄥ崟鍒涘缓鏃堕棿',
form_modified_time DATETIME COMMENT '琛ㄥ崟淇敼鏃堕棿',
-
data_sync_type TINYINT DEFAULT 1 COMMENT '鏁版嵁鍚屾绫诲瀷锛�1=鎵嬪姩 2=瀹氭椂浠诲姟',
data_source_type TINYINT DEFAULT 1 COMMENT '鏁版嵁鏉ユ簮绫诲瀷锛�1=閿�鍞鍗� 2=閿�鍞娴�',
-
create_time DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '鏁版嵁搴撳垱寤烘椂闂�',
update_time DATETIME COMMENT '鏁版嵁搴撴洿鏂版椂闂�',
@@ -48,7 +36,6 @@
INDEX idx_serial_no (serial_no),
INDEX idx_form_instance_id (form_instance_id),
INDEX idx_material_code (material_code)
-
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4 COMMENT ='閿�鍞敓浜ц鍒�';
@@ -82,3 +69,16 @@
`update_user` bigint NULL DEFAULT NULL COMMENT '鏇存柊鑰�',
PRIMARY KEY (`id`)
) COMMENT = '鑳芥簮绫诲瀷-鑳借�楁妱琛ㄦ槑缁�';
+
+CREATE TABLE `product-inventory-management-zsjc`.`energy_consumption_detail_file` (
+ `id` int NOT NULL AUTO_INCREMENT,
+ `energy_consumption_detail_id` int NULL COMMENT '鍏宠仈澶栭敭鑳借�楁妱琛╥d',
+ `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `file_size` double NULL DEFAULT NULL,
+ `create_time` timestamp(0) NULL DEFAULT NULL,
+ `create_user` int NULL DEFAULT NULL,
+ `update_time` timestamp(0) NULL DEFAULT NULL,
+ `update_user` int NULL DEFAULT NULL,
+ PRIMARY KEY (`id`)
+ ) COMMENT = '鑳芥簮绫诲瀷-鑳借�楁妱琛ㄦ槑缁哶闄勪欢';
--
Gitblit v1.9.3