From f904274947d9a4bb44037e4d18a7d85c6aadaf7b Mon Sep 17 00:00:00 2001 From: liding <756868258@qq.com> Date: 星期六, 14 六月 2025 15:08:37 +0800 Subject: [PATCH] 1.生产加工 2.库存优化 --- main-business/src/main/resources/db/migration/postgresql/V20250604101800__create_table_production.sql | 36 ++++++++++++++++++------------------ 1 files changed, 18 insertions(+), 18 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..2f9b09e 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,25 @@ -- 鍒涘缓鐢熶骇鏄庣粏琛� 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 + 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 VARCHAR(50), -- 鐢熶骇浜� + production_date DATE, -- 鐢熶骇鏃ユ湡 - 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 -- 鏈�鍚庢洿鏂版椂闂达紝榛樿褰撳墠鏃堕棿 ); -- 娣诲姞琛ㄦ敞閲� @@ -28,7 +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 '鑳借�楁垚鏈�'; -- Gitblit v1.9.3