gdslogininfo.md 1.67 KB

Edit Raw Blame History



gdslogininfo


用户信息


Rows (estimated): 12

Data size: 16.0 KB

Engine: InnoDB

Collation: utf8mb3_general_ci

Created: 2026-04-27 18:53:08

Updated: 2026-04-27 18:53:08


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
MUL


加工商ID


4
sSubsidiaryId
varchar(100)
NO


子公司ID


5
tCreateDate
datetime
NO

CURRENT_TIMESTAMP
DEFAULT_GENERATED
制单日期


6
sMakePerson
varchar(100)
NO


制单人


7
iOrder
int
NO

0

排序号


8
sUserNo
varchar(255)
NO
MUL


用户号


9
sUserName
varchar(255)
NO


用户名


10
sUserPwd
varchar(255)
NO


密码


11
sType
varchar(255)
NO


角色类型 ：sysadmin 超级管理员；admin：实施人员；customer：售后人员；


Indexes


Name
Unique
Type
Columns


IndexN_gdslogininfo

BTREE

sId, sBrandsId, sSubsidiaryId


IndexN_gdslogininfoNo

BTREE

sUserNo, sUserName


IndexU_gdslogininfo
✓
BTREE

sId, sBrandsId, sSubsidiaryId


IndexU_gdslogininfoNo
✓
BTREE

sBrandsId, sSubsidiaryId, sUserNo


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.