mftprocesschangeslave.md 2.58 KB

Edit Raw Blame History



mftprocesschangeslave


工单从表


Rows (estimated): 0

Data size: 16.0 KB

Engine: InnoDB

Collation: utf8mb3_general_ci

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

Updated: 


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


父级ID


7
sProcessId
varchar(100)
NO


工序Id


8
sSReserve1
varchar(255)
YES


预留字符1


9
sSReserve2
varchar(255)
YES


预留字符2


10
sSReserve3
varchar(255)
YES


预留字符3


11
sSReserve4
varchar(255)
YES


预留字符4


12
sSReserve5
varchar(255)
YES


预留字符5


13
sSReserve6
varchar(255)
YES


预留字符6


14
dSReserve1
decimal(18,6)
YES


预留数字1


15
dSReserve2
decimal(18,6)
YES


预留数字2


16
dSReserve3
decimal(18,6)
YES


预留数字3


17
iSReserve1
int
YES


预留整型1


18
iSReserve2
int
YES


预留整型2


19
iSReserve3
int
YES


预留整型3


20
tSReserve1
datetime
YES


预留日期1


21
tSReserve2
datetime
YES


预留日期2


22
sMakePerson
varchar(255)
NO


操作人


23
sSrcSlaveId
varchar(100)
NO


源单从表Id


24
sSrcId
varchar(100)
NO


源单ID


25
sOriginalProcessId
varchar(100)
NO


源工序名称


26
sType
varchar(255)
NO


类型


27
sBeforeAfter
varchar(255)
NO


置前置后


28
sSlaveMemo
text
YES


备注


Indexes


Name
Unique
Type
Columns


IndexN_mftprocesschangeslave

BTREE

sId, sBrandsId, sSubsidiaryId, sParentId, sMakePerson


IndexU_mftprocesschangeslave
✓
BTREE

sId, sBrandsId, sSubsidiaryId, sMakePerson


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.