| 字段 | 类型 | 键 | 可空 | 注释 |
|---|---|---|---|---|
| id | bigint | PRI | NO | |
| biz_id | varchar | — | NO | 业务幂等键(门店+日期+流水) |
| biz_type | varchar | MUL | NO | pos_order/merchant_order |
| store_id | varchar | MUL | YES | |
| merchant_id | varchar | — | YES | |
| terminal | varchar | — | YES | mobile/pc |
| device_id | varchar | — | YES | |
| amount | decimal | — | YES | |
| payload | json | — | YES | |
| occurred_at | datetime | — | YES | |
| received_at | datetime | — | YES |