| 字段 | 类型 | 键 | 可空 | 注释 |
|---|---|---|---|---|
| id | bigint | PRI | NO | |
| scope_type | varchar | MUL | NO | BIZ_TYPE/CATEGORY/PRODUCT |
| scope_value | varchar | — | NO | 业务类型码/分类ID/商品ID |
| points_per_yuan | decimal | — | NO | 每1元产出积分 |
| multiplier_mode | varchar | — | NO | FIXED=不叠加 LEVEL=按等级倍率 |
| priority | int | — | NO | 命中优先级,数值大优先 |
| status | tinyint | — | NO | |
| note | varchar | — | YES | |
| created_at | datetime | — | YES |