mftqualityaccidentemp.md 2.17 KB

Edit Raw Blame History



mftqualityaccidentemp


Rows (estimated): 10

Data size: 16.0 KB

Engine: InnoDB

Collation: utf8mb3_general_ci

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

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


Columns


#
Name
Type
Null
Key
Default
Extra
Comment


1
iIncrement
int
NO

0

自增列


2
sId
varchar(100)
NO


唯一ID


3
sBrandsId
varchar(100)
NO


加工商ID


4
sSubsidiaryId
varchar(100)
NO


子公司ID


5
iOrder
int
NO

0

排序号


6
sParentId
varchar(100)
NO


父级ID


7
sSqlConditionId
varchar(100)
YES


从表ID


8
sDeptId
varchar(100)
YES


9
sDeptName
varchar(255)
YES


部门


10
sEmployeeId
varchar(100)
NO


职员ID


11
sEmployeeName
varchar(255)
YES


责任人


12
dEmpRate
decimal(18,6)
YES


责任比列


13
dEmpMoney
decimal(18,6)
NO

0.000000

责任比列


14
sSReserve3
varchar(255)
YES


预留字符3


15
sSReserve4
varchar(255)
YES


预留字符4


16
sSReserve5
varchar(255)
YES


预留字符5


17
sSReserve6
varchar(255)
YES


预留字符6


18
dSReserve1
decimal(18,6)
YES


预留数字1


19
dSReserve2
decimal(18,6)
YES


预留数字2


20
dSReserve3
decimal(18,6)
YES


预留数字3


21
iSReserve1
int
YES


预留整型1


22
iSReserve2
int
YES


预留整型2


23
iSReserve3
int
YES


预留整型3


24
tSReserve1
datetime
YES


预留日期1


25
tSReserve2
datetime
YES


预留日期2


26
sMakePerson
varchar(255)
NO


操作人


27
sMemo
text
YES


备注


Narrative

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