设计产品和商品表

-- 产品表
DROP TABLE IF EXISTS `t_spu`;
CREATE TABLE `t_spu` (
  `id` BIGINT(20) UNSIGNED NOT NULL COMMENT '产品编码',
  `title` VARCHAR(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '主标题',
  `subtitle` VARCHAR(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '副标题',
  `media` JSON COMMENT '产品多媒体，包括图片和视频',
  `categoryid` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '分类编码',
  `brandid` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '品牌编码',
  `ptid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '品类编码',
  `isputon` TINYINT(1) UNSIGNED NOT NULL COMMENT '是否上架 0：否；1：是',
  `isvalid` TINYINT(1) UNSIGNED NOT NULL 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_brandid`(`brandid`) USING BTREE,
  INDEX `idx_categoryid`(`categoryid`) USING BTREE,
  INDEX `idx_ptid`(`ptid`) USING BTREE,
  INDEX `idx_isputon`(`isputon`) USING BTREE,
  INDEX `idx_isvalid`(`isvalid`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT = '产品表';

-- 产品历史表
DROP TABLE IF EXISTS `t_spu_history`;
CREATE TABLE `t_spu_history` (
  `id` BIGINT(20) UNSIGNED NOT NULL COMMENT '流水主键',
  `spuid` BIGINT(20) UNSIGNED NOT NULL COMMENT '产品编码',
  `title` VARCHAR(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '主标题',
  `subtitle` VARCHAR(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '副标题',
  `media` JSON COMMENT '产品多媒体，包括图片和视频',
  `categoryid` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '分类编码',
  `brandid` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '品牌编码',
  `ptid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '品类编码',
  `isputon` TINYINT(1) UNSIGNED NOT NULL COMMENT '是否上架 0：否；1：是',
  `isvalid` TINYINT(1) UNSIGNED NOT NULL COMMENT '是否有效 0：否；1：是',
  `createtime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_brandid`(`brandid`) USING BTREE,
  INDEX `idx_categoryid`(`categoryid`) USING BTREE,
  INDEX `idx_ptid`(`ptid`) USING BTREE,
  INDEX `idx_isputon`(`isputon`) USING BTREE,
  INDEX `idx_isvalid`(`isvalid`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT = '产品历史表';

-- 商品表
DROP TABLE IF EXISTS `t_sku`;
CREATE TABLE `t_sku` (
  `id` BIGINT(20) UNSIGNED NOT NULL COMMENT '商品编码',
  `spuid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '产品编码',
  `title` VARCHAR(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '商品标题',
  `subtitle` VARCHAR(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '商品副标题',
  `media` JSON COMMENT '商品多媒体，包括图片和视频',
  `price` DECIMAL(10, 2) UNSIGNED NOT NULL DEFAULT '0' COMMENT '价格',
  `params` JSON COMMENT '参数',
  `isputon` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否上架 0：否；1：是',
  `isvalid` 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_spuid`(`spuid`) USING BTREE,
  INDEX `idx_isputon`(`isputon`) USING BTREE,
  INDEX `idx_isvalid`(`isvalid`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT = '商品表';

-- 商品历史表
DROP TABLE IF EXISTS `t_sku_history`;
CREATE TABLE `t_sku_history` (
  `id` BIGINT(20) UNSIGNED NOT NULL COMMENT '流水主键',
  `skuid` BIGINT(20) UNSIGNED NOT NULL COMMENT '商品编码',
  `spuid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '产品编码',
  `title` VARCHAR(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '商品标题',
  `subtitle` VARCHAR(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '商品副标题',
  `media` JSON COMMENT '商品多媒体，包括图片和视频',
  `price` DECIMAL(10, 2) UNSIGNED NOT NULL DEFAULT '0' COMMENT '价格',
  `params` JSON COMMENT '参数',
  `isputon` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否上架 0：否；1：是',
  `isvalid` 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_spuid`(`spuid`) USING BTREE,
  INDEX `idx_isputon`(`isputon`) USING BTREE,
  INDEX `idx_isvalid`(`isvalid`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT = '商品历史表';

---

感谢支持

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