From ee31e1c8f823d3d6cb8692689fa69bf457f3a99a Mon Sep 17 00:00:00 2001
From: maven <2163098428@qq.com>
Date: 星期四, 28 八月 2025 18:02:21 +0800
Subject: [PATCH] yys
---
main-business/src/main/resources/db/migration/postgresql/V20250604111200__create_table_official_inventory.sql | 2 ++
1 files changed, 2 insertions(+), 0 deletions(-)
diff --git a/main-business/src/main/resources/db/migration/postgresql/V20250604111200__create_table_official_inventory.sql b/main-business/src/main/resources/db/migration/postgresql/V20250604111200__create_table_official_inventory.sql
index 739f7ec..20f560e 100644
--- a/main-business/src/main/resources/db/migration/postgresql/V20250604111200__create_table_official_inventory.sql
+++ b/main-business/src/main/resources/db/migration/postgresql/V20250604111200__create_table_official_inventory.sql
@@ -16,6 +16,7 @@
pending_id BIGINT, -- 寰呭叆搴搃d
coal_plan_id BIGINT, -- 鐓よ川鏂规id
merge_id VARCHAR(255), -- 鍚堝苟id
+ code VARCHAR(255), -- 缂栧彿
registration_date TIMESTAMP WITHOUT TIME ZONE,
deleted INT NOT NULL DEFAULT 0, -- 杞垹闄ゆ爣蹇楋細0=鏈垹闄わ紝1=宸插垹闄�
@@ -34,6 +35,7 @@
COMMENT ON COLUMN official_inventory.coal_id IS '鐓ょid';
COMMENT ON COLUMN official_inventory.unit IS '鍗曚綅';
COMMENT ON COLUMN official_inventory.inventory_quantity IS '搴撳瓨鏁伴噺';
+COMMENT ON COLUMN official_inventory.code IS '缂栧彿';
COMMENT ON COLUMN official_inventory.price_including_tax IS '鍗曚环锛堝惈绋庯級';
COMMENT ON COLUMN official_inventory.total_price_including_tax IS '鎬讳环锛堝惈绋庯級';
COMMENT ON COLUMN official_inventory.pending_replenishment IS '寰呰ˉ搴�';
--
Gitblit v1.9.3