plat_customer_account.md 1.61 KB

Edit Raw Blame History



plat_customer_account


平台客户账户表


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


创建时间


3
tModifyTime
datetime
NO


修改时间


4
sShopUserId
varchar(35)
NO
MUL


商铺用户编号


5
sCustomerUserId
varchar(35)
NO
UNI


客户用户编号


6
dTotalMoney
decimal(18,2)
NO

0.00

用户余额


7
dAvailableMoney
decimal(18,2)
NO

0.00

可用余额


8
dFreezeMoney
decimal(18,2)
NO

0.00

冻结金额


9
dTotalIntegralMoney
decimal(18,2)
NO

0.00

用户积分


10
dAvailableIntegralMoney
decimal(18,2)
NO

0.00

可用积分


11
dFreezeIntegralMoney
decimal(18,2)
NO

0.00

冻结积分


12
iIsLock
tinyint
NO

0

是否锁定(0:未锁定,1:锁定)


Indexes


Name
Unique
Type
Columns


PLAT_CUSTOMER_ACCOUNT_IDX1

BTREE
sShopUserId


PLAT_CUSTOMER_ACCOUNT_UNQ1
✓
BTREE
sCustomerUserId


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.