今天就來進行實體以及表結構的設計
文檔寫的不標準，一開始想先定義一下實體，最后寫著寫著寫把表關系也給寫上了
有什么不足希望大家多多指出
實體設計
用戶實體
user
Long id; // id
String username; // 用戶名
String password; // 密碼
String phone; // 電話號碼
String u_photo; // 頭像
String slat; // 鹽
分類
category
Long id;
String type_name;
String type_info;
String icon_url;
圖書信息
book
Long id;
String title; // 書名
String intro; // 簡介
Long a_id; // 作者id
String book_comment; // 書評
String image; // 封面
Date creatDate; // 起始更新時間
int chapter_number; // 章節(jié)數量
Date updateDate; // 最后更新時間
int state; // 狀態(tài) 1:完結 0:未完結
String protagonist; // 主角
Long c_id; // 分類id
圖書熱度
book_hot
Long b_id; // 圖書id
int click_num; // 點擊量
int search_num; // 搜索量
int hot; // 熱度
圖書章節(jié)
chapter
Long id; // id
int sequence_num; // 章節(jié)序號
String title; // 章節(jié)名
String context; // 內容
Long b_id; // 圖書id
作者信息
author
Long id;
String name; // 作者名
String introduce; // 簡介
String a_photo; // 照片
評論
review
Long id;
Long b_id; // 圖書id
String text; // 評論內容
Long u_id; // 用戶id
TimeStremp date; // 評論時間
書架(用戶---圖書)
user_book
Long u_id; // 用戶id
Long b_id; // 圖書id
Long c_id; // 章節(jié)id
管理員
admin
Long id;
String admin_name; // 用戶名
String password; // 密碼
String slat; // 鹽
數據庫設計
用戶實體(user)
用戶實體
分類(category)
分類
圖書信息(book)
圖書信息
圖書熱度(book_hot)
圖書熱度
圖書章節(jié)(chapters)
圖書章節(jié)
作者信息(author)
作者信息
評論(review)
評論
書架(用戶---圖書)(user_book)
書架
管理員(admin)
管理員
附：
/*
Navicat Premium Data Transfer
Source Server : localhostMysql
Source Server Type : MySQL
Source Server Version : 80012
Source Host : localhost:3306
Source Schema : wedo
Target Server Type : MySQL
Target Server Version : 80012
File Encoding : 65001
Date: 09/10/2020 19:53:29
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '管理員id',
`admin_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理員名',
`password` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密碼',
`slat` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鹽',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for author
-- ----------------------------
DROP TABLE IF EXISTS `author`;
CREATE TABLE `author` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
`name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '作者名',
`introduce` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '簡介',
`a_photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '照片',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 145 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for book
-- ----------------------------
DROP TABLE IF EXISTS `book`;
CREATE TABLE `book` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
`title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '書名',
`intro` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '簡介',
`a_id` bigint(20) NULL DEFAULT NULL COMMENT '作者id',
`book_comment` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '書評',
`image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '封面',
`creat_date` date NOT NULL COMMENT '起始更新時間',
`chapter_number` int(11) NOT NULL COMMENT '章節(jié)數量',
`update_date` date NOT NULL COMMENT '最后更新時間',
`state` tinyint(1) NOT NULL COMMENT '狀態(tài):1.完結;0.未完結',
`protagonist` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主角',
`c_id` bigint(20) NULL DEFAULT NULL COMMENT '分類id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 152 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for book_hot
-- ----------------------------
DROP TABLE IF EXISTS `book_hot`;
CREATE TABLE `book_hot` (
`b_id` bigint(20) NOT NULL COMMENT '圖書id',
`click_num` int(11) NULL DEFAULT NULL COMMENT '點擊量',
`search_num` int(11) NULL DEFAULT NULL COMMENT '搜索量',
`hot` int(11) NULL DEFAULT NULL COMMENT '熱度',
PRIMARY KEY (`b_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`type_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分類名',
`type_info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分類簡介',
`icon_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分類圖標',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for chapter
-- ----------------------------
DROP TABLE IF EXISTS `chapter`;
CREATE TABLE `chapter` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
`sequence_num` int(11) NULL DEFAULT NULL COMMENT '章節(jié)序號',
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '章節(jié)名',
`context` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '章節(jié)內容',
`b_id` bigint(20) NULL DEFAULT NULL COMMENT '圖書id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11064 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for review
-- ----------------------------
DROP TABLE IF EXISTS `review`;
CREATE TABLE `review` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
`b_id` bigint(20) NULL DEFAULT NULL COMMENT '圖書id',
`text` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '評論內容',
`u_id` bigint(20) NULL DEFAULT NULL COMMENT '用戶id',
`date` timestamp(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '評論時間',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` bigint(20) NOT NULL COMMENT '用戶id',
`username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用戶名',
`password` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密碼',
`phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '手機號',
`u_photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '頭像',
`slat` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '鹽',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for user_book
-- ----------------------------
DROP TABLE IF EXISTS `user_book`;
CREATE TABLE `user_book` (
`u_id` bigint(20) NOT NULL COMMENT '用戶id',
`b_id` bigint(255) NOT NULL COMMENT '圖書id',
`c_id` bigint(20) NULL DEFAULT NULL COMMENT '章節(jié)id',
PRIMARY KEY (`u_id`, `b_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
SET FOREIGN_KEY_CHECKS = 1;
上一篇：唯讀---需求分析
上一篇：唯讀---圖書微服務接口設計
