plat_coupon_detail.md 1.87 KB

plat_coupon_detail

平台优惠券明细表

  • Engine: InnoDB
  • Collation: utf8mb3_general_ci

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.