sisdeliver.md 1.41 KB

sisdeliver

送货类型

  • 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) NO 制单人
7 iOrder int NO 0 排序号
8 sName varchar(255) NO 名称
9 sNo varchar(255) NO 编号
10 bInvalid bit(1) NO b'0' 是否作废
11 sDeliverFormulaId varchar(100) YES 送货公式ID

Indexes

Name Unique Type Columns
IndexN_sisdeliver BTREE sId, sBrandsId, sSubsidiaryId, sName
IndexU_sisdeliver BTREE sId, sBrandsId, sSubsidiaryId
IndexU_sisdeliverName BTREE sBrandsId, sSubsidiaryId, sName
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.