From 5eec9b5a9d8bf9e49663d5a51cab7490fef5b204 Mon Sep 17 00:00:00 2001
From: maven <2163098428@qq.com>
Date: 星期二, 26 八月 2025 15:22:03 +0800
Subject: [PATCH] yys 生产管控（完成基本功能）
---
main-business/src/main/resources/db/migration/postgresql/V20250604101800__create_table_production.sql | 6 +++++-
1 files changed, 5 insertions(+), 1 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 c1e6c28..cc091ed 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
@@ -10,9 +10,11 @@
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, -- 鐢熶骇鏃ユ湡
+ type BIGINT, -- 鐓ゆ枡绫诲瀷 1-鎴愬搧 2-鍘熸枡
+ status BIGINT, -- 鐘舵�侊紙1-寰呮帓浜� 2-宸叉帓浜э級
deleted INT NOT NULL DEFAULT 0, -- 杞垹闄ゆ爣蹇楋細0=鏈垹闄わ紝1=宸插垹闄�
create_by VARCHAR(255), -- 鍒涘缓浜虹敤鎴峰悕
@@ -35,6 +37,8 @@
COMMENT ON COLUMN production.total_cost IS '鎬绘垚鏈�';
COMMENT ON COLUMN production.producer IS '鐢熶骇浜�';
COMMENT ON COLUMN production.production_date IS '鐢熶骇鏃ユ湡';
+COMMENT ON COLUMN production.type IS '鐓ゆ枡绫诲瀷 1-鎴愬搧 2-鍘熸枡';
+COMMENT ON COLUMN production.status IS '鐘舵�侊紙1-寰呮帓浜� 2-宸叉帓浜э級';
COMMENT ON COLUMN production.deleted IS '杞垹闄ゆ爣蹇楋紝0=鏈垹闄わ紝1=宸插垹闄�';
COMMENT ON COLUMN production.create_by IS '鍒涘缓璇ヨ褰曠殑鐢ㄦ埛';
--
Gitblit v1.9.3