From 8c627df4abacbe7397d0c1831f1a71c62ebe15b2 Mon Sep 17 00:00:00 2001
From: maven <2163098428@qq.com>
Date: 星期三, 15 十月 2025 10:45:33 +0800
Subject: [PATCH] yys 1.随机排产
---
main-business/src/main/resources/db/migration/postgresql/V20250613093400__create_table_production_master.sql | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/main-business/src/main/resources/db/migration/postgresql/V20250613093400__create_table_production_master.sql b/main-business/src/main/resources/db/migration/postgresql/V20250613093400__create_table_production_master.sql
index f5343db..51e69ed 100644
--- a/main-business/src/main/resources/db/migration/postgresql/V20250613093400__create_table_production_master.sql
+++ b/main-business/src/main/resources/db/migration/postgresql/V20250613093400__create_table_production_master.sql
@@ -2,7 +2,7 @@
CREATE TABLE production_master
(
id BIGSERIAL PRIMARY KEY, -- 涓婚敭ID
- coal VARCHAR(50) NOT NULL, -- 鐓ょ
+ coal_id VARCHAR(50), -- 鐓ょID
production_quantity INT NOT NULL, -- 鐢熶骇鏁伴噺
labor_cost DECIMAL(10, 2) NOT NULL, -- 浜哄伐鎴愭湰
energy_consumption_cost DECIMAL(10, 2) NOT NULL, -- 鑳借�楁垚鏈�
@@ -24,7 +24,7 @@
-- 娣诲姞瀛楁娉ㄩ噴
COMMENT ON COLUMN production_master.id IS '涓婚敭ID';
-COMMENT ON COLUMN production_master.coal IS '鐓ょ';
+COMMENT ON COLUMN production_master.coal_id IS '鐓ょID';
COMMENT ON COLUMN production_master.production_quantity IS '鐢熶骇鏁伴噺';
COMMENT ON COLUMN production_master.labor_cost IS '浜哄伐鎴愭湰';
COMMENT ON COLUMN production_master.energy_consumption_cost IS '鑳借�楁垚鏈�';
--
Gitblit v1.9.3