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/V20250604111200__create_table_official_inventory.sql | 26 +++++++++++++++++---------
1 files changed, 17 insertions(+), 9 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 a8043a8..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
@@ -2,19 +2,21 @@
CREATE TABLE official_inventory
(
id BIGSERIAL PRIMARY KEY, -- 涓婚敭ID
- supplier_name VARCHAR(255) NOT NULL, -- 渚涜揣鍟嗗悕绉�
- coal VARCHAR(50) NOT NULL, -- 鐓ょ
+ supplier_id BIGINT, -- 渚涜揣鍟唅d
+ coal_id BIGINT NOT NULL, -- 鐓ょ
unit VARCHAR(50) NOT NULL, -- 鍗曚綅
- inventory_quantity DECIMAL(10, 2) NOT NULL, -- 搴撳瓨鏁伴噺
+ inventory_quantity DECIMAL(10, 0), -- 搴撳瓨鏁伴噺
price_including_tax DECIMAL(10, 2) NOT NULL, -- 鍗曚环锛堝惈绋庯級
total_price_including_tax DECIMAL(10, 2) NOT NULL, -- 鎬讳环锛堝惈绋庯級
price_excluding_tax DECIMAL(10, 2) NOT NULL, -- 涓嶅惈绋庡崟浠�
total_price_excluding_tax DECIMAL(10, 2) NOT NULL, -- 涓嶅惈绋庢�讳环
- pending_replenishment DECIMAL(10, 2) NOT NULL, -- 寰呰ˉ搴�
- registrant_id VARCHAR(50) NOT NULL, -- 鐧昏浜篿d
- type VARCHAR(50) NOT NULL, -- 鐧昏浜篿d
+ pending_replenishment DECIMAL(10, 0), -- 寰呰ˉ搴�
+ registrant_id BIGINT NOT NULL, -- 鐧昏浜篿d
+ type BIGINT, -- 鐓ゆ枡绫诲瀷 1 鎴愬搧/ 2 鍘熸枡
pending_id BIGINT, -- 寰呭叆搴搃d
- merge_id BIGINT, -- 鍚堝苟id
+ 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=宸插垹闄�
@@ -29,16 +31,22 @@
-- 娣诲姞瀛楁娉ㄩ噴
COMMENT ON COLUMN official_inventory.id IS '涓婚敭ID';
-COMMENT ON COLUMN official_inventory.supplier_name IS '渚涜揣鍟嗗悕绉�';
-COMMENT ON COLUMN official_inventory.coal IS '鐓ょ';
+COMMENT ON COLUMN official_inventory.supplier_id IS '渚涜揣鍟唅d';
+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 '寰呰ˉ搴�';
+COMMENT ON COLUMN official_inventory.type IS '鐓ゆ枡绫诲瀷 1 鎴愬搧/ 2 鍘熸枡';
COMMENT ON COLUMN official_inventory.registrant_id IS '鐧昏浜篿d';
COMMENT ON COLUMN official_inventory.registration_date IS '鐧昏鏃ユ湡';
COMMENT ON COLUMN official_inventory.merge_id IS '鍚堝苟id';
+COMMENT ON COLUMN official_inventory.coal_plan_id IS '鐓よ川鏂规id';
+COMMENT ON COLUMN official_inventory.pending_id IS '寰呭叆搴搃d';
+COMMENT ON COLUMN official_inventory.price_excluding_tax IS '涓嶅惈绋庡崟浠�';
+COMMENT ON COLUMN official_inventory.total_price_excluding_tax IS '涓嶅惈绋庢�讳环';
COMMENT ON COLUMN official_inventory.deleted IS '杞垹闄ゆ爣蹇楋紝0=鏈垹闄わ紝1=宸插垹闄�';
COMMENT ON COLUMN official_inventory.create_by IS '鍒涘缓璇ヨ褰曠殑鐢ㄦ埛';
--
Gitblit v1.9.3