| 字段 | 类型 | 键 | 可空 | 注释 |
|---|---|---|---|---|
| id | bigint | PRI | NO | |
| user_id | bigint | MUL | NO | 发起人 |
| invitee_id | bigint | YES | 被邀请人 | |
| fission_type | varchar | NO | invite 人拉人 / group 拼团 / content 内容分享 / qr 门店码 | |
| channel | varchar | YES | h5/miniapp/app/qr | |
| store_id | bigint | MUL | YES | |
| org_id | bigint | YES | ||
| level | int | YES | 裂变层级,只算一级奖励 | |
| order_no | varchar | MUL | YES | 归因订单号 |
| reward_amount | decimal | YES | ||
| reward_status | varchar | YES | PENDING/SETTLED/CANCEL | |
| created_at | datetime | YES |