电子公文传输系统 团队作业 冲刺总结（五）

1.今日任务安排

• 确定每个人撰写的前端和后端部分代码以及数据库部分代码
• 开始撰写具体的代码

2.遇到的困难

• 具体代码编写过程中由于编程语言和web网页设计不是很熟练，所以花了不少时间在相关编程网站学习并回忆之前遗忘的知识点。
• 在和chatgpt描述功能设计时不够清楚，写出来的代码不尽如人意，在找到学长学姐的代码后具体分析后成功解决了这一问题。

3.今日成果

创建一个 MySQL 数据库，代码如下：

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `category_name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '类别' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of category
-- ----------------------------
INSERT INTO `category` VALUES (1, '密码系');
INSERT INTO `category` VALUES (2, '电通系');
INSERT INTO `category` VALUES (3, '网空系');
INSERT INTO `category` VALUES (4, '管理系');

-- ----------------------------
-- Table structure for file
-- ----------------------------
DROP TABLE IF EXISTS `file`;
CREATE TABLE `file`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `title` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '标题',
  `remark` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注',
  `url` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '文件地址',
  `input_date` datetime NULL DEFAULT NULL COMMENT '存入日期',
  `from_user` bigint NULL DEFAULT NULL COMMENT '上传者',
  `type_id` bigint NULL DEFAULT NULL COMMENT '密级ID',
  `level` int NULL DEFAULT NULL COMMENT '紧急程度',
  `is_deleted` int NULL DEFAULT 0 COMMENT '逻辑删除',
  `number` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '字号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '文件' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of file
-- ----------------------------
INSERT INTO `file` VALUES (24, '123', '123', '', '2023-11-27 19:04:25', 1, 2, 1, 0, NULL);
INSERT INTO `file` VALUES (25, '20211309', '20211309', '49e34607-6117-42a6-bbe1-07ca49441afd.txt', '2023-11-27 19:14:33', 1, 3, 2, 0, NULL);
INSERT INTO `file` VALUES (26, 'test', 'test', '00f647f5-6bcc-4810-8e3c-812f1d30cd84.txt', '2023-11-28 19:05:11', 1, 3, 3, 0, NULL);
INSERT INTO `file` VALUES (27, 'test01', 'test01', '7c5d5ef2-ff5d-409f-8d8c-a717ab1e2685.txt', '2023-11-28 19:18:19', 1, 3, 4, 0, NULL);
INSERT INTO `file` VALUES (28, '20211309nxy', '测试', '7347f2e5-8f7a-4d33-83ee-c1a8f370c343.txt', '2023-11-28 22:59:45', 3, 2, 2, 0, NULL);

-- ----------------------------
-- Table structure for file_category_list
-- ----------------------------
DROP TABLE IF EXISTS `file_category_list`;
CREATE TABLE `file_category_list`  (
  `id` bigint NOT NULL,
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户ID',
  `file_id` bigint NULL DEFAULT NULL COMMENT '文件ID',
  `category_id` bigint NULL DEFAULT NULL COMMENT '归档ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of file_category_list
-- ----------------------------
INSERT INTO `file_category_list` VALUES (1596392096267730946, 2, 2, 1596381194499895298);
INSERT INTO `file_category_list` VALUES (1728760802596057089, 1, 4, 1728760780575961089);
INSERT INTO `file_category_list` VALUES (1728760844950138882, 1, 2, 1728760780575961089);
INSERT INTO `file_category_list` VALUES (1729095917402529793, 1, 5, 1728760780575961089);
INSERT INTO `file_category_list` VALUES (1729096959322169346, 1, 25, 1728760780575961089);

-- ----------------------------
-- Table structure for filecategory
-- ----------------------------
DROP TABLE IF EXISTS `filecategory`;
CREATE TABLE `filecategory`  (
  `id` bigint NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '分类归档名',
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of filecategory
-- ----------------------------
INSERT INTO `filecategory` VALUES (1596381165043298305, '文化', 2);
INSERT INTO `filecategory` VALUES (1596381194499895298, '重要', 2);
INSERT INTO `filecategory` VALUES (1596381639230337025, '213', 2);
INSERT INTO `filecategory` VALUES (1596451774389538817, '123333', 2);
INSERT INTO `filecategory` VALUES (1728760760120340482, '', 1);
INSERT INTO `filecategory` VALUES (1728760780575961089, 'abc', 1);

-- ----------------------------
-- Table structure for filesend
-- ----------------------------
DROP TABLE IF EXISTS `filesend`;
CREATE TABLE `filesend`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `from_user` bigint NULL DEFAULT NULL COMMENT '源用户',
  `to_user` bigint NULL DEFAULT NULL COMMENT '目标用户',
  `file` bigint NULL DEFAULT NULL COMMENT '文件',
  `status` int NULL DEFAULT NULL COMMENT '状态(0:已发送,1:已接收,2:已退回)',
  `send_time` datetime NULL DEFAULT NULL COMMENT '发送时间',
  `solve_time` datetime NULL DEFAULT NULL COMMENT '处理时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '文件收发' ROW_FORMAT = DYNAMIC;

4.燃尽图

5.团队合照

6.今日工作量