From f6f57ba70679a0b050031f3cdf81b5bf5d4cbd60 Mon Sep 17 00:00:00 2001
From: liding <756868258@qq.com>
Date: 星期五, 11 七月 2025 15:28:37 +0800
Subject: [PATCH] 1.生产加工优化 2.销售，库存查询优化
---
main-business/src/main/resources/db/migration/postgresql/V20250701142700__create_table_equipment_management.sql | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/main-business/src/main/resources/db/migration/postgresql/V20250701142700__create_table_equipment_management.sql b/main-business/src/main/resources/db/migration/postgresql/V20250701142700__create_table_equipment_management.sql
index 0abb2b1..a682429 100644
--- a/main-business/src/main/resources/db/migration/postgresql/V20250701142700__create_table_equipment_management.sql
+++ b/main-business/src/main/resources/db/migration/postgresql/V20250701142700__create_table_equipment_management.sql
@@ -3,7 +3,7 @@
CREATE TABLE equipment_management
(
id BIGSERIAL PRIMARY KEY, -- 涓婚敭 ID
- equipment_id VARCHAR(50) NOT NULL, -- 璁惧缂栧彿
+ equipment_no VARCHAR(50) NOT NULL, -- 璁惧缂栧彿
equipment_name VARCHAR(100) NOT NULL, -- 璁惧鍚嶇О
quantity INT NOT NULL DEFAULT 0, -- 鏁伴噺
specification VARCHAR(50) NOT NULL, -- 瑙勬牸鍨嬪彿
@@ -27,7 +27,7 @@
COMMENT
ON COLUMN equipment_management.id IS ' 涓婚敭 ID';
COMMENT
-ON COLUMN equipment_management.equipment_id IS ' 璁惧缂栧彿 ';
+ON COLUMN equipment_management.equipment_no IS ' 璁惧缂栧彿 ';
COMMENT
ON COLUMN equipment_management.equipment_name IS ' 璁惧鍚嶇О ';
COMMENT
--
Gitblit v1.9.3