前言
为自己搭建一个可以自我思考的平台,其核心为“心想事成”。
一、思考过程?
首先是思考,在完成自己任务后对现在的难题进行思考!我想到在我所完成的项目中记录用户搜索的功能,关键字、关键词等都未留下足迹,导致每次输入的信息需要重新输入,此时咱们就需要完善。
二、完善
数据库、表设计
/*
Navicat Premium Data Transfer
Source Server : 本地环境
Source Server Type : MySQL
Source Server Version : 80030
Source Host : localhost:3306
Source Schema : sustainable
Target Server Type : MySQL
Target Server Version : 80030
File Encoding : 65001
Date: 13/10/2023 16:47:57
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- `关键表`:Table structure for keyword_record
-- ----------------------------
DROP TABLE IF EXISTS `keyword_record`;
CREATE TABLE `keyword_record` (
`id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`keyword` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关键词',
`sources` int(0) NULL DEFAULT NULL COMMENT '来源(0-用户管理,1-APP应用商店)',
`use_count` bigint(0) NULL DEFAULT 0 COMMENT '使用次数',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `ids_keyword_sources`(`keyword`, `sources`) USING BTREE COMMENT '关键字-来源唯一'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '关键字记录表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- `关键表` keyword_relation
-- ----------------------------
DROP TABLE IF EXISTS `keyword_relation`;
CREATE TABLE `keyword_relation` (
`id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`keyword` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关键字',
`keyword_relation_sentence` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关键字关联句子',
`sources` int(0) NULL DEFAULT NULL COMMENT '来源(0-用户,1-APP应用商店',
`use_count` bigint(0) NULL DEFAULT 0 COMMENT '使用次数',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `ids_keyword_relation_sources`(`keyword`, `keyword_relation_sentence`, `sources`) USING BTREE COMMENT '关键词句不允许重复'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '关键字关联表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- `搜索表` app_store
-- ----------------------------
DROP TABLE IF EXISTS `app_store`;
CREATE TABLE `app_store` (
`id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`app_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'APP名称',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '应用商店表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- `搜索表` user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '姓名',
`password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '密码',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
`del_flag` int(0) NULL DEFAULT NULL COMMENT '删除状态',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
SET FOREIGN_KEY_CHECKS = 1;
总结
创建完成表就是咱们的第一步了!