plat_customer_recharge_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				创建时间
3	tModifyTime	datetime	NO				修改时间
4	sShopUserId	varchar(35)	NO	MUL			商铺用户编号
5	sCustomerUserId	varchar(35)	NO	MUL			客户用户编号
6	sRechargeDetailId	varchar(35)	NO	UNI			充值明细编号(P_RCD开头)
7	iStatus	tinyint	NO				充值状态(0:待审核,1:审核通过,2:审核驳回)
8	iRechargeMethod	tinyint	NO				充值方式(0:现金,1:支付宝,2:微信,3:银行)
9	iRechargeType	tinyint	NO				充值类型(0:客户充值,1:代客户充值,2:线下erp充值)
10	iBankId	tinyint	YES				银行编号(只在银行方式时才有值)
11	dRechargeMoney	decimal(18,2)	NO		0.00		充值金额
12	tRemittanceTime	datetime	NO				汇款时间
13	tReceivablesTime	datetime	YES				到款时间
14	sSubmitUserId	varchar(35)	NO				充值提交人用户编号
15	tAuditTime	datetime	YES				审核时间
16	sAuditUserId	varchar(35)	NO				充值审核人用户编号
17	sRemark	varchar(255)	NO				备注
18	sAuditRemark	varchar(255)	NO				审核备注
19	dRechargeAuditMoney	decimal(18,2)	NO		0.00		充值审核金额
20	iRechargeAuditMethod	tinyint	NO				充值审核方式(0:现金,1:支付宝,2:微信,3:银行)
21	iAuditBankId	tinyint	YES				审核银行编号(只在银行方式时才有值)
22	iIsLock	tinyint	NO		0		是否上锁(0:不上锁,1:上锁)

Indexes

Name	Unique	Type	Columns
PLAT_CUSTOMER_RECHARGE_DETAIL_IDX1		BTREE	sCustomerUserId
PLAT_CUSTOMER_RECHARGE_DETAIL_IDX2		BTREE	sShopUserId
PLAT_CUSTOMER_RECHARGE_DETAIL_UNQ1	✓	BTREE	sRechargeDetailId
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.