mftproducereportmachinestate.md 1.85 KB

Edit Raw Blame History



mftproducereportmachinestate


Rows (estimated): 204678

Data size: 39.6 MB

Engine: InnoDB

Collation: utf8mb3_general_ci

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

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


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
sMakePerson
varchar(255)
NO


制单人


6
iOrder
int
NO

0

排序号


7
sParentId
varchar(100)
NO


父级ID


8
sSlaveId
varchar(100)
NO


从表Id


9
dAdjustableQty
decimal(18,6)
YES


调机数量


10
dHour
decimal(18,6)
NO

0.000000

工时


11
sMachineStateName
varchar(100)
NO


机台状态


12
sTReserve1
varchar(255)
YES


预留字符1


13
sTReserve2
varchar(255)
YES


预留字符2


14
sTReserve3
varchar(255)
YES


预留字符3


15
sTReserve4
varchar(255)
YES


预留字符4


16
sTReserve5
varchar(255)
YES


预留字符5


17
sTReserve6
varchar(255)
YES


预留字符6


18
dTReserve1
decimal(18,6)
YES


预留数字1


19
dTReserve2
decimal(18,6)
YES


预留数字2


20
dTReserve3
decimal(18,6)
YES


预留数字3


21
dWageMoney
decimal(18,6)
NO

0.000000

计件工资


Narrative

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