sysapilog.md 1.75 KB

sysapilog

API日志

  • 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(50) NO 制单人
7 sApiId varchar(50) NO MUL 接口ID
8 sApiName varchar(50) NO MUL 接口名称
9 sSendBody longtext YES 请求报文
10 sSendHead longtext YES 请求头部
11 sResponseBody longtext YES 响应注释
12 iType int YES MUL 日志类型 0:调用第三方,1:被第三方调用
13 iStatus int YES MUL 运行状态 0:失败 1:成功
14 sMemo longtext YES 注释
15 sIp varchar(50) YES MUL IP地址

Indexes

Name Unique Type Columns
IndexN_1 BTREE sApiName, sBrandsId, sSubsidiaryId
IndexN_2 BTREE iType
IndexN_3 BTREE sApiId
IndexN_4 BTREE sIp
IndexN_5 BTREE iStatus
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.