| 字段 | 类型 | 键 | 可空 | 注释 |
|---|---|---|---|---|
| id | bigint | PRI | NO | |
| store_id | int | MUL | NO | 数字门店ID(yjgw.store_stock 口径) |
| order_id | bigint | — | YES | |
| order_no | varchar | MUL | NO | |
| voucher_code | varchar | MUL | YES | |
| product_id | bigint | — | NO | |
| product_name | varchar | — | NO | |
| qty | int | — | NO | 预售件数 |
| picked_qty | int | — | NO | 已提货核销件数 |
| status | varchar | — | NO | WAIT_PICKUP/PICKED/CANCELLED |
| member_phone | varchar | — | YES | |
| expire_at | datetime | — | YES | |
| remark | varchar | — | YES | |
| created_at | datetime | — | NO | |
| updated_at | datetime | — | NO |