salsalesdesignslave.md 1.31 KB

salsalesdesignslave

  • Engine: InnoDB
  • Collation: utf8mb3_general_ci

Columns

# Name Type Null Key Default Extra Comment
1 iIncrement bigint NO 0 自增列
2 sId varchar(100) NO 唯一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 iOrder int NO 0 排序号
8 sFormId varchar(255) YES
9 sBillNo varchar(50) YES 单据号
10 sParentId varchar(100) NO 父级ID
11 sMemo text YES 备注说明
12 tCheckDate datetime YES 审核日期
13 sCheckPerson varchar(255) YES 审核人
14 bInvalid bit(1) YES b'0'
15 bCheck bit(1) YES b'0'
16 sStatus varchar(50) YES 0

Narrative

No human-written narrative yet — when this table is exercised by a vertical slice, link from there back to this page.