sisformulacustomizevariable.md 1.34 KB

sisformulacustomizevariable

自定义参数

  • 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 sParentId varchar(50) NO 父Id
6 sMakePerson varchar(50) NO 制单人
7 iOrder int NO 0 排序号
8 sName varchar(100) NO 变量名
9 sChinese varchar(100) NO 变量中文
10 sEnglish varchar(100) YES 变量英文
11 sBig5 varchar(100) YES 变量繁体
12 dValue int NO 0 变量值

Indexes

Name Unique Type Columns
IndexN_2 BTREE sBrandsId, sSubsidiaryId, sParentId
IndexU_1 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.