| | |
| | | production_master_id BIGINT NOT NULL DEFAULT 0, -- 生产主表ID |
| | | coal_id BIGINT NOT NULL DEFAULT 0, -- 煤种ID |
| | | production_quantity INT NOT NULL, -- 生产数量 |
| | | pending_quantity INT NOT NULL DEFAULT 0, -- 待排产数量 |
| | | labor_cost DECIMAL(10, 2) NOT NULL, -- 人工成本 |
| | | energy_consumption_cost DECIMAL(10, 2) NOT NULL, -- 能耗成本 |
| | | equipment_depreciation DECIMAL(10, 2) NOT NULL, -- 设备折旧 |
| | |
| | | COMMENT ON COLUMN production.id IS '主键ID'; |
| | | COMMENT ON COLUMN production.coal_id IS '煤种ID'; |
| | | COMMENT ON COLUMN production.production_quantity IS '生产数量'; |
| | | COMMENT ON COLUMN production.pending_quantity IS '待排产数量'; |
| | | COMMENT ON COLUMN production.labor_cost IS '人工成本'; |
| | | COMMENT ON COLUMN production.energy_consumption_cost IS '能耗成本'; |
| | | COMMENT ON COLUMN production.equipment_depreciation IS '设备折旧'; |