From 173f44a1f9a59509996192e3446cbd26f2613b5e Mon Sep 17 00:00:00 2001
From: maven <2163098428@qq.com>
Date: 星期五, 10 十月 2025 15:55:32 +0800
Subject: [PATCH] yys 新增关键煤种锁仓模块
---
main-business/src/main/resources/db/migration/postgresql/V20250613112800__create_table_production_inventory.sql | 7 +++----
1 files changed, 3 insertions(+), 4 deletions(-)
diff --git a/main-business/src/main/resources/db/migration/postgresql/V20250613112800__create_table_production_inventory.sql b/main-business/src/main/resources/db/migration/postgresql/V20250613112800__create_table_production_inventory.sql
index 37318d5..45c8d38 100644
--- a/main-business/src/main/resources/db/migration/postgresql/V20250613112800__create_table_production_inventory.sql
+++ b/main-business/src/main/resources/db/migration/postgresql/V20250613112800__create_table_production_inventory.sql
@@ -4,10 +4,9 @@
id BIGSERIAL PRIMARY KEY, -- 涓婚敭ID
production_master_id BIGINT NOT NULL DEFAULT 0, -- 鐢熶骇涓昏〃ID
coal_id BIGINT NOT NULL DEFAULT 0, -- 鐓ょID
- coal VARCHAR(50) NOT NULL, -- 鐓ょ
+ official_id BIGINT NOT NULL DEFAULT 0, -- 搴撳瓨ID
inventory_quantity INT NOT NULL, -- 搴撳瓨鏁伴噺
used_quantity INT NOT NULL, -- 浣跨敤鏁伴噺
-
deleted INT NOT NULL DEFAULT 0, -- 杞垹闄ゆ爣蹇楋細0=鏈垹闄わ紝1=宸插垹闄�
create_by VARCHAR(255), -- 鍒涘缓浜虹敤鎴峰悕
@@ -17,13 +16,13 @@
);
-- 娣诲姞琛ㄦ敞閲�
-COMMENT ON TABLE production_inventory IS '鐢熶骇涓昏〃';
+COMMENT ON TABLE production_inventory IS '鐢熶骇搴撳瓨浣跨敤璁板綍琛�';
-- 娣诲姞瀛楁娉ㄩ噴
COMMENT ON COLUMN production_inventory.id IS '涓婚敭ID';
COMMENT ON COLUMN production_inventory.production_master_id IS '鐢熶骇涓昏〃ID';
COMMENT ON COLUMN production_inventory.coal_id IS '鐓ょID';
-COMMENT ON COLUMN production_inventory.coal IS '鐓ょ';
+COMMENT ON COLUMN production_inventory.official_id IS '搴撳瓨ID';
COMMENT ON COLUMN production_inventory.inventory_quantity IS '搴撳瓨鏁伴噺';
COMMENT ON COLUMN production_inventory.used_quantity IS '浣跨敤鏁伴噺';
--
Gitblit v1.9.3