eleworkordercenterprocess.md 1.23 KB

eleworkordercenterprocess

  • Engine: InnoDB
  • Collation: utf8mb3_general_ci

Columns

# Name Type Null Key Default Extra Comment
1 iIncrement int NO PRI auto_increment 自增列
2 sId varchar(255) NO MUL 标准ID
3 sBrandsId varchar(255) NO 加工商ID
4 sSubsidiaryId varchar(255) NO 子公司ID
5 tCreateDate datetime YES CURRENT_TIMESTAMP DEFAULT_GENERATED 制单日期
6 sMakePerson varchar(255) YES 制单人
7 sProcessId varchar(255) YES MUL 工序ID
8 sParentId varchar(255) YES 主表id
9 iOrder int YES 序号

Indexes

Name Unique Type Columns
IndexN_eleworkcenterprocess_ProcessId BTREE sProcessId, sBrandsId, sSubsidiaryId
IndexU_eleworkcenterprocess 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.