基于jeecgboot的个人网盘功能开发（一）
今天主要是先设计数据库，相关数据库如下：
/*
Navicat MySQL Data Transfer
Source Server : 本地开发虚拟机数据库
Source Server Version : 50721
Source Host : 192.168.199.151:3306
Source Database : nbcio-boot
Target Server Type : MYSQL
Target Server Version : 50721
File Encoding : 65001
Date: 2023-04-19 12:56:53
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for nd_file
-- ----------------------------
DROP TABLE IF EXISTS `nd_file`;
CREATE TABLE `nd_file` (
`id` varchar(36) NOT NULL COMMENT '主键',
`createuserid` varchar(50) DEFAULT NULL COMMENT '创建用户id',
`filesize` int(10) DEFAULT NULL COMMENT '文件大小',
`filestatus` int(11) DEFAULT NULL COMMENT '文件状态(0-禁用，1-启用',
`fileurl` varchar(500) DEFAULT NULL COMMENT '文件url',
`identifier` varchar(32) DEFAULT NULL COMMENT 'md5唯一标识',
`storagetype` varchar(20) DEFAULT NULL COMMENT '存储类型',
`create_by` varchar(50) DEFAULT NULL COMMENT '创建人',
`create_time` datetime DEFAULT NULL COMMENT '创建日期',
`update_by` varchar(50) DEFAULT NULL COMMENT '更新人',
`update_time` datetime DEFAULT NULL COMMENT '更新日期',
`sys_org_code` varchar(64) DEFAULT NULL COMMENT '所属部门',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of nd_file
-- ----------------------------
-- ----------------------------
-- Table structure for nd_fileclassification
-- ----------------------------
DROP TABLE IF EXISTS `nd_fileclassification`;
CREATE TABLE `nd_fileclassification` (
`fileClassificationId` bigint(20) NOT NULL AUTO_INCREMENT,
`fileExtendName` varchar(25) DEFAULT NULL COMMENT '文件扩展名',
`fileTypeId` bigint(20) DEFAULT NULL COMMENT '文件类型id',
PRIMARY KEY (`fileClassificationId`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of nd_fileclassification
-- ----------------------------
INSERT INTO `nd_fileclassification` VALUES ('1', 'bmp', '1');
INSERT INTO `nd_fileclassification` VALUES ('2', 'jpg', '1');
INSERT INTO `nd_fileclassification` VALUES ('3', 'png', '1');
INSERT INTO `nd_fileclassification` VALUES ('4', 'tif', '1');
INSERT INTO `nd_fileclassification` VALUES ('5', 'gif', '1');
INSERT INTO `nd_fileclassification` VALUES ('6', 'jpeg', '1');
INSERT INTO `nd_fileclassification` VALUES ('7', 'doc', '2');
INSERT INTO `nd_fileclassification` VALUES ('8', 'docx', '2');
INSERT INTO `nd_fileclassification` VALUES ('9', 'docm', '2');
INSERT INTO `nd_fileclassification` VALUES ('10', 'dot', '2');
INSERT INTO `nd_fileclassification` VALUES ('11', 'dotx', '2');
INSERT INTO `nd_fileclassification` VALUES ('12', 'dotm', '2');
INSERT INTO `nd_fileclassification` VALUES ('13', 'odt', '2');
INSERT INTO `nd_fileclassification` VALUES ('14', 'fodt', '2');
INSERT INTO `nd_fileclassification` VALUES ('15', 'ott', '2');
INSERT INTO `nd_fileclassification` VALUES ('16', 'rtf', '2');
INSERT INTO `nd_fileclassification` VALUES ('17', 'txt', '2');
INSERT INTO `nd_fileclassification` VALUES ('18', 'html', '2');
INSERT INTO `nd_fileclassification` VALUES ('19', 'htm', '2');
INSERT INTO `nd_fileclassification` VALUES ('20', 'mht', '2');
INSERT INTO `nd_fileclassification` VALUES ('21', 'xml', '2');
INSERT INTO `nd_fileclassification` VALUES ('22', 'pdf', '2');
INSERT INTO `nd_fileclassification` VALUES ('23', 'djvu', '2');
INSERT INTO `nd_fileclassification` VALUES ('24', 'fb2', '2');
INSERT INTO `nd_fileclassification` VALUES ('25', 'epub', '2');
INSERT INTO `nd_fileclassification` VALUES ('26', 'xps', '2');
INSERT INTO `nd_fileclassification` VALUES ('27', 'xls', '2');
INSERT INTO `nd_fileclassification` VALUES ('28', 'xlsx', '2');
INSERT INTO `nd_fileclassification` VALUES ('29', 'xlsm', '2');
INSERT INTO `nd_fileclassification` VALUES ('30', 'xlt', '2');
INSERT INTO `nd_fileclassification` VALUES ('31', 'xltx', '2');
INSERT INTO `nd_fileclassification` VALUES ('32', 'xltm', '2');
INSERT INTO `nd_fileclassification` VALUES ('33', 'ods', '2');
INSERT INTO `nd_fileclassification` VALUES ('34', 'fods', '2');
INSERT INTO `nd_fileclassification` VALUES ('35', 'ots', '2');
INSERT INTO `nd_fileclassification` VALUES ('36', 'csv', '2');
INSERT INTO `nd_fileclassification` VALUES ('37', 'pps', '2');
INSERT INTO `nd_fileclassification` VALUES ('38', 'ppsx', '2');
INSERT INTO `nd_fileclassification` VALUES ('39', 'ppsm', '2');
INSERT INTO `nd_fileclassification` VALUES ('40', 'ppt', '2');
INSERT INTO `nd_fileclassification` VALUES ('41', 'pptx', '2');
INSERT INTO `nd_fileclassification` VALUES ('42', 'pptm', '2');
INSERT INTO `nd_fileclassification` VALUES ('43', 'pot', '2');
INSERT INTO `nd_fileclassification` VALUES ('44', 'potx', '2');
INSERT INTO `nd_fileclassification` VALUES ('45', 'potm', '2');
INSERT INTO `nd_fileclassification` VALUES ('46', 'odp', '2');
INSERT INTO `nd_fileclassification` VALUES ('47', 'fodp', '2');
INSERT INTO `nd_fileclassification` VALUES ('48', 'otp', '2');
INSERT INTO `nd_fileclassification` VALUES ('49', 'hlp', '2');
INSERT INTO `nd_fileclassification` VALUES ('50', 'wps', '2');
INSERT INTO `nd_fileclassification` VALUES ('51', 'java', '2');
INSERT INTO `nd_fileclassification` VALUES ('52', 'js', '2');
INSERT INTO `nd_fileclassification` VALUES ('53', 'css', '2');
INSERT INTO `nd_fileclassification` VALUES ('54', 'json', '2');
INSERT INTO `nd_fileclassification` VALUES ('55', 'avi', '3');
INSERT INTO `nd_fileclassification` VALUES ('56', 'mp4', '3');
INSERT INTO `nd_fileclassification` VALUES ('57', 'mpg', '3');
INSERT INTO `nd_fileclassification` VALUES ('58', 'mov', '3');
INSERT INTO `nd_fileclassification` VALUES ('59', 'swf', '3');
INSERT INTO `nd_fileclassification` VALUES ('60', 'wav', '4');
INSERT INTO `nd_fileclassification` VALUES ('61', 'aif', '4');
INSERT INTO `nd_fileclassification` VALUES ('62', 'au', '4');
INSERT INTO `nd_fileclassification` VALUES ('63', 'mp3', '4');
INSERT INTO `nd_fileclassification` VALUES ('64', 'ram', '4');
INSERT INTO `nd_fileclassification` VALUES ('65', 'wma', '4');
INSERT INTO `nd_fileclassification` VALUES ('66', 'mmf', '4');
INSERT INTO `nd_fileclassification` VALUES ('67', 'amr', '4');
INSERT INTO `nd_fileclassification` VALUES ('68', 'aac', '4');
INSERT INTO `nd_fileclassification` VALUES ('69', 'flac', '4');
INSERT INTO `nd_fileclassification` VALUES ('70', 'md', '2');
INSERT INTO `nd_fileclassification` VALUES ('71', 'markdown', '2');
-- ----------------------------
-- Table structure for nd_fileextend
-- ----------------------------
DROP TABLE IF EXISTS `nd_fileextend`;
CREATE TABLE `nd_fileextend` (
`fileExtendName` varchar(25) NOT NULL,
`fileExtendDesc` varchar(25) DEFAULT NULL COMMENT '文件扩展名描述',
`fileExtendImgUrl` varchar(100) DEFAULT NULL COMMENT '文件扩展名预览图',
PRIMARY KEY (`fileExtendName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of nd_fileextend
-- ----------------------------
INSERT INTO `nd_fileextend` VALUES ('aac', null, null);
INSERT INTO `nd_fileextend` VALUES ('aif', null, null);
INSERT INTO `nd_fileextend` VALUES ('amr', null, null);
INSERT INTO `nd_fileextend` VALUES ('au', null, null);
INSERT INTO `nd_fileextend` VALUES ('avi', null, null);
INSERT INTO `nd_fileextend` VALUES ('bmp', null, null);
INSERT INTO `nd_fileextend` VALUES ('css', null, null);
INSERT INTO `nd_fileextend` VALUES ('csv', null, null);
INSERT INTO `nd_fileextend` VALUES ('djvu', null, null);
INSERT INTO `nd_fileextend` VALUES ('doc', null, null);
INSERT INTO `nd_fileextend` VALUES ('docm', null, null);
INSERT INTO `nd_fileextend` VALUES ('docx', null, null);
INSERT INTO `nd_fileextend` VALUES ('dot', null, null);
INSERT INTO `nd_fileextend` VALUES ('dotm', null, null);
INSERT INTO `nd_fileextend` VALUES ('dotx', null, null);
INSERT INTO `nd_fileextend` VALUES ('epub', null, null);
INSERT INTO `nd_fileextend` VALUES ('fb2', null, null);
INSERT INTO `nd_fileextend` VALUES ('flac', null, null);
INSERT INTO `nd_fileextend` VALUES ('fodp', null, null);
INSERT INTO `nd_fileextend` VALUES ('fods', null, null);
INSERT INTO `nd_fileextend` VALUES ('fodt', null, null);
INSERT INTO `nd_fileextend` VALUES ('gif', null, null);
INSERT INTO `nd_fileextend` VALUES ('hlp', null, null);
INSERT INTO `nd_fileextend` VALUES ('htm', null, null);
INSERT INTO `nd_fileextend` VALUES ('html', null, null);
INSERT INTO `nd_fileextend` VALUES ('java', null, null);
INSERT INTO `nd_fileextend` VALUES ('jpeg', null, null);
INSERT INTO `nd_fileextend` VALUES ('jpg', null, null);
INSERT INTO `nd_fileextend` VALUES ('js', null, null);
INSERT INTO `nd_fileextend` VALUES ('json', null, null);
INSERT INTO `nd_fileextend` VALUES ('mht', null, null);
INSERT INTO `nd_fileextend` VALUES ('mmf', null, null);
INSERT INTO `nd_fileextend` VALUES ('mov', null, null);
INSERT INTO `nd_fileextend` VALUES ('mp3', null, null);
INSERT INTO `nd_fileextend` VALUES ('mp4', null, null);
INSERT INTO `nd_fileextend` VALUES ('mpg', null, null);
INSERT INTO `nd_fileextend` VALUES ('odp', null, null);
INSERT INTO `nd_fileextend` VALUES ('ods', null, null);
INSERT INTO `nd_fileextend` VALUES ('odt', null, null);
INSERT INTO `nd_fileextend` VALUES ('otp', null, null);
INSERT INTO `nd_fileextend` VALUES ('ots', null, null);
INSERT INTO `nd_fileextend` VALUES ('ott', null, null);
INSERT INTO `nd_fileextend` VALUES ('pdf', null, null);
INSERT INTO `nd_fileextend` VALUES ('png', null, null);
INSERT INTO `nd_fileextend` VALUES ('pot', null, null);
INSERT INTO `nd_fileextend` VALUES ('potm', null, null);
INSERT INTO `nd_fileextend` VALUES ('potx', null, null);
INSERT INTO `nd_fileextend` VALUES ('pps', null, null);
INSERT INTO `nd_fileextend` VALUES ('ppsm', null, null);
INSERT INTO `nd_fileextend` VALUES ('ppsx', null, null);
INSERT INTO `nd_fileextend` VALUES ('ppt', null, null);
INSERT INTO `nd_fileextend` VALUES ('pptm', null, null);
INSERT INTO `nd_fileextend` VALUES ('pptx', null, null);
INSERT INTO `nd_fileextend` VALUES ('ram', null, null);
INSERT INTO `nd_fileextend` VALUES ('rtf', null, null);
INSERT INTO `nd_fileextend` VALUES ('swf', null, null);
INSERT INTO `nd_fileextend` VALUES ('tif', null, null);
INSERT INTO `nd_fileextend` VALUES ('txt', null, null);
INSERT INTO `nd_fileextend` VALUES ('wav', null, null);
INSERT INTO `nd_fileextend` VALUES ('wma', null, null);
INSERT INTO `nd_fileextend` VALUES ('wps', null, null);
INSERT INTO `nd_fileextend` VALUES ('xls', null, null);
INSERT INTO `nd_fileextend` VALUES ('xlsm', null, null);
INSERT INTO `nd_fileextend` VALUES ('xlsx', null, null);
INSERT INTO `nd_fileextend` VALUES ('xlt', null, null);
INSERT INTO `nd_fileextend` VALUES ('xltm', null, null);
INSERT INTO `nd_fileextend` VALUES ('xltx', null, null);
INSERT INTO `nd_fileextend` VALUES ('xml', null, null);
INSERT INTO `nd_fileextend` VALUES ('xps', null, null);
-- ----------------------------
-- Table structure for nd_filepermission
-- ----------------------------
DROP TABLE IF EXISTS `nd_filepermission`;
CREATE TABLE `nd_filepermission` (
`filePermissionId` bigint(20) NOT NULL AUTO_INCREMENT,
`commonFileId` varchar(20) DEFAULT NULL COMMENT '共享文件id',
`filePermissionCode` int(2) DEFAULT NULL COMMENT '用户对文件的权限码',
`userId` varchar(36) DEFAULT NULL COMMENT '用户id',
PRIMARY KEY (`filePermissionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of nd_filepermission
-- ----------------------------
-- ----------------------------
-- Table structure for nd_filetype
-- ----------------------------
DROP TABLE IF EXISTS `nd_filetype`;
CREATE TABLE `nd_filetype` (
`id` varchar(36) NOT NULL COMMENT 'id',
`fileTypeName` varchar(50) DEFAULT NULL COMMENT '文件类型名',
`orderNum` int(2) DEFAULT NULL COMMENT '次序',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of nd_filetype
-- ----------------------------
INSERT INTO `nd_filetype` VALUES ('0', '全部', null);
INSERT INTO `nd_filetype` VALUES ('1', '图片', null);
INSERT INTO `nd_filetype` VALUES ('2', '文档', null);
INSERT INTO `nd_filetype` VALUES ('3', '视频', null);
INSERT INTO `nd_filetype` VALUES ('4', '音乐', null);
INSERT INTO `nd_filetype` VALUES ('5', '其他', null);
-- ----------------------------
-- Table structure for nd_image
-- ----------------------------
DROP TABLE IF EXISTS `nd_image`;
CREATE TABLE `nd_image` (
`id` varchar(36) NOT NULL,
`fileid` varchar(36) DEFAULT NULL COMMENT '文件ID',
`imageheight` int(11) DEFAULT NULL COMMENT '图像的高',
`imagewidth` int(11) DEFAULT NULL COMMENT '图像的宽',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of nd_image
-- ----------------------------
-- ----------------------------
-- Table structure for nd_music
-- ----------------------------
DROP TABLE IF EXISTS `nd_music`;
CREATE TABLE `nd_music` (
`id` varchar(36) NOT NULL,
`album` varchar(100) DEFAULT NULL COMMENT '专辑',
`albumartist` varchar(100) DEFAULT NULL COMMENT '专辑艺术家',
`albumimage` mediumblob COMMENT '专辑图片',
`artist` varchar(100) DEFAULT NULL COMMENT '艺术家',
`comment` varchar(255) DEFAULT NULL COMMENT '评论',
`composer` varchar(100) DEFAULT NULL COMMENT '创作者',
`copyright` varchar(100) DEFAULT NULL COMMENT '版权',
`encoder` varchar(100) DEFAULT NULL COMMENT '编码器',
`fileid` varchar(36) DEFAULT NULL COMMENT '文件ID',
`genre` varchar(100) DEFAULT NULL COMMENT '类型',
`lyrics` longtext COMMENT '歌词',
`originalartist` varchar(100) DEFAULT NULL COMMENT '原创艺术家',
`publicer` varchar(100) DEFAULT NULL COMMENT '公众',
`title` varchar(100) DEFAULT NULL COMMENT '题目',
`track` varchar(100) DEFAULT NULL COMMENT '声道',
`tracklength` double DEFAULT NULL COMMENT '声道长度',
`url` varchar(100) DEFAULT NULL COMMENT '地址',
`year` varchar(100) DEFAULT NULL COMMENT '年份',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of nd_music
-- ----------------------------
-- ----------------------------
-- Table structure for nd_picturefile
-- ----------------------------
DROP TABLE IF EXISTS `nd_picturefile`;
CREATE TABLE `nd_picturefile` (
`id` varchar(36) NOT NULL COMMENT 'id',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`create_by` varchar(50) DEFAULT NULL COMMENT '创建用户id',
`extendName` varchar(100) DEFAULT NULL COMMENT '扩展名',
`fileName` varchar(100) DEFAULT NULL COMMENT '文件名',
`filesize` int(19) DEFAULT NULL COMMENT '文件大小',
`fileUrl` varchar(500) DEFAULT NULL COMMENT '文件url',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
`update_by` varchar(50) DEFAULT NULL COMMENT '修改用户id',
`storagetype` varchar(20) DEFAULT NULL COMMENT '存储类型',
`userid` varchar(50) DEFAULT NULL COMMENT '用户id',
`createuserid` varchar(50) DEFAULT NULL COMMENT '创建用户id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of nd_picturefile
-- ----------------------------
-- ----------------------------
-- Table structure for nd_recoveryfile
-- ----------------------------
DROP TABLE IF EXISTS `nd_recoveryfile`;
CREATE TABLE `nd_recoveryfile` (
`id` varchar(36) NOT NULL COMMENT 'id',
`deleteBatchNum` varchar(50) DEFAULT NULL COMMENT '删除批次号',
`deletetime` datetime DEFAULT NULL COMMENT '删除时间',
`userfileid` varchar(36) DEFAULT NULL COMMENT '用户文件id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of nd_recoveryfile
-- ----------------------------
-- ----------------------------
-- Table structure for nd_share
-- ----------------------------
DROP TABLE IF EXISTS `nd_share`;
CREATE TABLE `nd_share` (
`id` varchar(36) NOT NULL,
`endtime` datetime DEFAULT NULL COMMENT '失效时间',
`extractioncode` varchar(10) DEFAULT NULL COMMENT '提取码',
`sharestatus` int(11) DEFAULT NULL COMMENT '分享状态(0正常,1已失效,2已撤销)',
`sharetype` int(11) DEFAULT NULL COMMENT '分享类型(0公共,1私密,2好友)',
`sharebatchnum` varchar(40) DEFAULT NULL COMMENT '分享批次号',
`create_by` varchar(50) DEFAULT NULL COMMENT '创建人',
`create_time` datetime DEFAULT NULL COMMENT '创建日期',
`sys_org_code` varchar(64) DEFAULT NULL COMMENT '所属部门',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of nd_share
-- ----------------------------
-- ----------------------------
-- Table structure for nd_sharefile
-- ----------------------------
DROP TABLE IF EXISTS `nd_sharefile`;
CREATE TABLE `nd_sharefile` (
`id` varchar(36) NOT NULL,
`sharebatchnum` varchar(50) DEFAULT NULL COMMENT '分享批次号',
`sharefilepath` varchar(100) DEFAULT NULL COMMENT '分享文件路径',
`userfileid` varchar(36) DEFAULT NULL COMMENT '用户文件id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of nd_sharefile
-- ----------------------------
-- ----------------------------
-- Table structure for nd_storage
-- ----------------------------
DROP TABLE IF EXISTS `nd_storage`;
CREATE TABLE `nd_storage` (
`id` varchar(36) NOT NULL COMMENT 'id',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
`update_by` varchar(50) DEFAULT NULL COMMENT '修改用户id',
`storagesize` bigint(20) DEFAULT NULL COMMENT '占用存储大小',
`totalstoragesize` bigint(20) DEFAULT NULL COMMENT '总存储大小',
`userid` varchar(50) DEFAULT NULL COMMENT 'userid',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of nd_storage
-- ----------------------------
INSERT INTO `nd_storage` VALUES ('1', null, null, null, '1024', 'admin');
INSERT INTO `nd_storage` VALUES ('2', null, null, null, '1024', 'zhangsan');
-- ----------------------------
-- Table structure for nd_sysparam
-- ----------------------------
DROP TABLE IF EXISTS `nd_sysparam`;
CREATE TABLE `nd_sysparam` (
`id` varchar(36) NOT NULL COMMENT 'id',
`groupname` varchar(50) DEFAULT NULL COMMENT 'groupname',
`sysparamdesc` varchar(50) DEFAULT NULL COMMENT 'sysparamdesc',
`sysparamkey` varchar(50) DEFAULT NULL COMMENT 'sysparamkey',
`sysparamvalue` varchar(50) DEFAULT NULL COMMENT 'sysparamvalue',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of nd_sysparam
-- ----------------------------
INSERT INTO `nd_sysparam` VALUES ('1', null, '总存储大小（单位M）', 'totalStorageSize', '1024');
INSERT INTO `nd_sysparam` VALUES ('2', null, '系统初始化数据标识', 'initDataFlag', '1');
INSERT INTO `nd_sysparam` VALUES ('3', null, '当前脚本的版本号', 'version', '1.0.0');
-- ----------------------------
-- Table structure for nd_uploadtask
-- ----------------------------
DROP TABLE IF EXISTS `nd_uploadtask`;
CREATE TABLE `nd_uploadtask` (
`id` varchar(36) NOT NULL COMMENT 'id',
`extendName` varchar(100) DEFAULT NULL COMMENT '扩展名',
`fileName` varchar(100) DEFAULT NULL COMMENT '文件名称',
`filepath` varchar(100) DEFAULT NULL COMMENT '文件路径',
`identifier` varchar(32) DEFAULT NULL COMMENT 'md5唯一标识',
`uploadStatus` int(1) DEFAULT NULL COMMENT '上传状态(1-成功,0-失败或未完成)',
`uploadtime` datetime DEFAULT NULL COMMENT '上传时间',
`userid` varchar(36) DEFAULT NULL COMMENT '用户id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of nd_uploadtask
-- ----------------------------
INSERT INTO `nd_uploadtask` VALUES ('1648549189221920770', 'pdf', '1+2021中医学一级学科博士学位授权点建设年度报告', '/', '3a8fc48a5421fa915bd4b9a85296af42', '1', '2023-04-19 12:48:50', 'admin');
INSERT INTO `nd_uploadtask` VALUES ('1648550230235590657', 'XML', 'diagram(2)', '/', '38de93622bf5c402962957e51e6c8937', '1', '2023-04-19 12:52:58', 'admin');
INSERT INTO `nd_uploadtask` VALUES ('1648550368932835329', 'doc', '附件1. 杭州电子科技大学优秀博士学位论文推荐表', '/', '9f3e2b5d2d67614ae7fbb854bd6fae61', '1', '2023-04-19 12:53:31', 'admin');
INSERT INTO `nd_uploadtask` VALUES ('1648550613037133825', 'pdf', '宁波十校3月联考-生物答案', '/', 'fc1b41ddbb0b33b6679601d0b9f868fe', '1', '2023-04-19 12:54:29', 'admin');
-- ----------------------------
-- Table structure for nd_uploadtaskdetail
-- ----------------------------
DROP TABLE IF EXISTS `nd_uploadtaskdetail`;
CREATE TABLE `nd_uploadtaskdetail` (
`id` varchar(36) NOT NULL COMMENT 'id',
`chunkNumber` int(5) DEFAULT NULL COMMENT '当前分片数',
`chunksize` int(19) DEFAULT NULL COMMENT '当前分片大小',
`filepath` varchar(100) DEFAULT NULL COMMENT '文件路径',
`filename` varchar(100) DEFAULT NULL COMMENT '文件名称',
`identifier` varchar(32) DEFAULT NULL COMMENT '文件md5唯一标识',
`relativepath` varchar(100) DEFAULT NULL COMMENT '文件相对路径',
`totalChunks` int(5) DEFAULT NULL COMMENT '文件总分片数',
`totalsize` int(19) DEFAULT NULL COMMENT '文件总大小',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of nd_uploadtaskdetail
-- ----------------------------
-- ----------------------------
-- Table structure for nd_userfile
-- ----------------------------
DROP TABLE IF EXISTS `nd_userfile`;
CREATE TABLE `nd_userfile` (
`id` varchar(36) NOT NULL COMMENT '主键',
`fileid` varchar(36) DEFAULT NULL COMMENT '文件ID',
`filename` varchar(100) DEFAULT NULL COMMENT '文件名称',
`extendname` varchar(20) DEFAULT NULL COMMENT '扩展名',
`filepath` varchar(500) DEFAULT NULL COMMENT '文件路径',
`isdir` int(1) DEFAULT NULL COMMENT '是否是目录(0-否,1-是)',
`deleteflag` int(1) DEFAULT NULL COMMENT '删除标志',
`deletetime` datetime DEFAULT NULL COMMENT '删除时间',
`create_by` varchar(50) DEFAULT NULL COMMENT '创建人',
`create_time` datetime DEFAULT NULL COMMENT '创建日期',
`sys_org_code` varchar(64) DEFAULT NULL COMMENT '所属部门',
`deletebatchnum` varchar(50) DEFAULT NULL COMMENT '删除批次号',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of nd_userfile
-- ----------------------------