elematerialsworkcenter.md 1.2 KB

elematerialsworkcenter

  • Engine: InnoDB
  • Collation: utf8mb3_general_ci

Columns

# Name Type Null Key Default Extra Comment
1 iIncrement int NO 0 自增列
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 sMaterialsId varchar(100) NO 材料ID
9 sMaterialsStyle varchar(100) NO 材料规格
10 sWorkCenterId varchar(100) NO 工作中心ID
11 sWorkCenterName varchar(100) NO 工作中心
12 sDepartId varchar(100) NO 部门ID
13 sDepartName varchar(100) NO 部门

Narrative

No human-written narrative yet — when this table is exercised by a vertical slice, link from there back to this page.