| 字段 | 类型 | 键 | 可空 | 注释 |
|---|---|---|---|---|
| id | bigint | PRI | NO | |
| transfer_no | varchar | UNI | NO | |
| from_warehouse | bigint | NO | 调出仓 scm_warehouse.id | |
| to_store | bigint | MUL | NO | 调入门店 store.id |
| product_id | bigint | NO | ||
| qty | int | NO | ||
| status | varchar | NO | pending/in_transit/done | |
| remark | varchar | YES | ||
| create_time | datetime | YES | ||
| confirm_time | datetime | YES |