sysbillcheckresult.md 2.09 KB

sysbillcheckresult

审核结果

  • Rows (estimated): 0
  • Data size: 16.0 KB
  • Engine: InnoDB
  • Collation: utf8mb3_general_ci
  • Created: 2026-04-27 18:57:08
  • Updated:

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 sBillId varchar(100) NO 单据Id
9 sCheckPhaseId varchar(100) NO 审核阶段Id
10 sCheckPerson varchar(255) NO 审核人
11 sTitle varchar(255) NO 审核标题
12 sContent text YES 内容
13 sBillNo varchar(255) NO 单据号
14 sBillKey varchar(255) NO 存储过程调用名
15 sTbName varchar(255) NO 表名
16 sResult varchar(255) NO 结果
17 sReplyContent text YES 回复内容
18 sFormId varchar(100) YES 界面ID
19 sCheckModelId varchar(100) NO 审核模板Id
20 sMsgId varchar(100) NO 插入一条时审核模版对应的消息Id
21 sMemo text YES 备注
22 tMakeDate datetime NO CURRENT_TIMESTAMP DEFAULT_GENERATED 制单日期

Indexes

Name Unique Type Columns
IndexU_sisunit 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.