sislogisticsprice.md 1.61 KB

Edit Raw Blame History



sislogisticsprice


Rows (estimated): 89

Data size: 16.0 KB

Engine: InnoDB

Collation: utf8mb4_general_ci

Created: 2026-04-27 18:57:01

Updated: 2026-04-27 18:57:01


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
sCity
varchar(255)
NO


名称


9
sShortCity
varchar(255)
YES


简称


10
dVolumePrice
decimal(24,13)
NO

0.0000000000000


11
dWeightPrice
decimal(24,13)
NO

0.0000000000000


12
sEffect
varchar(255)
YES


时效


13
bInvalid
bit(1)
NO

b'0'

是否作废


14
sAllId
text
YES


树型所有Id


15
sChildren
varchar(255)
YES


是否为最子级


16
sParentId
varchar(100)
YES


父级ID


17
sType
varchar(255)
YES


仓库类型


18
bFrozen
bit(1)
NO

b'0'

是否冻结


Narrative

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