（十）快递表和退货表

快递表

 

CREATE TABLE `t_delivery`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
  `order_id` int UNSIGNED NOT NULL COMMENT '订单ID',
  `sku` json NOT NULL COMMENT '商品',
  `qa_id` int UNSIGNED NOT NULL COMMENT '质检员ID',
  `de_id` int UNSIGNED NOT NULL COMMENT '发货员ID',
  `postid` int UNSIGNED NOT NULL COMMENT '快递编号',
  `price` decimal(10, 2) UNSIGNED NOT NULL COMMENT '快递费',
  `address` varchar(200) NOT NULL COMMENT '收货地址',
  `warehouse_id` int UNSIGNED NOT NULL COMMENT '仓库ID',
  `ecp` tinyint UNSIGNED NOT NULL COMMENT '快递公司编号',
  `create_time` timestamp NOT NULL DEFAULT NOW() COMMENT '添加时间',
  PRIMARY KEY (`id`),
  INDEX `idx_order_id`(`order_id`),
  INDEX `idx_qa_id`(`qa_id`),
  INDEX `idx_de_id`(`de_id`),
  INDEX `idx_postid`(`postid`),
  INDEX `idx_address_id`(`address_id`),
  INDEX `idx_warehouse_id`(`warehouse_id`),
  INDEX `idx_ecp`(`ecp`)
) COMMENT = '快递表';

 

 

 

退货表

CREATE TABLE `t_backstock`  (
  `id` int UNSIGNED PRIMARY KEY AUTO_INCREMENT COMMENT '主键',
  `order_id` int UNSIGNED NOT NULL COMMENT '订单ID',
  `sku` json NOT NULL COMMENT '退货商品',
  `reason` varchar(200) NOT NULL COMMENT '退货原因',
  `qa_id` int UNSIGNED NOT NULL COMMENT '质检员ID',
  `payment` decimal(10, 2) UNSIGNED NOT NULL COMMENT '退款金额',
  `payment_type` tinyint UNSIGNED NOT NULL COMMENT '退款方式：1借记卡，2信用卡，3微信，4支付宝，5现金',
  `status` tinyint UNSIGNED NOT NULL COMMENT '状态：1退货成功,2无法退货',
  `create_time` timestamp NOT NULL DEFAULT NOW() COMMENT '添加时间',
  INDEX `idx_order_id`(`order_id`),
  INDEX `idx_qa_id`(`qa_id`),
  INDEX `idx_status`(`status`)
) COMMENT = '退货表';