syssystemsettings.md 1.47 KB

Edit Raw Blame History



syssystemsettings


系统设定表


Rows (estimated): 208

Data size: 64.0 KB

Engine: InnoDB

Collation: utf8mb3_general_ci

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

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
1

唯一ID


3
sBrandsId
varchar(100)
NO
MUL


加工商ID


4
sSubsidiaryId
varchar(100)
NO


子公司ID


5
tCreateDate
datetime
NO

2018-03-12 10:15:01

创建时间


6
sMakePerson
varchar(100)
NO


制单人


7
iOrder
int
NO

0

排序


8
sName
varchar(255)
YES


名称


9
sValue
varchar(255)
YES


值


10
sKeyName
varchar(20)
YES


类型


Indexes


Name
Unique
Type
Columns


IndexN_syssystemsettings

BTREE

sId, sBrandsId, sSubsidiaryId, sName


IndexU_syssystemsettings
✓
BTREE

sId, sBrandsId, sSubsidiaryId


IndexU_syssystemsettingsName
✓
BTREE

sBrandsId, sSubsidiaryId, sName


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.