plat_coupon_detail.md 1.97 KB

Edit Raw Blame History



plat_coupon_detail


平台优惠券明细表


Rows (estimated): 0

Data size: 16.0 KB

Engine: InnoDB

Collation: utf8mb3_general_ci

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

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


优惠券明细编号(P_CPD开头)


7
sCustomerCouponId
varchar(35)
NO
MUL


用户优惠券编号


8
sDetailContent
varchar(100)
NO


明细内容


9
iInOutType
tinyint
NO


优惠券出入类型(0:获取,1:使用)


10
iCouponType
tinyint
NO


优惠券类型(0:店铺优惠券,1:商品优惠券)


11
sBillNo
varchar(35)
NO
MUL


单据编号


12
dMoney
decimal(18,2)
NO
MUL


优惠券面值


13
sRemark
varchar(255)
NO


备注


Indexes


Name
Unique
Type
Columns


PLAT_COUPON_DETAIL_IDX1

BTREE
sCustomerUserId


PLAT_COUPON_DETAIL_IDX2

BTREE
sShopUserId


PLAT_COUPON_DETAIL_IDX3

BTREE
sCustomerCouponId


PLAT_COUPON_DETAIL_IDX4

BTREE
sBillNo


PLAT_COUPON_DETAIL_IDX5

BTREE
dMoney


PLAT_COUPON_DETAIL_IDX6

BTREE
tCreateTime


PLAT_COUPON_DETAIL_UNQ1
✓
BTREE
sCouponDetailId


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.