| 字段 | 类型 | 键 | 可空 | 注释 |
|---|---|---|---|---|
| id | int | PRI | NO | |
| activity_no | varchar | UNI | NO | |
| name | varchar | — | NO | |
| sponsor_type | varchar | — | NO | |
| merchant_id | varchar | — | YES | |
| store_id | varchar | — | YES | |
| target_type | varchar | — | NO | |
| target_value | text | — | YES | |
| discount_value | decimal | — | NO | |
| min_amount | decimal | — | NO | |
| start_time | datetime | — | NO | |
| end_time | datetime | — | NO | |
| per_user_limit | int | — | NO | |
| total_budget | decimal | — | NO | |
| budget_used | decimal | — | NO | |
| status | varchar | — | NO | |
| note | varchar | — | YES | |
| created_at | datetime | — | YES | |
| updated_at | datetime | — | YES | |
| fund_code | varchar | — | YES |