sysbillnosettingsreceive.md 1.47 KB

sysbillnosettingsreceive

单据编号

  • 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(100) NO 制单人
7 iOrder int NO 0 排序
8 sParentId varchar(100) NO 父类ID
9 sReceiveId varchar(100) NO 接收人Id
10 sReceiveMemo text YES 接收信息
11 sReceiveType varchar(255) NO 接收类型(审核后,保存后)

Indexes

Name Unique Type Columns
IndexN_gdslogininfo BTREE sId, sBrandsId, sSubsidiaryId, sParentId
IndexU_gdslogininfo BTREE sId, sBrandsId, sSubsidiaryId
IndexU_gdsloginInfoNo BTREE sBrandsId, sSubsidiaryId, sParentId
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.