/*
Navicat MySQL Data Transfer

Source Server         : 127.0.0.1
Source Server Version : 110302
Source Host           : 127.0.0.1:33069
Source Database       : prd

Target Server Type    : MYSQL
Target Server Version : 110302
File Encoding         : 65001

Date: 2025-12-25 23:03:47
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for biz_view_file
-- ----------------------------
DROP TABLE IF EXISTS `biz_view_file`;
CREATE TABLE `biz_view_file` (
  `create_time` datetime DEFAULT current_timestamp() COMMENT '创建时间',
  `id` varchar(64) NOT NULL COMMENT '主键ID',
  `file_name` varchar(255) DEFAULT NULL COMMENT '文件名',
  `file_size` int(11) DEFAULT NULL COMMENT '文件大小（字节）',
  `file_suffix` varchar(50) DEFAULT NULL COMMENT '文件后缀',
  `virtual_key` varchar(500) DEFAULT NULL COMMENT '虚拟路径',
  `relative_path` varchar(500) DEFAULT NULL COMMENT '相对路径',
  `absolute_path` varchar(500) DEFAULT NULL COMMENT '绝对路径',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='文件表';

-- ----------------------------
-- Table structure for biz_view_project
-- ----------------------------
DROP TABLE IF EXISTS `biz_view_project`;
CREATE TABLE `biz_view_project` (
  `create_time` datetime DEFAULT current_timestamp() COMMENT '创建时间',
  `id` varchar(64) NOT NULL COMMENT '主键ID',
  `project_name` varchar(255) DEFAULT NULL COMMENT '项目名称',
  `state` int(11) DEFAULT NULL COMMENT '状态',
  `create_user_id` varchar(64) DEFAULT NULL COMMENT '创建人ID',
  `is_delete` int(11) DEFAULT 0 COMMENT '是否删除（0-未删除，1-已删除）',
  `index_image` varchar(500) DEFAULT NULL COMMENT '封面图片',
  `remarks` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='项目表';

-- ----------------------------
-- Table structure for biz_view_project_data
-- ----------------------------
DROP TABLE IF EXISTS `biz_view_project_data`;
CREATE TABLE `biz_view_project_data` (
  `create_time` datetime DEFAULT current_timestamp() COMMENT '创建时间',
  `id` varchar(64) NOT NULL COMMENT '主键ID',
  `project_id` varchar(64) DEFAULT NULL COMMENT '项目ID',
  `create_user_id` varchar(64) DEFAULT NULL COMMENT '创建人ID',
  `content` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_project_id` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='项目数据表';

-- ----------------------------
-- Table structure for biz_view_user
-- ----------------------------
DROP TABLE IF EXISTS `biz_view_user`;
CREATE TABLE `biz_view_user` (
  `create_time` datetime DEFAULT current_timestamp() COMMENT '创建时间',
  `id` varchar(64) NOT NULL COMMENT '主键ID',
  `username` varchar(50) NOT NULL COMMENT '用户名',
  `password` varchar(100) NOT NULL COMMENT '密码（建议加密存储）',
  `nickname` varchar(50) DEFAULT NULL COMMENT '昵称',
  `dep_id` int(11) DEFAULT NULL COMMENT '部门ID',
  `pos_id` varchar(64) DEFAULT NULL COMMENT '职位ID',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户表';
