| 字段 | 类型 | 键 | 可空 | 注释 |
|---|---|---|---|---|
| id | bigint | PRI | NO | |
| inbound_no | varchar | UNI | NO | |
| supplier_id | bigint | — | NO | 供应商 scm_supplier.id |
| warehouse_id | bigint | MUL | NO | 云仓 scm_warehouse.id |
| product_id | bigint | — | NO | 商品 product.id |
| qty | int | — | NO | |
| unit_cost | decimal | — | NO | 采购成本 |
| status | varchar | — | NO | pending/done |
| remark | varchar | — | YES | |
| create_time | datetime | — | YES | |
| confirm_time | datetime | — | YES |