CREATE DATABASE IF NOT EXISTS `fd_fusion_xj` CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_general_ci'; USE `fd_fusion_xj`; SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- 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, PRIMARY KEY (`case_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 412 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- 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 = 18 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- 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, PRIMARY KEY (`files_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 708 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- 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 '附件类型名称', `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 (`files_type_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_case_files_type -- ---------------------------- INSERT INTO `t_case_files_type` VALUES (1, '现场图', 0, '2022-08-02 17:30:54', '2022-08-02 17:31:19'); INSERT INTO `t_case_files_type` VALUES (2, '照片制卷', 0, '2022-08-02 17:31:21', '2022-08-02 17:31:40'); INSERT INTO `t_case_files_type` VALUES (3, '勘验笔录', 0, '2022-08-02 17:31:22', '2022-08-02 17:31:45'); INSERT INTO `t_case_files_type` VALUES (4, '提取清单', 0, '2024-07-04 17:02:40', '2024-07-16 10:13:55'); INSERT INTO `t_case_files_type` VALUES (5, '认定书', 0, '2023-08-09 12:04:59', '2024-07-16 10:13:57'); -- ---------------------------- -- 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` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '融合标题', `case_id` int NULL DEFAULT NULL COMMENT '案件id', `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 = 270 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- 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合并图片', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 486 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- 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, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- 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 = 29 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- 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, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 251 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- 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 = 2670 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- 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 = 25 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- 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 = 30 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- 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', `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, PRIMARY KEY (`settings_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 80 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- 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, `case_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; -- ---------------------------- -- 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, `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, `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 (`tag_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 263 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- 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, PRIMARY KEY (`tag_point_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 749 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- 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 = 514 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- 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 = 313 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- 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 = 505 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- 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', `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, PRIMARY KEY (`fusion_guide_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 233 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- 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 '排序', `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 = 914 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- 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 = 374 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- 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 = 1251 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- 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, PRIMARY KEY (`icon_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 111 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, 84, 1, 1, 0, '2022-08-04 11:06:39', '2024-08-07 10:04:33'); -- ---------------------------- -- 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', PRIMARY KEY (`model_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1440 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- 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, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 172 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- 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, `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 = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_system_setting -- ---------------------------- INSERT INTO `t_system_setting` VALUES (1, '消防火调三维远程勘验平台', 'd8000a', 0, '2024-07-04 15:18:39', '2024-08-05 18:12:09'); INSERT INTO `t_system_setting` VALUES (2, 'fire', 'd8000a', 0, '2024-07-24 14:15:59', '2024-07-24 14:16:11'); INSERT INTO `t_system_setting` VALUES (3, 'fire', 'd8000a', 0, '2024-07-24 14:15:59', '2024-07-24 14:15:59'); -- ---------------------------- -- 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; -- ---------------------------- -- 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', '2021-04-06 19:13:57', 0, '2024-07-24 12:01:09', 0, '火调队伍', 1, 'L1', '186666666666', '备注', '1'); INSERT INTO `tm_department` VALUES ('DEP000011816369371116605440', '1', NULL, '2024-07-25 15:06:19', 0, '2024-07-25 15:06:19', 1, '新疆总队', 3, NULL, NULL, NULL, '1'); INSERT INTO `tm_department` VALUES ('DEP000011816379562193195008', 'DEP000011816369371116605440', NULL, '2024-07-25 15:46:48', 0, '2024-07-25 15:46:48', 2, '新疆支队', 4, NULL, NULL, NULL, '1'); INSERT INTO `tm_department` VALUES ('DEP000011816379897993367552', 'DEP000011816379562193195008', NULL, '2024-07-25 15:48:09', 0, '2024-07-25 15:48:09', 3, '2203', 5, '2203', '18819272203', NULL, '1'); INSERT INTO `tm_department` VALUES ('DEP000011816651482134351872', '1', NULL, '2024-07-26 09:47:19', 1, '2024-07-26 10:06:49', 2, 'qyc组织qyc组织qyc组织qyc组织qyc组织qyc组织qyc组织qyc组织qyc组织qyc组织', 3, 'qycqycqycqycqycqycqycqycqycqyc', '18078590712', '这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条测试数据这是一条', '1'); INSERT INTO `tm_department` VALUES ('DEP000011816746718986637312', 'DEP000011816379562193195008', NULL, '2024-07-26 16:05:45', 1, '2024-07-26 16:07:04', 1, '平台管理员角色创建222', 2, '平台角色测试', '18284848440', NULL, 'USER00011816651601244192768'); INSERT INTO `tm_department` VALUES ('DEP000011816762403976515584', 'DEP000011816379562193195008', NULL, '2024-07-26 17:08:05', 0, '2024-07-26 17:08:05', 2, '1111', 5, NULL, NULL, NULL, '1'); INSERT INTO `tm_department` VALUES ('DEP000011816768911393034240', 'DEP000011816379562193195008', NULL, '2024-07-26 17:33:57', 1, '2024-07-26 17:34:20', 2, 'qyc的组织', 2, 'qyc888', '18078590713', '对对对', 'USER00011816651601244192768'); INSERT INTO `tm_department` VALUES ('DEP000011816769104192606208', 'DEP000011816379562193195008', NULL, '2024-07-26 17:34:43', 1, '2024-07-26 17:37:25', 2, 'qyc的组织', 2, 'qyc888', '18078590713', '多大点事', 'USER00011816651601244192768'); INSERT INTO `tm_department` VALUES ('DEP000011816771490336346112', '0', NULL, '2024-07-26 17:44:11', 1, '2024-07-26 21:27:18', 1, '测试数据', 2, NULL, NULL, NULL, '1'); INSERT INTO `tm_department` VALUES ('DEP000011817753084442316800', 'DEP000011816369371116605440', NULL, '2024-07-29 10:44:42', 0, '2024-07-29 10:44:42', 2, '新疆支队-sq', 2, NULL, NULL, NULL, 'USER00011816369684879900672'); INSERT INTO `tm_department` VALUES ('DEP000011817753163689496576', 'DEP000011817753084442316800', NULL, '2024-07-29 10:45:01', 0, '2024-07-29 10:45:01', 3, '新疆大队-sq', 3, NULL, NULL, NULL, 'USER00011816369684879900672'); INSERT INTO `tm_department` VALUES ('DEP000011817852929949700096', '0', NULL, '2024-07-29 17:21:27', 1, '2024-07-29 17:41:49', 1, '大哈总队', 2, NULL, NULL, NULL, '1'); INSERT INTO `tm_department` VALUES ('DEP000011817858572467179520', '1', NULL, '2024-07-29 17:43:52', 1, '2024-07-29 17:44:14', 1, '总队统计数据', 3, NULL, NULL, NULL, '1'); INSERT INTO `tm_department` VALUES ('DEP000011818902624457330688', '0', NULL, '2024-08-01 14:52:33', 1, '2024-08-01 14:52:39', 1, '222', 2, NULL, NULL, NULL, '1'); INSERT INTO `tm_department` VALUES ('DEP000011818945423747715072', 'DEP000011816369371116605440', NULL, '2024-08-01 17:42:38', 0, '2024-08-06 15:32:20', 2, '某支队', 4, NULL, NULL, NULL, '1'); INSERT INTO `tm_department` VALUES ('DEP000011818989983886610432', 'DEP000011817753084442316800', NULL, '2024-08-01 20:39:42', 0, '2024-08-01 20:39:42', 3, '新疆大队-sq2', 3, NULL, NULL, NULL, 'USER00011816369684879900672'); -- ---------------------------- -- 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; -- ---------------------------- -- 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 utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '权限标识', `module` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '模块', `reamrk` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_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 utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '0' COMMENT '记录的状态，0: 生效，1: 禁用', `creator_id` varchar(28) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '创建者ID', `url` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '路由', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 85 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_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, 'scene:gen', 'scene', '点云生成mesh', '2023-10-09 15:38:57', '2023-10-09 15:38:57', '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 (72, 'cameraVersion:view', 'cameraVersion', '固件', '2024-07-24 12:05:22', '2024-07-24 12:05:22', '0', NULL, NULL); INSERT INTO `tm_permission` VALUES (73, 'cameraVersion:add', 'cameraVersion', '固件', '2024-07-24 12:05:22', '2024-07-24 12:05:22', '0', NULL, NULL); INSERT INTO `tm_permission` VALUES (74, 'cameraVersion:edit', 'cameraVersion', '固件', '2024-07-24 12:05:22', '2024-07-24 12:05:22', '0', NULL, NULL); INSERT INTO `tm_permission` VALUES (75, 'cameraVersion:del', 'cameraVersion', '固件', '2024-07-24 12:05:22', '2024-07-24 12:05:22', '0', NULL, NULL); INSERT INTO `tm_permission` VALUES (76, 'cameraVersionApp:view', 'cameraVersionApp', 'app', '2024-07-24 12:06:30', '2024-07-24 12:06:30', '0', NULL, NULL); INSERT INTO `tm_permission` VALUES (77, 'cameraVersionApp:add', 'cameraVersionApp', 'app', '2024-07-24 12:06:38', '2024-07-24 12:06:38', '0', NULL, NULL); INSERT INTO `tm_permission` VALUES (78, 'cameraVersionApp:edit', 'cameraVersionApp', 'app', '2024-07-24 12:06:40', '2024-07-24 12:06:40', '0', NULL, NULL); INSERT INTO `tm_permission` VALUES (79, 'cameraVersionApp:del', 'cameraVersionApp', 'app', '2024-07-24 12:06:44', '2024-07-24 12:06:44', '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); -- ---------------------------- -- 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; -- ---------------------------- -- 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'); INSERT INTO `tm_role` VALUES ('5', '系统管理员', '系统管理员', 'admin-system', 5, '2024-07-24 11:59:33', '2024-07-24 11:59:36', '0', NULL, '1'); -- ---------------------------- -- 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 utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, `permission_id` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_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 utf8mb3 COLLATE utf8mb3_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 utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '创建者ID', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1382 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_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 (18, '2', '18', '2021-10-28 15:10:14', NULL, '0', 1, NULL); INSERT INTO `tm_role_permission` VALUES (19, '2', '19', '2021-10-28 15:10:14', NULL, '0', 1, NULL); INSERT INTO `tm_role_permission` VALUES (20, '2', '20', '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 (62, '2', '30', '2021-10-28 15:10:14', NULL, '0', 1, 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 (90, '2', '36', '2021-11-04 14:34:33', 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 (209, '2', '51', '2023-09-06 18:08:02', '2023-09-06 18:08:02', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (210, '2', '59', '2023-09-06 18:09:08', '2023-09-06 18:09:08', '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 (380, '2', '11', '2023-09-08 16:04:43', '2023-09-08 16:04:43', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (381, '2', '64', '2023-09-08 16:05:07', '2023-09-08 16:05:07', '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 (581, '2', '58', '2023-11-07 09:43:14', '2023-11-07 09:43:14', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (582, '2', '50', '2023-11-08 10:10:59', '2023-11-08 10:10:59', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (710, '2', '69', '2024-01-15 09:40:29', '2024-01-15 09:40:29', '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 (1097, '5', '70', '2024-07-24 12:19:48', '2024-07-24 12:19:48', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1098, '5', '72', '2024-07-24 12:19:48', '2024-07-24 12:19:48', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1099, '5', '73', '2024-07-24 12:19:48', '2024-07-24 12:19:48', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1100, '5', '74', '2024-07-24 12:19:48', '2024-07-24 12:19:48', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1101, '5', '75', '2024-07-24 12:19:48', '2024-07-24 12:19:48', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1102, '5', '76', '2024-07-24 12:19:48', '2024-07-24 12:19:48', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1103, '5', '77', '2024-07-24 12:19:48', '2024-07-24 12:19:48', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1104, '5', '78', '2024-07-24 12:19:48', '2024-07-24 12:19:48', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1105, '5', '79', '2024-07-24 12:19:48', '2024-07-24 12:19:48', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1233, '5', '83', '2024-07-26 20:24:13', '2024-07-26 20:24:13', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1234, '5', '84', '2024-07-26 20:24:13', '2024-07-26 20:24:13', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1235, '2', '72', '2024-07-26 20:28:39', '2024-07-26 20:28:39', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1236, '2', '73', '2024-07-26 20:28:39', '2024-07-26 20:28:39', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1237, '2', '74', '2024-07-26 20:28:39', '2024-07-26 20:28:39', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1238, '2', '75', '2024-07-26 20:28:39', '2024-07-26 20:28:39', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1239, '2', '76', '2024-07-26 20:28:39', '2024-07-26 20:28:39', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1240, '2', '77', '2024-07-26 20:28:39', '2024-07-26 20:28:39', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1241, '2', '78', '2024-07-26 20:28:39', '2024-07-26 20:28:39', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1242, '2', '79', '2024-07-26 20:28:39', '2024-07-26 20:28:39', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1243, '2', '80', '2024-07-26 20:28:39', '2024-07-26 20:28:39', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1246, '2', '83', '2024-07-26 20:28:39', '2024-07-26 20:28:39', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1247, '2', '84', '2024-07-26 20:28:39', '2024-07-26 20:28:39', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1248, '3', '80', '2024-07-26 20:29:14', '2024-07-26 20:29:14', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1249, '3', '81', '2024-07-26 20:29:14', '2024-07-26 20:29:14', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1250, '3', '82', '2024-07-26 20:29:14', '2024-07-26 20:29:14', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1251, '4', '80', '2024-07-26 20:29:20', '2024-07-26 20:29:20', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1252, '4', '81', '2024-07-26 20:29:20', '2024-07-26 20:29:20', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1253, '4', '82', '2024-07-26 20:29:20', '2024-07-26 20:29:20', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1254, '2', '70', '2024-07-29 12:29:21', '2024-07-29 12:29:21', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1255, '1', '1', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1256, '1', '2', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1257, '1', '3', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1258, '1', '4', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1259, '1', '5', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1260, '1', '9', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1261, '1', '10', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1262, '1', '11', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1263, '1', '12', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1264, '1', '13', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1265, '1', '14', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1266, '1', '15', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1267, '1', '16', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1268, '1', '17', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1269, '1', '18', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1270, '1', '19', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1271, '1', '20', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1272, '1', '21', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1273, '1', '22', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1274, '1', '23', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1275, '1', '24', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1276, '1', '25', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1277, '1', '26', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1278, '1', '27', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1279, '1', '28', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1280, '1', '29', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1281, '1', '30', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1282, '1', '31', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1283, '1', '32', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1284, '1', '33', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1285, '1', '35', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1286, '1', '36', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1287, '1', '37', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1288, '1', '38', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1289, '1', '39', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1290, '1', '40', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1291, '1', '41', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1292, '1', '42', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1293, '1', '43', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1294, '1', '44', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1295, '1', '45', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1296, '1', '46', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1297, '1', '47', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1298, '1', '48', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1299, '1', '49', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1300, '1', '50', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1301, '1', '51', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1302, '1', '52', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1303, '1', '53', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1304, '1', '54', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1305, '1', '55', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1306, '1', '56', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1307, '1', '57', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1308, '1', '58', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1309, '1', '59', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1310, '1', '61', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1311, '1', '62', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1312, '1', '63', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1313, '1', '64', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1314, '1', '65', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1315, '1', '66', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1316, '1', '67', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1317, '1', '68', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1318, '1', '69', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1319, '1', '70', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1320, '1', '71', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1321, '1', '72', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1322, '1', '73', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1323, '1', '74', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1324, '1', '75', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1325, '1', '76', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1326, '1', '77', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1327, '1', '78', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1328, '1', '79', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1329, '1', '80', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1330, '1', '81', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1331, '1', '82', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1332, '1', '83', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '0', NULL, NULL); INSERT INTO `tm_role_permission` VALUES (1333, '1', '84', '2024-08-01 16:45:17', '2024-08-01 16:45:17', '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); INSERT INTO `tm_user` VALUES ('USER00011816369684879900672', 'DEP000011816369371116605440', NULL, '', '13866666666', '平台管理员', 1, '2024-07-25 15:07:34', 0, '2024-07-25 15:08:16', '1', 0); INSERT INTO `tm_user` VALUES ('USER00011816369814265790464', 'DEP000011816369371116605440', NULL, '', '13888888888', '系统管理员', 1, '2024-07-25 15:08:04', 0, '2024-07-25 15:08:04', '1', 0); -- ---------------------------- -- 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'); INSERT INTO `tm_user_role` VALUES ('USERROLE1816369814760718336', 'USER00011816369814265790464', '5', '2024-07-25 15:08:05', 0, '2024-07-25 15:08:05', NULL); INSERT INTO `tm_user_role` VALUES ('USERROLE1816369862579978240', 'USER00011816369684879900672', '2', '2024-07-25 15:08:16', 0, '2024-07-25 15:08:16', NULL); SET FOREIGN_KEY_CHECKS = 1;