eleproductfile.md 1.5 KB

eleproductfile

印件文件

  • 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 varchar(11) NO 0 排序号
7 sParentId varchar(50) NO 父级ID
8 sPicturePath varchar(255) YES 图片地址
9 bDefault bit(1) NO b'0' 是否默认
10 sFileName varchar(100) NO 文件名
11 dMReserve1 decimal(18,6) YES 预留数字1
12 sType varchar(50) YES 类型
13 sMReserve1 varchar(50) NO 预留字符1
14 sMReserve2 varchar(50) YES 预留字符2

Indexes

Name Unique Type Columns
IndexN_eleproductfile BTREE sId, sBrandsId, sSubsidiaryId
IndexU_eleproductfile 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.