eleproductprice.md 2.02 KB

Edit Raw Blame History Permalink



eleproductprice


印件客户


Engine: InnoDB

Collation: utf8mb3_general_ci


Columns


#
Name
Type
Null
Key
Default
Extra
Comment


1
iIncrement
int
NO
PRI

auto_increment
自增列


2
sId
varchar(50)
NO
MUL


标准ID


3
sBrandsId
varchar(50)
NO


加工商ID


4
sSubsidiaryId
varchar(50)
NO


子公司ID


5
sMakePerson
varchar(50)
NO


制单人


6
iOrder
int
NO

0

排序号


7
sParentId
varchar(50)
NO


父级ID


8
sCustomerId
varchar(50)
NO


客户ID


9
bDefault
bit(1)
NO

b'0'

是否默认


10
dProductPrice
decimal(18,6)
NO

0.000000

价格


11
sTaxId
varchar(50)
NO


税率ID


12
dQuotationPrice
decimal(18,6)
NO

0.000000

报价价格


13
tQuotationDate
datetime
YES


报价日期


14
sCustomerMaterialsNo
varchar(50)
NO


客户料号


15
sMemo
varchar(2000)
YES


备注


16
dBeginQty
decimal(18,0)
NO

0

起数


17
dEndQty
decimal(18,0)
NO

0

止数


18
dOldQuotationPrice
decimal(18,6)
NO

0.000000

原报价价格


19
sQuotationPerson
varchar(50)
NO


更新人


20
tPCreateDate
datetime
YES

CURRENT_TIMESTAMP
DEFAULT_GENERATED
价格日期


21
dQuoMoney
decimal(18,6)
YES

0.000000

基准价


22
dQuoRate
decimal(18,6)
YES

0.000000

毛利率


Indexes


Name
Unique
Type
Columns


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