sisproductclassifyparts.md 1.89 KB

Edit Raw Blame History



sisproductclassifyparts


印件分类-部件表


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


加工商ID


4
sSubsidiaryId
varchar(50)
NO


子公司ID


5
sMakePerson
varchar(50)
NO


制单人


6
iOrder
int
NO

0

排序号


7
sParentId
varchar(50)
NO
MUL


父级ID


8
sProcessClassifyId
varchar(50)
YES


工序分类ID


9
sPartsName
varchar(100)
NO
UNI


部件名称


10
sProcessId
varchar(50)
NO


默认工序ID


11
sMaterialsId
varchar(50)
YES


材料ID


12
sColorName
varchar(5000)
NO


颜色名称


13
sTypeKey
varchar(50)
NO


对应的分类key（danzhang,huace....）


14
sAllId
text
YES


树型所有Id


15
sNodId
varchar(255)
YES


父级


16
sFartherName
varchar(100)
NO


父级名称


17
sColorId
varchar(255)
YES

0.000000

色数


Indexes


Name
Unique
Type
Columns


IndexU_sisproductclassifyprocessclassify
✓
BTREE

sId, sBrandsId, sSubsidiaryId


IndexU_sisproductclassifyprocessclassifyId
✓
BTREE

sParentId, sProcessClassifyId, sPartsName, sBrandsId, sSubsidiaryId


IndexU_sPartsName
✓
BTREE
sPartsName


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.