From cb966ac5c02835eab5a99b7b93a5a9a063cf3201 Mon Sep 17 00:00:00 2001
From: liding <756868258@qq.com>
Date: 星期三, 25 六月 2025 15:55:08 +0800
Subject: [PATCH] 人员优化
---
main-business/src/main/resources/db/migration/postgresql/V20250604101800__create_table_production.sql | 4 +---
1 files changed, 1 insertions(+), 3 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 2f9b09e..a733470 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
@@ -4,14 +4,13 @@
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, -- 鐓ょ
production_quantity INT NOT NULL, -- 鐢熶骇鏁伴噺
labor_cost DECIMAL(10, 2) NOT NULL, -- 浜哄伐鎴愭湰
energy_consumption_cost DECIMAL(10, 2) NOT NULL, -- 鑳借�楁垚鏈�
equipment_depreciation DECIMAL(10, 2) NOT NULL, -- 璁惧鎶樻棫
purchase_price DECIMAL(10, 2) NOT NULL, -- 閲囪喘鍗曚环
total_cost DECIMAL(10, 2) NOT NULL, -- 鎬绘垚鏈�
- producer_id VARCHAR(50), -- 鐢熶骇浜篿d
+ producer_id BIGINT, -- 鐢熶骇浜篿d
producer VARCHAR(50), -- 鐢熶骇浜�
production_date DATE, -- 鐢熶骇鏃ユ湡
@@ -28,7 +27,6 @@
-- 娣诲姞瀛楁娉ㄩ噴
COMMENT ON COLUMN production.id IS '涓婚敭ID';
COMMENT ON COLUMN production.coal_id IS '鐓ょID';
-COMMENT ON COLUMN production.coal IS '鐓ょ';
COMMENT ON COLUMN production.production_quantity IS '鐢熶骇鏁伴噺';
COMMENT ON COLUMN production.labor_cost IS '浜哄伐鎴愭湰';
COMMENT ON COLUMN production.energy_consumption_cost IS '鑳借�楁垚鏈�';
--
Gitblit v1.9.3