mysql订单退款记录表

CREATE TABLE `www54` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `orderld` int(11) NOT NULL COMMENT '订单id',
  `refundTo` int(11) NOT NULL DEFAULT '0' COMMENT '接受退款用户',
  `refundResson` int(11) NOT NULL DEFAULT '0' COMMENT '用户申请退款原因ID',
  `refundOtherReason` varchar(255) COLLATE utf8_slovenian_ci DEFAULT NULL COMMENT '用户申请退款原因',
  `backMoney` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '用户退款金额',
  `refundTradeNo` varchar(100) COLLATE utf8_slovenian_ci DEFAULT NULL COMMENT '管理员退款流水号',
  `refundRemark` varchar(500) COLLATE utf8_slovenian_ci NOT NULL COMMENT '退款备注',
  `refundTime` datetime NOT NULL COMMENT '退款时间',
  `shopRejectReason` varchar(255) COLLATE utf8_slovenian_ci DEFAULT NULL COMMENT '店铺不同意拒收原因',
  `refundStatus` tinyint(4) NOT NULL DEFAULT '0' COMMENT '退款状态（-1：商家不同意0：等待商家处理1：商家同意2：管理员已处理）',
  `create Time` datetime NOT NULL COMMENT '用户申请退款时间',
  `serviceld` int(10) NOT NULL DEFAULT '0' COMMENT '售后单id',
  `isServiceRefund` tinyint(4) NOT NULL DEFAULT '0' COMMENT '售后单是否已退款（0：未退款1”已退款）',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci COMMENT='王雨玲 订单退款记录表';