/*
 Navicat Premium Data Transfer

 Source Server         : 192.168.0.93-大理
 Source Server Type    : MySQL
 Source Server Version : 80027
 Source Host           : 192.168.0.93:13306
 Source Schema         : fd_fusion

 Target Server Type    : MySQL
 Target Server Version : 80027
 File Encoding         : 65001

 Date: 22/01/2026 16:37:36
*/

use fd_fusion;
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_ai_content
-- ----------------------------
DROP TABLE IF EXISTS `t_ai_content`;
CREATE TABLE `t_ai_content`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_ai_content
-- ----------------------------

-- ----------------------------
-- Table structure for t_case
-- ----------------------------
DROP TABLE IF EXISTS `t_case`;
CREATE TABLE `t_case`  (
  `case_id` int NOT NULL AUTO_INCREMENT COMMENT '案件表',
  `case_title` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '案件标题',
  `user_name` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '四维用户名',
  `tb_status` tinyint(1) NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `type` int NULL DEFAULT 0 COMMENT '0刑侦案件，1火调案件',
  `tm_project_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '火调项目id',
  `dept_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门ID',
  `map_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地图链接',
  `lat_and_long` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `case_num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '案件编号',
  `case_category` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '案件类别',
  `case_region` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '案发区域',
  `case_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '案发地址',
  `homicide_case` int NULL DEFAULT NULL COMMENT '是否命案，0否，1是',
  `criminal_case` int NULL DEFAULT NULL COMMENT '是否刑案，0否，1是',
  `sys_user_id` int NULL DEFAULT NULL,
  `crime_time` timestamp NULL DEFAULT NULL COMMENT '案发时间',
  `show_scenes` int NULL DEFAULT NULL COMMENT '是否展示场景0否，1是',
  `map_id` int NULL DEFAULT NULL,
  `map_show` int NULL DEFAULT NULL,
  PRIMARY KEY (`case_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 807 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_case
-- ----------------------------

-- ----------------------------
-- Table structure for t_case_animation
-- ----------------------------
DROP TABLE IF EXISTS `t_case_animation`;
CREATE TABLE `t_case_animation`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `case_id` int NULL DEFAULT NULL,
  `fusion_id` int NULL DEFAULT NULL,
  `title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `show_title` int NULL DEFAULT NULL COMMENT '0否，1是',
  `font_size` int NULL DEFAULT NULL,
  `global_visibility` int NULL DEFAULT NULL COMMENT '0否，1是',
  `visibility_range` int NULL DEFAULT NULL,
  `frames` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `actions` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `subtitles` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `paths` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `mat` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 107 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_case_animation
-- ----------------------------

-- ----------------------------
-- Table structure for t_case_device
-- ----------------------------
DROP TABLE IF EXISTS `t_case_device`;
CREATE TABLE `t_case_device`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `mac_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `device_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `character_model_id` int NULL DEFAULT NULL,
  `is_show_trace` int NULL DEFAULT NULL,
  `case_id` int NULL DEFAULT NULL,
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_case_device
-- ----------------------------

-- ----------------------------
-- Table structure for t_case_extract_detail
-- ----------------------------
DROP TABLE IF EXISTS `t_case_extract_detail`;
CREATE TABLE `t_case_extract_detail`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `case_id` int NULL DEFAULT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '地址',
  `time` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '提取时间',
  `detail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '提取清单',
  `extract_user` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '提取人信息',
  `witness_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '证人信息',
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2265 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_case_extract_detail
-- ----------------------------

-- ----------------------------
-- Table structure for t_case_files
-- ----------------------------
DROP TABLE IF EXISTS `t_case_files`;
CREATE TABLE `t_case_files`  (
  `files_id` int NOT NULL AUTO_INCREMENT COMMENT '卷宗',
  `case_id` int NULL DEFAULT NULL,
  `files_type_id` int NULL DEFAULT NULL COMMENT '附件类型',
  `files_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '附件标题',
  `files_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `img_type` int NULL DEFAULT NULL COMMENT '0现场图，1方位图',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '现场图或方位图json',
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人账号',
  `nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人昵称',
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `create_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'upload' COMMENT '创建类型',
  `ogn_files_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `overview_id` int NULL DEFAULT NULL,
  `tabulation_id` int NULL DEFAULT NULL,
  `extract_id` int NULL DEFAULT NULL,
  `inquest_id` int NULL DEFAULT NULL,
  PRIMARY KEY (`files_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2315 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_case_files
-- ----------------------------

-- ----------------------------
-- Table structure for t_case_files_type
-- ----------------------------
DROP TABLE IF EXISTS `t_case_files_type`;
CREATE TABLE `t_case_files_type`  (
  `files_type_id` int NOT NULL AUTO_INCREMENT COMMENT '附件类型',
  `files_type_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '附件类型名称',
  `sort` int NULL DEFAULT 1,
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `parent_id` int NULL DEFAULT NULL,
  `modal_show` int NULL DEFAULT 0,
  `flat_show` int NULL DEFAULT 0,
  `dict_id` int NULL DEFAULT NULL,
  PRIMARY KEY (`files_type_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_case_files_type
-- ----------------------------
INSERT INTO `t_case_files_type` VALUES (1, '现场图', 1, 0, '2022-08-02 17:30:54', '2024-10-17 15:06:19', NULL, 0, 0, NULL);
INSERT INTO `t_case_files_type` VALUES (2, '照片卷', 4, 0, '2022-08-02 17:31:21', '2025-11-27 10:39:40', NULL, 0, 0, NULL);
INSERT INTO `t_case_files_type` VALUES (3, '勘验笔录', 2, 0, '2022-08-02 17:31:22', '2025-11-27 10:39:11', NULL, 0, 0, NULL);
INSERT INTO `t_case_files_type` VALUES (4, '提取清单', 3, 0, '2024-09-29 11:11:35', '2025-11-27 10:39:14', NULL, 0, 0, NULL);
INSERT INTO `t_case_files_type` VALUES (6, '其他资料', 6, 0, '2024-10-17 15:37:02', '2024-10-17 15:37:02', NULL, 0, 0, NULL);
INSERT INTO `t_case_files_type` VALUES (7, '认定书', 4, 1, '2023-08-09 12:04:59', '2025-01-23 09:56:16', NULL, 0, 0, NULL);

-- ----------------------------
-- Table structure for t_case_files_type_icon
-- ----------------------------
DROP TABLE IF EXISTS `t_case_files_type_icon`;
CREATE TABLE `t_case_files_type_icon`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `files_type_id` int NULL DEFAULT NULL,
  `icon_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 60 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_case_files_type_icon
-- ----------------------------
INSERT INTO `t_case_files_type_icon` VALUES (34, 'handprint.png', 59, '/oss/manage/media-library/evidence-icon/handprint.png', 0, '2025-08-22 15:37:41', '2025-09-02 18:02:13');
INSERT INTO `t_case_files_type_icon` VALUES (35, 'zhiwen.png', 59, '/oss/manage/media-library/evidence-icon/zhiwen.png', 0, '2025-08-22 15:37:41', '2025-08-26 14:45:54');
INSERT INTO `t_case_files_type_icon` VALUES (36, 'hand_l.png', 59, '/oss/manage/media-library/evidence-icon/hand_l.png', 0, '2025-08-22 15:37:41', '2025-08-26 14:45:54');
INSERT INTO `t_case_files_type_icon` VALUES (37, 'hand_r.png', 59, '/oss/manage/media-library/evidence-icon/hand_r.png', 0, '2025-08-22 15:37:41', '2025-09-02 18:02:10');
INSERT INTO `t_case_files_type_icon` VALUES (38, 'footprint.png', 60, '/oss/manage/media-library/evidence-icon/footprint.png', 0, '2025-08-22 15:37:41', '2025-09-02 18:03:38');
INSERT INTO `t_case_files_type_icon` VALUES (39, 'zuozuji.png', 60, '/oss/manage/media-library/evidence-icon/zuozuji.png', 0, '2025-08-22 15:37:41', '2025-08-26 14:45:54');
INSERT INTO `t_case_files_type_icon` VALUES (40, 'youzuji.png', 60, '/oss/manage/media-library/evidence-icon/youzuji.png', 0, '2025-08-22 15:37:41', '2025-09-02 18:03:31');
INSERT INTO `t_case_files_type_icon` VALUES (41, 'xieyin.png', 60, '/oss/manage/media-library/evidence-icon/xieyin.png', 0, '2025-08-22 15:37:41', '2025-08-26 14:45:54');
INSERT INTO `t_case_files_type_icon` VALUES (42, 'virus.png', 61, '/oss/manage/media-library/evidence-icon/virus.png', 0, '2025-08-22 15:37:41', '2025-09-02 18:05:04');
INSERT INTO `t_case_files_type_icon` VALUES (43, 'wrenchAndScrewdriver.png', 63, '/oss/manage/media-library/evidence-icon/wrenchAndScrewdriver.png', 0, '2025-08-22 15:37:41', '2025-08-26 14:45:54');
INSERT INTO `t_case_files_type_icon` VALUES (44, 'video.png', 64, '/oss/manage/media-library/evidence-icon/video.png', 0, '2025-08-22 15:37:41', '2025-08-26 14:45:54');
INSERT INTO `t_case_files_type_icon` VALUES (45, 'xuepo.png', 61, '/oss/manage/media-library/evidence-icon/xuepo.png', 0, '2025-08-22 15:37:41', '2025-08-26 14:45:54');
INSERT INTO `t_case_files_type_icon` VALUES (46, 'xueji.png', 61, '/oss/manage/media-library/evidence-icon/xueji.png', 0, '2025-08-22 15:37:41', '2025-08-26 14:45:54');
INSERT INTO `t_case_files_type_icon` VALUES (48, 'cartridge.png', 65, '/oss/manage/media-library/evidence-icon/cartridge.png', 0, '2025-08-22 15:37:41', '2025-09-02 18:04:57');
INSERT INTO `t_case_files_type_icon` VALUES (49, 'poison.png', 66, '/oss/manage/media-library/evidence-icon/poison.png', 0, '2025-08-22 15:37:41', '2025-09-02 18:04:46');
INSERT INTO `t_case_files_type_icon` VALUES (50, 'physics_and_chemistry.png', 67, '/oss/manage/media-library/evidence-icon/physics_and_chemistry.png', 0, '2025-08-22 15:37:41', '2025-08-26 14:45:54');
INSERT INTO `t_case_files_type_icon` VALUES (51, 'folder_close.png', 68, '/oss/manage/media-library/evidence-icon/folder_close.png', 0, '2025-08-22 15:37:41', '2025-08-26 14:45:54');
INSERT INTO `t_case_files_type_icon` VALUES (52, 'check.png', 69, '/oss/manage/media-library/evidence-icon/check.png', 0, '2025-08-22 15:37:41', '2025-08-26 14:45:54');
INSERT INTO `t_case_files_type_icon` VALUES (53, 'case_other.png', 62, '/oss/manage/media-library/evidence-icon/case_other.png', 0, '2025-08-22 15:37:41', '2025-08-26 14:45:54');
INSERT INTO `t_case_files_type_icon` VALUES (54, 'dot.png', 62, '/oss/manage/media-library/evidence-icon/dot.png', 0, '2025-08-22 15:37:41', '2025-08-26 14:45:54');
INSERT INTO `t_case_files_type_icon` VALUES (55, 'electronic.png', 70, '/oss/manage/media-library/evidence-icon/electronic.png', 0, '2025-08-22 15:37:41', '2025-08-26 14:45:54');
INSERT INTO `t_case_files_type_icon` VALUES (56, 'cube.png', 71, '/oss/manage/media-library/evidence-icon/cube.png', 0, '2025-08-22 15:37:41', '2025-08-26 14:45:54');
INSERT INTO `t_case_files_type_icon` VALUES (57, 'shitiz.png', 58, '/oss/manage/media-library/evidence-icon/shitiz.png', 0, '2025-08-22 15:37:41', '2025-08-26 14:45:54');
INSERT INTO `t_case_files_type_icon` VALUES (58, 'shitib.png', 58, '/oss/manage/media-library/evidence-icon/shitib.png', 0, '2025-08-22 15:37:41', '2025-08-26 14:45:54');
INSERT INTO `t_case_files_type_icon` VALUES (59, 'shitifuhao.png', 58, '/oss/manage/media-library/evidence-icon/shitifuhao.png', 0, '2025-08-22 15:37:41', '2025-08-26 14:45:54');
INSERT INTO `t_case_files_type_icon` VALUES (60, 'corpse.png', 58, '/oss/manage/media-library/evidence-icon/corpse.png', 0, '2025-08-22 15:37:41', '2025-08-26 14:45:54');

-- ----------------------------
-- Table structure for t_case_fusion
-- ----------------------------
DROP TABLE IF EXISTS `t_case_fusion`;
CREATE TABLE `t_case_fusion`  (
  `fusion_id` int NOT NULL AUTO_INCREMENT COMMENT '多元融合',
  `fusion_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '融合标题',
  `case_id` int NULL DEFAULT NULL COMMENT '案件id',
  `sys_user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `lat_and_long` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`fusion_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 481 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_case_fusion
-- ----------------------------

-- ----------------------------
-- Table structure for t_case_fusion_relation
-- ----------------------------
DROP TABLE IF EXISTS `t_case_fusion_relation`;
CREATE TABLE `t_case_fusion_relation`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `case_id` int NULL DEFAULT NULL,
  `fusion_id` int NULL DEFAULT NULL,
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 874 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_case_fusion_relation
-- ----------------------------

-- ----------------------------
-- Table structure for t_case_img
-- ----------------------------
DROP TABLE IF EXISTS `t_case_img`;
CREATE TABLE `t_case_img`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `case_id` int NULL DEFAULT NULL COMMENT '案例id',
  `img_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图片链接',
  `img_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图片说明',
  `status` int NULL DEFAULT 0 COMMENT '0未应用，1已应用',
  `sort` int NULL DEFAULT 0 COMMENT '排序',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `type` int NULL DEFAULT 0 COMMENT '0图片，1合并图片',
  `parent_id` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 938 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_case_img
-- ----------------------------

-- ----------------------------
-- Table structure for t_case_img_tag
-- ----------------------------
DROP TABLE IF EXISTS `t_case_img_tag`;
CREATE TABLE `t_case_img_tag`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `case_id` int NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `is_horizontal` int NULL DEFAULT 0,
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `img_id` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 341 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_case_img_tag
-- ----------------------------

-- ----------------------------
-- Table structure for t_case_inquest
-- ----------------------------
DROP TABLE IF EXISTS `t_case_inquest`;
CREATE TABLE `t_case_inquest`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `case_id` int NULL DEFAULT NULL,
  `count` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '勘验次数',
  `start_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '勘验开始时间',
  `end_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '勘验结束时间',
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '勘验地点',
  `user_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '勘验人员信息',
  `weather` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '勘验气象条件',
  `situation` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '勘验情况',
  `environment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '环境勘验',
  `first_inquest` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '初步勘验',
  `careful_inquest` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '细项勘验',
  `special_inquest` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '专项勘验',
  `item_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '提取物品描述',
  `img_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '现场拍照制图描述',
  `leader` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '负责人',
  `recorder` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '记录人',
  `inspector` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '勘验人',
  `witness_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '证人信息数组',
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2279 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_case_inquest
-- ----------------------------

-- ----------------------------
-- Table structure for t_case_inquest_criminal
-- ----------------------------
DROP TABLE IF EXISTS `t_case_inquest_criminal`;
CREATE TABLE `t_case_inquest_criminal`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `case_id` int NULL DEFAULT NULL,
  `inquest_file_id` int NULL DEFAULT NULL,
  `inquest_num` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '现场勘验号',
  `dept_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '单位名称',
  `title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '标题',
  `send_dept` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '发送单位',
  `recorder` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '笔录人',
  `painter` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '绘图人',
  `photographer` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '照相人',
  `issuance_count` int NULL DEFAULT NULL COMMENT '份数',
  `make_time` timestamp NULL DEFAULT NULL COMMENT '制作时间',
  `issuance_opinion` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '签发意见',
  `signature` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '签名',
  `signature_time` timestamp NULL DEFAULT NULL COMMENT '签名时间',
  `report_dept` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '报告单位',
  `inquest_time` timestamp NULL DEFAULT NULL COMMENT '时间',
  `times` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '勘验时间数组',
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '勘验地址',
  `protection_situation` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '现场保护情况',
  `protector` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '现场保护人',
  `protection_measures` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '现场保护措施',
  `situation` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '现场情况',
  `change_reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '变动原因',
  `change_reason_other_value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `weather_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '天气情况',
  `light` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '光线',
  `inquest_commander` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '勘验指挥人',
  `inquest_situation` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '勘验情况',
  `image_num` int NULL DEFAULT NULL COMMENT '现场勘验制图数量',
  `photograph_num` int NULL DEFAULT NULL COMMENT '照相数量',
  `photography_min_num` int NULL DEFAULT NULL COMMENT '摄影数量',
  `photography_sec_num` int NULL DEFAULT NULL,
  `recorder_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '现场勘验纪录人员obj',
  `signature_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '现场勘验人员签名数组',
  `witness_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '现场勘验见证人数组',
  `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注',
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '讯飞ai全景图解析场景码',
  `inquest_resource` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '勘验事由',
  `recording_min_num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `recording_Sec_num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_case_inquest_criminal
-- ----------------------------

-- ----------------------------
-- Table structure for t_case_inquest_info
-- ----------------------------
DROP TABLE IF EXISTS `t_case_inquest_info`;
CREATE TABLE `t_case_inquest_info`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `case_id` int NULL DEFAULT NULL,
  `command_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '指挥中心电话时间',
  `alarm_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '接警时间',
  `alarm_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '接警人',
  `inquest_dept` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '现场勘验单位',
  `assign_dept` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '指派/报告单位',
  `assign_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '指派方式',
  `times` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '勘验时间数组',
  `inquest_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '勘验地点',
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_case_inquest_info
-- ----------------------------

-- ----------------------------
-- Table structure for t_case_live
-- ----------------------------
DROP TABLE IF EXISTS `t_case_live`;
CREATE TABLE `t_case_live`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `case_id` int NULL DEFAULT NULL,
  `tm_user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `take_room_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `num_list` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 301 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_case_live
-- ----------------------------

-- ----------------------------
-- Table structure for t_case_num
-- ----------------------------
DROP TABLE IF EXISTS `t_case_num`;
CREATE TABLE `t_case_num`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `case_id` int NULL DEFAULT NULL,
  `num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `num_type` int NULL DEFAULT NULL COMMENT '0 四维看看，1看见场景，2 深时场景,3 三维模型,4深时obj',
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4653 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_case_num
-- ----------------------------

-- ----------------------------
-- Table structure for t_case_offline
-- ----------------------------
DROP TABLE IF EXISTS `t_case_offline`;
CREATE TABLE `t_case_offline`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `case_id` int NULL DEFAULT NULL,
  `offline_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `version` int NULL DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 162 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_case_offline
-- ----------------------------

-- ----------------------------
-- Table structure for t_case_overview
-- ----------------------------
DROP TABLE IF EXISTS `t_case_overview`;
CREATE TABLE `t_case_overview`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `case_id` int NULL DEFAULT NULL,
  `title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `cover` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `store` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '数据',
  `viewport` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '视口',
  `type` int NULL DEFAULT 0,
  `map_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `high` int NULL DEFAULT NULL,
  `width` int NULL DEFAULT NULL,
  `list_cover` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `kankan_cover` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `platform_id` int NULL DEFAULT NULL,
  `sys_user_id` int NULL DEFAULT NULL,
  `is_copy` int NULL DEFAULT NULL,
  `num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `sub_group` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1129 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_case_overview
-- ----------------------------

-- ----------------------------
-- Table structure for t_case_path
-- ----------------------------
DROP TABLE IF EXISTS `t_case_path`;
CREATE TABLE `t_case_path`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `case_id` int NULL DEFAULT NULL,
  `fusion_id` int NULL DEFAULT NULL,
  `path` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `record_start_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `record_end_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `path_type` int NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 289 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_case_path
-- ----------------------------

-- ----------------------------
-- Table structure for t_case_script
-- ----------------------------
DROP TABLE IF EXISTS `t_case_script`;
CREATE TABLE `t_case_script`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `case_id` int NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_case_script
-- ----------------------------

-- ----------------------------
-- Table structure for t_case_settings
-- ----------------------------
DROP TABLE IF EXISTS `t_case_settings`;
CREATE TABLE `t_case_settings`  (
  `settings_id` int NOT NULL AUTO_INCREMENT COMMENT '融合场景设置表',
  `case_id` int NULL DEFAULT NULL COMMENT '案件id',
  `fusion_id` int NULL DEFAULT NULL,
  `pose` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '初始画面json',
  `cover` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '封面图',
  `back` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '背景，天空',
  `back_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `open_compass` int NULL DEFAULT 0,
  `map_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `map_open` int NULL DEFAULT 0,
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `scale` double(11, 4) NULL DEFAULT NULL COMMENT '缩放系数',
  `fov` double(11, 2) NULL DEFAULT NULL COMMENT '视角范围',
  `rotate` double(11, 4) NULL DEFAULT NULL,
  `map_id` int NULL DEFAULT NULL,
  `location_model_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`settings_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 167 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_case_settings
-- ----------------------------

-- ----------------------------
-- Table structure for t_case_settings_resource
-- ----------------------------
DROP TABLE IF EXISTS `t_case_settings_resource`;
CREATE TABLE `t_case_settings_resource`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `fusion_id` int NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '名称',
  `resource` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '资源链接',
  `back_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型，0天空，1地面',
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `scale` double(11, 4) NULL DEFAULT NULL COMMENT '缩放系数',
  `rotate` double(11, 4) NULL DEFAULT NULL COMMENT '旋转系数',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 116 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_case_settings_resource
-- ----------------------------

-- ----------------------------
-- Table structure for t_case_tabulation
-- ----------------------------
DROP TABLE IF EXISTS `t_case_tabulation`;
CREATE TABLE `t_case_tabulation`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `case_id` int NULL DEFAULT NULL,
  `title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `store` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '数据',
  `viewport` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '视口',
  `cover` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '封面图',
  `paper_key` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '纸张',
  `is_auto_gen` int NULL DEFAULT NULL,
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `overview_id` int NULL DEFAULT NULL,
  `map_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `high` int NULL DEFAULT NULL,
  `width` int NULL DEFAULT NULL,
  `list_cover` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `platform_id` int NULL DEFAULT NULL,
  `sys_user_id` int NULL DEFAULT NULL,
  `is_copy` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 607 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_case_tabulation
-- ----------------------------

-- ----------------------------
-- Table structure for t_case_tag
-- ----------------------------
DROP TABLE IF EXISTS `t_case_tag`;
CREATE TABLE `t_case_tag`  (
  `tag_id` int NOT NULL AUTO_INCREMENT COMMENT '标注表',
  `tag_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题',
  `tag_describe` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '描述',
  `leave_behind` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '遗留部位',
  `get_method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '提取方法',
  `get_user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '提取人',
  `place_num` int NULL DEFAULT NULL,
  `tag_img_url` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '标注图片集',
  `hot_icon_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '热点iconurl',
  `hot_icon_id` int NULL DEFAULT NULL COMMENT '热点iconid',
  `case_id` int NULL DEFAULT NULL,
  `fusion_id` int NULL DEFAULT NULL,
  `mtype` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `cat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `tsms` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `sort` int NULL DEFAULT 1,
  `show3d_title` int NULL DEFAULT 0,
  `audio` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`tag_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 459 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_case_tag
-- ----------------------------

-- ----------------------------
-- Table structure for t_case_tag_point
-- ----------------------------
DROP TABLE IF EXISTS `t_case_tag_point`;
CREATE TABLE `t_case_tag_point`  (
  `tag_point_id` int NOT NULL AUTO_INCREMENT COMMENT '标注位置表',
  `tag_point_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '位置名称',
  `tag_point` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '位置json',
  `tag_id` int NULL DEFAULT NULL COMMENT '标注id',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `sort` int NULL DEFAULT 1,
  `tb_status` int NULL DEFAULT 0,
  `fusion_num_id` int NULL DEFAULT NULL,
  `bind_hide` int NULL DEFAULT 0,
  `global_visibility` int NULL DEFAULT 0,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `mat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `font_size` double(11, 1) NULL DEFAULT NULL,
  `line_height` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `visibility_range` int NULL DEFAULT NULL,
  `normal` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `pose` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  PRIMARY KEY (`tag_point_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1378 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_case_tag_point
-- ----------------------------

-- ----------------------------
-- Table structure for t_case_video
-- ----------------------------
DROP TABLE IF EXISTS `t_case_video`;
CREATE TABLE `t_case_video`  (
  `video_id` int NOT NULL AUTO_INCREMENT,
  `folder_id` int NULL DEFAULT NULL,
  `video_path` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `video_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `video_cover` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '封面图',
  `sort` int NULL DEFAULT NULL,
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `upload_status` int NULL DEFAULT 0 COMMENT '上传状态0上传中，1上传成功，-1上传失败',
  PRIMARY KEY (`video_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 640 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_case_video
-- ----------------------------

-- ----------------------------
-- Table structure for t_case_video_folder
-- ----------------------------
DROP TABLE IF EXISTS `t_case_video_folder`;
CREATE TABLE `t_case_video_folder`  (
  `video_folder_id` int NOT NULL AUTO_INCREMENT COMMENT '视频文件夹',
  `video_folder_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '视频文件夹名称',
  `case_id` int NULL DEFAULT NULL COMMENT '案件id',
  `video_folder_cover` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '封面图',
  `video_merge_url` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '合并片段之后的视频url',
  `sort` int NULL DEFAULT 0 COMMENT '排序',
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `upload_status` int NULL DEFAULT 0,
  PRIMARY KEY (`video_folder_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 475 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_case_video_folder
-- ----------------------------

-- ----------------------------
-- Table structure for t_case_view
-- ----------------------------
DROP TABLE IF EXISTS `t_case_view`;
CREATE TABLE `t_case_view`  (
  `view_id` int NOT NULL AUTO_INCREMENT COMMENT '视图截取',
  `view_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '视图名称',
  `view_point` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '场景进入位置',
  `view_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '视图截图',
  `view_img_small` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '视图截图缩略图',
  `case_id` int NULL DEFAULT NULL COMMENT '案件id',
  `num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '场景码',
  `num_type` int NULL DEFAULT NULL COMMENT '场景类型',
  `num_thumb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '场景链接',
  `sort` int NULL DEFAULT 1,
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `fusion_id` int NULL DEFAULT NULL,
  `bind_hide` int NULL DEFAULT 0,
  PRIMARY KEY (`view_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 661 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_case_view
-- ----------------------------

-- ----------------------------
-- Table structure for t_common_upload
-- ----------------------------
DROP TABLE IF EXISTS `t_common_upload`;
CREATE TABLE `t_common_upload`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `file_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `file_size` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `new_file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `file_type_str` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `file_format` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `result_file_format` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` int NULL DEFAULT 0,
  `unzip_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `file_type` int NULL DEFAULT NULL,
  `wgs84` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `gcj02` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `use_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'ordinary',
  `convert_type` int NULL DEFAULT NULL,
  `source_file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `coordinate_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1141 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_common_upload
-- ----------------------------
INSERT INTO `t_common_upload` VALUES (1, 'Man', '/oss/fusion/default/model/glb/man.glb', '3303348', 'Man', '模型', 'glb', 'glb', 'A', '2025-03-28 10:00:04', '2026-01-22 16:10:30', 1, NULL, 3, NULL, NULL, 'animation', NULL, NULL, NULL);
INSERT INTO `t_common_upload` VALUES (2, 'Hammer2', '/oss/fusion/default/model/glb/hammer2.glb', '284844', 'Hammer2', '模型', 'glb', 'glb', 'A', '2025-03-28 10:00:04', '2026-01-22 16:10:28', 1, NULL, 3, NULL, NULL, 'animation', NULL, NULL, NULL);
INSERT INTO `t_common_upload` VALUES (3, 'Gun', '/oss/fusion/default/model/glb/gun.glb', '248080', 'Gun', '模型', 'glb', 'glb', 'A', '2025-03-28 10:00:04', '2026-01-22 16:10:26', 1, NULL, 3, NULL, NULL, 'animation', NULL, NULL, NULL);
INSERT INTO `t_common_upload` VALUES (4, 'Kid', '/oss/fusion/default/model/glb/kid.glb', '2636492', 'Kid', '模型', 'glb', 'glb', 'A', '2025-03-28 10:00:04', '2026-01-22 16:10:25', 1, NULL, 3, NULL, NULL, 'animation', NULL, NULL, NULL);
INSERT INTO `t_common_upload` VALUES (5, 'Hammer1', '/oss/fusion/default/model/glb/hammer1.glb', '2113100', 'Hammer1', '模型', 'glb', 'glb', 'A', '2025-03-28 10:00:04', '2026-01-22 16:09:40', 1, NULL, 3, NULL, NULL, 'animation', NULL, NULL, NULL);
INSERT INTO `t_common_upload` VALUES (6, 'Knife', '/oss/fusion/default/model/glb/knife.glb', '1008742', 'Knife', '模型', 'glb', 'glb', 'A', '2025-03-28 10:00:04', '2026-01-22 16:09:40', 1, NULL, 3, NULL, NULL, 'animation', NULL, NULL, NULL);
INSERT INTO `t_common_upload` VALUES (7, 'Machinegun', '/oss/fusion/default/model/glb/machinegun.glb', '111104', 'Machinegun', '模型', 'glb', 'glb', 'A', '2025-03-28 10:00:04', '2026-01-22 16:09:40', 1, NULL, 3, NULL, NULL, 'animation', NULL, NULL, NULL);
INSERT INTO `t_common_upload` VALUES (8, 'Baseballbat', '/oss/fusion/default/model/glb/baseballbat.glb', '259276', 'Baseballbat', '模型', 'glb', 'glb', 'A', '2025-03-28 10:00:04', '2026-01-22 16:09:40', 1, NULL, 3, NULL, NULL, 'animation', NULL, NULL, NULL);
INSERT INTO `t_common_upload` VALUES (9, 'women', '/oss/fusion/default/model/glb/women.glb', '359276', 'women', '模型', 'glb', 'glb', 'A', '2025-03-28 10:00:04', '2026-01-22 16:09:40', 1, NULL, 3, NULL, NULL, 'animation', NULL, NULL, NULL);
INSERT INTO `t_common_upload` VALUES (10, 'fireman', '/oss/fusion/default/model/glb/fireman.glb', '3592760', 'fireman', '模型', 'glb', 'glb', 'A', '2025-03-28 10:00:04', '2026-01-22 16:09:40', 1, NULL, 3, NULL, NULL, 'animation', NULL, NULL, NULL);

-- ----------------------------
-- Table structure for t_dict
-- ----------------------------
DROP TABLE IF EXISTS `t_dict`;
CREATE TABLE `t_dict`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `dict_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `dict_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `sort` int NULL DEFAULT 1,
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `sys_user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `parent_id` int NULL DEFAULT NULL,
  `use_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'ordinary',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 116 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_dict
-- ----------------------------
INSERT INTO `t_dict` VALUES (1, '动画模型', 'media-library', 1, 'A', '2025-03-28 10:00:04', '2025-03-28 10:00:04', '1', NULL, 'animation');

-- ----------------------------
-- Table structure for t_dict_file
-- ----------------------------
DROP TABLE IF EXISTS `t_dict_file`;
CREATE TABLE `t_dict_file`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `type_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `dict_id` int NULL DEFAULT NULL,
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `sys_user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `upload_id` int NULL DEFAULT NULL,
  `use_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'ordinary',
  `hash_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `down_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `use_device` int NULL DEFAULT NULL COMMENT '0女，1男，2消防员',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1140 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_dict_file
-- ----------------------------
INSERT INTO `t_dict_file` VALUES (1, 'Man', 'media-library', 1, 'A', '2025-03-28 10:00:04', '2025-08-22 10:31:29', '1', 1, 'animation', 'https://4dkk.4dage.com/fusion/media-library/down/1/1_hash.txt', 'https://4dkk.4dage.com/fusion/default/model/glb/man.glb', 1);
INSERT INTO `t_dict_file` VALUES (2, 'Hammer2', 'media-library', 1, 'A', '2025-03-28 10:00:04', '2025-05-14 16:28:52', '1', 2, 'animation', 'https://4dkk.4dage.com/fusion/media-library/down/2/2_hash.txt', 'https://4dkk.4dage.com/fusion/default/model/glb/hammer2.glb', NULL);
INSERT INTO `t_dict_file` VALUES (3, 'Gun', 'media-library', 1, 'A', '2025-03-28 10:00:04', '2025-05-14 16:28:50', '1', 3, 'animation', NULL, 'https://4dkk.4dage.com/fusion/default/model/glb/gun.glb', NULL);
INSERT INTO `t_dict_file` VALUES (4, 'Kid', 'media-library', 1, 'A', '2025-03-28 10:00:04', '2025-05-14 16:28:47', '1', 4, 'animation', NULL, 'https://4dkk.4dage.com/fusion/default/model/glb/kid.glb', NULL);
INSERT INTO `t_dict_file` VALUES (5, 'Hammer1', 'media-library', 1, 'A', '2025-03-28 10:00:04', '2025-05-14 16:28:45', '1', 5, 'animation', NULL, 'https://4dkk.4dage.com/fusion/default/model/glb/hammer1.glb', NULL);
INSERT INTO `t_dict_file` VALUES (6, 'Knife', 'media-library', 1, 'A', '2025-03-28 10:00:04', '2025-05-14 16:28:44', '1', 6, 'animation', NULL, 'https://4dkk.4dage.com/fusion/default/model/glb/knife.glb', NULL);
INSERT INTO `t_dict_file` VALUES (7, 'Machinegun', 'media-library', 1, 'A', '2025-03-28 10:00:04', '2025-05-14 16:28:41', '1', 7, 'animation', NULL, 'https://4dkk.4dage.com/fusion/default/model/glb/machinegun.glb', NULL);
INSERT INTO `t_dict_file` VALUES (8, 'Baseballbat', 'media-library', 1, 'A', '2025-03-28 10:00:04', '2025-05-12 09:34:46', '1', 8, 'animation', 'https://4dkk.4dage.com/fusion/media-library/down/8/8_hash.txt', 'https://4dkk.4dage.com/fusion/default/model/glb/baseballbat.glb', NULL);
INSERT INTO `t_dict_file` VALUES (9, 'women', 'media-library', 1, 'A', '2025-03-28 10:00:04', '2025-08-22 10:31:31', '1', 9, 'animation', NULL, 'https://4dkk.4dage.com/fusion/default/model/glb/women.glb', 0);
INSERT INTO `t_dict_file` VALUES (10, 'fireman', 'media-library', 1, 'A', '2025-03-28 10:00:04', '2025-09-05 14:32:22', '1', 10, 'animation', NULL, 'https://4dkk.4dage.com/fusion/default/model/glb/fireman.glb', 2);

-- ----------------------------
-- Table structure for t_fusion_guide
-- ----------------------------
DROP TABLE IF EXISTS `t_fusion_guide`;
CREATE TABLE `t_fusion_guide`  (
  `fusion_guide_id` int NOT NULL AUTO_INCREMENT COMMENT '融合场景导览，路线',
  `case_id` int NULL DEFAULT NULL COMMENT '案件id',
  `fusion_id` int NULL DEFAULT NULL,
  `cover` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '封面图',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题',
  `sort` int NULL DEFAULT 1 COMMENT '排序',
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `recovery_content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `show_taggings` int NULL DEFAULT NULL,
  `show_measure` int NULL DEFAULT NULL,
  `show_monitor` int NULL DEFAULT NULL,
  `show_path` int NULL DEFAULT NULL,
  PRIMARY KEY (`fusion_guide_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 379 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_fusion_guide
-- ----------------------------

-- ----------------------------
-- Table structure for t_fusion_guide_path
-- ----------------------------
DROP TABLE IF EXISTS `t_fusion_guide_path`;
CREATE TABLE `t_fusion_guide_path`  (
  `guide_path_id` int NOT NULL AUTO_INCREMENT,
  `guide_id` int NULL DEFAULT NULL,
  `target` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '位置json',
  `position` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '位置json',
  `cover` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '封面图',
  `time` int NULL DEFAULT NULL COMMENT '持续时间 秒',
  `speed` double(10, 2) NULL DEFAULT NULL COMMENT '速度 m/s ',
  `sort` int NULL DEFAULT 1 COMMENT '排序',
  `pano_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `play_animation` int NULL DEFAULT NULL,
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`guide_path_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1737 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_fusion_guide_path
-- ----------------------------

-- ----------------------------
-- Table structure for t_fusion_meter
-- ----------------------------
DROP TABLE IF EXISTS `t_fusion_meter`;
CREATE TABLE `t_fusion_meter`  (
  `fusion_meter_id` int NOT NULL AUTO_INCREMENT COMMENT '测量',
  `fusion_id` int NULL DEFAULT NULL COMMENT '融合id',
  `meter_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题',
  `meter_type` int NULL DEFAULT NULL COMMENT '测量工具类型，0 自由，1垂直，2面积',
  `position` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '位置',
  `length` double(10, 2) NULL DEFAULT NULL COMMENT '长度  米',
  `hide` int NULL DEFAULT 0 COMMENT '0展示，1隐藏',
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `bind_hide` int NULL DEFAULT 0,
  PRIMARY KEY (`fusion_meter_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 758 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_fusion_meter
-- ----------------------------

-- ----------------------------
-- Table structure for t_fusion_num
-- ----------------------------
DROP TABLE IF EXISTS `t_fusion_num`;
CREATE TABLE `t_fusion_num`  (
  `fusion_num_id` int NOT NULL AUTO_INCREMENT,
  `fusion_id` int NULL DEFAULT NULL,
  `model_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `transform` json NULL COMMENT '位置,比例等属性',
  `bottom` double(10, 2) NULL DEFAULT 1.00 COMMENT '高度',
  `opacity` double(10, 2) NULL DEFAULT 0.50 COMMENT '透明度',
  `hide` int NULL DEFAULT 0 COMMENT '是否隐藏0否，1是',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `tb_status` int NULL DEFAULT 0,
  PRIMARY KEY (`fusion_num_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2345 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_fusion_num
-- ----------------------------

-- ----------------------------
-- Table structure for t_hot_icon
-- ----------------------------
DROP TABLE IF EXISTS `t_hot_icon`;
CREATE TABLE `t_hot_icon`  (
  `icon_id` int NOT NULL AUTO_INCREMENT,
  `icon_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `icon_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `is_system` int NULL DEFAULT 0 COMMENT '是否系统默认，0否，1是',
  `use_num` int NULL DEFAULT 0 COMMENT '使用次数',
  `last_use` int NULL DEFAULT 0 COMMENT '1上次使用',
  `is_new` int NULL DEFAULT 1 COMMENT '0否，1是',
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `case_id` int NULL DEFAULT NULL,
  `fusion_id` int NULL DEFAULT NULL,
  `parent_id` int NULL DEFAULT NULL,
  `dict_id` int NULL DEFAULT NULL,
  `sort` int NULL DEFAULT 1,
  PRIMARY KEY (`icon_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 221 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_hot_icon
-- ----------------------------
INSERT INTO `t_hot_icon` VALUES (1, '系统默认', '/oss/fusion/default/tag_icon_default.svg', NULL, 1, 113, 1, 1, 1, '2022-08-04 11:06:39', '2026-01-22 16:16:20', NULL, NULL, 220, NULL, 1);
INSERT INTO `t_hot_icon` VALUES (2, '2', '/oss/fusion/default/hand_l.png', NULL, 1, 22, 1, 1, 0, '2024-12-19 11:10:50', '2026-01-22 16:16:20', NULL, NULL, 220, NULL, 1);
INSERT INTO `t_hot_icon` VALUES (3, '2', '/oss/fusion/default/hand_r.png', NULL, 1, 5, 1, 1, 0, '2024-12-19 11:10:50', '2026-01-22 16:16:20', NULL, NULL, 220, NULL, 1);
INSERT INTO `t_hot_icon` VALUES (4, '2', '/oss/fusion/default/zhiwen.png', NULL, 1, 13, 1, 1, 0, '2024-12-19 11:10:50', '2026-01-22 16:16:20', NULL, NULL, 220, NULL, 1);
INSERT INTO `t_hot_icon` VALUES (5, '3', '/oss/fusion/default/xieyin.png', NULL, 1, 2, 1, 1, 0, '2024-12-19 11:10:50', '2026-01-22 16:16:20', NULL, NULL, 220, NULL, 1);
INSERT INTO `t_hot_icon` VALUES (6, '3', '/oss/fusion/default/youzuji.png', NULL, 1, 3, 1, 1, 0, '2024-12-19 11:10:50', '2026-01-22 16:16:20', NULL, NULL, 220, NULL, 1);
INSERT INTO `t_hot_icon` VALUES (7, '3', '/oss/fusion/default/zuozuji.png', NULL, 1, 8, 1, 1, 0, '2024-12-19 11:10:50', '2026-01-22 16:16:20', NULL, NULL, 220, NULL, 1);
INSERT INTO `t_hot_icon` VALUES (8, '4', '/oss/fusion/default/xueji.png', NULL, 1, 5, 1, 1, 0, '2024-12-19 11:10:50', '2026-01-22 16:16:21', NULL, NULL, 220, NULL, 1);
INSERT INTO `t_hot_icon` VALUES (9, '4', '/oss/fusion/default/xuepo.png', NULL, 1, 3, 1, 1, 0, '2024-12-19 11:10:50', '2026-01-22 16:16:21', NULL, NULL, 220, NULL, 1);
INSERT INTO `t_hot_icon` VALUES (10, '5', '/oss/fusion/default/shitiz.png', NULL, 1, 0, 1, 1, 0, '2024-12-19 11:10:50', '2026-01-22 16:16:21', NULL, NULL, 220, NULL, 1);
INSERT INTO `t_hot_icon` VALUES (11, '5', '/oss/fusion/default/shitib.png', NULL, 1, 2, 1, 1, 0, '2024-12-19 11:10:50', '2026-01-22 16:16:21', NULL, NULL, 220, NULL, 1);
INSERT INTO `t_hot_icon` VALUES (12, '5', '/oss/fusion/default/shitifuhao.png', NULL, 1, 0, 1, 1, 0, '2024-12-19 11:10:50', '2026-01-22 16:16:21', NULL, NULL, 220, NULL, 1);
INSERT INTO `t_hot_icon` VALUES (13, '6', '/oss/fusion/default/h_default.png', NULL, 1, 18, 1, 1, 0, '2024-12-19 11:10:50', '2026-01-22 16:16:21', NULL, NULL, 220, NULL, 1);
INSERT INTO `t_hot_icon` VALUES (14, '7', '/oss/fusion/default/h_default.png', NULL, 1, 2, 1, 1, 1, '2024-12-19 11:10:50', '2026-01-22 16:16:21', NULL, NULL, 220, NULL, 1);
INSERT INTO `t_hot_icon` VALUES (18, '8', '/oss/fusion/default/h_default.png', NULL, 1, 137, 1, 1, 1, '2024-12-19 11:10:50', '2026-01-22 16:16:21', NULL, NULL, 220, NULL, 1);
INSERT INTO `t_hot_icon` VALUES (20, '8', '/oss/fusion/default/indicate1.png', NULL, 1, 29, 1, 1, 0, '2024-12-19 11:10:50', '2026-01-22 16:16:21', NULL, NULL, 220, NULL, 1);
INSERT INTO `t_hot_icon` VALUES (21, '8', '/oss/fusion/default/indicate2.png', NULL, 1, 11, 1, 1, 0, '2024-12-19 11:10:50', '2026-01-22 16:16:21', NULL, NULL, 220, NULL, 1);
INSERT INTO `t_hot_icon` VALUES (22, '8', '/oss/fusion/default/indicate3.png', NULL, 1, 15, 1, 1, 0, '2024-12-19 11:10:50', '2026-01-22 16:16:21', NULL, NULL, 220, NULL, 1);
INSERT INTO `t_hot_icon` VALUES (220, '其他', NULL, NULL, 1, 0, 0, 1, 0, '2025-12-02 18:22:05', '2026-01-22 16:12:37', NULL, NULL, NULL, NULL, 1);

-- ----------------------------
-- Table structure for t_map_config
-- ----------------------------
DROP TABLE IF EXISTS `t_map_config`;
CREATE TABLE `t_map_config`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `map_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `coord` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `tb_status` int NULL DEFAULT 0,
  `geocode_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `resp_list_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `resp_location_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `resp_address_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `resp_name_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_map_config
-- ----------------------------
INSERT INTO `t_map_config` VALUES (1, '高德影像地图', '[{\"tempUrl\":\"//wprd04.is.autonavi.com/appmaptile?lang=zh_cn&size=1&scale=1&style=6&x={x}&y={y}&z={z}&layer=6&token=YOUR_API_KEY\",\"maximumLevel\":18},{\"tempUrl\":\"//wprd04.is.autonavi.com/appmaptile?lang=zh_cn&size=1&scale=1&style=8&x={x}&y={y}&z={z}&layer=6&token=YOUR_API_KEY\",\"maximumLevel\":18}]', NULL, '2025-03-28 11:21:01', '2026-01-15 17:21:09', 0, 'https://restapi.amap.com/v3/place/text?keywords={address}&offset=20&page=1&key=32454e2553a8b28db96e1212a47ff8a0&extensions=base', 'pois', 'location', 'address', 'name');
INSERT INTO `t_map_config` VALUES (2, '高德矢量地图', '[{\"tempUrl\":\"//wprd04.is.autonavi.com/appmaptile?lang=zh_cn&size=1&scale=1&style=8&x={x}&y={y}&z={z}&layer=6&token=YOUR_API_KEY\",\"maximumLevel\":18},{\"tempUrl\":\"//wprd04.is.autonavi.com/appmaptile?lang=zh_cn&size=1&scale=1&style=7&x={x}&y={y}&z={z}&layer=6&token=YOUR_API_KEY\",\"maximumLevel\":18}]', NULL, '2025-03-28 11:22:00', '2026-01-15 17:21:12', 0, 'https://restapi.amap.com/v3/place/text?keywords={address}&offset=20&page=1&key=32454e2553a8b28db96e1212a47ff8a0&extensions=base', 'pois', 'location', 'address', 'name');

-- ----------------------------
-- Table structure for t_model
-- ----------------------------
DROP TABLE IF EXISTS `t_model`;
CREATE TABLE `t_model`  (
  `model_id` int NOT NULL AUTO_INCREMENT COMMENT '三维模型id',
  `model_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '三维模型标题',
  `model_date_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '三维模型数据类型',
  `model_size` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '大小',
  `model_obj_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `model_glb_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `type` int NULL DEFAULT 3 COMMENT '0看看，1看见，2深时，3用户上传三维模型，4深时点云',
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `create_status` int NULL DEFAULT 0 COMMENT '0初始化，创建中，1创建成功 ,-1上传失败，-2已取消',
  `num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '场景码',
  `model_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模型类型\'glb\'|\'pointcloud\',类型 点云还是模型,',
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `dept_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门ID',
  `file_new_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `render_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'base',
  `wgs84` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `gcj02` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `convert_type` int NULL DEFAULT 1,
  `coordinate_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `is_obj` int NULL DEFAULT NULL,
  `upload_id` int NULL DEFAULT NULL,
  PRIMARY KEY (`model_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12423 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_model
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_dept_share
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_dept_share`;
CREATE TABLE `t_scene_dept_share`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `is_obj` int NULL DEFAULT NULL,
  `dept_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `is_auth` int NULL DEFAULT 0,
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `case_id` int NULL DEFAULT NULL,
  `share_auth` int NULL DEFAULT NULL COMMENT '0仅登录用户访问，1设置分享链接',
  `share_auth_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `fusion_id` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 281 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_dept_share
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_down_log
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_down_log`;
CREATE TABLE `t_scene_down_log`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '下载场景记录表',
  `scene_num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '场景码',
  `scene_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '场景标题',
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户账号',
  `nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户昵称',
  `sn_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '场景相机sn',
  `dept_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '组织名称',
  `dept_level` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '组织类型',
  `dept_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '组织id',
  `status` int NULL DEFAULT 0 COMMENT '0下载中，1下载完成，2下载失败',
  `version` int NULL DEFAULT NULL COMMENT '场景版本',
  `down_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '下载链接',
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `is_obj` int NULL DEFAULT NULL,
  `down_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'scene',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 357 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_down_log
-- ----------------------------

-- ----------------------------
-- Table structure for t_system_setting
-- ----------------------------
DROP TABLE IF EXISTS `t_system_setting`;
CREATE TABLE `t_system_setting`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '系统标题',
  `theme_colour` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `platform_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_system_setting
-- ----------------------------
INSERT INTO `t_system_setting` VALUES (1, '消防火调三维远程勘验平台', 'd8000a', 'fire', 0, '2024-09-29 10:58:47', '2026-01-12 11:44:45');
INSERT INTO `t_system_setting` VALUES (2, '多尺度融合的现场3D数字化重建系统', '0960bd', 'criminal', 0, '2025-01-20 10:51:32', '2025-01-20 10:52:55');
INSERT INTO `t_system_setting` VALUES (3, '消防火调三维远程勘验平台', 'd8000a', 'cjzfire', 0, '2025-04-17 14:24:16', '2025-04-17 16:14:20');
INSERT INTO `t_system_setting` VALUES (4, '消防火调三维远程勘验平台', 'd8000a', 'xmfire', 0, '2025-08-04 10:07:29', '2025-08-04 10:07:37');

-- ----------------------------
-- Table structure for t_upload_file
-- ----------------------------
DROP TABLE IF EXISTS `t_upload_file`;
CREATE TABLE `t_upload_file`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `file_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `file_size` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `file_md5` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_upload_file
-- ----------------------------

-- ----------------------------
-- Table structure for t_xfyun_config
-- ----------------------------
DROP TABLE IF EXISTS `t_xfyun_config`;
CREATE TABLE `t_xfyun_config`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `host_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `appid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `api_secret` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `api_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `df_question` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_xfyun_config
-- ----------------------------

-- ----------------------------
-- Table structure for t_xfyun_image
-- ----------------------------
DROP TABLE IF EXISTS `t_xfyun_image`;
CREATE TABLE `t_xfyun_image`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '场景码',
  `image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图片路径',
  `xfyun_answer` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '讯飞回复',
  `tb_status` int NULL DEFAULT 0,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_xfyun_image
-- ----------------------------

-- ----------------------------
-- Table structure for tm_attachment
-- ----------------------------
DROP TABLE IF EXISTS `tm_attachment`;
CREATE TABLE `tm_attachment`  (
  `id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '唯一ID',
  `file_name` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '附件名称',
  `attachment_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '附件类型',
  `type` tinyint NULL DEFAULT NULL COMMENT '文件类型:1->照片;2->文件',
  `file_oss_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '附件的oss路径',
  `dept_id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '附件所属的部门ID',
  `creator_id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '附件上传人ID',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '最新更新时间',
  `is_delete` tinyint NULL DEFAULT NULL COMMENT '是否删除: 0->未删除;1->已删除',
  `project_id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '附件所属的火调项目ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tm_attachment
-- ----------------------------

-- ----------------------------
-- Table structure for tm_camera
-- ----------------------------
DROP TABLE IF EXISTS `tm_camera`;
CREATE TABLE `tm_camera`  (
  `id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '唯一ID',
  `camera_sn` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '相机编码',
  `is_delete` tinyint NULL DEFAULT 0 COMMENT '是否被删除:0->未被删除;1->已被删除',
  `dept_id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属用户的部门id',
  `user_id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属用户的id',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最新更新时间',
  `fd_camera_id` bigint NULL DEFAULT NULL COMMENT '四维看看相机ID',
  `creator_id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建者ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '相机关联关系表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tm_camera
-- ----------------------------

-- ----------------------------
-- Table structure for tm_department
-- ----------------------------
DROP TABLE IF EXISTS `tm_department`;
CREATE TABLE `tm_department`  (
  `id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `parent_id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '父类id',
  `ancestors` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '祖级列表',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `is_delete` tinyint NULL DEFAULT 0 COMMENT '是否删除：0: 未删除，1: 已删除',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `dept_type` int NULL DEFAULT NULL COMMENT '组织类型 1总队，2支队，3大队',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门名称',
  `level` tinyint NULL DEFAULT NULL COMMENT '排序',
  `leader` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '负责人',
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系电话',
  `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注',
  `creator_id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tm_department
-- ----------------------------
INSERT INTO `tm_department` VALUES ('0', NULL, NULL, '2023-08-02 17:12:29', 0, '2024-01-15 10:01:03', 0, '超管组织', 0, NULL, NULL, '超管组织', NULL);
INSERT INTO `tm_department` VALUES ('1', '0', '0', '2024-09-27 19:13:57', 0, '2024-09-27 15:25:36', 0, '火调队伍', 1, 'L1', NULL, '备注', NULL);
INSERT INTO `tm_department` VALUES ('2', '0', '0', '2021-04-06 19:13:57', 0, '2024-01-27 18:43:32', 0, '刑侦队伍', 1, 'L2', NULL, '备注', NULL);

-- ----------------------------
-- Table structure for tm_message
-- ----------------------------
DROP TABLE IF EXISTS `tm_message`;
CREATE TABLE `tm_message`  (
  `id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '唯一ID',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '留言内容',
  `project_id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '留言所属的火调项目ID',
  `user_id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '留言用户ID',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最新更新时间',
  `is_delete` tinyint NULL DEFAULT 0 COMMENT '是否删除：0->未删除;1->已删除',
  `creator_id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建者ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '留言信息表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tm_message
-- ----------------------------

-- ----------------------------
-- Table structure for tm_permission
-- ----------------------------
DROP TABLE IF EXISTS `tm_permission`;
CREATE TABLE `tm_permission`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `perms` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '权限标识',
  `module` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模块',
  `reamrk` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `is_delete` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '记录的状态，0: 生效，1: 禁用',
  `creator_id` varchar(28) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者ID',
  `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '路由',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 110 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tm_permission
-- ----------------------------
INSERT INTO `tm_permission` VALUES (1, 'dept:view', 'dept', '查看', '2021-08-26 16:12:47', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (2, 'dept:add', 'dept', '新增', '2021-10-25 17:15:36', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (3, 'dept:edit', 'dept', '编辑', '2021-10-25 17:37:09', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (4, 'dept:del', 'dept', '删除', '2021-10-26 09:28:43', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (5, 'camera:view', 'camera', '查看', '2021-10-26 09:50:48', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (9, 'dispatch:view', 'dispatch', '查看', '2021-10-27 09:06:39', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (10, 'dispatch:add', 'dispatch', '新增', '2021-10-27 12:08:37', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (11, 'dispatch:edit', 'dispatch', '火调项目编辑', '2023-09-06 18:01:32', '2023-09-06 18:01:32', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (12, 'dispatch:del', 'dispatch', '删除', '2021-10-27 12:08:37', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (13, 'teaching:view', 'teaching', '查看项目', '2021-10-27 12:08:37', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (14, 'teaching:scene', 'teaching', '查看场景', '2021-10-27 12:08:37', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (15, 'teaching:message', 'teaching', '留言管理', '2021-10-27 12:08:37', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (16, 'teaching:cancel', 'teaching', '撤销教学', '2021-10-27 12:08:37', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (17, 'user:view', 'user', '查看', '2021-10-27 12:08:37', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (18, 'user:add', 'user', '新增', '2021-10-27 12:08:37', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (19, 'user:edit', 'user', '修改', '2021-10-27 12:08:37', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (20, 'user:del', 'user', '删除', '2021-10-27 12:08:37', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (21, 'scene:view', 'scene', '查看', '2021-10-27 12:08:37', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (22, 'scene:sync', 'scene', '同步', '2021-10-27 12:08:37', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (23, 'scene:edit', 'scene', '修改', '2021-10-27 12:08:37', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (24, 'scene:del', 'scene', '删除', '2021-10-27 12:08:37', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (25, 'dispatch:readFile', 'dispatch', '查看档案', '2021-10-28 15:55:39', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (26, 'dispatch:fileUpload', 'dispatch', '上传附件', '2021-10-28 15:55:39', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (27, 'dispatch:teach', 'dispatch', '设置教学', '2021-10-28 15:55:39', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (28, 'dispatch:share', 'dispatch', '分享', '2021-10-28 15:55:39', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (29, 'teaching:readFile', 'teaching', '查看档案', '2021-10-28 15:55:39', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (30, 'user:disabled', 'user', '启用/禁用', '2021-10-27 12:08:37', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (31, 'user:editPassWord', 'user', '修改密码', '2021-10-27 12:08:37', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (32, 'camera:unbind', 'camera', '解绑', '2021-10-28 16:49:27', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (33, 'camera:bind', 'camera', '绑定', '2021-10-28 16:49:27', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (35, 'otherDept:view', 'otherDept', '其他查询部门权限', '2023-09-06 17:58:56', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (36, 'dispatch:look', 'dispatch', '带看', '2023-09-06 17:58:56', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (37, 'otherCamera:view', 'otherCamera', '场景同步查询用户相机', '2023-09-06 17:58:56', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (38, 'example:view', 'example', '查看', '2021-10-27 09:06:39', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (39, 'example:add', 'example', '新增', '2021-10-27 12:08:37', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (40, 'example:edit', 'example', '编辑', '2021-10-27 12:08:37', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (41, 'example:del', 'example', '删除', '2021-10-27 12:08:37', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (42, 'teaching:message:look', 'teaching', '留言查看', '2023-09-06 15:54:51', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (43, 'teaching:message:add', 'teaching', '添加留言', '2023-09-06 17:58:56', NULL, '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (44, 'dispatch:edit:info', 'dispatch', '火调信息', '2023-09-06 18:02:12', '2023-09-06 18:02:12', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (45, 'dispatch:edit:scene', 'dispatch', '场景管理', '2023-09-06 18:02:17', '2023-09-06 18:02:17', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (46, 'dispatch:edit:fuse', 'dispatch', '多元融合', '2023-09-06 18:02:33', '2023-09-06 18:02:33', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (47, 'dispatch:edit:view', 'dispatch', '视图提取', '2023-09-06 18:02:43', '2023-09-06 18:02:43', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (48, 'dispatch:edit:record', 'dispatch', '屏幕录制', '2023-09-06 18:02:54', '2023-09-06 18:02:54', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (49, 'dispatch:edit:file', 'dispatch', '卷宗管理', '2023-09-06 18:03:04', '2023-09-06 18:03:04', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (50, 'dispatch:edit:sync', 'dispatch', '带看', '2023-09-06 18:03:07', '2023-09-06 18:03:07', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (51, 'dispatch:edit:share', 'dispatch', '分享', '2023-09-06 18:03:11', '2023-09-06 18:03:11', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (52, 'example:edit:info', 'example', '火调信息', '2023-09-06 18:03:44', '2023-09-06 18:03:44', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (53, 'example:edit:scene', 'example', '场景管理', '2023-09-06 18:03:44', '2023-09-06 18:03:44', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (54, 'example:edit:fuse', 'example', '多元融合', '2023-09-06 18:03:44', '2023-09-06 18:03:44', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (55, 'example:edit:view', 'example', '视图提取', '2023-09-06 18:03:44', '2023-09-06 18:03:44', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (56, 'example:edit:record', 'example', '屏幕录制', '2023-09-06 18:03:44', '2023-09-06 18:03:44', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (57, 'example:edit:file', 'example', '卷宗管理', '2023-09-06 18:03:44', '2023-09-06 18:03:44', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (58, 'example:edit:sync', 'example', '带看', '2023-09-06 18:03:44', '2023-09-06 18:03:44', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (59, 'example:edit:share', 'example', '分享', '2023-09-06 18:03:44', '2023-09-06 18:03:44', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (61, 'camera:edit', 'camera', '相机编辑', '2023-09-07 10:36:43', '2023-09-07 10:36:43', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (62, 'camera:unbind', 'camera', '相机解绑', '2023-09-07 10:36:43', '2023-09-07 10:36:43', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (63, 'camera:bind', 'camera', '相机绑定', '2023-09-07 10:36:43', '2023-09-07 10:36:43', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (64, 'example:edit', 'example', '案例编辑', '2023-09-07 10:58:10', '2023-09-07 10:58:10', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (65, 'example:view', 'example', '案例查看', '2023-09-07 10:58:15', '2023-09-07 10:58:15', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (66, 'example:del', 'example', '案例删除', '2023-09-07 10:58:20', '2023-09-07 10:58:20', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (67, 'example:add', 'example', '案例添加', '2023-09-13 14:23:57', '2023-09-13 14:23:57', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (68, 'dyManager:gen', 'scene', '点云生成mesh', '2026-01-07 12:11:55', '2026-01-07 12:11:55', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (69, 'scene:download', 'scene', '下载场景', '2024-01-15 09:39:43', '2024-01-15 09:39:43', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (70, 'downloadLog:query', 'downloadLog', '下载记录列表', '2024-01-15 09:43:43', '2024-01-15 09:43:43', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (71, 'statistics:query', 'statistics', '统计首页', '2024-01-15 10:29:15', '2024-01-15 10:29:15', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (80, 'caseRecovery:view', 'caseRecovery', '案件回收', '2024-07-26 20:19:07', '2024-07-26 20:19:07', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (81, 'caseRecovery:retruen', 'caseRecovery', '案件回收', '2024-07-26 20:19:57', '2024-07-26 20:19:57', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (82, 'caseRecovery:del', 'caseRecovery', '案件回收', '2024-07-26 20:20:02', '2024-07-26 20:20:02', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (83, 'system:view', 'system', '系统设置', '2024-07-26 20:22:55', '2024-07-26 20:22:55', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (84, 'system:update', 'system', '系统设置', '2024-07-26 20:23:09', '2024-07-26 20:23:09', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (85, 'dispatch:edit:download', 'dispatch', '案件下载', '2025-02-06 14:46:55', '2025-02-06 14:46:55', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (86, 'example:edit:download', 'example', '案件下载', '2025-02-06 17:17:26', '2025-02-06 17:17:26', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (88, 'mediaLibrary:view', 'mediaLibrary', '媒体库', '2025-05-08 16:30:51', '2025-05-08 16:30:51', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (89, 'mediaLibrary:group', 'mediaLibrary', '媒体库', '2025-05-08 16:30:51', '2025-05-08 16:30:51', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (90, 'mediaLibrary:upload', 'mediaLibrary', '媒体库', '2025-05-08 16:30:51', '2025-05-08 16:30:51', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (91, 'meshManager:view', 'meshManager', 'mesh场景', '2025-11-28 16:12:48', '2025-11-28 16:12:48', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (92, 'dyManager:view', 'dyManager', '点云场景', '2025-11-28 16:12:54', '2025-11-28 16:12:54', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (93, 'mix3dManager:view', 'mix3dManager', '多元融合', '2025-11-28 16:12:55', '2025-11-28 16:12:55', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (94, 'meshManager:edit', 'meshManager', 'mesh场景', '2025-11-28 16:13:24', '2025-11-28 16:13:24', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (95, 'dyManager:edit', 'dyManager', '点云场景', '2025-11-28 16:13:26', '2025-11-28 16:13:26', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (96, 'mix3dManager:edit', 'mix3dManager', '多元融合', '2025-11-28 16:13:29', '2025-11-28 16:13:29', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (97, 'meshManager:del', 'meshManager', 'mesh场景', '2025-11-28 16:13:24', '2025-11-28 16:13:24', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (98, 'dyManager:del', 'dyManager', '点云场景', '2025-11-28 16:13:26', '2025-11-28 16:13:26', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (99, 'mix3dManager:del', 'mix3dManager', '多元融合', '2025-11-28 16:13:29', '2025-11-28 16:13:29', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (100, 'example:copy', 'example', '案件复制', '2026-01-06 16:54:35', '2026-01-06 16:54:35', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (101, 'meshManager:hash', 'meshManager', 'mesh场景hash', '2026-01-06 16:58:33', '2026-01-06 16:58:33', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (102, 'dyManager:hash', 'dyManager', '点云场景hash', '2026-01-06 16:58:40', '2026-01-06 16:58:40', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (103, 'mix3dManager:hash', 'mix3dManager', '多元融合hash', '2026-01-06 16:58:41', '2026-01-06 16:58:41', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (104, 'meshManager:copy', 'meshManager', 'mesh场景复制', '2026-01-06 16:58:25', '2026-01-06 16:58:25', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (105, 'dyManager:copy', 'dyManager', '点云场景复制', '2026-01-06 16:58:26', '2026-01-06 16:58:26', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (106, 'mix3dManager:copy', 'mix3dManager', '多元融合复制', '2026-01-06 16:58:27', '2026-01-06 16:58:27', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (107, 'meshManager:down', 'meshManager', 'mesh场景下载', '2026-01-06 16:58:18', '2026-01-06 16:58:18', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (108, 'dyManager:down', 'dyManager', '点云场景下载', '2026-01-06 16:58:19', '2026-01-06 16:58:19', '0', NULL, NULL);
INSERT INTO `tm_permission` VALUES (109, 'mix3dManager:down', 'mix3dManager', '多元融合下载', '2026-01-06 16:58:20', '2026-01-06 16:58:20', '0', NULL, NULL);

-- ----------------------------
-- Table structure for tm_project
-- ----------------------------
DROP TABLE IF EXISTS `tm_project`;
CREATE TABLE `tm_project`  (
  `id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '唯一ID',
  `project_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目编号',
  `project_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '起火对象名称',
  `project_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '起火对象地址',
  `project_site` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '起火场所',
  `project_site_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '起火场所层级编码',
  `dept_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '承办单位ID',
  `organizer_dept_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '承办单位名称',
  `organizer_users` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '承办人员',
  `accident_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '事故日期',
  `fire_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '事故原因',
  `scene_num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '场景码',
  `is_teached` tinyint NULL DEFAULT 0 COMMENT '是否是教学项目: 0->不是;1->是',
  `creator_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建者ID',
  `creator_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建者名称',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `editor_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '编辑者ID',
  `editor_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建者名称',
  `edit_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '编辑时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最新更新时间',
  `is_delete` tinyint NULL DEFAULT 0 COMMENT '是否删除: 0->未删除;1->已删除',
  `status` tinyint NULL DEFAULT 0 COMMENT '状态: 0->未认定;1已认定',
  `creator_dept_id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建者部门ID',
  `vr_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '场景链接',
  `case_new_name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `latlng` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `map_show` int NULL DEFAULT 0,
  `field1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `field2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `field3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `field4` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `field5` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `field6` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `field7` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `field8` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `field9` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `field10` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '火调项目信息表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tm_project
-- ----------------------------

-- ----------------------------
-- Table structure for tm_role
-- ----------------------------
DROP TABLE IF EXISTS `tm_role`;
CREATE TABLE `tm_role`  (
  `id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'id',
  `role_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '角色描述',
  `role_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '角色名',
  `role_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '角色key',
  `sort` int NULL DEFAULT NULL COMMENT '排序',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `is_delete` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '记录的状态，0: 生效，1: 禁用',
  `dataScope` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '数据范围（1：所有数据权限；2：自定义数据权限；3：本部门数据权限；4：本部门及以下数据权限；5：仅本人数据权限',
  `creator_id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建者ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tm_role
-- ----------------------------
INSERT INTO `tm_role` VALUES ('1', '超级管理员', '超级管理员', 'admin-super', 1, NULL, NULL, '0', '1', '1');
INSERT INTO `tm_role` VALUES ('2', '平台运营管理员', '平台运营管理员', 'admin', 2, '2021-04-07 12:12:37', '2021-04-07 12:12:40', '0', '1', 'USER00011379381288039055360');
INSERT INTO `tm_role` VALUES ('3', '组织总管理员', '组织总管理员', 'admin-dept', 3, '2021-04-12 14:49:41', '2021-04-12 14:49:44', '0', NULL, 'USER00011379381288039055360');
INSERT INTO `tm_role` VALUES ('4', '普通管理员', '普通管理员', 'admin-ordinary', 4, '2021-04-12 14:50:25', '2021-04-12 14:50:28', '0', NULL, 'USER00011379381288039055360');

-- ----------------------------
-- Table structure for tm_role_permission
-- ----------------------------
DROP TABLE IF EXISTS `tm_role_permission`;
CREATE TABLE `tm_role_permission`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `role_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `permission_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `is_delete` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '记录的状态，0: 生效，1: 禁用',
  `dataScope` int NULL DEFAULT NULL COMMENT '数据范围（1：所有数据权限；2：自定义数据权限；3：本部门数据权限；4：本部门及以下数据权限；5：仅本人数据权限',
  `creator_id` varchar(28) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2813 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tm_role_permission
-- ----------------------------
INSERT INTO `tm_role_permission` VALUES (1, '2', '1', '2021-10-27 17:40:21', NULL, '0', 1, NULL);
INSERT INTO `tm_role_permission` VALUES (2, '2', '2', '2021-10-27 17:40:21', NULL, '0', 1, NULL);
INSERT INTO `tm_role_permission` VALUES (3, '2', '3', '2021-10-27 17:40:21', NULL, '0', 1, NULL);
INSERT INTO `tm_role_permission` VALUES (4, '2', '4', '2021-10-27 17:40:21', NULL, '0', 1, NULL);
INSERT INTO `tm_role_permission` VALUES (5, '2', '5', '2021-10-28 15:10:14', NULL, '0', 1, NULL);
INSERT INTO `tm_role_permission` VALUES (9, '2', '9', '2021-10-28 15:10:14', NULL, '0', 1, NULL);
INSERT INTO `tm_role_permission` VALUES (13, '2', '13', '2021-10-28 15:10:14', NULL, '0', 1, NULL);
INSERT INTO `tm_role_permission` VALUES (17, '2', '17', '2021-10-28 15:10:14', NULL, '0', 1, NULL);
INSERT INTO `tm_role_permission` VALUES (25, '3', '1', '2021-10-28 15:10:14', NULL, '0', 4, NULL);
INSERT INTO `tm_role_permission` VALUES (29, '3', '5', '2021-10-28 15:10:14', NULL, '0', 3, NULL);
INSERT INTO `tm_role_permission` VALUES (33, '3', '9', '2021-10-28 15:10:14', NULL, '0', 3, NULL);
INSERT INTO `tm_role_permission` VALUES (34, '3', '10', '2021-10-28 15:10:14', NULL, '0', 3, NULL);
INSERT INTO `tm_role_permission` VALUES (35, '3', '11', '2021-10-28 15:10:14', NULL, '0', 3, NULL);
INSERT INTO `tm_role_permission` VALUES (36, '3', '12', '2021-10-28 15:10:14', NULL, '0', 3, NULL);
INSERT INTO `tm_role_permission` VALUES (37, '3', '13', '2021-10-28 15:10:14', NULL, '0', 4, NULL);
INSERT INTO `tm_role_permission` VALUES (38, '3', '14', '2021-10-28 15:10:14', NULL, '0', 4, NULL);
INSERT INTO `tm_role_permission` VALUES (39, '3', '15', '2021-10-28 15:10:14', NULL, '0', 4, NULL);
INSERT INTO `tm_role_permission` VALUES (40, '3', '16', '2021-10-28 15:10:14', NULL, '0', 4, NULL);
INSERT INTO `tm_role_permission` VALUES (41, '3', '17', '2021-10-28 15:10:14', NULL, '0', 3, NULL);
INSERT INTO `tm_role_permission` VALUES (42, '3', '18', '2021-10-28 15:10:14', NULL, '0', 3, NULL);
INSERT INTO `tm_role_permission` VALUES (43, '3', '19', '2021-10-28 15:10:14', NULL, '0', 3, NULL);
INSERT INTO `tm_role_permission` VALUES (45, '3', '21', '2021-10-28 15:10:14', NULL, '0', 3, NULL);
INSERT INTO `tm_role_permission` VALUES (46, '3', '22', '2021-10-28 15:10:14', NULL, '0', 3, NULL);
INSERT INTO `tm_role_permission` VALUES (47, '3', '23', '2021-10-28 15:10:14', NULL, '0', 3, NULL);
INSERT INTO `tm_role_permission` VALUES (49, '4', '5', '2021-10-28 15:10:14', NULL, '0', 3, NULL);
INSERT INTO `tm_role_permission` VALUES (50, '4', '9', '2021-10-28 15:10:14', NULL, '0', 3, NULL);
INSERT INTO `tm_role_permission` VALUES (51, '4', '10', '2021-10-28 15:10:14', NULL, '0', 5, NULL);
INSERT INTO `tm_role_permission` VALUES (52, '4', '11', '2021-10-28 15:10:14', NULL, '0', 5, NULL);
INSERT INTO `tm_role_permission` VALUES (53, '4', '12', '2021-10-28 15:10:14', NULL, '0', 5, NULL);
INSERT INTO `tm_role_permission` VALUES (54, '4', '13', '2021-10-28 15:10:14', NULL, '0', 4, NULL);
INSERT INTO `tm_role_permission` VALUES (55, '4', '14', '2021-10-28 15:10:14', NULL, '0', 4, NULL);
INSERT INTO `tm_role_permission` VALUES (56, '4', '15', '2021-10-28 15:10:14', NULL, '0', 4, NULL);
INSERT INTO `tm_role_permission` VALUES (58, '4', '21', '2021-10-28 15:10:14', NULL, '0', 3, NULL);
INSERT INTO `tm_role_permission` VALUES (59, '4', '22', '2021-10-28 15:10:14', NULL, '0', 5, NULL);
INSERT INTO `tm_role_permission` VALUES (60, '4', '23', '2021-10-28 15:10:14', NULL, '0', 5, NULL);
INSERT INTO `tm_role_permission` VALUES (61, '4', '24', '2021-10-28 15:10:14', NULL, '0', 5, NULL);
INSERT INTO `tm_role_permission` VALUES (63, '2', '31', '2021-10-28 15:10:14', NULL, '0', 1, NULL);
INSERT INTO `tm_role_permission` VALUES (64, '3', '33', '2021-10-28 15:10:14', NULL, '0', 3, NULL);
INSERT INTO `tm_role_permission` VALUES (65, '3', '32', '2021-10-28 15:10:14', NULL, '0', 3, NULL);
INSERT INTO `tm_role_permission` VALUES (66, '3', '25', '2021-10-28 15:10:14', NULL, '0', 3, NULL);
INSERT INTO `tm_role_permission` VALUES (67, '3', '26', '2021-10-28 15:10:14', NULL, '0', 3, NULL);
INSERT INTO `tm_role_permission` VALUES (68, '3', '27', '2021-10-28 15:10:14', NULL, '0', 3, NULL);
INSERT INTO `tm_role_permission` VALUES (69, '3', '28', '2021-10-28 15:10:14', NULL, '0', 3, NULL);
INSERT INTO `tm_role_permission` VALUES (70, '4', '25', '2021-10-28 15:10:14', NULL, '0', 3, NULL);
INSERT INTO `tm_role_permission` VALUES (71, '4', '26', '2021-10-28 15:10:14', NULL, '0', 5, NULL);
INSERT INTO `tm_role_permission` VALUES (72, '4', '28', '2021-10-28 15:10:14', NULL, '0', 5, NULL);
INSERT INTO `tm_role_permission` VALUES (73, '3', '29', '2021-10-28 15:10:14', NULL, '0', 3, NULL);
INSERT INTO `tm_role_permission` VALUES (74, '4', '29', '2021-10-28 15:10:14', NULL, '0', 3, NULL);
INSERT INTO `tm_role_permission` VALUES (75, '3', '30', '2021-10-28 15:10:14', NULL, '0', 3, NULL);
INSERT INTO `tm_role_permission` VALUES (77, '3', '31', '2021-10-28 15:10:14', NULL, '0', 5, NULL);
INSERT INTO `tm_role_permission` VALUES (78, '4', '31', '2021-10-28 15:10:14', NULL, '0', 5, NULL);
INSERT INTO `tm_role_permission` VALUES (82, '4', '1', '2021-11-03 15:55:50', NULL, '0', 3, NULL);
INSERT INTO `tm_role_permission` VALUES (83, '2', '25', '2021-11-03 15:55:50', NULL, '0', 1, NULL);
INSERT INTO `tm_role_permission` VALUES (84, '2', '14', '2021-11-03 15:55:50', NULL, '0', 1, NULL);
INSERT INTO `tm_role_permission` VALUES (85, '2', '29', '2021-11-03 15:55:50', NULL, '0', 1, NULL);
INSERT INTO `tm_role_permission` VALUES (86, '3', '24', '2021-11-04 10:08:39', NULL, '0', 1, NULL);
INSERT INTO `tm_role_permission` VALUES (87, '3', '35', '2021-11-04 14:26:52', NULL, '0', 3, NULL);
INSERT INTO `tm_role_permission` VALUES (88, '4', '35', '2021-11-04 14:26:52', NULL, '0', 3, NULL);
INSERT INTO `tm_role_permission` VALUES (89, '2', '35', '2021-11-04 14:26:52', NULL, '0', 1, NULL);
INSERT INTO `tm_role_permission` VALUES (91, '3', '36', '2021-11-04 14:34:33', NULL, '0', 3, NULL);
INSERT INTO `tm_role_permission` VALUES (92, '4', '36', '2021-11-04 14:34:33', NULL, '0', 3, NULL);
INSERT INTO `tm_role_permission` VALUES (93, '2', '37', '2021-11-04 14:34:33', NULL, '0', 1, NULL);
INSERT INTO `tm_role_permission` VALUES (94, '3', '37', '2021-11-04 14:34:33', NULL, '0', 5, NULL);
INSERT INTO `tm_role_permission` VALUES (95, '4', '37', '2021-11-04 14:34:33', NULL, '0', 5, NULL);
INSERT INTO `tm_role_permission` VALUES (140, '3', '42', '2023-09-06 15:57:09', NULL, '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (141, '3', '43', '2023-09-06 15:57:19', NULL, '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (142, '4', '42', '2023-09-06 15:57:52', NULL, '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (143, '4', '43', '2023-09-06 15:57:54', NULL, '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (144, '2', '28', '2023-09-06 16:11:33', NULL, '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (145, '2', '21', '2023-09-06 16:40:39', NULL, '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (211, '3', '44', '2023-09-06 18:10:06', '2023-09-06 18:10:06', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (212, '3', '45', '2023-09-06 18:10:06', '2023-09-06 18:10:06', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (213, '3', '46', '2023-09-06 18:10:06', '2023-09-06 18:10:06', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (214, '3', '47', '2023-09-06 18:10:06', '2023-09-06 18:10:06', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (215, '3', '48', '2023-09-06 18:10:06', '2023-09-06 18:10:06', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (216, '3', '49', '2023-09-06 18:10:06', '2023-09-06 18:10:06', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (217, '3', '50', '2023-09-06 18:10:06', '2023-09-06 18:10:06', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (218, '3', '51', '2023-09-06 18:10:06', '2023-09-06 18:10:06', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (219, '3', '52', '2023-09-06 18:10:06', '2023-09-06 18:10:06', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (220, '3', '53', '2023-09-06 18:10:06', '2023-09-06 18:10:06', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (221, '3', '54', '2023-09-06 18:10:06', '2023-09-06 18:10:06', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (222, '3', '55', '2023-09-06 18:10:06', '2023-09-06 18:10:06', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (223, '3', '56', '2023-09-06 18:10:06', '2023-09-06 18:10:06', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (224, '3', '57', '2023-09-06 18:10:06', '2023-09-06 18:10:06', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (225, '3', '58', '2023-09-06 18:10:06', '2023-09-06 18:10:06', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (226, '3', '59', '2023-09-06 18:10:06', '2023-09-06 18:10:06', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (227, '4', '44', '2023-09-06 18:10:48', '2023-09-06 18:10:55', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (228, '4', '45', '2023-09-06 18:10:48', '2023-09-06 18:10:56', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (229, '4', '46', '2023-09-06 18:10:48', '2023-09-06 18:10:56', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (230, '4', '47', '2023-09-06 18:10:48', '2023-09-06 18:10:56', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (231, '4', '48', '2023-09-06 18:10:49', '2023-09-06 18:10:56', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (232, '4', '49', '2023-09-06 18:10:49', '2023-09-06 18:10:56', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (233, '4', '50', '2023-09-06 18:10:49', '2023-09-06 18:10:56', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (234, '4', '51', '2023-09-06 18:10:49', '2023-09-06 18:10:56', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (235, '4', '52', '2023-09-06 18:10:49', '2023-09-06 18:10:56', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (236, '4', '53', '2023-09-06 18:10:49', '2023-09-06 18:10:56', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (237, '4', '54', '2023-09-06 18:10:49', '2023-09-06 18:10:56', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (238, '4', '55', '2023-09-06 18:10:49', '2023-09-06 18:10:56', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (239, '4', '56', '2023-09-06 18:10:49', '2023-09-06 18:10:56', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (240, '4', '57', '2023-09-06 18:10:49', '2023-09-06 18:10:56', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (241, '4', '58', '2023-09-06 18:10:49', '2023-09-06 18:10:56', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (242, '4', '59', '2023-09-06 18:10:49', '2023-09-06 18:10:56', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (306, '3', '61', '2023-09-07 10:37:49', '2023-09-07 10:37:49', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (307, '3', '62', '2023-09-07 10:37:49', '2023-09-07 10:37:49', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (308, '3', '63', '2023-09-07 10:37:49', '2023-09-07 10:37:49', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (309, '4', '27', '2023-09-07 10:44:52', '2023-09-07 10:44:52', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (373, '2', '65', '2023-09-07 11:00:03', '2023-09-07 11:00:03', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (374, '3', '64', '2023-09-07 11:00:33', '2023-09-07 11:00:33', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (375, '3', '65', '2023-09-07 11:00:33', '2023-09-07 11:00:33', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (376, '3', '66', '2023-09-07 11:00:33', '2023-09-07 11:00:33', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (377, '4', '64', '2023-09-07 11:01:01', '2023-09-07 11:01:01', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (378, '4', '65', '2023-09-07 11:01:01', '2023-09-07 11:01:01', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (379, '4', '66', '2023-09-07 11:01:01', '2023-09-07 11:01:01', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (382, '4', '16', '2023-09-08 16:06:55', '2023-09-08 16:06:55', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (383, '3', '20', '2023-09-08 16:07:55', '2023-09-08 16:07:55', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (384, '3', '2', '2023-09-08 16:08:36', '2023-09-08 16:08:36', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (385, '3', '3', '2023-09-08 16:08:36', '2023-09-08 16:08:36', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (386, '3', '4', '2023-09-08 16:08:36', '2023-09-08 16:08:36', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (387, '3', '67', '2023-09-13 14:33:57', '2023-09-13 14:33:57', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (388, '4', '67', '2023-09-13 14:34:11', '2023-09-13 14:34:11', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (579, '3', '68', '2023-10-09 18:19:41', '2023-10-09 18:19:41', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (580, '4', '68', '2023-10-09 18:19:52', '2023-10-09 18:19:52', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (711, '3', '69', '2024-01-15 09:40:47', '2024-01-15 09:40:47', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (712, '4', '69', '2024-01-15 09:40:59', '2024-01-15 09:40:59', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (967, '2', '71', '2024-01-15 10:29:59', '2024-01-15 10:29:59', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (968, '3', '71', '2024-01-15 10:30:34', '2024-01-15 10:30:34', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (969, '4', '71', '2024-01-15 10:30:39', '2024-01-15 10:30:39', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (1860, '3', '85', '2025-02-06 14:47:05', '2025-02-06 14:47:05', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (1861, '4', '85', '2025-02-06 14:47:05', '2025-02-06 14:47:05', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (1990, '3', '86', '2025-02-06 17:09:21', '2025-02-06 17:09:21', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (1991, '4', '86', '2025-02-06 17:09:21', '2025-02-06 17:09:21', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (1992, '2', '80', '2025-02-07 15:08:01', '2025-02-07 15:08:01', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (1993, '3', '80', '2025-02-07 15:08:01', '2025-02-07 15:08:01', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (1994, '4', '80', '2025-02-07 15:08:01', '2025-02-07 15:08:01', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (1995, '2', '81', '2025-02-07 15:08:01', '2025-02-07 15:08:01', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (1996, '3', '81', '2025-02-07 15:08:01', '2025-02-07 15:08:01', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (1997, '4', '81', '2025-02-07 15:08:01', '2025-02-07 15:08:01', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (1998, '2', '82', '2025-02-07 15:08:01', '2025-02-07 15:08:01', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (1999, '3', '82', '2025-02-07 15:08:01', '2025-02-07 15:08:01', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2000, '4', '82', '2025-02-07 15:08:01', '2025-02-07 15:08:01', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2131, '3', '88', '2025-05-08 16:33:18', '2025-05-08 16:33:18', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2132, '3', '89', '2025-05-08 16:33:18', '2025-05-08 16:33:18', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2133, '3', '90', '2025-05-08 16:33:18', '2025-05-08 16:33:18', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2134, '4', '88', '2025-05-08 16:33:26', '2025-05-08 16:33:26', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2135, '4', '89', '2025-05-08 16:33:26', '2025-05-08 16:33:26', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2136, '4', '90', '2025-05-08 16:33:26', '2025-05-08 16:33:26', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2264, '2', '91', '2025-11-26 14:59:52', '2025-11-26 14:59:52', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2265, '2', '92', '2025-11-26 14:59:52', '2025-11-26 14:59:52', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2266, '2', '93', '2025-11-26 14:59:52', '2025-11-26 14:59:52', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2267, '3', '91', '2025-11-26 14:59:52', '2025-11-26 14:59:52', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2268, '3', '92', '2025-11-26 14:59:52', '2025-11-26 14:59:52', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2269, '3', '93', '2025-11-26 14:59:52', '2025-11-26 14:59:52', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2270, '4', '91', '2025-11-26 14:59:52', '2025-11-26 14:59:52', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2271, '4', '92', '2025-11-26 14:59:52', '2025-11-26 14:59:52', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2272, '4', '93', '2025-11-26 14:59:52', '2025-11-26 14:59:52', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2400, '3', '94', '2025-11-28 16:16:26', '2025-11-28 16:16:26', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2401, '3', '95', '2025-11-28 16:16:26', '2025-11-28 16:16:26', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2402, '3', '96', '2025-11-28 16:16:26', '2025-11-28 16:16:26', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2403, '4', '94', '2025-11-28 16:16:26', '2025-11-28 16:16:26', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2404, '4', '95', '2025-11-28 16:16:26', '2025-11-28 16:16:26', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2405, '4', '96', '2025-11-28 16:16:26', '2025-11-28 16:16:26', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2406, '3', '97', '2025-11-28 16:16:26', '2025-11-28 16:16:26', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2407, '3', '98', '2025-11-28 16:16:26', '2025-11-28 16:16:26', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2408, '3', '99', '2025-11-28 16:16:26', '2025-11-28 16:16:26', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2409, '4', '97', '2025-11-28 16:16:26', '2025-11-28 16:16:26', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2410, '4', '98', '2025-11-28 16:16:26', '2025-11-28 16:16:26', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2411, '4', '99', '2025-11-28 16:16:26', '2025-11-28 16:16:26', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2666, '1', '1', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2667, '1', '2', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2668, '1', '3', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2669, '1', '4', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2670, '1', '5', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2671, '1', '9', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2672, '1', '10', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2673, '1', '11', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2674, '1', '12', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2675, '1', '13', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2676, '1', '14', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2677, '1', '15', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2678, '1', '16', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2679, '1', '17', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2680, '1', '18', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2681, '1', '19', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2682, '1', '20', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2683, '1', '21', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2684, '1', '22', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2685, '1', '23', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2686, '1', '24', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2687, '1', '25', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2688, '1', '26', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2689, '1', '27', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2690, '1', '28', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2691, '1', '29', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2692, '1', '30', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2693, '1', '31', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2694, '1', '32', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2695, '1', '33', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2696, '1', '35', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2697, '1', '36', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2698, '1', '37', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2699, '1', '38', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2700, '1', '39', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2701, '1', '40', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2702, '1', '41', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2703, '1', '42', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2704, '1', '43', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2705, '1', '44', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2706, '1', '45', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2707, '1', '46', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2708, '1', '47', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2709, '1', '48', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2710, '1', '49', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2711, '1', '50', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2712, '1', '51', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2713, '1', '52', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2714, '1', '53', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2715, '1', '54', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2716, '1', '55', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2717, '1', '56', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2718, '1', '57', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2719, '1', '58', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2720, '1', '59', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2721, '1', '61', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2722, '1', '62', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2723, '1', '63', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2724, '1', '64', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2725, '1', '65', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2726, '1', '66', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2727, '1', '67', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2728, '1', '68', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2729, '1', '69', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2730, '1', '70', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2731, '1', '71', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2732, '1', '80', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2733, '1', '81', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2734, '1', '82', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2735, '1', '83', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2736, '1', '84', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2737, '1', '85', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2738, '1', '86', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2739, '1', '88', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2740, '1', '89', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2741, '1', '90', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2742, '1', '91', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2743, '1', '92', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2744, '1', '93', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2745, '1', '94', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2746, '1', '95', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2747, '1', '96', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2748, '1', '97', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2749, '1', '98', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2750, '1', '99', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2751, '1', '100', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2752, '1', '101', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2753, '1', '102', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2754, '1', '103', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2755, '1', '104', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2756, '1', '105', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2757, '1', '106', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2758, '1', '107', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2759, '1', '108', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2760, '1', '109', '2026-01-06 17:19:50', '2026-01-06 17:19:50', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2793, '3', '100', '2026-01-06 17:23:32', '2026-01-06 17:23:32', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2794, '3', '101', '2026-01-06 17:23:32', '2026-01-06 17:23:32', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2795, '3', '102', '2026-01-06 17:23:32', '2026-01-06 17:23:32', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2796, '3', '103', '2026-01-06 17:23:32', '2026-01-06 17:23:32', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2797, '3', '104', '2026-01-06 17:23:32', '2026-01-06 17:23:32', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2798, '3', '105', '2026-01-06 17:23:32', '2026-01-06 17:23:32', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2799, '3', '106', '2026-01-06 17:23:32', '2026-01-06 17:23:32', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2800, '3', '107', '2026-01-06 17:23:32', '2026-01-06 17:23:32', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2801, '3', '108', '2026-01-06 17:23:32', '2026-01-06 17:23:32', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2802, '3', '109', '2026-01-06 17:23:32', '2026-01-06 17:23:32', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2803, '4', '100', '2026-01-06 17:24:09', '2026-01-06 17:24:09', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2804, '4', '101', '2026-01-06 17:24:09', '2026-01-06 17:24:09', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2805, '4', '102', '2026-01-06 17:24:09', '2026-01-06 17:24:09', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2806, '4', '104', '2026-01-06 17:24:09', '2026-01-06 17:24:09', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2807, '4', '104', '2026-01-06 17:24:09', '2026-01-06 17:24:09', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2808, '4', '105', '2026-01-06 17:24:09', '2026-01-06 17:24:09', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2809, '4', '106', '2026-01-06 17:24:09', '2026-01-06 17:24:09', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2810, '4', '107', '2026-01-06 17:24:09', '2026-01-06 17:24:09', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2811, '4', '108', '2026-01-06 17:24:09', '2026-01-06 17:24:09', '0', NULL, NULL);
INSERT INTO `tm_role_permission` VALUES (2812, '4', '109', '2026-01-06 17:24:09', '2026-01-06 17:24:09', '0', NULL, NULL);

-- ----------------------------
-- Table structure for tm_scene
-- ----------------------------
DROP TABLE IF EXISTS `tm_scene`;
CREATE TABLE `tm_scene`  (
  `id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '唯一主键',
  `scene_num` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '场景码',
  `dept_id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属部门ID',
  `user_id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属用户的ID',
  `camera_id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属相机ID',
  `is_delete` tinyint NULL DEFAULT NULL COMMENT '是否删除: 0->未删除;1->已删除',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '最新更新时间',
  `video_create_time` date NULL DEFAULT NULL COMMENT '拍摄日期',
  `title` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '场景标题',
  `cover_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '场景封面照片',
  `vr_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '场景浏览链接',
  `creator_id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建者ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '场景关联关系表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tm_scene
-- ----------------------------

-- ----------------------------
-- Table structure for tm_user
-- ----------------------------
DROP TABLE IF EXISTS `tm_user`;
CREATE TABLE `tm_user`  (
  `id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `dept_id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门id',
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像对应的链接地址',
  `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户密码',
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户名',
  `nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '昵称',
  `status` tinyint NOT NULL DEFAULT 1 COMMENT '是否禁用：1->可用;0->禁用',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `is_delete` tinyint(1) NULL DEFAULT 0 COMMENT '是否删除，0: 未删除，1: 已删除',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `creator_id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建者ID',
  `is_admin` tinyint NULL DEFAULT 0 COMMENT '0：否 1：是',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `user_name`(`user_name`(191)) USING BTREE,
  INDEX `nick_name`(`nick_name`(191)) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户信息表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tm_user
-- ----------------------------
INSERT INTO `tm_user` VALUES ('1', '0', NULL, '', '88888888888', '超级管理员', 1, NULL, 0, '2023-08-02 17:18:34', NULL, 1);

-- ----------------------------
-- Table structure for tm_user_role
-- ----------------------------
DROP TABLE IF EXISTS `tm_user_role`;
CREATE TABLE `tm_user_role`  (
  `id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `user_id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户表id',
  `role_id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色表id',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `is_delete` tinyint NULL DEFAULT 0 COMMENT '是否删除，0: 未删除，1: 已经删除',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `creator_id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建者ID',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `role_id`(`role_id`) USING BTREE,
  INDEX `fk_user_id_1`(`user_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户角色关系表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tm_user_role
-- ----------------------------
INSERT INTO `tm_user_role` VALUES ('1', '1', '1', NULL, 0, NULL, '1');

SET FOREIGN_KEY_CHECKS = 1;
