# 这是一次改变,因为我的小伙伴终于可以独立使用VueCLi进行项目的构建,所以,以后的技术只涉及到java后端,不在涉及前端
## 全栈程序员,告辞
项目的功能
1. 上传文件,需要提供KID ---> 返回文件的网络地址
2. 对于文件进行管理 ----> 增加文件,删除文件(通过文件的序号名字进行删除文件),下载文件(通过文件的序号名字进行下载文件),修改文件名(通过文件的序号名字进行修改)
3. 对于文件进行分类
4. 登录注册功能
技术
数据库 : MySQL + DataGrip + Navicat + Redis
Java后端 : Java + idea + spring + MyBatis + MyBatis-Plus
项目地址 : 网盘
数据库设计
/*
Navicat Premium Data Transfer
Source Server : HCY
Source Server Type : MySQL
Source Server Version : 50515
Source Host : 47.104.249.85:3306
Source Schema : typefile
Target Server Type : MySQL
Target Server Version : 50515
File Encoding : 65001
Date: 27/09/2020 12:41:48
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for tbl_api
-- ----------------------------
DROP TABLE IF EXISTS `tbl_api`;
CREATE TABLE `tbl_api` (
`api_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'api接口的序号',
`api_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'api接口的说明',
`api_code` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT 'api接口的代码',
`api_creation` timestamp NULL DEFAULT NULL COMMENT 'api接口的创建时间',
`api_modification` timestamp NULL DEFAULT NULL COMMENT 'api接口的修改时间',
PRIMARY KEY (`api_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for tbl_file
-- ----------------------------
DROP TABLE IF EXISTS `tbl_file`;
CREATE TABLE `tbl_file` (
`file_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '文件序号',
`file_uuname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件的uuid+名字',
`file_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件原本的名称',
`file_postfix` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件的后缀',
`file_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件的类别',
`file_size` bigint(20) NULL DEFAULT NULL COMMENT '文件的大小',
`file_site` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件的地址',
`file_creation` timestamp NULL DEFAULT NULL COMMENT '文件的创建时间',
`file_modification` timestamp NULL DEFAULT NULL COMMENT '文件的修改时间',
`file_affiliation` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件的所属人',
PRIMARY KEY (`file_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for tbl_register
-- ----------------------------
DROP TABLE IF EXISTS `tbl_register`;
CREATE TABLE `tbl_register` (
`register_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户序号',
`register_account` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户账号',
`register_password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户密码',
`register_creation` timestamp NULL DEFAULT NULL COMMENT '用户创建时间',
`register_modification` timestamp NULL DEFAULT NULL COMMENT '用户修改时间',
PRIMARY KEY (`register_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for tbl_type
-- ----------------------------
DROP TABLE IF EXISTS `tbl_type`;
CREATE TABLE `tbl_type` (
`type_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '类别序号',
`type_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类别名称',
`type_creation` timestamp NULL DEFAULT NULL COMMENT '类别创建时间',
`type_modification` timestamp NULL DEFAULT NULL COMMENT '类别修改时间',
`type_affiliation` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类别的所属人员',
PRIMARY KEY (`type_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for tbl_user
-- ----------------------------
DROP TABLE IF EXISTS `tbl_user`;
CREATE TABLE `tbl_user` (
`user_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户序号',
`user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户昵称',
`user_icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户头像',
`user_KID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户Token',
`user_creation` timestamp NULL DEFAULT NULL COMMENT '用户创建时间',
`user_modification` timestamp NULL DEFAULT NULL COMMENT '用户修改时间',
PRIMARY KEY (`user_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for tbl_web
-- ----------------------------
DROP TABLE IF EXISTS `tbl_web`;
CREATE TABLE `tbl_web` (
`web_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '网站说明序号',
`web_value` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '网站说明',
`web_creation` timestamp NULL DEFAULT NULL COMMENT '网站说明创建时间',
`web_modification` timestamp NULL DEFAULT NULL COMMENT '网站说明修改时间',
PRIMARY KEY (`web_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
SET FOREIGN_KEY_CHECKS = 1;
