sisscheme.md 1.07 KB

sisscheme

  • Engine: InnoDB
  • Collation: utf8mb4_general_ci

Columns

# Name Type Null Key Default Extra Comment
1 iIncrement int NO 0 自增列
2 iOrder int YES
3 sId varchar(100) NO 标准ID
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 bInvalid bit(1) NO b'0' 是否作废
9 sMemo text YES 备注
10 sParentName varchar(255) YES 父类型
11 sChildName varchar(255) YES 子类型
12 sReMark varchar(255) YES 备注

Narrative

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