elematerialscard.md 1.34 KB

Edit Raw Blame History



elematerialscard


Engine: InnoDB

Collation: utf8mb3_general_ci


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


名称


9
sNo
varchar(255)
NO


编号


10
iWeigth
int
YES


重量


11
dPrices
decimal(18,6)
NO

0.000000

税率


12
dLoss
decimal(18,6)
YES

0.000000

损耗


13
bInvalid
bit(1)
YES

b'0'

作废


14
dHoleRate
decimal(18,6)
YES

0.000000

起坑率


15
dWorkMoney
decimal(18,6)
YES

0.000000

加工费


16
sType
varchar(50)
YES


类型


Narrative

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