quoquotationcalc_tmp.md 1.43 KB

quoquotationcalc_tmp

工单材料表

  • 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 sSlaveId varchar(50) NO 产品Id
8 dProductQty decimal(18,6) NO 产品数量
9 dCalcQty decimal(18,6) NO 计算数量
10 tCreateTmpDate datetime NO CURRENT_TIMESTAMP DEFAULT_GENERATED 临时表创建时间

Indexes

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