| | |
| | | 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), -- 生产人id |
| | | producer_id BIGINT, -- 生产人id |
| | | 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), -- 创建人用户名 |
| | |
| | | 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 '创建该记录的用户'; |