sysapibrand.md 1.33 KB

sysapibrand

对接接口供应商

  • 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 sCorpName varchar(255) NO MUL 供应商名称
8 sCorpId varchar(255) NO MUL 加密ID
9 sCorpSecret varchar(255) NO 加密密钥
10 iLossTime int NO 1440 TOKEN时效时间(分钟)

Indexes

Name Unique Type Columns
IndexN_1 BTREE sCorpId, sBrandsId, sSubsidiaryId
IndexN_2 BTREE sCorpName
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.