mftdatabagmaster.md 2.06 KB

Edit Raw Blame History



mftdatabagmaster


Rows (estimated): 5

Data size: 16.0 KB

Engine: InnoDB

Collation: utf8mb3_general_ci

Created: 2026-04-27 18:53:21

Updated: 2026-04-27 18:53:21


Columns


#
Name
Type
Null
Key
Default
Extra
Comment


1
iIncrement
int
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(100)
NO


窗体ID


9
sBillNo
varchar(50)
NO


单据号


10
bInvalid
bit(1)
NO

b'0'

作废


11
bCheck
bit(1)
NO

b'0'

审核


12
sMReserve1
varchar(255)
YES


预留字符1


13
sMReserve2
varchar(255)
YES


预留字符2


14
sMReserve3
varchar(255)
YES


预留字符3


15
sMReserve4
varchar(255)
YES


预留字符4


16
sMReserve5
varchar(255)
YES


预留字符5


17
sMReserve6
varchar(255)
YES


预留字符6


18
dMReserve1
decimal(18,6)
YES


预留数字1


19
dMReserve2
decimal(18,6)
YES


预留数字2


20
dMReserve3
decimal(18,6)
YES


预留数字3


21
iMReserve1
int
YES


预留整型1


22
iMReserve2
int
YES


预留整型2


23
iMReserve3
int
YES


预留整型3


24
tMReserve1
datetime
YES


预留日期1


25
tMReserve2
datetime
YES


预留日期2


Narrative

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