plat_customer_integral_detail.md 2.27 KB

Edit Raw Blame History



plat_customer_integral_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
sIntegralDetailId
varchar(35)
NO
UNI


积分明细编号(P_IGD开头)


7
iInOutType
tinyint
NO


积分出入类型(0:增加,1:减少)


8
iIntegralType
tinyint
NO
MUL


积分类型(0:用户注册,1:充值审核,2:订单审核,3:下单扣除,4:退单返还,5:积分定期清除)


9
sDetailContent
varchar(100)
NO


明细内容


10
sRemark
varchar(255)
NO


备注


11
dMoney
decimal(18,2)
NO
MUL
0.00

明细数量


12
dTotalIntegralMoney
decimal(18,2)
NO

0.00

用户积分


13
dAvailableIntegralMoney
decimal(18,2)
NO

0.00

可用积分


14
dFreezeIntegralMoney
decimal(18,2)
NO

0.00

冻结积分


15
sBillNo
varchar(35)
NO
MUL


单据编号


Indexes


Name
Unique
Type
Columns


PLAT_CUSTOMER_INTEGRAL_DETAIL_IDX1

BTREE
sCustomerUserId


PLAT_CUSTOMER_INTEGRAL_DETAIL_IDX2

BTREE
sShopUserId


PLAT_CUSTOMER_INTEGRAL_DETAIL_IDX3

BTREE
iIntegralType


PLAT_CUSTOMER_INTEGRAL_DETAIL_IDX4

BTREE
dMoney


PLAT_CUSTOMER_INTEGRAL_DETAIL_IDX5

BTREE
tCreateTime


PLAT_CUSTOMER_INTEGRAL_DETAIL_IDX6

BTREE
sBillNo


PLAT_CUSTOMER_INTEGRAL_DETAIL_UNQ1
✓
BTREE
sIntegralDetailId


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.