| | |
|---|
| | | pending_id BIGINT, -- 待入库id |
|---|
| | | coal_plan_id BIGINT, -- 煤质方案id |
|---|
| | | merge_id VARCHAR(255), -- 合并id |
|---|
| | | code VARCHAR(255), -- 编号 |
|---|
| | | registration_date TIMESTAMP WITHOUT TIME ZONE, |
|---|
| | | |
|---|
| | | deleted INT NOT NULL DEFAULT 0, -- 软删除标志：0=未删除，1=已删除 |
|---|
| | |
|---|
| | | COMMENT ON COLUMN official_inventory.coal_id IS '煤种id'; |
|---|
| | | COMMENT ON COLUMN official_inventory.unit IS '单位'; |
|---|
| | | COMMENT ON COLUMN official_inventory.inventory_quantity IS '库存数量'; |
|---|
| | | COMMENT ON COLUMN official_inventory.code IS '编号'; |
|---|
| | | COMMENT ON COLUMN official_inventory.price_including_tax IS '单价（含税）'; |
|---|
| | | COMMENT ON COLUMN official_inventory.total_price_including_tax IS '总价（含税）'; |
|---|
| | | COMMENT ON COLUMN official_inventory.pending_replenishment IS '待补库'; |
|---|
