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/V20250604101800__create_table_production.sql | 2 ++
1 files changed, 2 insertions(+), 0 deletions(-)
diff --git a/main-business/src/main/resources/db/migration/postgresql/V20250604101800__create_table_production.sql b/main-business/src/main/resources/db/migration/postgresql/V20250604101800__create_table_production.sql
index cc091ed..adf249b 100644
--- a/main-business/src/main/resources/db/migration/postgresql/V20250604101800__create_table_production.sql
+++ b/main-business/src/main/resources/db/migration/postgresql/V20250604101800__create_table_production.sql
@@ -5,6 +5,7 @@
production_master_id BIGINT NOT NULL DEFAULT 0, -- 鐢熶骇涓昏〃ID
coal_id BIGINT NOT NULL DEFAULT 0, -- 鐓ょID
production_quantity INT NOT NULL, -- 鐢熶骇鏁伴噺
+ pending_quantity INT NOT NULL DEFAULT 0, -- 寰呮帓浜ф暟閲�
labor_cost DECIMAL(10, 2) NOT NULL, -- 浜哄伐鎴愭湰
energy_consumption_cost DECIMAL(10, 2) NOT NULL, -- 鑳借�楁垚鏈�
equipment_depreciation DECIMAL(10, 2) NOT NULL, -- 璁惧鎶樻棫
@@ -30,6 +31,7 @@
COMMENT ON COLUMN production.id IS '涓婚敭ID';
COMMENT ON COLUMN production.coal_id IS '鐓ょID';
COMMENT ON COLUMN production.production_quantity IS '鐢熶骇鏁伴噺';
+COMMENT ON COLUMN production.pending_quantity IS '寰呮帓浜ф暟閲�';
COMMENT ON COLUMN production.labor_cost IS '浜哄伐鎴愭湰';
COMMENT ON COLUMN production.energy_consumption_cost IS '鑳借�楁垚鏈�';
COMMENT ON COLUMN production.equipment_depreciation IS '璁惧鎶樻棫';
--
Gitblit v1.9.3