-- CREATE DATABASE IF NOT EXISTS fd_fusion CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; -- use fd_fusion; -- 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, `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是', PRIMARY KEY (`case_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 600 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 = 3 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, `create_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'upload' COMMENT '创建类型', PRIMARY KEY (`files_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1181 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 '附件类型名称', `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, PRIMARY KEY (`files_type_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 63 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- 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 = 275 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 = 81 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 = 7 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 = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- 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 = 49 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- 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 = 10 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, `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 241 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 = 3657 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 = 41 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- 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, `path` 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 = 194 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 = 1 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 = 76 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 = 1 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, `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 = 401 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, `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` int 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, PRIMARY KEY (`tag_point_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1210 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 = 513 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 = 304 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 = 538 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for t_fusion_guide -- ---------------------------- DROP TABLE IF EXISTS `t_fusion_guide2`; CREATE TABLE `t_fusion_guide2` ( `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 = 261 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for t_fusion_guide_path -- ---------------------------- DROP TABLE IF EXISTS `t_fusion_guide_path2`; CREATE TABLE `t_fusion_guide_path2` ( `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, `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 = 1133 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 = 640 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 = 2012 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, `case_id` int NULL DEFAULT NULL, `sort` int NULL DEFAULT 1, PRIMARY KEY (`icon_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 272 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for t_model -- ---------------------------- DROP TABLE IF EXISTS `t_model2`; CREATE TABLE `t_model2` ( `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, PRIMARY KEY (`model_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 12647 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 = 110 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 = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- 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; -- ---------------------------- -- 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; -- ---------------------------- -- 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; -- ---------------------------- -- 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; -- ---------------------------- -- 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 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 = 88 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- 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; -- ---------------------------- -- 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 = 1732 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- 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; -- ---------------------------- -- 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; -- ---------------------------- -- 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; 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_0900_ai_ci NULL DEFAULT NULL, `file_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `file_size` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `new_file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `file_type_str` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `file_format` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `result_file_format` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_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_0900_ai_ci NULL DEFAULT NULL, `file_type` int NULL DEFAULT NULL, `wgs84` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `gcj02` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 723 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- 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_0900_ai_ci NULL DEFAULT NULL, `dict_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `sort` int NULL DEFAULT 1, `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_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` int NULL DEFAULT NULL, `parent_id` int NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 130 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- 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_0900_ai_ci NULL DEFAULT NULL, `type_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `dict_id` int NULL DEFAULT NULL, `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_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` int NULL DEFAULT NULL, `upload_id` int NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 718 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; ALTER TABLE `laser`.`t_case` ADD COLUMN `thumb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '案件封面图' AFTER `show_scenes`; INSERT INTO `t_hot_icon` VALUES (1, '系统默认', 'profile/fusion/default/tag_icon_default.svg', NULL, 1, 0, 1, 1, 1, '2022-08-04 11:06:39', '2024-12-19 16:16:36', NULL, 1); INSERT INTO `t_hot_icon` VALUES (2, '2', 'profile/fusion/default/hand_l.png', NULL, 1, 2, 1, 1, 0, '2024-12-19 11:10:50', '2024-12-31 11:15:07', NULL, 2); INSERT INTO `t_hot_icon` VALUES (3, '2', 'profile/fusion/default/hand_r.png', NULL, 1, 1, 1, 1, 0, '2024-12-19 11:10:50', '2024-12-20 10:09:26', NULL, 3); INSERT INTO `t_hot_icon` VALUES (4, '2', 'profile/fusion/default/zhiwen.png', NULL, 1, 9, 1, 1, 0, '2024-12-19 11:10:50', '2025-02-27 11:00:33', NULL, 1); INSERT INTO `t_hot_icon` VALUES (5, '3', 'profile/fusion/default/xieyin.png', NULL, 1, 2, 1, 1, 0, '2024-12-19 11:10:50', '2025-02-16 20:47:56', NULL, 3); INSERT INTO `t_hot_icon` VALUES (6, '3', 'profile/fusion/default/youzuji.png', NULL, 1, 2, 1, 1, 0, '2024-12-19 11:10:50', '2025-02-13 17:46:00', NULL, 2); INSERT INTO `t_hot_icon` VALUES (7, '3', 'profile/fusion/default/zuozuji.png', NULL, 1, 5, 1, 1, 0, '2024-12-19 11:10:50', '2025-02-20 14:29:35', NULL, 1); INSERT INTO `t_hot_icon` VALUES (8, '4', 'profile/fusion/default/xueji.png', NULL, 1, 3, 1, 1, 0, '2024-12-19 11:10:50', '2025-02-27 14:43:06', NULL, 2); INSERT INTO `t_hot_icon` VALUES (9, '4', 'profile/fusion/default/xuepo.png', NULL, 1, 0, 1, 1, 0, '2024-12-19 11:10:50', '2024-12-19 16:10:24', NULL, 1); INSERT INTO `t_hot_icon` VALUES (10, '5', 'profile/fusion/default/shitiz.png', NULL, 1, 0, 1, 1, 0, '2024-12-19 11:10:50', '2024-12-19 16:10:24', NULL, 1); INSERT INTO `t_hot_icon` VALUES (11, '5', 'profile/fusion/default/shitib.png', NULL, 1, 1, 1, 1, 0, '2024-12-19 11:10:50', '2025-01-02 09:54:29', NULL, 2); INSERT INTO `t_hot_icon` VALUES (12, '5', 'profile/fusion/default/shitifuhao.png', NULL, 1, 0, 1, 1, 0, '2024-12-19 11:10:50', '2024-12-19 16:10:24', NULL, 3); INSERT INTO `t_hot_icon` VALUES (13, '6', 'profile/fusion/default/h_default.png', NULL, 1, 1, 1, 1, 0, '2024-12-19 11:10:50', '2024-12-19 17:27:49', NULL, 1); INSERT INTO `t_hot_icon` VALUES (14, '7', 'profile/fusion/default/h_default.png', NULL, 1, 2, 1, 1, 0, '2024-12-19 11:10:50', '2025-01-08 17:02:50', NULL, 1); INSERT INTO `t_hot_icon` VALUES (18, '8', 'profile/fusion/default/h_default.png', NULL, 1, 96, 1, 1, 0, '2024-12-19 11:10:50', '2025-02-27 14:34:10', NULL, 1); INSERT INTO `t_hot_icon` VALUES (20, '8', 'profile/fusion/default/indicate1.png', NULL, 1, 12, 1, 1, 0, '2024-12-19 11:10:50', '2025-02-16 20:30:29', NULL, 2); INSERT INTO `t_hot_icon` VALUES (21, '8', 'profile/fusion/default/indicate2.png', NULL, 1, 3, 1, 1, 0, '2024-12-19 11:10:50', '2025-01-02 15:02:40', NULL, 3); INSERT INTO `t_hot_icon` VALUES (22, '8', 'profile/fusion/default/indicate3.png', NULL, 1, 7, 1, 1, 0, '2024-12-19 11:10:50', '2025-02-16 20:46:33', NULL, 4); INSERT INTO `t_case_files_type` VALUES (1, '原始照片', 1, 0, '2024-12-10 15:19:08', '2024-12-10 15:25:02', NULL, 1, 0); INSERT INTO `t_case_files_type` VALUES (2, '三录材料', 1, 0, '2024-12-10 15:19:53', '2024-12-10 15:19:55', NULL, 0, 0); INSERT INTO `t_case_files_type` VALUES (3, '案件卷宗', 1, 0, '2024-12-10 15:20:01', '2024-12-10 15:20:04', NULL, 0, 0); INSERT INTO `t_case_files_type` VALUES (4, '其他资料', 1, 0, '2024-12-10 15:20:09', '2024-12-10 15:20:12', NULL, 0, 0); INSERT INTO `t_case_files_type` VALUES (11, '中心现场照片', 1, 0, '2024-12-10 09:40:19', '2024-12-10 15:20:53', 1, 0, 0); INSERT INTO `t_case_files_type` VALUES (12, '关联现场照片', 2, 0, '2024-12-10 09:41:31', '2024-12-10 15:20:53', 1, 0, 0); INSERT INTO `t_case_files_type` VALUES (13, '痕迹物证照片', 3, 0, '2024-12-10 09:41:43', '2024-12-10 15:20:53', 1, 0, 0); INSERT INTO `t_case_files_type` VALUES (14, '其他', 4, 0, '2024-12-10 09:41:58', '2024-12-10 15:20:53', 1, 0, 0); INSERT INTO `t_case_files_type` VALUES (23, '方位', 5, 0, '2024-12-10 09:44:05', '2024-12-10 15:18:35', 11, 0, 0); INSERT INTO `t_case_files_type` VALUES (24, '概貌', 6, 0, '2024-12-10 09:44:15', '2024-12-10 15:18:35', 11, 0, 0); INSERT INTO `t_case_files_type` VALUES (25, '重点部位', 7, 0, '2024-12-10 09:44:21', '2024-12-10 15:18:35', 11, 0, 0); INSERT INTO `t_case_files_type` VALUES (26, '细目', 8, 0, '2024-12-10 09:44:22', '2024-12-10 15:18:35', 11, 0, 0); INSERT INTO `t_case_files_type` VALUES (27, '其他', 9, 0, '2024-12-10 09:44:29', '2024-12-10 15:18:35', 11, 0, 0); INSERT INTO `t_case_files_type` VALUES (28, '尸检照片', 10, 0, '2024-12-10 09:46:25', '2024-12-10 15:18:41', 12, 0, 0); INSERT INTO `t_case_files_type` VALUES (29, '其他', 11, 0, '2024-12-10 09:46:29', '2024-12-10 15:18:41', 12, 0, 0); INSERT INTO `t_case_files_type` VALUES (30, '尸体', 12, 0, '2024-12-10 09:49:02', '2024-12-10 15:18:51', 13, 0, 0); INSERT INTO `t_case_files_type` VALUES (31, '手印', 13, 0, '2024-12-10 09:49:08', '2024-12-10 15:18:51', 13, 0, 0); INSERT INTO `t_case_files_type` VALUES (32, '足迹', 14, 0, '2024-12-10 09:49:14', '2024-12-10 15:18:51', 13, 0, 0); INSERT INTO `t_case_files_type` VALUES (33, '血迹', 15, 0, '2024-12-10 09:49:18', '2024-12-10 15:18:51', 13, 0, 0); INSERT INTO `t_case_files_type` VALUES (34, '其他', 16, 0, '2024-12-10 09:49:23', '2024-12-10 15:18:51', 13, 0, 0); INSERT INTO `t_case_files_type` VALUES (38, '现场图', 1, 0, '2024-12-10 15:22:08', '2024-12-10 15:25:12', 2, 0, 1); INSERT INTO `t_case_files_type` VALUES (39, '现场照片', 1, 0, '2024-12-10 15:22:24', '2024-12-10 15:25:21', 2, 1, 0); INSERT INTO `t_case_files_type` VALUES (40, '勘验笔录', 1, 0, '2024-12-10 15:22:28', '2024-12-10 15:22:38', 2, 0, 0); INSERT INTO `t_case_files_type` VALUES (41, '平面图', 1, 0, '2024-12-10 15:23:09', '2024-12-10 15:23:16', 38, 0, 0); INSERT INTO `t_case_files_type` VALUES (42, '方位图', 1, 0, '2024-12-10 15:23:12', '2025-01-02 10:58:53', 38, 0, 0); INSERT INTO `t_case_files_type` VALUES (43, '侦查实验', 1, 0, '2024-12-10 15:23:58', '2024-12-10 15:24:05', 4, 0, 0); INSERT INTO `t_case_files_type` VALUES (44, '其他材料', 1, 0, '2024-12-10 15:24:02', '2024-12-10 15:24:05', 4, 0, 0); INSERT INTO `t_case_files_type` VALUES (45, '诉讼卷', 1, 0, '2024-12-10 15:24:31', '2024-12-10 15:24:45', 3, 0, 0); INSERT INTO `t_case_files_type` VALUES (46, '证据卷', 1, 0, '2024-12-10 15:24:37', '2024-12-10 15:24:45', 3, 0, 0); INSERT INTO `t_case_files_type` VALUES (47, '中心现场照片', 1, 0, '2024-12-18 17:00:49', '2024-12-18 17:00:58', 39, 0, 0); INSERT INTO `t_case_files_type` VALUES (48, '关联现场照片', 1, 0, '2024-12-18 17:00:49', '2024-12-18 17:00:58', 39, 0, 0); INSERT INTO `t_case_files_type` VALUES (49, '痕迹物证照片', 1, 0, '2024-12-18 17:00:49', '2024-12-18 17:00:58', 39, 0, 0); INSERT INTO `t_case_files_type` VALUES (50, '其他', 1, 0, '2024-12-18 17:00:49', '2024-12-18 17:00:58', 39, 0, 0); INSERT INTO `t_case_files_type` VALUES (51, '方位', 1, 0, '2024-12-18 17:00:49', '2024-12-18 17:01:08', 47, 0, 0); INSERT INTO `t_case_files_type` VALUES (52, '概貌', 1, 0, '2024-12-18 17:00:49', '2024-12-18 17:01:08', 47, 0, 0); INSERT INTO `t_case_files_type` VALUES (53, '重点部位', 1, 0, '2024-12-18 17:00:49', '2024-12-18 17:01:08', 47, 0, 0); INSERT INTO `t_case_files_type` VALUES (54, '细目', 1, 0, '2024-12-18 17:00:49', '2024-12-18 17:01:08', 47, 0, 0); INSERT INTO `t_case_files_type` VALUES (55, '其他', 1, 0, '2024-12-18 17:00:49', '2024-12-18 17:01:14', 47, 0, 0); INSERT INTO `t_case_files_type` VALUES (56, '尸检照片', 1, 0, '2024-12-18 17:00:49', '2024-12-18 17:01:30', 48, 0, 0); INSERT INTO `t_case_files_type` VALUES (57, '其他', 1, 0, '2024-12-18 17:00:49', '2024-12-18 17:01:30', 48, 0, 0); INSERT INTO `t_case_files_type` VALUES (58, '尸体', 1, 0, '2024-12-18 17:00:49', '2024-12-18 17:01:40', 49, 0, 0); INSERT INTO `t_case_files_type` VALUES (59, '手印', 1, 0, '2024-12-18 17:00:49', '2024-12-18 17:01:40', 49, 0, 0); INSERT INTO `t_case_files_type` VALUES (60, '足迹', 1, 0, '2024-12-18 17:00:49', '2024-12-18 17:01:40', 49, 0, 0); INSERT INTO `t_case_files_type` VALUES (61, '血迹', 1, 0, '2024-12-18 17:00:49', '2024-12-18 17:01:40', 49, 0, 0); INSERT INTO `t_case_files_type` VALUES (62, '其他', 1, 0, '2024-12-18 17:00:49', '2024-12-18 17:01:40', 49, 0, 0); ALTER TABLE `laser`.`t_model2` ADD COLUMN `convert_type` int NULL DEFAULT 0 AFTER `gcj02`; ALTER TABLE `laser`.`t_case` ADD COLUMN `offline_status` int NULL DEFAULT 0 COMMENT '离线包打包状态-1打包失败，0未打包，1打包中，2打包完成' AFTER `thumb`, ADD COLUMN `offline_path` varchar(255) NULL COMMENT '离线包路径' AFTER `offline_status`; ALTER TABLE `laser`.`t_case` ADD COLUMN `offline_start_time` timestamp NULL AFTER `offline_path`, ADD COLUMN `offline_end_time` timestamp NULL AFTER `offline_start_time`; ALTER TABLE `laser`.`t_model2` ADD COLUMN `upload_id` int NULL DEFAULT null AFTER `gcj02`; ALTER TABLE `laser`.`t_case_files` ADD COLUMN `upload_id` int NULL DEFAULT null AFTER `content`;