salsalesorderstatuschange.md 1.78 KB

Edit Raw Blame History



salsalesorderstatuschange


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
sFormId
varchar(100)
NO


窗体id


6
sMakePerson
varchar(100)
NO


制单人


7
sCustomerId
varchar(100)
NO


客户id


8
sBillNo
varchar(255)
NO


单据号


9
bCheck
bit(1)
NO

b'0'

是否审核


10
tCheckDate
datetime
NO


审核日期


11
sCheckPerson
varchar(100)
NO


审核人


12
sChangeReason
varchar(2000)
YES


变更原因


13
sMReserve1
varchar(255)
YES


预留字段1


14
sMReserve2
varchar(255)
YES


预留字段2


15
sMReserve3
varchar(255)
YES


预留字段3


16
tCreateDate
datetime
NO

CURRENT_TIMESTAMP
DEFAULT_GENERATED
创建时间


Indexes


Name
Unique
Type
Columns


IndexN_salsalesorderstatuschange

BTREE

sBrandsId, sSubsidiaryId, sMakePerson, sCustomerId, sBillNo, bCheck, tCheckDate, tCreateDate, sId


IndexU_salsalesorderstatuschange
✓
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.