DROP TABLE IF EXISTS `li_goods`;
CREATE TABLE `li_goods` (
`id` bigint NOT NULL COMMENT 'ID',
`create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建者',
`create_time` datetime(6) DEFAULT NULL COMMENT '创建时间',
`delete_flag` bit(1) DEFAULT NULL COMMENT '删除标志 true/false 删除/未删除',
`update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '更新者',
`update_time` datetime(6) DEFAULT NULL COMMENT '更新时间',
`auth_message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '审核信息',
`brand_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '品牌ID',
`buy_count` int DEFAULT '0' COMMENT '购买数量',
`category_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '分类路径',
`comment_num` int DEFAULT NULL COMMENT '评论数量',
`cost` double(10,2) DEFAULT NULL COMMENT '成本价格',
`goods_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '商品名称',
`goods_unit` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '计量单位',
`goods_video` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '商品视频',
`grade` double(10,2) DEFAULT NULL COMMENT '商品好评率',
`intro` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '商品详情',
`auth_flag` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '审核状态',
`market_enable` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '上架状态',
`mobile_intro` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '商品移动端详情',
`original` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '原图路径',
`price` double(10,2) DEFAULT NULL COMMENT '商品价格',
`quantity` int DEFAULT '0' COMMENT '库存',
`recommend` bit(1) DEFAULT NULL COMMENT '是否为推荐商品',
`sales_model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '销售模式',
`self_operated` bit(1) DEFAULT NULL COMMENT '是否自营',
`store_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '店铺ID',
`store_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '店铺名称',
`selling_point` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '卖点',
`shop_category_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '店铺分类',
`small` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '小图路径',
`sn` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '商品编号',
`template_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '运费模板ID',
`thumbnail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '缩略图路径',
`under_message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '下架原因',
`weight` double(10,2) DEFAULT NULL COMMENT '重量',
`store_category_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '店铺分类路径',
`big` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '大图路径',
`params` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
`goods_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
KEY `store_id` (`store_id`) USING BTREE COMMENT '店铺id索引'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
-- ----------------------------
-- Records of li_goods
-- ----------------------------
BEGIN;
INSERT INTO `li_goods` VALUES (1376373278360207360, '15810610731', '2021-03-28 22:18:55.997000', b'0', 'admin', '2021-06-29 15:43:49.007000', NULL, '1349563815406886925', 28, '1348576427264204941,1348576427264204942,1348576427264204943', 0, 4200.00, '一加 OnePlus 9 ', '个', NULL, 100.00, '<p><img src=\"https://lilishop-oss.oss-cn-beijing.aliyuncs.com/e9f010bdc5f448c0807ea0fb51897db0.jpg\" style=\"max-width:100%;\"/><br/></p>', 'PASS', 'DOWN', '<p><img src=\"https://lilishop-oss.oss-cn-beijing.aliyuncs.com/e9f010bdc5f448c0807ea0fb51897db0.jpg\"/><br/></p>', 'https://lilishop-oss.oss-cn-beijing.aliyuncs.com/5abb096ba77e4919a1ec6725e9ec1111.jpg', 3799.00, 3980, b'1', 'RETAIL', b'1', '1376369067769724928', 'Lilishop自营店', ' 8GB+128GB 5G手机', NULL, 'https://lilishop-oss.oss-cn-beijing.aliyuncs.com/5abb096ba77e4919a1ec6725e9ec1111.jpg?x-oss-process=style/200X200', '12256551216', '1376425599173656576', 'https://lilishop-oss.oss-cn-beijing.aliyuncs.com/5abb096ba77e4919a1ec6725e9ec1111.jpg?x-oss-process=style/400X400', '测试', 2.00, '1376372682651598848,1386932603621212160', NULL, '[]', 'PHYSICAL_GOODS');
DROP TABLE IF EXISTS `li_goods_collection`;
CREATE TABLE `li_goods_collection` (
`id` bigint NOT NULL COMMENT 'ID',
`create_time` datetime(6) DEFAULT NULL COMMENT '创建时间',
`member_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '会员id',
`sku_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '商品id',
PRIMARY KEY (`id`) USING BTREE,
KEY `member_id` (`member_id`) USING BTREE COMMENT '会员id'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
DROP TABLE IF EXISTS `li_goods_gallery`;
CREATE TABLE `li_goods_gallery` (
`id` bigint NOT NULL COMMENT 'ID',
`create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建者',
`goods_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '商品ID',
`is_default` int DEFAULT NULL COMMENT '是否是默认图片',
`original` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '原图路径',
`small` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '小图路径',
`sort` int DEFAULT NULL COMMENT '排序',
`thumbnail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '缩略图路径',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
DROP TABLE IF EXISTS `li_goods_params`;
CREATE TABLE `li_goods_params` (
`id` bigint NOT NULL COMMENT 'ID',
`create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建者',
`create_time` datetime(6) DEFAULT NULL COMMENT '创建时间',
`delete_flag` bit(1) DEFAULT NULL COMMENT '删除标志 true/false 删除/未删除',
`update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '更新者',
`update_time` datetime(6) DEFAULT NULL COMMENT '更新时间',
`goods_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '商品ID',
`param_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '参数ID',
`param_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '参数名字',
`param_value` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '参数值',
`is_index` int DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
INSERT INTO `li_goods_params` VALUES (1387976458604904448, '15810610731', '2021-04-30 11:45:49.742000', b'0', NULL, NULL, '1377800619737219072', '1384433344917274624', 'cpu', '4核', NULL);
DROP TABLE IF EXISTS `li_goods_sku`;
CREATE TABLE `li_goods_sku` (
`id` bigint NOT NULL COMMENT 'ID',
`create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建者',
`create_time` datetime(6) DEFAULT NULL COMMENT '创建时间',
`delete_flag` bit(1) DEFAULT NULL COMMENT '删除标志 true/false 删除/未删除',
`update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '更新者',
`update_time` datetime(6) DEFAULT NULL COMMENT '更新时间',
`auth_message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '审核信息',
`big` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '大图路径',
`brand_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '品牌ID',
`buy_count` int DEFAULT NULL COMMENT '购买数量',
`category_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '分类路径',
`comment_num` int DEFAULT NULL COMMENT '评价数量',
`cost` double(20,2) DEFAULT NULL COMMENT '成本价格',
`freight_payer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '运费承担者',
`freight_template_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '配送模版ID',
`goods_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '商品ID',
`goods_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '商品名称',
`goods_unit` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '计量单位',
`goods_video` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '商品视频',
`grade` double(20,2) DEFAULT NULL COMMENT '商品好评率',
`intro` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '商品详情',
`auth_flag` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '审核状态',
`promotion_flag` bit(1) DEFAULT NULL COMMENT '是否是促销商品',
`market_enable` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '上架状态',
`mobile_intro` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '移动端商品详情',
`original` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '原图路径',
`price` double(20,2) DEFAULT NULL COMMENT '商品价格',
`promotion_price` double(20,2) DEFAULT NULL COMMENT '促销价',
`quantity` int DEFAULT NULL COMMENT '库存',
`recommend` bit(1) NOT NULL COMMENT '是否为推荐商品',
`sales_model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '销售模式',
`self_operated` bit(1) DEFAULT NULL COMMENT '是否自营',
`store_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '店铺ID',
`store_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '店铺名称',
`selling_point` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '卖点',
`small` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '小图路径',
`sn` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '商品编号',
`specs` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '规格信息json',
`template_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '运费模板id',
`thumbnail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '缩略图路径',
`under_message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '下架原因',
`view_count` int DEFAULT NULL COMMENT '浏览数量',
`weight` double(20,2) DEFAULT NULL COMMENT '重量',
`simple_specs` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '规格信息',
`store_category_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '店铺分类路径',
`goods_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
KEY `goods_id` (`goods_id`) USING BTREE COMMENT '商品id索引'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
DROP TABLE IF EXISTS `li_goods_unit`;
CREATE TABLE `li_goods_unit` (
`id` bigint NOT NULL COMMENT 'ID',
`create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建者',
`create_time` datetime(6) DEFAULT NULL COMMENT '创建时间',
`delete_flag` bit(1) DEFAULT NULL COMMENT '计量单位名称',
`update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '更新者',
`update_time` datetime(6) DEFAULT NULL COMMENT '更新时间',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '删除标志 true/false 删除/未删除',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
DROP TABLE IF EXISTS `li_goods_words`;
CREATE TABLE `li_goods_words` (
`id` bigint NOT NULL,
`create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`create_time` datetime(6) DEFAULT NULL,
`delete_flag` bit(1) DEFAULT NULL,
`update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`update_time` datetime(6) DEFAULT NULL,
`abbreviate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`sort` int DEFAULT NULL,
`type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`whole_spell` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`words` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
产品模块设计参考SQL
最新推荐文章于 2024-07-13 18:02:33 发布