| 字段 | 类型 | 键 | 可空 | 注释 |
|---|---|---|---|---|
| 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 |