sys_reset_pwd.md 1.41 KB

Edit Raw Blame History



sys_reset_pwd


重置表


Rows (estimated): 2

Data size: 16.0 KB

Engine: InnoDB

Collation: utf8mb3_general_ci

Created: 2026-04-27 18:57:07

Updated: 2026-04-27 18:57:07


Columns


#
Name
Type
Null
Key
Default
Extra
Comment


1
iIncrement
int
NO
PRI

auto_increment
自增列


2
sId
varchar(100)
NO
MUL


标准ID


3
sBrandsId
varchar(100)
NO


加工商Id


4
sSubsidiaryId
varchar(100)
NO


子公司ID


5
sMakePerson
varchar(100)
NO


制单人


6
tCreateDate
datetime
NO

CURRENT_TIMESTAMP
DEFAULT_GENERATED
制单日期


7
sUserName
varchar(100)
NO


用户名称


8
sUserId
varchar(100)
NO
MUL


用户Id


9
sUserType
varchar(100)
NO


用户类型


10
sUserOldPwd
varchar(100)
NO


用户修改前密码


Indexes


Name
Unique
Type
Columns


IndexN_1

BTREE

sUserId, sUserOldPwd, sBrandsId, sSubsidiaryId


IndexU_1
✓
BTREE

sId, sBrandsId, sSubsidiaryId


PRIMARY
✓
BTREE
iIncrement


Narrative

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