sysafteroperationmsg.md 1.51 KB

sysafteroperationmsg

  • Engine: InnoDB
  • Collation: utf8mb3_general_ci

Columns

# Name Type Null Key Default Extra Comment
1 iIncrement int NO PRI auto_increment 自增列
2 sId varchar(100) NO MUL 标准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 bInvalid bit(1) NO b'0' 是否作废
9 sParentId varchar(100) NO 父级id
10 sReceiverPerson varchar(255) NO MUL 接收人
11 sMemo text YES 工作内容
12 bSaveAfter bit(1) NO b'0' 是否保存后
13 bCheckAfter bit(1) NO b'0' 是否审核后

Indexes

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