yvjia/db/sys_upload.sql

/**
Source Server Version: 8.0.31
Source Database: backendsys
Date: 2023/05/23 17:09:22
*/

DROP TABLE IF EXISTS `sys_upload`;
CREATE TABLE `sys_upload` (
    PRIMARY KEY (`id`),
    `id` BIGINT(10) AUTO_INCREMENT COMMENT 'ID',
    `category_id` BIGINT(10) COMMENT '分类ID',
    `user_id` BIGINT(10) COMMENT '上传用户ID',
    `name` VARCHAR(255) NOT NULL COMMENT '文件名称',
    `full_path` VARCHAR(1000) COMMENT '文件完整路径',
    `object_key` VARCHAR(500) COMMENT 'ObjectKey',
    `size` INT COMMENT '文件大小',
    `md5` VARCHAR(255) COMMENT '文件MD5',
    `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间'
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='系统上传文件表';