设计物流表

快递一般都是由平台提供的服务，商家是无法修改的，只能用或者不用，因此就不需要历史表。

-- 快递表
DROP TABLE IF EXISTS `t_delivery`;
CREATE TABLE `t_delivery` (
  `id` BIGINT(20) UNSIGNED NOT NULL COMMENT '快递编码',
  `postid` VARCHAR(32) NOT NULL COMMENT '快递单号',
  `orderid` BIGINT(20) UNSIGNED NOT NULL COMMENT '订单编码',
  `sku` JSON NOT NULL COMMENT '商品',
  `whid` INT(11) UNSIGNED NOT NULL COMMENT '仓库编码',
  `qaid` INT(11) UNSIGNED NOT NULL COMMENT '质检员编码',
  `opid` INT(11) UNSIGNED NOT NULL COMMENT '发货员编码',
  `fee` DECIMAL(10, 0) UNSIGNED NOT NULL COMMENT '快递费',
  `exptype` TINYINT(1) UNSIGNED NOT NULL COMMENT '快递公司类型 0：EMS；1：顺丰；2：其他',
  `areaid` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '收获地区编码',
  `address` VARCHAR(256) NOT NULL COMMENT '收货详细地址',
  `isdeleted` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '逻辑删除 0：正常；1：已删除',
  `createtime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatetime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_postid`(`postid`) USING BTREE,
  INDEX `idx_orderid`(`orderid`) USING BTREE,
  INDEX `idx_whid`(`whid`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT = '快递表';

-- 退货表
DROP TABLE IF EXISTS `t_backstock`;
CREATE TABLE `t_backstock` (
  `id` BIGINT(20) UNSIGNED NOT NULL COMMENT '退货编码',
  `postid` VARCHAR(32) NOT NULL COMMENT '快递单号',
  `orderid` BIGINT(20) UNSIGNED NOT NULL COMMENT '订单编码',
  `sku` JSON NOT NULL COMMENT '退货商品',
  `reason` VARCHAR(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '退货原因',
  `qaid` INT(11) UNSIGNED NOT NULL COMMENT '质检员编码',
  `amount` DECIMAL(10, 2) UNSIGNED NOT NULL COMMENT '退款金额',
  `type` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '退款方式 0：原路退回；1：借记卡；2：微信；3：支付宝',
  `status` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '状态 0：退货成功；1：无法失败',
  `isdeleted` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '逻辑删除 0：正常；1：已删除',
  `createtime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatetime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_postid`(`postid`) USING BTREE,
  INDEX `idx_orderid`(`orderid`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT = '退货表';

-- 退货历史表
DROP TABLE IF EXISTS `t_backstock`;
CREATE TABLE `t_backstock` (
  `id` BIGINT(20) UNSIGNED NOT NULL COMMENT '流水主键',
  `backid` BIGINT(20) UNSIGNED NOT NULL COMMENT '退货编码',
  `postid` VARCHAR(32) NOT NULL COMMENT '快递单号',
  `orderid` BIGINT(20) UNSIGNED NOT NULL COMMENT '订单编码',
  `sku` JSON NOT NULL COMMENT '退货商品',
  `reason` VARCHAR(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '退货原因',
  `qaid` INT(11) UNSIGNED NOT NULL COMMENT '质检员编码',
  `amount` DECIMAL(10, 2) UNSIGNED NOT NULL COMMENT '退款金额',
  `type` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '退款方式 0：原路退回；1：借记卡；2：微信；3：支付宝',
  `status` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '状态 0：退货成功；1：无法失败',
  `createtime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_postid`(`postid`) USING BTREE,
  INDEX `idx_orderid`(`orderid`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT = '退货历史表';

---

感谢支持

更多内容，请移步《超级个体》。