eleprocessmachine.md 1.42 KB

Edit Raw Blame History



eleprocessmachine


机台工序


Engine: InnoDB

Collation: utf8mb3_general_ci


Columns


#
Name
Type
Null
Key
Default
Extra
Comment


1
iIncrement
int
NO
PRI

auto_increment
自增列


2
sId
varchar(50)
NO
MUL


唯一ID


3
sBrandsId
varchar(50)
NO
MUL


加工商ID


4
sSubsidiaryId
varchar(50)
NO


子公司ID


5
sMakePerson
varchar(50)
NO


制单人


6
iOrder
int
NO

0

排序号


7
sParentId
varchar(50)
NO


父级ID


8
sMachineId
varchar(50)
NO


机台ID


9
bDefault
bit(1)
NO


默认机台


10
bAuto
bit(1)
NO

b'1'

优先自动排程


11
dAPSminQty
int
NO

0

数量优先 从


12
dAPSmaxQty
int
NO

0

数量优先 到


13
sMemo
text
YES


备注


Indexes


Name
Unique
Type
Columns


IndexN1

BTREE

sBrandsId, sSubsidiaryId, sMachineId, bDefault


IndexU_eleprocessmachine
✓
BTREE

sId, sBrandsId, sSubsidiaryId


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.