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/V20250604104500__create_table_pending_inventory.sql | 4 ++++
1 files changed, 4 insertions(+), 0 deletions(-)
diff --git a/main-business/src/main/resources/db/migration/postgresql/V20250604104500__create_table_pending_inventory.sql b/main-business/src/main/resources/db/migration/postgresql/V20250604104500__create_table_pending_inventory.sql
index d51c775..83e436d 100644
--- a/main-business/src/main/resources/db/migration/postgresql/V20250604104500__create_table_pending_inventory.sql
+++ b/main-business/src/main/resources/db/migration/postgresql/V20250604104500__create_table_pending_inventory.sql
@@ -17,6 +17,8 @@
supplier_id BIGINT, -- 渚涜揣鍟咺D
coal_id BIGINT, -- 鐓ょID
master_id BIGINT, -- 鐢熶骇鍔犲伐id
+ purchase_id BIGINT, -- 閲囪喘id
+ coal_plan_id BIGINT, -- 鐓よ川鏂规id
deleted INTEGER DEFAULT 0, -- 杞垹闄ゆ爣蹇楋紝0=鏈垹闄わ紝1=宸插垹闄�
create_by VARCHAR(255), -- 鍒涘缓璇ヨ褰曠殑鐢ㄦ埛
@@ -45,6 +47,8 @@
COMMENT ON COLUMN pending_inventory.supplier_id IS '渚涜揣鍟咺D';
COMMENT ON COLUMN pending_inventory.coal_id IS '鐓ょID';
COMMENT ON COLUMN pending_inventory.master_id IS '鐢熶骇鍔犲伐id';
+COMMENT ON COLUMN pending_inventory.purchase_id IS '閲囪喘id';
+COMMENT ON COLUMN pending_inventory.coal_plan_id IS '鐓よ川鏂规id';
COMMENT ON COLUMN pending_inventory.deleted IS '杞垹闄ゆ爣蹇楋紝0=鏈垹闄わ紝1=宸插垹闄�';
COMMENT ON COLUMN pending_inventory.create_by IS '鍒涘缓璇ヨ褰曠殑鐢ㄦ埛';
--
Gitblit v1.9.3