ome_refund_apply_luban

抖音退款申请附加信息表

所属应用: ome

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
apply_id	apply_id	mediumint(8) unsigned	Y		N
refund_apply_bn	退款申请单号	varchar(32)	Y		N
shop_id	来源店铺	varchar(32)	N		N
refuse_message	拒绝退款原因留言	longtext	N		N
refuse_proof	拒绝退款举证上传	varchar(255)	N		N
outer_lastmodify	数据推送的修改时间	int(10) unsigned	N		N
trade_status	trade_status	varchar(64)	N		N
refund_type	refund_type refund:退款单;return:退货单;	enum('refund','return')	N	refund	N
bill_type	bill_type refund_bill:退款单;return_bill:退货单;	enum('refund_bill','return_bill')	N	refund_bill	N
oid	子订单号	varchar(50)	N	0	N
refund_fee	需退金额	decimal(20,3)	N		N
message_text	留言凭证	longtext	N		N

索引

Key name	Column names	Unique	Comment
primary	apply_id	Y
ind_refund_apply_bn_shop	refund_apply_bn, shop_id, apply_id	Y
idx_c_shop_id	shop_id	N