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