| 字段 | 类型 | 键 | 可空 | 注释 |
|---|---|---|---|---|
| id | bigint | PRI | NO | |
| user_id | bigint | MUL | NO | 持券人 |
| title | varchar | — | NO | |
| discount_type | varchar | — | YES | FIX满减/RATE折扣 |
| discount_value | decimal | — | NO | |
| min_amount | decimal | — | YES | 使用门槛 |
| status | varchar | — | YES | UNUSED/USED/EXPIRED |
| expire_time | datetime | — | YES | |
| created_at | datetime | — | YES |