前言
菜鸟开发记录,大佬看到可以求点评
小白在学习路上的二次开发,
一、数据库设计
#
# Structure for table "goods_comment"
#
CREATE TABLE `goods_comment` (
`id` char(19) NOT NULL COMMENT 'ID',
`goods_id` varchar(19) NOT NULL DEFAULT '' COMMENT '商品id',
`merchant_id` char(19) NOT NULL DEFAULT '' COMMENT '商家id',
`member_id` varchar(19) NOT NULL DEFAULT '' COMMENT '会员id',
`nickname` varchar(50) DEFAULT NULL COMMENT '会员昵称',
`avatar` varchar(255) DEFAULT NULL COMMENT '会员头像',
`content` varchar(500) DEFAULT NULL COMMENT '评论内容',
`is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '逻辑删除 1(true)已删除, 0(false)未删除',
`gmt_create` datetime NOT NULL COMMENT '创建时间',
`gmt_modified` datetime NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`),
KEY `idx_goods_id` (`goods_id`),
KEY `idx_merchant_id` (`merchant_id`),
KEY `idx_member_id` (`member_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='评论';
#
# Structure for table "goods_info"
#
CREATE TABLE `goods_info` (
`id` char(19) NOT NULL COMMENT '商品ID',
`merchant_id` char(19) NOT NULL COMMENT '商家ID',
`classify_id` char(19) NOT NULL COMMENT '商品分类ID',
`title` varchar(50) NOT NULL COMMENT '商品标题',
`price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '商品销售价格,默认0元 免费嫖',
`cover` varchar(255) CHARACTER SET utf8 NOT NULL COMMENT '商品封面图片路径',
`buy_count` bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '销售数量',
`view_count` bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '浏览数量',
`version` bigint(20) unsigned NOT NULL DEFAULT '1' COMMENT '乐观锁',
`status` varchar(10) NOT NULL DEFAULT 'Draft' COMMENT '商品状态 Draft未发布 Normal已发布',
`is_deleted` tinyint(3) DEFAULT NULL COMMENT '逻辑删除 1(true)已删除, 0(false)未删除',
`gmt_create` datetime NOT NULL COMMENT '创建时间',
`gmt_modified` datetime NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`),
KEY `idx_title` (`title`),
KEY `idx_classify_id` (`classify_id`),
KEY `idx_merchant_id` (`merchant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='商品';
#
# Structure for table "goods_info_collect"
#
CREATE TABLE `goods_info_collect` (
`id` char(19) NOT NULL COMMENT '收藏ID',
`merchant_id` char(19) NOT NULL COMMENT '商家ID',
`classify_id` char(19) NOT NULL DEFAULT '' COMMENT '商品分类ID',
`is_deleted` tinyint(3) NOT NULL DEFAULT '0' COMMENT '逻辑删除 1(true)已删除, 0(false)未删除',
`gmt_create` datetime NOT NULL COMMENT '创建时间',
`gmt_modified` datetime NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='商品收藏';
#
# Structure for table "goods_info_description"
#
CREATE TABLE `goods_info_description` (
`id` char(19) NOT NULL COMMENT '商品ID',
`description` text COMMENT '商品简介',
`gmt_create` datetime NOT NULL COMMENT '创建时间',
`gmt_modified` datetime NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='商品简介';
#
# Structure for table "goods_classify"
#
CREATE TABLE `goods_classify` (
`id` char(19) NOT NULL COMMENT '商品类别ID',
`title` varchar(10) NOT NULL COMMENT '类别名称',
`sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序字段',
`gmt_create` datetime NOT NULL COMMENT '创建时间',
`gmt_modified` datetime NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='商品分类';
#
# Structure for table "goods_merchant"
#
CREATE TABLE `goods_merchant` (
`id` char(19) NOT NULL COMMENT '商家ID',
`name` varchar(20) NOT NULL COMMENT '商家姓名',
`intro` varchar(500) NOT NULL DEFAULT '' COMMENT '商家简介',
`career` varchar(500) DEFAULT NULL COMMENT '商家资历,一句话说明商家',
`level` int(10) unsigned NOT NULL COMMENT '头衔 1高级卖家 2首席卖家',
`avatar` varchar(255) DEFAULT NULL COMMENT '卖家头像',
`sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
`is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '逻辑删除 1(true)已删除, 0(false)未删除',
`gmt_create` datetime NOT NULL COMMENT '创建时间',
`gmt_modified` datetime NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='商家';
#
# Structure for table "goods_video"
#
CREATE TABLE `goods_video` (
`id` char(19) NOT NULL COMMENT '视频ID',
`goods_id` char(19) NOT NULL COMMENT '商品ID',
`title` varchar(50) NOT NULL COMMENT '视频名称',
`video_source_id` varchar(100) DEFAULT NULL COMMENT '云端视频资源',
`video_original_name` varchar(100) DEFAULT NULL COMMENT '原始文件名称',
`sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序字段',
`play_count` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '播放次数',
`duration` float NOT NULL DEFAULT '0' COMMENT '视频时长(秒)',
`status` varchar(20) NOT NULL DEFAULT 'Empty' COMMENT 'Empty未上传 Transcoding转码中 Normal正常',
`size` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '视频源文件大小(字节)',
`version` bigint(20) unsigned NOT NULL DEFAULT '1' COMMENT '乐观锁',
`gmt_create` datetime NOT NULL COMMENT '创建时间',
`gmt_modified` datetime NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`),
KEY `idx_goods_id` (`goods_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='商品视频';
总结
设计了商品
商家
类别
视频
评论
商品收藏
商品简介
表,先开发后台系统