siscommonstyleproductclassify.md 1.29 KB

siscommonstyleproductclassify

常用规格列表

  • 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) YES MUL 父级ID
8 sProductClassifyId varchar(50) NO 印件分类ID

Indexes

Name Unique Type Columns
IndexN_siscommonstyleproductclassify BTREE sBrandsId, sSubsidiaryId, sParentId, sProductClassifyId
IndexU_siscommonstyleproductclassify BTREE sId, sBrandsId, sSubsidiaryId
IndexU_siscommonstyleproductclassifyId BTREE sParentId, sProductClassifyId
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.