sysmsguser.md 1.43 KB

Edit Raw Blame History



sysmsguser


审核模板-审核条件


Rows (estimated): 2

Data size: 16.0 KB

Engine: InnoDB

Collation: utf8mb3_general_ci

Created: 2026-04-27 19:10:02

Updated: 2026-04-27 19:10:02


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
iOrder
int
NO

0

排序号


6
sParentId
varchar(100)
NO
MUL


父级ID


7
sUserId
varchar(100)
NO
MUL


审核公式ID


8
bIsView
bit(1)
NO


以哪张表计算,是否查看了


9
bReply
bit(1)
NO

b'0'

是否回复


10
sMakePerson
varchar(255)
NO


制单人


Indexes


Name
Unique
Type
Columns


IndexN_sysmsguser

BTREE
sParentId


IndexN_sysmsguserUserId

BTREE

sUserId, sBrandsId, sSubsidiaryId


IndexU_sysmsguser
✓
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.