materialsguidepriceapplyslave.md 2.06 KB

Edit Raw Blame History



materialsguidepriceapplyslave


Rows (estimated): 0

Data size: 16.0 KB

Engine: InnoDB

Collation: utf8mb3_general_ci

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

Updated: 


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
iOrder
int
NO

0

排序号


6
sMakePerson
varchar(255)
YES


制单人


7
sParentId
varchar(100)
NO


父级ID


8
sMaterialsId
varchar(100)
NO


材料ID


9
dOldGuidePrice
decimal(24,13)
NO

0.0000000000000


10
dNewGuidePrice
decimal(24,13)
NO

0.0000000000000


11
sSlaveMemo
text
YES


备注


12
sSReserve1
varchar(255)
YES


预留字符1


13
sSReserve2
varchar(255)
YES


预留字符2


14
sSReserve3
varchar(255)
YES


预留字符3


15
sSReserve4
varchar(255)
YES


预留字符4


16
sSReserve5
varchar(255)
YES


预留字符5


17
sSReserve6
varchar(255)
YES


预留字符6


18
dSReserve1
decimal(18,6)
YES


预留数字1


19
dSReserve2
decimal(18,6)
YES


预留数字2


20
dSReserve3
decimal(18,6)
YES


预留数字3


21
iSReserve1
int
YES


预留整型1


22
iSReserve2
int
YES


预留整型2


23
iSReserve3
int
YES


预留整型3


24
tSReserve1
datetime
YES


预留日期1


25
tSReserve2
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.