eleprocessmachinesinstallarea.md 1.37 KB

Edit Raw Blame History



eleprocessmachinesinstallarea


机台工序


Rows (estimated): 120

Data size: 48.0 KB

Engine: InnoDB

Collation: utf8mb3_general_ci

Created: 2026-04-27 18:52:21

Updated: 2026-04-27 18:52:21


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
sInstallArea
varchar(50)
YES


设备位置


7
iOrder
int
NO

0

排序号


8
sParentId
varchar(50)
NO


父级ID


9
sMachineId
varchar(50)
NO


机台ID


10
bDefault
bit(1)
NO

b'0'

默认


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.