快递表、退货表与评价表

这里也可以说是售后相关表，用户购买后的流程，主要就进入了这几张表的操作。

快递表

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

退货表

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

评价表

CREATE TABLE `t_rating`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '评价ID',
  `order_id` int(10) UNSIGNED NOT NULL COMMENT '订单ID',
  `sku_id` int(10) UNSIGNED NOT NULL COMMENT '商品ID',
  `img` json NULL COMMENT '买家晒图',
  `rating` tinyint(3) UNSIGNED NOT NULL COMMENT '评分',
  `comment` varchar(200) NULL DEFAULT NULL COMMENT '评论',
  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_order_id`(`order_id`) USING BTREE,
  INDEX `idx_sku_id`(`sku_id`) USING BTREE,
  INDEX `idx_create_time`(`create_time`) USING BTREE
)  COMMENT = '评价表';