| 字段 | 类型 | 键 | 可空 | 注释 |
|---|---|---|---|---|
| id | bigint | PRI | NO | |
| order_no | varchar | MUL | NO | |
| user_id | bigint | MUL | NO | |
| offset_type | varchar | — | NO | BALANCE 权益值 / COUPON 优惠券 / POINTS 积分 |
| coupon_id | bigint | — | YES | |
| amount | decimal | — | NO | 冲抵金额(元) |
| points_used | decimal | — | YES | 消耗积分(10积分=1元) |
| balance_before | decimal | — | YES | |
| balance_after | decimal | — | YES | |
| status | varchar | — | YES | OFFSET 已冲抵 / REVERSED 已冲回 |
| created_at | datetime | — | YES |