elemachineday.md 1.8 KB

elemachineday

  • 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 sParentId varchar(255) YES
4 sBrandsId varchar(100) NO 加工商ID
5 sSubsidiaryId varchar(100) NO 子公司ID
6 tCreateDate datetime NO CURRENT_TIMESTAMP DEFAULT_GENERATED 制单日期
7 sMakePerson varchar(255) NO 制单人
8 iOrder int NO 0 排序号
9 sCReserve1 varchar(255) YES 预留字符1
10 sCReserve2 varchar(255) YES 预留字符2
11 sCReserve3 varchar(255) YES 预留字符3
12 dCReserve1 decimal(18,6) YES 预留数字1
13 dCReserve2 decimal(18,6) YES 预留数字2
14 dCReserve3 decimal(18,6) YES 预留数字3
15 iCReserve1 int YES 预留整型1
16 iCReserve2 int YES 预留整型2
17 iCReserve3 int YES 预留整型3
18 tCReserve1 datetime YES 预留日期1
19 tCReserve2 datetime YES 预留日期2
20 tCReserve3 datetime YES 预留日期3
21 tStartDate datetime YES 起始时间
22 tEndDate datetime YES 结束时间
23 sMemo longtext YES 备注

Narrative

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