syssearchapprove.md 1.42 KB

Edit Raw Blame History



syssearchapprove


过滤条件--默认表


Rows (estimated): 3

Data size: 16.0 KB

Engine: InnoDB

Collation: utf8mb3_general_ci

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

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


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
tCreateDate
datetime
NO

CURRENT_TIMESTAMP
DEFAULT_GENERATED
创建时间


6
sMakePerson
varchar(100)
NO


制单人


7
iOrder
int
NO

0

排序


8
sParentId
varchar(255)
NO


查询条件表Id


9
sUserId
varchar(100)
NO
MUL


用户ID


10
sFormId
varchar(255)
NO


窗体显示


Indexes


Name
Unique
Type
Columns


IndexU_sysSearch
✓
BTREE

sId, sBrandsId, sSubsidiaryId


IndexU_sysSearchName
✓
BTREE

sUserId, sBrandsId, sSubsidiaryId, sParentId


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.