mftprocesschangecontrol.md 2.55 KB

Edit Raw Blame History Permalink



mftprocesschangecontrol


工单从表


Engine: InnoDB

Collation: utf8mb3_general_ci


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
sValue
varchar(100)
NO


值


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
sOriginalValue
varchar(100)
NO


源值


26
sType
varchar(255)
NO


类型


27
sChangeType
varchar(255)
NO


修改字段值


28
sBeforeAfter
varchar(255)
NO


置前置后


29
dCoefficient
decimal(18,6)
NO

1.000000

系数


Indexes


Name
Unique
Type
Columns


IndexN_mftprocesschangecontrol

BTREE

sId, sBrandsId, sSubsidiaryId, sParentId, sMakePerson


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