plat_customer_account_detail.md 2.23 KB

Edit Raw Blame History



plat_customer_account_detail


平台客户账户明细表


Rows (estimated): 0

Data size: 16.0 KB

Engine: InnoDB

Collation: utf8mb3_general_ci

Created: 2026-04-27 18:54:50

Updated: 


Columns


#
Name
Type
Null
Key
Default
Extra
Comment


1
iIncreaseId
int
NO
PRI

auto_increment
主键(自增序列)


2
tCreateTime
datetime
NO
MUL


创建时间


3
tModifyTime
datetime
NO


修改时间


4
sShopUserId
varchar(35)
NO
MUL


商铺用户编号


5
sCustomerUserId
varchar(35)
NO
MUL


客户用户编号


6
sAccountDetailId
varchar(35)
NO
UNI


账户明细编号(P_ACD开头)


7
iInOutType
tinyint
NO


账户出入类型(0:支出,1:收入)


8
iDetailType
tinyint
NO


账户明细类型(0:充值,1:订单扣款,2:订单退款)


9
iPaymentType
tinyint
NO


账户支付类型(0:余额,1:支付宝,2:微信,3:银联,4:银行)


10
sDetailContent
varchar(100)
NO


明细内容


11
sRemark
varchar(255)
NO


备注


12
dMoney
decimal(18,2)
NO
MUL
0.00

明细金额


13
dTotalMoney
decimal(18,2)
NO

0.00

用户余额


14
dAvailableMoney
decimal(18,2)
NO

0.00

可用余额


15
dFreezeMoney
decimal(18,2)
NO

0.00

冻结金额


16
sBillNo
varchar(35)
NO
MUL


单据编号


Indexes


Name
Unique
Type
Columns


PLAT_CUSTOMER_ACCOUNT_DETAIL_IDX1

BTREE
sCustomerUserId


PLAT_CUSTOMER_ACCOUNT_DETAIL_IDX2

BTREE
sShopUserId


PLAT_CUSTOMER_ACCOUNT_DETAIL_IDX3

BTREE
dMoney


PLAT_CUSTOMER_ACCOUNT_DETAIL_IDX4

BTREE
sBillNo


PLAT_CUSTOMER_ACCOUNT_DETAIL_IDX5

BTREE
tCreateTime


PLAT_CUSTOMER_ACCOUNT_DETAIL_UNQ1
✓
BTREE
sAccountDetailId


PRIMARY
✓
BTREE
iIncreaseId


Narrative

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