如何设计一个可靠的MySQL表结构来实现文件压缩功能？

id int not null primary key auto_increment,
file_name varchar(255) not null,
compressed_data mediumblob not null,
compression_method varchar(50) not null,
created_at datetime not null default current_timestamp,
file_size int not null,
compressed_size int not null

public static void main(String[] args) {
    String filePath = "path/to/file.txt";
    
    try {
        // 读取文件
        byte[] data = Files.readAllBytes(Paths.get(filePath));
        
        // 创建压缩流
        ByteArrayOutputStream outputStream = new ByteArrayOutputStream();
        DeflaterOutputStream compressor = new DeflaterOutputStream(outputStream);
        
        // 压缩文件
        compressor.write(data);
        compressor.finish();
        
        // 获取压缩后的文件数据
        byte[] compressedData = outputStream.toByteArray();
        
        // 获取文件大小
        int fileSize = data.length;
        
        // 获取压缩后的文件大小
        int compressedSize = compressedData.length;
        
        // 保存到数据库
        saveToFile(filePath, compressedData, fileSize, compressedSize);
        
        System.out.println("文件压缩成功！");
    } catch (IOException e) {
        e.printStackTrace();
    }
}

private static void saveToFile(String fileName, byte[] compressedData, int fileSize, int compressedSize) {
    // 连接数据库并保存文件信息到表中
}

public static void main(String[] args) {
    String compressedData = getCompressedDataFromDatabase();
    
    try {
        // 创建解压缩流
        ByteArrayInputStream inputStream = new ByteArrayInputStream(compressedData.getBytes());
        InflaterInputStream decompressor = new InflaterInputStream(inputStream);
        
        // 解压缩文件
        byte[] decompressedData = decompressor.readAllBytes();
        
        // 将解压缩后的文件保存到本地
        saveToFile("path/to/uncompressed/file.txt", decompressedData);
        
        System.out.println("文件解压缩成功！");
    } catch (IOException e) {
        e.printStackTrace();
    }
}

private static void saveToFile(String fileName, byte[] decompressedData) {
    // 将解压缩后的文件保存到本地
}

private static String getCompressedDataFromDatabase() {
    // 从数据库中获取压缩后的文件数据
    return null;
}