plat_user

平台用户表

• Rows (estimated): 0
• Data size: 16.0 KB
• Engine: InnoDB
• Collation: utf8mb3_general_ci
• Created: 2026-04-27 18:54:56
• Updated:

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.