mftprocesschangeprocess.md 3.08 KB

Edit Raw Blame History



mftprocesschangeprocess


工单从表


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


工单id


29
sWorkOrderNo
varchar(100)
NO


工单号


30
sPartsType
varchar(100)
NO


部件类型


31
sWorkOrderControlId
varchar(100)
NO


工单控制表Id


32
bOriginalOutSide
bit(1)
NO

b'0'

源是否发外


33
bOutSide
bit(1)
NO

b'0'

是否发外


34
dOriginalAdjustLossQty
decimal(18,6)
NO

0.000000

源调整数量


35
dAdjustLossQty
decimal(18,6)
NO

0.000000

调整数量


36
sProcessMemo
text
YES


工序备注


Indexes


Name
Unique
Type
Columns


IndexN_mftprocesschangeprocess

BTREE

sId, sBrandsId, sSubsidiaryId, sParentId, sMakePerson


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