/* 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;