| 字段 | 类型 | 键 | 可空 | 注释 |
|---|---|---|---|---|
| id | bigint | PRI | NO | |
| user_id | bigint | UNI | NO | 本地sys_user.id |
| level_id | bigint | YES | member_level.id | |
| level_code | varchar | YES | 官网档位A-F | |
| points | int | YES | ||
| balance | decimal | YES | ||
| growth_value | int | YES | ||
| invite_code | varchar | MUL | YES | 本人推广/邀请码 |
| referral_code | varchar | YES | 上级推荐人码 | |
| referrer_user_id | bigint | YES | 上级本地user_id | |
| order_count | int | YES | ||
| total_spent | decimal | YES | ||
| sign_in_streak | int | YES | ||
| official_member_id | varchar | MUL | YES | 官网members.id |
| status | tinyint | YES | ||
| created_at | datetime | YES | ||
| updated_at | datetime | YES | ||
| redeem_code | varchar | UNI | NO |