member_account 字段统计会员账户(官网members回落本地)
精确行数与字段画像 · 估算行数 57 · 主键 id
类型分布
字段可空与键位
| 字段 | 类型 | 键 | 可空 | 注释 |
| 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 | |
相关
返回全景目录