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