plat_user.md 2.03 KB

plat_user

平台用户表

  • Engine: InnoDB
  • Collation: utf8mb3_general_ci

Columns

# Name Type Null Key Default Extra Comment
1 iIncreaseId int NO PRI auto_increment 主键(自增序列)
2 tCreateTime datetime NO MUL 创建时间
3 tModifyTime datetime NO 修改时间
4 sUserId varchar(35) NO UNI 用户编号(P_USR开头)
5 sShopUserId varchar(35) NO MUL 商铺用户编号
6 sUserName varchar(50) NO MUL 用户名
7 sPassWord varchar(100) NO 登陆密码
8 iUserType tinyint NO MUL 用户类型(0:超级管理员,1:加工商,2:店铺,3:员工,4:客户)
9 sLoginMobile varchar(20) NO MUL 登陆手机
10 sLoginMail varchar(100) NO MUL 登录邮箱
11 iIsMobileLogin tinyint NO 1 是否开启手机登陆(0:不开启,1:开启)
12 sUnionLoginName varchar(100) NO MUL 联合登录用户名
13 iUnionLoginType tinyint YES 联合登录类型(0:微信,1:qq)
14 iRegisterLocation tinyint NO 0 注册所在地(0:国内,1:海外)
15 iIsDelete tinyint NO 0 是否被删除(0:未删除,1:已删除)

Indexes

Name Unique Type Columns
PLAY_USER_IDX1 BTREE sUnionLoginName
PLAY_USER_IDX2 BTREE tCreateTime
PLAY_USER_IDX3 BTREE sLoginMail
PLAY_USER_IDX4 BTREE sShopUserId
PLAY_USER_IDX5 BTREE sUserName
PLAY_USER_IDX6 BTREE iUserType
PLAY_USER_IDX7 BTREE sLoginMobile
PLAY_USER_UNQ1 BTREE sUserId
PRIMARY BTREE iIncreaseId

Narrative

No human-written narrative yet — when this table is exercised by a vertical slice, link from there back to this page.