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 | 40 +++++++++++++++++++++------------------- 1 files changed, 21 insertions(+), 19 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 31bc9b2..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 @@ -1,24 +1,26 @@ -- 鍒涘缓鐢熶骇鏄庣粏琛� CREATE TABLE production ( - id BIGSERIAL PRIMARY KEY, -- 涓婚敭ID - coal_id BIGINT NOT NULL DEFAULT 0, -- 鐓ょID - coal VARCHAR(50) NOT NULL, -- 鐓ょ - calorific_value INT 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 VARCHAR(50), -- 鐢熶骇浜� - production_date DATE, -- 鐢熶骇鏃ユ湡 + id BIGSERIAL PRIMARY KEY, -- 涓婚敭ID + production_master_id BIGINT NOT NULL DEFAULT 0, -- 鐢熶骇涓昏〃ID + coal_id BIGINT NOT NULL DEFAULT 0, -- 鐓ょID + 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 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), -- 鍒涘缓浜虹敤鎴峰悕 - create_time TIMESTAMP WITHOUT TIME ZONE, -- 鍒涘缓鏃堕棿锛岄粯璁ゅ綋鍓嶆椂闂� - update_by VARCHAR(255), -- 鏈�鍚庢洿鏂颁汉鐢ㄦ埛鍚� - update_time TIMESTAMP WITHOUT TIME ZONE -- 鏈�鍚庢洿鏂版椂闂达紝榛樿褰撳墠鏃堕棿 + deleted INT NOT NULL DEFAULT 0, -- 杞垹闄ゆ爣蹇楋細0=鏈垹闄わ紝1=宸插垹闄� + create_by VARCHAR(255), -- 鍒涘缓浜虹敤鎴峰悕 + create_time TIMESTAMP WITHOUT TIME ZONE, -- 鍒涘缓鏃堕棿锛岄粯璁ゅ綋鍓嶆椂闂� + update_by VARCHAR(255), -- 鏈�鍚庢洿鏂颁汉鐢ㄦ埛鍚� + update_time TIMESTAMP WITHOUT TIME ZONE -- 鏈�鍚庢洿鏂版椂闂达紝榛樿褰撳墠鏃堕棿 ); -- 娣诲姞琛ㄦ敞閲� @@ -27,8 +29,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.calorific_value IS '鐑��'; COMMENT ON COLUMN production.production_quantity IS '鐢熶骇鏁伴噺'; COMMENT ON COLUMN production.labor_cost IS '浜哄伐鎴愭湰'; COMMENT ON COLUMN production.energy_consumption_cost IS '鑳借�楁垚鏈�'; @@ -37,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