ome_refund_negotiate

售后协商申请表

所属应用: ome

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
id	主键	int(10) unsigned	Y		Y
refund_type	退款类型 return:退货;refund:退款;	enum('return','refund')	N		N
original_id	来源ID	int(10) unsigned	N		N
original_bn	来源编号	varchar(32)	N		N
order_id	订单ID	varchar(32)	N		N
order_bn	订单编号	varchar(32)	N		N
shop_id	店铺ID	varchar(32)	N		N
negotiate_type	协商类型 2:退款金额协商;4:退款凭证协商;8:已超售后时效;9:补发商品;15:修改运单号协商;16:退货商品异常;17:协商售后信息;	enum('2','4','8','9','15','16','17')	N		N
negotiate_sync_status	协商状态 none:不可协商;pending:可协商;succ:协商发起成功;fail:协商发起失败;running:协商发起中;	enum('none','pending','succ','fail','running')	N	pending	N
negotiate_sync_msg	协商同步消息	varchar(500)	N		N
negotiate_desc	协商类型描述	text	N		N
negotiate_text	推荐话术	text	N		N
negotiate_refund_fee	建议退款金额	decimal(10,2)	N		N
negotiate_reason_id	建议原因ID	int(11)	N		N
negotiate_reason_text	建议原因描述	varchar(255)	N		N
negotiate_address_id	收货地址ID	int(11)	N		N
negotiate_address_text	收货地址	text	N		N
refund_type_code	退款类型代码	int(11)	N	0	N
refund_version	退款版本号	varchar(50)	N		N
at_time	创建时间	timestamp	N	CURRENT_TIMESTAMP	N
up_time	更新时间	timestamp	N	CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP	N

索引

Key name	Column names	Unique	Comment
primary	id	Y
idx_original_id	original_id	N
idx_order_id	order_id	N
idx_shop_id	shop_id	N
idx_negotiate_type	negotiate_type	N
idx_negotiate_sync_status	negotiate_sync_status	N
idx_at_time	at_time	N
idx_up_time	up_time	N
idx_original_id_refund_type	original_id, refund_type	Y