cahreceivables.md 1.52 KB

Edit Raw Blame History



cahreceivables


单位


Engine: InnoDB

Collation: utf8mb3_general_ci


Columns


#
Name
Type
Null
Key
Default
Extra
Comment


1
iIncrement
int
NO
PRI

auto_increment
自增列


2
sId
varchar(100)
NO
MUL


标准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
dBillMoney
decimal(18,6)
NO


单据金额


9
dCheckingMoney
decimal(18,6)
NO


对账金额


10
sFormId
varchar(100)
NO


界面ID


11
sBillId
varchar(100)
NO
MUL


单据ID


12
sBillNo
varchar(255)
NO


单据编号


13
sMemo
text
YES


备注


14
sCustomerId
varchar(100)
NO


客户ID


Indexes


Name
Unique
Type
Columns


IndexN_cahreceivables

BTREE

sBillId, sSubsidiaryId, sBrandsId


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