salsalesorderplatexe.md 1.63 KB

salsalesorderplatexe

平台获取订单异常表

  • 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 MUL 加工商Id
4 sSubsidiaryId varchar(100) NO 子公司ID
5 tCreateDate datetime NO CURRENT_TIMESTAMP DEFAULT_GENERATED 制单日期
6 sMakePerson varchar(255) YES 制单人
7 iOrder int NO 0 排序号
8 sBillNo varchar(100) NO 平台单据号
9 sCustomerName varchar(100) NO 客户名称
10 sWebOrderId varchar(100) NO MUL 平台订单Id
11 sMsg longtext YES 异常原因
12 bInvalid bit(1) NO b'0' 是否获取
13 sOrderJson longtext YES 线上订单数据结构

Indexes

Name Unique Type Columns
IndexN_CustomerName BTREE sBrandsId, sSubsidiaryId, sCustomerName
IndexN_WebOrderId BTREE sWebOrderId
IndexU_BillNo BTREE sBrandsId, sSubsidiaryId, sBillNo
IndexU_Id 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.