member_account会员账户(官网members回落本地)
账户与会员域的实体表,18 个字段 · 主键 id · 外键候选 2 个
字段结构
| 字段 | 类型 | 键 | 可空 | 注释 |
| 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 | |
同域接口
相关角色
所属域
返回全景目录