mftcalcparam.md 1.3 KB

mftcalcparam

  • Engine: InnoDB
  • Collation: utf8mb3_general_ci

Columns

# Name Type Null Key Default Extra Comment
1 iIncrement bigint NO PRI auto_increment 自增列
2 sId varchar(100) NO 唯一ID
3 sBrandsId varchar(100) NO 加工商ID
4 sSubsidiaryId varchar(100) NO 子公司ID
5 tCreateDate datetime NO CURRENT_TIMESTAMP DEFAULT_GENERATED 制单日期
6 sMakePerson varchar(255) NO 制单人
7 iOrder int NO 0 排序号
8 sSrcId varchar(100) YES 单据Id
9 sSrcSlaveId varchar(100) YES 从表Id
10 sParamName varchar(255) YES 变量名
11 sChineseName varchar(255) YES 变量中文名
12 sParamValue varchar(255) YES 变量值
13 sChangeValue varchar(255) YES 变动值

Indexes

Name Unique Type Columns
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.