eleproductcustomer.md 1.88 KB

Edit Raw Blame History



eleproductcustomer


印件客户


Rows (estimated): 655

Data size: 160.0 KB

Engine: InnoDB

Collation: utf8mb3_general_ci

Created: 2026-04-27 18:52:22

Updated: 2026-04-27 18:52:22


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
MUL


父级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
sCustomerMaterialsName
varchar(100)
NO


客户物料描述


16
sZflag
varchar(5)
YES

I

更新标识


17
sMemo
text
YES


备注


Indexes


Name
Unique
Type
Columns


IndexU_eleproductcustomer
✓
BTREE

sId, sBrandsId, sSubsidiaryId


IndexU_eleproductcustomerId
✓
BTREE

sParentId, sCustomerId, 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.