admin/wisdomsite_road_java
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
wisdomsite_road_java/wisdomsite_road.sql

536 lines
121 KiB
MySQL
Raw Permalink Normal View History

数据库信息
2025-04-01 16:54:49 +08:00
/*
Navicat Premium Data Transfer
Source Server : localhost
Source Server Type : MySQL
Source Server Version : 50741
Source Host : localhost:3306
Source Schema : wisdomsite_road
Target Server Type : MySQL
Target Server Version : 50741
File Encoding : 65001
Date: 01/04/2025 16:54:42
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for annex_file
-- ----------------------------
DROP TABLE IF EXISTS `annex_file`;
CREATE TABLE `annex_file` (
`file_id` bigint(35) NOT NULL AUTO_INCREMENT COMMENT '工程文件id',
`file_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件名',
`extend_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '扩展名',
`file_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件url',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '上传时间',
`file_size` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件大小',
`file_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型',
PRIMARY KEY (`file_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1825832361098739715 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '附件文件信息' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of annex_file
-- ----------------------------
INSERT INTO `annex_file` VALUES (1825832361098739713, 'fengche.gltf', 'gltf', 'http://jxjzw.zhgdyun.com/:6678/image/5C4AB95604114E4596F5BE18B773598A.gltf', '2024-08-20 17:48:52', '401659', 'fengche');
INSERT INTO `annex_file` VALUES (1825832361098739714, 'fengche.gltf', 'gltf', 'http://jxjzw.zhgdyun.com/:6678/image/5C4AB95604114E4596F5BE18B773598A.gltf', '2024-08-20 17:48:52', '401659', 'fengche');
-- ----------------------------
-- Table structure for inspection_dev
-- ----------------------------
DROP TABLE IF EXISTS `inspection_dev`;
CREATE TABLE `inspection_dev` (
`id` bigint(35) NOT NULL COMMENT '巡检设备ID',
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '设备编号',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '设备名称',
`url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '视频分析地址',
`car_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '车牌号',
`state` int(2) NULL DEFAULT NULL COMMENT '状态(0：空闲;1:巡检中)',
`tenant_id` int(11) NULL DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of inspection_dev
-- ----------------------------
INSERT INTO `inspection_dev` VALUES (1844924583479840770, '88887777', '测试设备', 'rtsp://admin:jxj12345@10.0.77.102:554/h264/ch1/sub/av_stream', '粤A88888', 0, 1);
INSERT INTO `inspection_dev` VALUES (1855804790382186497, '11111', 'thgy-mqtt', '123', '222', 0, 1);
INSERT INTO `inspection_dev` VALUES (1855938922928070658, '.001', '测速设备', 'rtsp://admin:jxj12345@10.0.77.102:554/h264/ch1/sub/av_stream', '粤BH25957', 1, 4);
-- ----------------------------
-- Table structure for inspection_question
-- ----------------------------
DROP TABLE IF EXISTS `inspection_question`;
CREATE TABLE `inspection_question` (
`id` bigint(35) NOT NULL COMMENT '问题记录ID',
`hardware_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '硬件设备名称',
`hardware_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'AI分析硬件唯一标识',
`inspection_user` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '巡检人',
`image_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片路径',
`alarm_type` int(11) NULL DEFAULT NULL COMMENT '类型 (字典数据)',
`location` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '位置',
`create_time` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '添加时间',
`rectification_person_id` bigint(35) NULL DEFAULT NULL COMMENT '指定整改人id',
`status` tinyint(3) NULL DEFAULT 1 COMMENT '整改状态 0待分配 1 待整改 2已整改',
`request_rectification_date` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '规划完成时间',
`priority` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '紧急程度',
`correct_image` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '施工后照片',
`correct_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '施工日期',
`complete_date` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '完工日期',
`repair_desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '维修说明',
`repair_remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '维修备注',
`route_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '路线名称',
`longitude` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '经度',
`latitude` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '纬度',
`route_id` bigint(35) NULL DEFAULT NULL COMMENT '路线ID',
`street` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '检测路段',
`township` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属街道',
`code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '病害编号',
`speed` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '速度',
`area` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '面积',
`inspection_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '巡检类型',
`device_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备类型',
`team` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '负责团队',
`protect_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '养护状态',
`tenant_id` int(11) NULL DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `uk_hardware_id_create_time`(`hardware_id`, `create_time`) USING BTREE,
INDEX `idx_location`(`location`) USING BTREE,
INDEX `idx_alarm_type`(`alarm_type`) USING BTREE,
INDEX `idx_status`(`status`) USING BTREE,
INDEX `idx_hardware_id`(`hardware_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'AI分析硬件设备报警记录' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of inspection_question
-- ----------------------------
INSERT INTO `inspection_question` VALUES (1854102406922612738, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/D5F270D8E2984A51A5A8E9EC5E176584.jpg', 3, NULL, '2024-11-06 18:03:48', NULL, 3, '2024-11-21', '18', '[{\"name\":\"天地图.png\",\"percentage\":100,\"status\":\"success\",\"size\":8372,\"raw\":{\"uid\":1730895111627},\"uid\":1730895111627,\"url\":\"blob:http://192.168.34.129:8848/d983bb0f-f688-469e-a1b9-c9005923aba9\",\"response\":{\"code\":200,\"msg\":null,\"result\":{\"ext\":\"png\",\"filename\":\"87BD99FCA1F34C998DB09D2713DA7776.png\",\"size\":\"8372\",\"completeUrl\":\"D:/road/87BD99FCA1F34C998DB09D2713DA7776.png\",\"contentType\":\"image/png\",\"url\":\"http://192.168.34.155:6679/image/87BD99FCA1F34C998DB09D2713DA7776.png\",\"originalFilename\":\"天地图.png\"},\"success\":true}},{\"name\":\"天地图电子.png\",\"percentage\":100,\"status\":\"success\",\"size\":5628,\"raw\":{\"uid\":1730895113710},\"uid\":1730895113710,\"url\":\"blob:http://192.168.34.129:8848/0a0da963-e088-4840-ae9c-ccd30523ef95\",\"response\":{\"code\":200,\"msg\":null,\"result\":{\"ext\":\"png\",\"filename\":\"8C491EB7D11745069A954DBBA8C5275C.png\",\"size\":\"5628\",\"completeUrl\":\"D:/road/8C491EB7D11745069A954DBBA8C5275C.png\",\"contentType\":\"image/png\",\"url\":\"http://192.168.34.155:6679/image/8C491EB7D11745069A954DBBA8C5275C.png\",\"originalFilename\":\"天地图电子.png\"},\"success\":true}},{\"name\":\"腾讯电子.png\",\"percentage\":100,\"status\":\"success\",\"size\":4864,\"raw\":{\"uid\":1730895115939},\"uid\":1730895115939,\"url\":\"blob:http://192.168.34.129:8848/ff0e407f-37b5-4fc8-ba60-e2c624b17936\",\"response\":{\"code\":200,\"msg\":null,\"result\":{\"ext\":\"png\",\"filename\":\"A8399048F549469B82AA2E2FC342C9BD.png\",\"size\":\"4864\",\"completeUrl\":\"D:/road/A8399048F549469B82AA2E2FC342C9BD.png\",\"contentType\":\"image/png\",\"url\":\"http://192.168.34.155:6679/image/A8399048F549469B82AA2E2FC342C9BD.png\",\"originalFilename\":\"腾讯电子.png\"},\"success\":true}}]', '2024-11-28', '2024-11-06 18:03:56', NULL, NULL, '测试路线2', '113.80486', '22.676905', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241106180348', '', NULL, '21', '23', '24', '26', 1);
INSERT INTO `inspection_question` VALUES (1854102415713873921, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/917A911EA5FB475DB31B39155666D07D.jpg', 3, NULL, '2024-11-06 18:03:44', NULL, 3, '2024-11-28', '20', '[{\"name\":\"高德地图.png\",\"percentage\":100,\"status\":\"success\",\"size\":4651,\"raw\":{\"uid\":1730895198637},\"uid\":1730895198637,\"url\":\"blob:http://192.168.34.129:8848/7326bf14-dc24-47be-a167-eecc18533763\",\"response\":{\"code\":200,\"msg\":null,\"result\":{\"ext\":\"png\",\"filename\":\"37A3F3BD48D7429CABE63430C543CEFC.png\",\"size\":\"4651\",\"completeUrl\":\"D:/road/37A3F3BD48D7429CABE63430C543CEFC.png\",\"contentType\":\"image/png\",\"url\":\"http://192.168.34.155:6679/image/37A3F3BD48D7429CABE63430C543CEFC.png\",\"originalFilename\":\"高德地图.png\"},\"success\":true}},{\"name\":\"腾讯电子.png\",\"percentage\":100,\"status\":\"success\",\"size\":4864,\"raw\":{\"uid\":1730895200933},\"uid\":1730895200933,\"url\":\"blob:http://192.168.34.129:8848/486428e6-f3dd-4fb1-81ed-a469100ba7d8\",\"response\":{\"code\":200,\"msg\":null,\"result\":{\"ext\":\"png\",\"filename\":\"A6A428F0EF274304A73617DAD693A08C.png\",\"size\":\"4864\",\"completeUrl\":\"D:/road/A6A428F0EF274304A73617DAD693A08C.png\",\"contentType\":\"image/png\",\"url\":\"http://192.168.34.155:6679/image/A6A428F0EF274304A73617DAD693A08C.png\",\"originalFilename\":\"腾讯电子.png\"},\"success\":true}},{\"name\":\"天地图.png\",\"percentage\":100,\"status\":\"success\",\"size\":8372,\"raw\":{\"uid\":1730895203209},\"uid\":1730895203209,\"url\":\"blob:http://192.168.34.129:8848/82d6fe7d-55d4-4085-bfde-34299a0b9438\",\"response\":{\"code\":200,\"msg\":null,\"result\":{\"ext\":\"png\",\"filename\":\"A06BBDAF306F4A7D9EF2335911C201DF.png\",\"size\":\"8372\",\"completeUrl\":\"D:/road/A06BBDAF306F4A7D9EF2335911C201DF.png\",\"contentType\":\"image/png\",\"url\":\"http://192.168.34.155:6679/image/A06BBDAF306F4A7D9EF2335911C201DF.png\",\"originalFilename\":\"天地图.png\"},\"success\":true}},{\"name\":\"天地图电子.png\",\"percentage\":100,\"status\":\"success\",\"size\":5628,\"raw\":{\"uid\":1730895205403},\"uid\":1730895205403,\"url\":\"blob:http://192.168.34.129:8848/f4c13028-3de6-4899-ad96-8314161584eb\",\"response\":{\"code\":200,\"msg\":null,\"result\":{\"ext\":\"png\",\"filename\":\"C6A222E4F7DF418B96004FE668A70557.png\",\"size\":\"5628\",\"completeUrl\":\"D:/road/C6A222E4F7DF418B96004FE668A70557.png\",\"contentType\":\"image/png\",\"url\":\"http://192.168.34.155:6679/image/C6A222E4F7DF418B96004FE668A70557.png\",\"originalFilename\":\"天地图电子.png\"},\"success\":true}},{\"name\":\"gsiotback.png\",\"percentage\":100,\"status\":\"success\",\"size\":2069909,\"raw\":{\"uid\":1730895207892},\"uid\":1730895207892,\"url\":\"blob:http://192.168.34.129:8848/79b82a16-5080-4b98-9778-41d6e78fd5de\",\"response\":{\"code\":200,\"msg\":null,\"result\":{\"ext\":\"png\",\"filename\":\"F0CED9E4F7404F63AF3BC9C0BE1B5C1F.png\",\"size\":\"2069909\",\"completeUrl\":\"D:/road/F0CED9E4F7404F63AF3BC9C0BE1B5C1F.png\",\"contentType\":\"image/png\",\"url\":\"http://192.168.34.155:6679/image/F0CED9E4F7404F63AF3BC9C0BE1B5C1F.png\",\"originalFilename\":\"gsiotback.png\"},\"success\":true}}]', '2024-11-26', '2024-11-06 18:03:58', NULL, NULL, '测试路线2', '113.80486', '22.676905', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241106180344', '', NULL, '21', '23', '24', '26', 1);
INSERT INTO `inspection_question` VALUES (1854118249890951169, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/F8F6D578ADAA4C7082D07198397A2659.jpg', 3, NULL, '2024-11-06 18:15:04', NULL, 3, '2024-11-28', '18', '[{\"name\":\"天地图.png\",\"percentage\":100,\"status\":\"success\",\"size\":8372,\"raw\":{\"uid\":1730891273596},\"uid\":1730891273596,\"url\":\"blob:http://192.168.34.129:8848/6e0cd174-35f0-4a47-9d29-82f33e1819d9\",\"response\":{\"code\":200,\"msg\":null,\"result\":{\"ext\":\"png\",\"filename\":\"8818A023643A4AE1A30B16759C137B30.png\",\"size\":\"8372\",\"completeUrl\":\"D:/road/8818A023643A4AE1A30B16759C137B30.png\",\"contentType\":\"image/png\",\"url\":\"http://192.168.34.155:6679/image/8818A023643A4AE1A30B16759C137B30.png\",\"originalFilename\":\"天地图.png\"},\"success\":true}},{\"name\":\"gsiotback.png\",\"percentage\":100,\"status\":\"success\",\"size\":2069909,\"raw\":{\"uid\":1730891276274},\"uid\":1730891276274,\"url\":\"blob:http://192.168.34.129:8848/721275be-16ef-4651-9394-4875d357d480\",\"response\":{\"code\":200,\"msg\":null,\"result\":{\"ext\":\"png\",\"filename\":\"2AEB623F6D804F8E800EFE398B53C7CA.png\",\"size\":\"2069909\",\"completeUrl\":\"D:/road/2AEB623F6D804F8E800EFE398B53C7CA.png\",\"contentType\":\"image/png\",\"url\":\"http://192.168.34.155:6679/image/2AEB623F6D804F8E800EFE398B53C7CA.png\",\"originalFilename\":\"gsiotback.png\"},\"success\":true}}]', '2024-11-15', '2024-11-06 19:06:53', NULL, NULL, '测试路线2', '113.804774', '22.677', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241106181504', '', NULL, '21', '23', '24', '25', 1);
INSERT INTO `inspection_question` VALUES (1854118602095046658, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/9AB9E25C6446421281737DD2DC820770.jpg', 3, '', '2024-11-06 18:04:22', NULL, 3, '2024-11-21', '20', '[{\"id\":\"054C1F1833674582AF2173FAA72C2EBA.jpg\",\"url\":\"http://192.168.34.155:6679/image/054C1F1833674582AF2173FAA72C2EBA.jpg\",\"name\":\"054C1F1833674582AF2173FAA72C2EBA.jpg\"},{\"id\":\"413829BD7E8B4EA78C0C3A215007B14B.jpg\",\"url\":\"http://192.168.34.155:6679/image/413829BD7E8B4EA78C0C3A215007B14B.jpg\",\"name\":\"413829BD7E8B4EA78C0C3A215007B14B.jpg\"}]', '2024-11-06', '2024-11-06 19:08:17', '', '', '测试路线2', '113.80486', '22.676905', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241106180422', '', '', '21', '23', '24', '25', 1);
INSERT INTO `inspection_question` VALUES (1854414323365031938, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/D302F8E601184B1DA4CEE10AFB0183F4.jpg', 11, '', '2024-11-07 14:34:20', NULL, 3, '2024-11-28', '19', '[{\"id\":\"D1DEBD82FF704050AB9D37C4B60CCBC5.jpg\",\"url\":\"http://192.168.34.155:6679/image/D1DEBD82FF704050AB9D37C4B60CCBC5.jpg\",\"name\":\"D1DEBD82FF704050AB9D37C4B60CCBC5.jpg\"}]', '2024-11-07', '2024-11-07 14:43:22', '', '', '测试路线2', '113.804778', '22.677042', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241107143420', '', '', '21', '23', '24', '25', 1);
INSERT INTO `inspection_question` VALUES (1854414332143710210, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/76913F21873642168174DFFA10FDEB35.jpg', 11, NULL, '2024-11-07 14:18:44', NULL, 3, '2024-11-15', '18', '[{\"name\":\"天地图电子.png\",\"percentage\":100,\"status\":\"success\",\"size\":5628,\"raw\":{\"uid\":1731032197063},\"uid\":1731032197063,\"url\":\"blob:http://192.168.34.129:8848/cf6b8ee2-031a-4bc8-aa6e-ae3d8d67939b\",\"response\":{\"code\":200,\"msg\":null,\"result\":{\"ext\":\"png\",\"filename\":\"2E15A0516899458FA84C4A8158707120.png\",\"size\":\"5628\",\"completeUrl\":\"D:/road/2E15A0516899458FA84C4A8158707120.png\",\"contentType\":\"image/png\",\"url\":\"http://192.168.34.155:6679/image/2E15A0516899458FA84C4A8158707120.png\",\"originalFilename\":\"天地图电子.png\"},\"success\":true}}]', '2024-11-29', '2024-11-07 14:43:24', NULL, NULL, '测试路线2', '113.804766', '22.677006', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241107141844', '', NULL, '22', '23', '24', '25', 1);
INSERT INTO `inspection_question` VALUES (1854414339152392194, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/DB31BDFAD0224734AD93716AC8EBE547.jpg', 11, '', '2024-11-07 14:30:46', NULL, 3, '2024-11-28', '18', '[{\"id\":\"28DC81626DF7467E80688DCD152F71C0.jpg\",\"url\":\"http://192.168.34.155:6679/image/28DC81626DF7467E80688DCD152F71C0.jpg\",\"name\":\"28DC81626DF7467E80688DCD152F71C0.jpg\"},{\"id\":\"ECEB4CD3FA0B4FEFA6E332DB68AC4DAF.jpg\",\"url\":\"http://192.168.34.155:6679/image/ECEB4CD3FA0B4FEFA6E332DB68AC4DAF.jpg\",\"name\":\"ECEB4CD3FA0B4FEFA6E332DB68AC4DAF.jpg\"}]', '2024-11-07', '2024-11-07 14:43:26', '', '', '测试路线2', '113.804765', '22.677033', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241107143046', '', '', '21', '23', '24', '26', 1);
INSERT INTO `inspection_question` VALUES (1854414346794414081, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/0237DD556B1D4566A85FFE8FA639C03F.jpg', 14, NULL, '2024-11-07 14:07:10', NULL, 3, '2024-11-28', '18', '[{\"name\":\"天地图电子.png\",\"percentage\":100,\"status\":\"success\",\"size\":5628,\"raw\":{\"uid\":1731032197063},\"uid\":1731032197063,\"url\":\"blob:http://192.168.34.129:8848/cf6b8ee2-031a-4bc8-aa6e-ae3d8d67939b\",\"response\":{\"code\":200,\"msg\":null,\"result\":{\"ext\":\"png\",\"filename\":\"2E15A0516899458FA84C4A8158707120.png\",\"size\":\"5628\",\"completeUrl\":\"D:/road/2E15A0516899458FA84C4A8158707120.png\",\"contentType\":\"image/png\",\"url\":\"http://192.168.34.155:6679/image/2E15A0516899458FA84C4A8158707120.png\",\"originalFilename\":\"天地图电子.png\"},\"success\":true}}]', '2024-11-29', '2024-11-07 14:43:28', NULL, NULL, '测试路线2', '113.804771', '22.676979', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241107140710', '', NULL, '22', '23', '24', '26', 1);
INSERT INTO `inspection_question` VALUES (1854451149823913986, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/6330A3C292F5469B8C7F4EEFC1FF21B0.jpg', 1, NULL, '2024-11-07 17:04:34', NULL, 3, '2024-11-21', '18', '[{\"name\":\"天地图电子.png\",\"percentage\":100,\"status\":\"success\",\"size\":5628,\"raw\":{\"uid\":1731032197063},\"uid\":1731032197063,\"url\":\"blob:http://192.168.34.129:8848/cf6b8ee2-031a-4bc8-aa6e-ae3d8d67939b\",\"response\":{\"code\":200,\"msg\":null,\"result\":{\"ext\":\"png\",\"filename\":\"2E15A0516899458FA84C4A8158707120.png\",\"size\":\"5628\",\"completeUrl\":\"D:/road/2E15A0516899458FA84C4A8158707120.png\",\"contentType\":\"image/png\",\"url\":\"http://192.168.34.155:6679/image/2E15A0516899458FA84C4A8158707120.png\",\"originalFilename\":\"天地图电子.png\"},\"success\":true}}]', '2024-11-21', '2024-11-07 17:09:42', NULL, NULL, '测试路线2', '113.804764', '22.676986', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241107170434', '', NULL, '21', '23', '24', '26', 1);
INSERT INTO `inspection_question` VALUES (1854451158304796674, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/5A7E464EC9DD468B87152FCE5C1DC125.jpg', 15, NULL, '2024-11-07 16:59:07', NULL, 3, '2024-11-20', '18', '[{\"name\":\"天地图电子.png\",\"percentage\":100,\"status\":\"success\",\"size\":5628,\"raw\":{\"uid\":1731032197063},\"uid\":1731032197063,\"url\":\"blob:http://192.168.34.129:8848/cf6b8ee2-031a-4bc8-aa6e-ae3d8d67939b\",\"response\":{\"code\":200,\"msg\":null,\"result\":{\"ext\":\"png\",\"filename\":\"2E15A0516899458FA84C4A8158707120.png\",\"size\":\"5628\",\"completeUrl\":\"D:/road/2E15A0516899458FA84C4A8158707120.png\",\"contentType\":\"image/png\",\"url\":\"http://192.168.34.155:6679/image/2E15A0516899458FA84C4A8158707120.png\",\"originalFilename\":\"天地图电子.png\"},\"success\":true}}]', '2024-11-23', '2024-11-07 17:09:44', NULL, NULL, '测试路线2', '113.804852', '22.676967', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241107165907', '', NULL, '21', '23', '24', '26', 1);
INSERT INTO `inspection_question` VALUES (1854451165984567297, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/2A45B0EC94104255801021C9D858FB2B.jpg', 3, NULL, '2024-11-07 16:59:34', NULL, 3, '2024-11-27', '19', '[{\"name\":\"天地图电子.png\",\"percentage\":100,\"status\":\"success\",\"size\":5628,\"raw\":{\"uid\":1731032197063},\"uid\":1731032197063,\"url\":\"blob:http://192.168.34.129:8848/cf6b8ee2-031a-4bc8-aa6e-ae3d8d67939b\",\"response\":{\"code\":200,\"msg\":null,\"result\":{\"ext\":\"png\",\"filename\":\"2E15A0516899458FA84C4A8158707120.png\",\"size\":\"5628\",\"completeUrl\":\"D:/road/2E15A0516899458FA84C4A8158707120.png\",\"contentType\":\"image/png\",\"url\":\"http://192.168.34.155:6679/image/2E15A0516899458FA84C4A8158707120.png\",\"originalFilename\":\"天地图电子.png\"},\"success\":true}}]', '2024-11-29', '2024-11-07 17:09:46', NULL, NULL, '测试路线2', '113.804852', '22.676967', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241107165934', '', NULL, '21', '23', '24', '26', 1);
INSERT INTO `inspection_question` VALUES (1854451174733885442, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/D8EF8BECAAA4458889907DBFA25553D9.jpg', 3, NULL, '2024-11-07 16:55:07', NULL, 3, '2024-11-28', '18', '[{\"name\":\"天地图电子.png\",\"percentage\":100,\"status\":\"success\",\"size\":5628,\"raw\":{\"uid\":1731032197063},\"uid\":1731032197063,\"url\":\"blob:http://192.168.34.129:8848/cf6b8ee2-031a-4bc8-aa6e-ae3d8d67939b\",\"response\":{\"code\":200,\"msg\":null,\"result\":{\"ext\":\"png\",\"filename\":\"2E15A0516899458FA84C4A8158707120.png\",\"size\":\"5628\",\"completeUrl\":\"D:/road/2E15A0516899458FA84C4A8158707120.png\",\"contentType\":\"image/png\",\"url\":\"http://192.168.34.155:6679/image/2E15A0516899458FA84C4A8158707120.png\",\"originalFilename\":\"天地图电子.png\"},\"success\":true}}]', '2024-11-28', '2024-11-07 17:09:48', NULL, NULL, '测试路线2', '113.804764', '22.676985', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241107165507', '', NULL, '21', '23', '24', '25', 1);
INSERT INTO `inspection_question` VALUES (1854451182300409857, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/A097D09516DC41FAB375E45F886CF013.jpg', 17, NULL, '2024-11-07 16:49:14', NULL, 3, '2024-11-27', '19', '[{\"name\":\"天地图电子.png\",\"percentage\":100,\"status\":\"success\",\"size\":5628,\"raw\":{\"uid\":1731032197063},\"uid\":1731032197063,\"url\":\"blob:http://192.168.34.129:8848/cf6b8ee2-031a-4bc8-aa6e-ae3d8d67939b\",\"response\":{\"code\":200,\"msg\":null,\"result\":{\"ext\":\"png\",\"filename\":\"2E15A0516899458FA84C4A8158707120.png\",\"size\":\"5628\",\"completeUrl\":\"D:/road/2E15A0516899458FA84C4A8158707120.png\",\"contentType\":\"image/png\",\"url\":\"http://192.168.34.155:6679/image/2E15A0516899458FA84C4A8158707120.png\",\"originalFilename\":\"天地图电子.png\"},\"success\":true}}]', '2024-12-06', '2024-11-07 17:09:50', NULL, NULL, '测试路线2', '113.804859', '22.676927', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241107164914', '', NULL, '21', '23', '24', '26', 1);
INSERT INTO `inspection_question` VALUES (1854451189762076673, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/7423A03F500D412AB63D23C327E06154.jpg', 15, NULL, '2024-11-07 16:49:08', NULL, 3, '2024-11-28', '19', '[{\"name\":\"天地图电子.png\",\"percentage\":100,\"status\":\"success\",\"size\":5628,\"raw\":{\"uid\":1731032197063},\"uid\":1731032197063,\"url\":\"blob:http://192.168.34.129:8848/cf6b8ee2-031a-4bc8-aa6e-ae3d8d67939b\",\"response\":{\"code\":200,\"msg\":null,\"result\":{\"ext\":\"png\",\"filename\":\"2E15A0516899458FA84C4A8158707120.png\",\"size\":\"5628\",\"completeUrl\":\"D:/road/2E15A0516899458FA84C4A8158707120.png\",\"contentType\":\"image/png\",\"url\":\"http://192.168.34.155:6679/image/2E15A0516899458FA84C4A8158707120.png\",\"originalFilename\":\"天地图电子.png\"},\"success\":true}}]', '2024-11-28', '2024-11-07 17:09:52', NULL, NULL, '测试路线2', '113.804775', '22.676985', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241107164908', '', NULL, '21', '23', '24', '25', 1);
INSERT INTO `inspection_question` VALUES (1854451196665901058, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/6815626EC4B84B26A24416625D454432.jpg', 14, NULL, '2024-11-07 16:49:05', NULL, 3, '2024-11-27', '19', '[{\"name\":\"天地图电子.png\",\"percentage\":100,\"status\":\"success\",\"size\":5628,\"raw\":{\"uid\":1731032197063},\"uid\":1731032197063,\"url\":\"blob:http://192.168.34.129:8848/cf6b8ee2-031a-4bc8-aa6e-ae3d8d67939b\",\"response\":{\"code\":200,\"msg\":null,\"result\":{\"ext\":\"png\",\"filename\":\"2E15A0516899458FA84C4A8158707120.png\",\"size\":\"5628\",\"completeUrl\":\"D:/road/2E15A0516899458FA84C4A8158707120.png\",\"contentType\":\"image/png\",\"url\":\"http://192.168.34.155:6679/image/2E15A0516899458FA84C4A8158707120.png\",\"originalFilename\":\"天地图电子.png\"},\"success\":true}}]', '2024-11-28', '2024-11-07 17:09:53', NULL, NULL, '测试路线2', '113.804775', '22.676985', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241107164905', '', NULL, '21', '23', '24', '26', 1);
INSERT INTO `inspection_question` VALUES (1854451225610792961, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/00275C8FD00148C5A0B8745A3345A32D.jpg', 13, NULL, '2024-11-07 16:49:02', NULL, 3, '2024-11-26', '19', '[{\"name\":\"天地图电子.png\",\"percentage\":100,\"status\":\"success\",\"size\":5628,\"raw\":{\"uid\":1731032197063},\"uid\":1731032197063,\"url\":\"blob:http://192.168.34.129:8848/cf6b8ee2-031a-4bc8-aa6e-ae3d8d67939b\",\"response\":{\"code\":200,\"msg\":null,\"result\":{\"ext\":\"png\",\"filename\":\"2E15A0516899458FA84C4A8158707120.png\",\"size\":\"5628\",\"completeUrl\":\"D:/road/2E15A0516899458FA84C4A8158707120.png\",\"contentType\":\"image/png\",\"url\":\"http://192.168.34.155:6679/image/2E15A0516899458FA84C4A8158707120.png\",\"originalFilename\":\"天地图电子.png\"},\"success\":true}}]', '2024-11-28', '2024-11-07 17:10:00', NULL, NULL, '测试路线2', '113.804775', '22.676985', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241107164902', '', NULL, '21', '23', '24', '26', 1);
INSERT INTO `inspection_question` VALUES (1854451232669806594, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/11C0DBA1375E45A8B16270143F1EF902.jpg', 10, NULL, '2024-11-07 16:48:53', NULL, 3, '2024-11-28', '19', '[{\"name\":\"天地图电子.png\",\"percentage\":100,\"status\":\"success\",\"size\":5628,\"raw\":{\"uid\":1731032197063},\"uid\":1731032197063,\"url\":\"blob:http://192.168.34.129:8848/cf6b8ee2-031a-4bc8-aa6e-ae3d8d67939b\",\"response\":{\"code\":200,\"msg\":null,\"result\":{\"ext\":\"png\",\"filename\":\"2E15A0516899458FA84C4A8158707120.png\",\"size\":\"5628\",\"completeUrl\":\"D:/road/2E15A0516899458FA84C4A8158707120.png\",\"contentType\":\"image/png\",\"url\":\"http://192.168.34.155:6679/image/2E15A0516899458FA84C4A8158707120.png\",\"originalFilename\":\"天地图电子.png\"},\"success\":true}}]', '2024-11-29', '2024-11-07 17:10:02', NULL, NULL, '测试路线2', '113.804775', '22.676985', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241107164853', '', NULL, '21', '23', '24', '25', 1);
INSERT INTO `inspection_question` VALUES (1854698136418758658, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/8950E08D3244482FA09DF80FFFDBC16D.jpg', 5, NULL, '2024-11-08 09:30:54', NULL, 3, '2024-11-27', '18', '[{\"name\":\"天地图电子.png\",\"percentage\":100,\"status\":\"success\",\"size\":5628,\"raw\":{\"uid\":1731031922070},\"uid\":1731031922070,\"url\":\"blob:http://192.168.34.129:8848/668581a1-a9b1-4b9e-b07a-5ebd535608ba\",\"response\":{\"code\":200,\"msg\":null,\"result\":{\"ext\":\"png\",\"filename\":\"539734F1C5B241779E20057790D26468.png\",\"size\":\"5628\",\"completeUrl\":\"D:/road/539734F1C5B241779E20057790D26468.png\",\"contentType\":\"image/png\",\"url\":\"http://192.168.34.155:6679/image/539734F1C5B241779E20057790D26468.png\",\"originalFilename\":\"天地图电子.png\"},\"success\":true}}]', '2024-11-29', '2024-11-20', NULL, NULL, '测试路线2', '113.804762', '22.67697', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241108093054', '', NULL, '21', '23', '24', '26', 1);
INSERT INTO `inspection_question` VALUES (1854709873983569921, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/7EED22B57ADB4620840312925BD4A89B.jpg', 1, NULL, '2024-11-08 10:17:44', NULL, 3, '2024-11-21', '19', '[{\"name\":\"天地图电子.png\",\"percentage\":100,\"status\":\"success\",\"size\":5628,\"raw\":{\"uid\":1731032448769},\"uid\":1731032448769,\"url\":\"blob:http://192.168.34.129:8848/17e78495-44e6-4783-804c-7e5ae2031f50\",\"response\":{\"code\":200,\"msg\":null,\"result\":{\"ext\":\"png\",\"filename\":\"AE55B3B4D02C4A95AC35B7B851372503.png\",\"size\":\"5628\",\"completeUrl\":\"D:/road/AE55B3B4D02C4A95AC35B7B851372503.png\",\"contentType\":\"image/png\",\"url\":\"http://192.168.34.155:6679/image/AE55B3B4D02C4A95AC35B7B851372503.png\",\"originalFilename\":\"天地图电子.png\"},\"success\":true}}]', '2024-11-18', '2024-11-20', NULL, NULL, '测试路线2', '113.804758', '22.676967', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241108101744', '', NULL, '21', '23', '24', '25', 1);
INSERT INTO `inspection_question` VALUES (1854709880543461378, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/0929230258D444E09957ED1B54D4066A.jpg', 1, NULL, '2024-11-08 10:17:41', NULL, 3, '2024-11-12', '19', '[{\"name\":\"天地图电子.png\",\"percentage\":100,\"status\":\"success\",\"size\":5628,\"raw\":{\"uid\":1731032511777},\"uid\":1731032511777,\"url\":\"blob:http://192.168.34.129:8848/1a8951d0-2f4b-42b7-b79e-1c599eeb5efc\",\"response\":{\"code\":200,\"msg\":null,\"result\":{\"ext\":\"png\",\"filename\":\"7688B583FD2E47268C6B8D799A85736A.png\",\"size\":\"5628\",\"completeUrl\":\"D:/road/7688B583FD2E47268C6B8D799A85736A.png\",\"contentType\":\"image/png\",\"url\":\"http://192.168.34.155:6679/image/7688B583FD2E47268C6B8D799A85736A.png\",\"originalFilename\":\"天地图电子.png\"},\"success\":true}}]', '2024-11-11', '2024-11-14', NULL, NULL, '测试路线2', '113.804758', '22.676967', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241108101741', '', NULL, '21', '23', '24', '25', 1);
INSERT INTO `inspection_question` VALUES (1854711316643790850, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/1B37A76CA20F4FCAB498A0322291CD18.jpg', 1, NULL, '2024-11-08 10:23:27', NULL, 3, '2024-11-09', '20', '[{\"name\":\"天地图电子.png\",\"percentage\":100,\"status\":\"success\",\"size\":5628,\"raw\":{\"uid\":1731032694863},\"uid\":1731032694863,\"url\":\"blob:http://192.168.34.129:8848/347a0cee-3511-44f2-a04b-408ed72c18e1\",\"response\":{\"code\":200,\"msg\":null,\"result\":{\"ext\":\"png\",\"filename\":\"17AED93B04274E5588BA69647A456E07.png\",\"size\":\"5628\",\"completeUrl\":\"D:/road/17AED93B04274E5588BA69647A456E07.png\",\"contentType\":\"image/png\",\"url\":\"http://192.168.34.155:6679/image/17AED93B04274E5588BA69647A456E07.png\",\"originalFilename\":\"天地图电子.png\"},\"success\":true}}]', '2024-11-08', '2024-11-11', NULL, NULL, '测试路线2', '113.804774', '22.676988', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241108102327', '', NULL, '21', '23', '24', '26', 1);
INSERT INTO `inspection_question` VALUES (1854711867280408578, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/30A23B91251B469091FE4BC1A79BB1C3.jpg', 1, '', '2024-11-08 10:25:38', NULL, 3, '2024-11-06', '19', '[{\"id\":\"C0F436D6D593461584C97C93E09D613B.jpg\",\"url\":\"http://192.168.34.155:6679/image/C0F436D6D593461584C97C93E09D613B.jpg\",\"name\":\"C0F436D6D593461584C97C93E09D613B.jpg\"},{\"id\":\"42FD5CA2789C454E8C36F47A8EB81772.jpg\",\"url\":\"http://192.168.34.155:6679/image/42FD5CA2789C454E8C36F47A8EB81772.jpg\",\"name\":\"42FD5CA2789C454E8C36F47A8EB81772.jpg\"}]', '2024-11-08', '2024-11-09', '', '', '测试路线2', '113.804853', '22.676985', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241108102538', '', '', '22', '23', '24', '26', 1);
INSERT INTO `inspection_question` VALUES (1854733648389120001, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/927C43006A244763852E2A634D86B54F.jpg', 1, NULL, '2024-11-08 11:12:47', NULL, 3, '2024-11-14', '19', '[{\"name\":\"gsiotback.png\",\"percentage\":100,\"status\":\"success\",\"size\":2069909,\"raw\":{\"uid\":1731116236839},\"uid\":1731116236839,\"url\":\"blob:http://192.168.34.129:8848/a9114f7e-c48f-462e-857a-04f6f7d39732\",\"response\":{\"code\":200,\"msg\":null,\"result\":{\"ext\":\"png\",\"filename\":\"E5F46A7ACCC6499C9E3F2E9208C2B95E.png\",\"size\":\"2069909\",\"completeUrl\":\"D:/road/E5F46A7ACCC6499C9E3F2E9208C2B95E.png\",\"contentType\":\"image/png\",\"url\":\"http://192.168.34.155:6679/image/E5F46A7ACCC6499C9E3F2E9208C2B95E.png\",\"originalFilename\":\"gsiotback.png\"},\"success\":true}}]', '2024-11-15', '2024-11-21', NULL, NULL, '测试路线2', '113.804772', '22.676964', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241108111247', '', NULL, '21', '23', '24', NULL, 1);
INSERT INTO `inspection_question` VALUES (1854734175474720769, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/9D04C2E10C73496590FE2018F258BF8A.jpg', 1, NULL, '2024-11-08 10:44:24', NULL, 3, '2024-11-13', '19', '[{\"name\":\"天地图电子.png\",\"percentage\":100,\"status\":\"success\",\"size\":5628,\"raw\":{\"uid\":1731142885905},\"uid\":1731142885905,\"url\":\"blob:http://192.168.34.129:8848/b92a0e7d-fde1-4835-88ca-50c897175f23\",\"response\":{\"code\":200,\"msg\":null,\"result\":{\"ext\":\"png\",\"filename\":\"2E62D8ECDFB14699AB2ABC86BB405724.png\",\"size\":\"5628\",\"completeUrl\":\"D:/road/2E62D8ECDFB14699AB2ABC86BB405724.png\",\"contentType\":\"image/png\",\"url\":\"http://192.168.34.155:6679/image/2E62D8ECDFB14699AB2ABC86BB405724.png\",\"originalFilename\":\"天地图电子.png\"},\"success\":true}}]', '2024-11-06', '2024-11-14', NULL, NULL, '测试路线2', '113.804774', '22.67694', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241108104424', '', NULL, '21', '23', '24', NULL, 1);
INSERT INTO `inspection_question` VALUES (1854831401060409345, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/FE5C8800E9E6427EAFF08192E37517F0.jpg', 1, '', '2024-11-08 18:17:28', NULL, 3, '2024-11-12', '20', '[{\"id\":\"FA6E83D67F5C4027A670FB7EB8E5E161.jpg\",\"url\":\"http://jxjzw.zhgdyun.com:6679/image/FA6E83D67F5C4027A670FB7EB8E5E161.jpg\",\"name\":\"FA6E83D67F5C4027A670FB7EB8E5E161.jpg\"},{\"id\":\"6E0FE97D57884654A177E7945826177D.jpg\",\"url\":\"http://jxjzw.zhgdyun.com:6679/image/6E0FE97D57884654A177E7945826177D.jpg\",\"name\":\"6E0FE97D57884654A177E7945826177D.jpg\"}]', '2024-11-08', '2024-11-08', '', '', '测试路线2', '113.804755', '22.676955', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241108181728', '', '', '21', '23', '24', '', 1);
INSERT INTO `inspection_question` VALUES (1854854235598036994, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/E7F876AF8A604723BEDE15DECC2C8D6E.jpg', 3, NULL, '2024-11-08 19:50:36', NULL, 3, '2024-11-14', '19', '[{\"name\":\"天地图.png\",\"percentage\":100,\"status\":\"success\",\"size\":8372,\"raw\":{\"uid\":1731066789269},\"uid\":1731066789269,\"url\":\"blob:http://192.168.34.129:8848/62c354d1-e5e0-4752-8ebb-38357dbb63c0\",\"response\":{\"code\":200,\"msg\":null,\"result\":{\"ext\":\"png\",\"filename\":\"01C2B65746B747EB8009B87F927D8F05.png\",\"size\":\"8372\",\"completeUrl\":\"D:/road/01C2B65746B747EB8009B87F927D8F05.png\",\"contentType\":\"image/png\",\"url\":\"http://192.168.34.155:6679/image/01C2B65746B747EB8009B87F927D8F05.png\",\"originalFilename\":\"天地图.png\"},\"success\":true}},{\"name\":\"腾讯电子.png\",\"percentage\":100,\"status\":\"success\",\"size\":4864,\"raw\":{\"uid\":1731066792311},\"uid\":1731066792311,\"url\":\"blob:http://192.168.34.129:8848/00eab8d4-6999-4d54-9ab5-d086a9ac13fa\",\"response\":{\"code\":200,\"msg\":null,\"result\":{\"ext\":\"png\",\"filename\":\"35FAF76B47F34DF6BDA093E71A72CCD6.png\",\"size\":\"4864\",\"completeUrl\":\"D:/road/35FAF76B47F34DF6BDA093E71A72CCD6.png\",\"contentType\":\"image/png\",\"url\":\"http://192.168.34.155:6679/image/35FAF76B47F34DF6BDA093E71A72CCD6.png\",\"originalFilename\":\"腾讯电子.png\"},\"success\":true}}]', '2024-11-14', '2024-11-23', '无', NULL, '测试路线2', '113.804762', '22.677002', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241108195036', '', NULL, '21', '23', '24', NULL, 1);
INSERT INTO `inspection_question` VALUES (1854854242585747458, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/5BAF80A9A0A34416BA043DE4DA03A4BC.jpg', 11, '', '2024-11-08 19:32:45', NULL, 3, '2024-11-08', '19', '[{\"id\":\"5557911BBBEB4C32A05B395C1D0ED1AE.jpg\",\"url\":\"http://jxjzw.zhgdyun.com:6679/image/5557911BBBEB4C32A05B395C1D0ED1AE.jpg\",\"name\":\"5557911BBBEB4C32A05B395C1D0ED1AE.jpg\"},{\"id\":\"A2E155F291BA4D9D965A4910E2AC4FFC.jpg\",\"url\":\"http://jxjzw.zhgdyun.com:6679/image/A2E155F291BA4D9D965A4910E2AC4FFC.jpg\",\"name\":\"A2E155F291BA4D9D965A4910E2AC4FFC.jpg\"}]', '2024-11-08', '2024-11-10', '无', '', '测试路线2', '113.804767', '22.676969', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241108193245', '', '', '21', '23', '24', '', 1);
INSERT INTO `inspection_question` VALUES (1855062423448420353, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/3C01D1BA5F3D4E18988A13588305799E.jpg', 9, NULL, '2024-11-09 09:38:36', NULL, 3, '2024-11-15', '20', '[{\"name\":\"天地图电子.png\",\"percentage\":100,\"status\":\"success\",\"size\":5628,\"raw\":{\"uid\":1731142893390},\"uid\":1731142893390,\"url\":\"blob:http://192.168.34.129:8848/c8927c3d-b019-4c24-a1c1-41e36c3bb5e2\",\"response\":{\"code\":200,\"msg\":null,\"result\":{\"ext\":\"png\",\"filename\":\"2F9A1FBD7B864092852E8EE8BDDED578.png\",\"size\":\"5628\",\"completeUrl\":\"D:/road/2F9A1FBD7B864092852E8EE8BDDED578.png\",\"contentType\":\"image/png\",\"url\":\"http://192.168.34.155:6679/image/2F9A1FBD7B864092852E8EE8BDDED578.png\",\"originalFilename\":\"天地图电子.png\"},\"success\":true}}]', '2024-11-13', '2024-11-13', NULL, NULL, '测试路线2', '113.80477', '22.677007', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241109093836', '', NULL, '22', '23', '24', NULL, 1);
INSERT INTO `inspection_question` VALUES (1855063228700262402, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/46A65A9310B54BF0912DC546ADC72F00.jpg', 9, NULL, '2024-11-09 09:19:58', NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '测试路线2', '113.804765', '22.677025', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241109091958', '', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `inspection_question` VALUES (1855063305594437633, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/5A222415951646F2A7720FDCD32C1083.jpg', 9, NULL, '2024-11-09 09:19:29', NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '测试路线2', '113.804765', '22.677025', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241109091929', '', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `inspection_question` VALUES (1855063404609372162, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/081CFE6E28D14775A0B570CF6C9783E6.jpg', 9, NULL, '2024-11-09 09:42:30', NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '测试路线2', '113.804761', '22.6771', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241109094230', '', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `inspection_question` VALUES (1855063583567740929, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/0410752A735247068B975A1E81EEEFF6.jpg', 9, NULL, '2024-11-09 09:43:12', NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '测试路线2', '113.804761', '22.6771', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241109094312', '', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `inspection_question` VALUES (1855063704544051202, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/5F97F87BD3084F93A6BD3C095941A6E1.jpg', 9, NULL, '2024-11-09 09:43:43', NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '测试路线2', '113.804769', '22.677022', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241109094343', '', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `inspection_question` VALUES (1855063779898916866, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/79B6F9D615B941299E78E8EB4E04BC7D.jpg', 9, '', '2024-11-09 09:43:59', NULL, 3, '2024-11-12', '19', '[{\"id\":\"1BC9485B5329411CBC4269FE610AB76D.jpg\",\"url\":\"http://jxjzw.zhgdyun.com:6679/image/1BC9485B5329411CBC4269FE610AB76D.jpg\",\"name\":\"1BC9485B5329411CBC4269FE610AB76D.jpg\"},{\"id\":\"5FF78605DA974AD7BEA6EA6D7A3F942C.jpg\",\"url\":\"http://jxjzw.zhgdyun.com:6679/image/5FF78605DA974AD7BEA6EA6D7A3F942C.jpg\",\"name\":\"5FF78605DA974AD7BEA6EA6D7A3F942C.jpg\"}]', '2024-11-09', '2024-11-11', '', '', '测试路线2', '113.80478', '22.676995', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241109094359', '', '', '22', '23', '24', '', 1);
INSERT INTO `inspection_question` VALUES (1855076279759503362, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/660E99A6671E480E85BCD4E767B60F12.jpg', 1, NULL, '2024-11-09 10:32:55', NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '测试路线2', '113.804762', '22.677025', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241109103255', '', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `inspection_question` VALUES (1855076568411504641, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/2FA89160881540DC89FF88F236201226.jpg', 3, '', '2024-11-09 10:34:22', NULL, 3, '2024-11-10', '20', '[{\"id\":\"90133744B7C94000BC388B4EE4FFCB39.jpg\",\"url\":\"http://jxjzw.zhgdyun.com:6679/image/90133744B7C94000BC388B4EE4FFCB39.jpg\",\"name\":\"90133744B7C94000BC388B4EE4FFCB39.jpg\"}]', '2024-11-09', '2024-11-15', '', '', '测试路线2', '113.804757', '22.677079', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241109103422', '', '', '22', '23', '24', '', 1);
INSERT INTO `inspection_question` VALUES (1855149290039304193, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/DF731C691AB84E86B82268C5A489A2FA.jpg', 1, NULL, '2024-11-09 10:55:11', NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '测试路线2', '113.804763', '22.677049', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241109105511', '', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `inspection_question` VALUES (1855149312541745154, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/E7B85B68EF334186ABE89D75B7485F34.jpg', 1, NULL, '2024-11-09 10:55:07', NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '测试路线2', '113.804814', '22.676966', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241109105507', '', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `inspection_question` VALUES (1855172793337700353, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/BDC5B623FA6A41C29D866A7F457AE61E.jpg', 1, NULL, '2024-11-09 16:57:00', NULL, 3, '2024-11-15', '20', '[{\"name\":\"天地图电子.png\",\"percentage\":100,\"status\":\"success\",\"size\":5628,\"raw\":{\"uid\":1731142903458},\"uid\":1731142903458,\"url\":\"blob:http://192.168.34.129:8848/a70ff292-5746-4df8-8c0c-f82dfa44026b\",\"response\":{\"code\":200,\"msg\":null,\"result\":{\"ext\":\"png\",\"filename\":\"1939E6935CD64FF5BC9DACB4303DA4AD.png\",\"size\":\"5628\",\"completeUrl\":\"D:/road/1939E6935CD64FF5BC9DACB4303DA4AD.png\",\"contentType\":\"image/png\",\"url\":\"http://192.168.34.155:6679/image/1939E6935CD64FF5BC9DACB4303DA4AD.png\",\"originalFilename\":\"天地图电子.png\"},\"success\":true}}]', '2024-11-15', '2024-11-14', NULL, NULL, '测试', '113.804763', '22.677006', 1855171411314532353, '永福路', '福海街道', 'BAQ-YFL-20241109165700', '', NULL, '21', '23', '24', NULL, 1);
INSERT INTO `inspection_question` VALUES (1855174014110851074, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/FECB62D49F924DDEBA84AE253D6D5824.jpg', 1, NULL, '2024-11-09 17:02:02', NULL, 3, '2024-11-28', '20', '', NULL, NULL, NULL, NULL, '测试', '113.804779', '22.676987', 1855171411314532353, '永福路', '福海街道', 'BAQ-YFL-20241109170202', '', NULL, '21', '23', '24', NULL, 1);
INSERT INTO `inspection_question` VALUES (1855178131161403393, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/6AFC176C62F945CDA8488BDFD7C05EA5.jpg', 1, NULL, '2024-11-09 17:17:45', NULL, 3, '2024-11-13', '20', '', NULL, NULL, NULL, NULL, '测试', '113.804882', '22.676949', 1855171411314532353, '永福路', '福海街道', 'BAQ-YFL-20241109171745', '', NULL, '22', '23', '24', NULL, 1);
INSERT INTO `inspection_question` VALUES (1855181890876854273, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/8F599679760044E390613A65F94CE89C.jpg', 1, NULL, '2024-11-09 17:32:39', NULL, 3, '2024-11-28', '19', '', NULL, NULL, NULL, NULL, '测试', '113.804819', '22.677025', 1855171411314532353, '永福路', '福海街道', 'BAQ-YFL-20241109173239', '', NULL, '21', '23', '24', NULL, 1);
INSERT INTO `inspection_question` VALUES (1855181898745368577, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/D6481452B3054BA186D89BC2134FDE29.jpg', 1, NULL, '2024-11-09 17:32:33', NULL, 3, '2024-11-28', '19', '', NULL, NULL, NULL, NULL, '测试', '113.804819', '22.677025', 1855171411314532353, '永福路', '福海街道', 'BAQ-YFL-20241109173233', '', NULL, '21', '23', '24', NULL, 1);
INSERT INTO `inspection_question` VALUES (1855181905212985346, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/D2564041855249DB8F4C094F10C20FA2.jpg', 1, NULL, '2024-11-09 17:32:36', NULL, 3, '2024-11-27', '19', '', NULL, NULL, NULL, NULL, '测试', '113.804819', '22.677025', 1855171411314532353, '永福路', '福海街道', 'BAQ-YFL-20241109173236', '', NULL, '22', '23', '24', NULL, 1);
INSERT INTO `inspection_question` VALUES (1855182699853238274, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/2A42A3FCE43D4B0B8D89582192FFCB7D.jpg', 1, '', '2024-11-09 17:36:32', 1855135825677590529, 3, '2024-11-29', '18', '[{\"id\":\"04AC9281775C45E88029BC2E0D1AAB7A.jpg\",\"url\":\"http://jxjzw.zhgdyun.com:6679/image/04AC9281775C45E88029BC2E0D1AAB7A.jpg\",\"name\":\"04AC9281775C45E88029BC2E0D1AAB7A.jpg\"}]', '2024-11-09', '2024-11-09', '', '', '测试', '113.804766', '22.677039', 1855171411314532353, '永福路', '福海街道', 'BAQ-YFL-20241109173632', '', '', '22', '23', '24', '', 1);
INSERT INTO `inspection_question` VALUES (1855182709848264705, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/5891BAF15C4342FBAA735B434C015E5F.jpg', 1, NULL, '2024-11-09 17:36:30', 1855135825677590529, 3, '2024-12-06', '19', '', NULL, NULL, NULL, NULL, '测试', '113.804766', '22.677039', 1855171411314532353, '永福路', '福海街道', 'BAQ-YFL-20241109173630', '', NULL, '21', '23', '24', NULL, 1);
INSERT INTO `inspection_question` VALUES (1855184308247158785, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/E57EEB5048464A408E31BD4B65AA7380.jpg', 1, NULL, '2024-11-09 17:42:16', NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '测试', '113.804765', '22.677019', 1855171411314532353, '永福路', '福海街道', 'BAQ-YFL-20241109174216', '', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `inspection_question` VALUES (1855185871405522945, '测试设备', '88887777', '1855135825677590529', 'http://192.168.34.155:6679/image/1AFFF21F487049E1A71B479A8288E6E4.jpg', 1, NULL, '2024-11-09 17:48:48', NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '104', '113.80476', '22.677019', 1855075590777962497, '永福路', '福海街道', 'BAQ-YFL-20241109174848', '', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `inspection_question` VALUES (1855186378178109442, '测试设备', '88887777', '1855135825677590529', 'http://192.168.34.155:6679/image/9AF1673AE8A94DFBBF75ACAC12C132B8.jpg', 1, NULL, '2024-11-09 17:50:42', NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '104', '113.804761', '22.677047', 1855075590777962497, '永福路', '福海街道', 'BAQ-YFL-20241109175042', '', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `inspection_question` VALUES (1855921165452894210, '测试设备', '88887777', '1855908044717944833', 'http://192.168.34.155:6679/image/D9209B7A918647319A2CDBD85ED7C43C.jpg', 1, '', '2024-11-11 18:17:34', 1855918213195550722, 2, '2024-11-28', '19', '[{\"id\":\"437B50F69DAC4ABEAB189F851B230014.jpg\",\"url\":\"http://jxjzw.zhgdyun.com:6679/image/437B50F69DAC4ABEAB189F851B230014.jpg\",\"name\":\"437B50F69DAC4ABEAB189F851B230014.jpg\"}]', '2024-11-11', '2024-11-13', '', '', '佳信捷-1', '113.804766', '22.677006', 1855908364210663425, '永福路', '福海街道', 'BAQ-YFL-20241111181734', '', '', '21', '36', '37', '', 1);
INSERT INTO `inspection_question` VALUES (1857326604489043970, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/CE19881BE4964548B00939AAC832A836.jpg', 1, NULL, '2024-11-09 17:41:14', 1855902726956965889, 2, '2024-11-27', '19', '[{\"name\":\"天地图电子.png\",\"percentage\":100,\"status\":\"success\",\"size\":5628,\"raw\":{\"uid\":1731656198618},\"uid\":1731656198618,\"url\":\"blob:http://192.168.34.129:8848/839cfe70-38f6-44d6-ac8d-558375c25011\",\"response\":{\"code\":200,\"msg\":null,\"result\":{\"ext\":\"png\",\"filename\":\"83ABD450E77C4D9BB21F47C2DFBCC669.png\",\"size\":\"5628\",\"completeUrl\":\"D:/road/83ABD450E77C4D9BB21F47C2DFBCC669.png\",\"contentType\":\"image/png\",\"url\":\"http://192.168.34.155:6679/image/83ABD450E77C4D9BB21F47C2DFBCC669.png\",\"originalFilename\":\"天地图电子.png\"},\"success\":true}}]', '2024-11-13', '2024-11-13', NULL, NULL, '测试', '113.804752', '22.677037', 1855171411314532353, '永福路', '福海街道', 'BAQ-YFL-20241109174114', '', NULL, '21', '36', '37', NULL, 1);
INSERT INTO `inspection_question` VALUES (1857327108816351233, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/B46BC899E31949B3BE6330D94B02023F.jpg', 3, NULL, '2024-11-09 16:56:18', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '测试路线2', '113.804763', '22.677006', 1844669233467969538, '永福路', '福海街道', 'BAQ-YFL-20241109165618', '', NULL, NULL, NULL, NULL, NULL, 1);
-- ----------------------------
-- Table structure for inspection_record
-- ----------------------------
DROP TABLE IF EXISTS `inspection_record`;
CREATE TABLE `inspection_record` (
`id` bigint(35) NOT NULL COMMENT '整改记录ID',
`hardware_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '硬件设备名称',
`hardware_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'AI分析硬件唯一标识',
`inspection_user` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '巡检人',
`image_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片路径',
`alarm_type` int(11) NULL DEFAULT NULL COMMENT '类型 (字典数据)',
`location` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '位置',
`create_time` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '添加时间',
`update_date` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
`inspection_car_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '巡检车牌',
`state` int(1) NULL DEFAULT NULL COMMENT '状态(0：未处理；1：移入问题清单)',
`route_id` bigint(35) NULL DEFAULT NULL COMMENT '路线ID',
`route_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '路线名称',
`longitude` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '经度',
`latitude` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '纬度',
`street` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '检测路段',
`township` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属街道',
`code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '病害编号',
`speed` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '速度',
`tenant_id` int(11) NULL DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `uk_hardware_id_create_time`(`hardware_id`, `create_time`) USING BTREE,
INDEX `idx_location`(`location`) USING BTREE,
INDEX `idx_alarm_type`(`alarm_type`) USING BTREE,
INDEX `idx_hardware_id`(`hardware_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'AI分析硬件设备报警记录' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of inspection_record
-- ----------------------------
INSERT INTO `inspection_record` VALUES (1853759346967650306, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/66bb19045b84bea37b127557.jpg', 1, '西乡大道', '2024-10-15 14:55:25', '2024-11-09 17:18:08', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.880512', '22.567757', '宝安大道', '新安街道', 'BAQ-BADD-20241015145525', '10km/h', 1);
INSERT INTO `inspection_record` VALUES (1853759552069115905, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/66bb19045b84bea37b127557.jpg', 1, '西乡大道', '2024-10-15 15:15:25', '2024-11-09 17:18:08', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.880512', '22.567757', '宝安大道', '新安街道', 'BAQ-BADD-20241015151525', '10km/h', 1);
INSERT INTO `inspection_record` VALUES (1853759591290052610, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/66bb19045b84bea37b127557.jpg', 1, '西乡大道', '2024-10-15 15:17:25', '2024-11-09 17:18:08', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.880512', '22.567757', '宝安大道', '新安街道', 'BAQ-BADD-20241015151725', '10km/h', 1);
INSERT INTO `inspection_record` VALUES (1853759617789665281, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/66bb19045b84bea37b127557.jpg', 1, '西乡大道', '2024-10-15 15:18:25', '2024-11-09 17:18:08', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.880512', '22.567757', '宝安大道', '新安街道', 'BAQ-BADD-20241015151825', '10km/h', 1);
INSERT INTO `inspection_record` VALUES (1853759634826928129, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/66bb19045b84bea37b127557.jpg', 1, '西乡大道', '2024-10-15 15:19:25', '2024-11-09 17:18:08', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.880512', '22.567757', '宝安大道', '新安街道', 'BAQ-BADD-20241015151925', '10km/h', 1);
INSERT INTO `inspection_record` VALUES (1853759717656043521, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/66bb19045b84bea37b127557.jpg', 1, '西乡大道', '2024-10-15 15:20:25', '2024-11-09 17:18:08', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.880512', '22.567757', '宝安大道', '新安街道', 'BAQ-BADD-20241015152025', '10km/h', 1);
INSERT INTO `inspection_record` VALUES (1853759736400388098, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/66bb19045b84bea37b127557.jpg', 1, '西乡大道', '2024-10-15 15:21:25', '2024-11-09 17:18:08', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.880512', '22.567757', '宝安大道', '新安街道', 'BAQ-BADD-20241015152125', '10km/h', 1);
INSERT INTO `inspection_record` VALUES (1853759752854642690, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/66bb19045b84bea37b127557.jpg', 1, '西乡大道', '2024-10-15 15:22:25', '2024-11-09 17:18:08', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.880512', '22.567757', '宝安大道', '新安街道', 'BAQ-BADD-20241015152225', '10km/h', 1);
INSERT INTO `inspection_record` VALUES (1854033067129286658, '测试设备', '88887777', '1855133471796375554', NULL, 1, '西乡大道', '2024-10-16 15:22:25', '2024-11-09 17:18:08', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.880512', '22.567757', '宝安大道', '新安街道', 'BAQ-BADD-20241016152225', '10km/h', 1);
INSERT INTO `inspection_record` VALUES (1854043926526275586, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/4462EE9A921A42479B8F0337CFBB0BD3.jpg', 1, NULL, '2024-11-06 14:11:31', '2024-11-09 17:18:08', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.804767', '22.67694', '永福路', '福海街道', 'BAQ-YFL-20241106141131', '', 1);
INSERT INTO `inspection_record` VALUES (1854043977721950209, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/DC68A4B84C194DDEB5CAB566B23A60DB.jpg', 1, NULL, '2024-11-06 14:11:42', '2024-11-09 17:18:08', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.804767', '22.67694', '永福路', '福海街道', 'BAQ-YFL-20241106141142', '', 1);
INSERT INTO `inspection_record` VALUES (1854046581738811393, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/AB3DDC967338495E9CF3D945578158FE.jpg', 1, NULL, '2024-11-06 14:22:03', '2024-11-09 17:18:08', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.804763', '22.676965', '永福路', '福海街道', 'BAQ-YFL-20241106142203', '', 1);
INSERT INTO `inspection_record` VALUES (1854047627504627713, '测试设备', '88887777', '1855133471796375554', NULL, 1, '西乡大道', '2024-10-16 15:23:25', '2024-11-09 17:18:08', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.880512', '22.567757', '宝安大道', '新安街道', 'BAQ-BADD-20241016152325', '10km/h', 1);
INSERT INTO `inspection_record` VALUES (1854047648253849602, '测试设备', '88887777', '1855133471796375554', NULL, 1, '西乡大道', '2024-10-16 15:24:25', '2024-11-09 17:18:08', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.880512', '22.567757', '宝安大道', '新安街道', 'BAQ-BADD-20241016152425', '10km/h', 1);
INSERT INTO `inspection_record` VALUES (1854047663835688961, '测试设备', '88887777', '1855133471796375554', NULL, 1, '西乡大道', '2024-10-16 15:25:25', '2024-11-09 17:18:08', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.880512', '22.567757', '宝安大道', '新安街道', 'BAQ-BADD-20241016152525', '10km/h', 1);
INSERT INTO `inspection_record` VALUES (1854047837043666946, '测试设备', '88887777', '1855133471796375554', NULL, 1, '西乡大道', '2024-10-16 15:26:25', '2024-11-09 17:18:08', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.880512', '22.567757', '宝安大道', '新安街道', 'BAQ-BADD-20241016152625', '10km/h', 1);
INSERT INTO `inspection_record` VALUES (1854047858417840130, '测试设备', '88887777', '1855133471796375554', NULL, 1, '西乡大道', '2024-10-16 15:27:25', '2024-11-09 17:18:08', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.880512', '22.567757', '宝安大道', '新安街道', 'BAQ-BADD-20241016152725', '10km/h', 1);
INSERT INTO `inspection_record` VALUES (1854053082750627842, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/60C33E01A27444378927871C93C9DC14.jpg', 1, NULL, '2024-11-06 14:47:53', '2024-11-09 17:18:08', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.804767', '22.676975', '永福路', '福海街道', 'BAQ-YFL-20241106144753', '', 1);
INSERT INTO `inspection_record` VALUES (1854055295774470146, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/967F5B66258A4A0F8C138F9FE6A37119.jpg', 1, NULL, '2024-11-06 14:56:43', '2024-11-09 17:18:08', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.804762', '22.676984', '永福路', '福海街道', 'BAQ-YFL-20241106145643', '', 1);
INSERT INTO `inspection_record` VALUES (1854055897912946690, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/420A058A860C4A26AA0C42CB331C7E65.jpg', 1, NULL, '2024-11-06 14:59:03', '2024-11-09 17:18:08', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.804762', '22.676967', '永福路', '福海街道', 'BAQ-YFL-20241106145903', '', 1);
INSERT INTO `inspection_record` VALUES (1854098242012295169, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/C449410A11394ACEB942577AC5BC8D68.jpg', 3, NULL, '2024-11-06 17:47:21', '2024-11-09 17:18:08', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.804852', '22.676875', '永福路', '福海街道', 'BAQ-YFL-20241106174721', '', 1);
INSERT INTO `inspection_record` VALUES (1854102364354621441, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/917A911EA5FB475DB31B39155666D07D.jpg', 3, NULL, '2024-11-06 18:03:44', '2024-11-09 17:18:08', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.80486', '22.676905', '永福路', '福海街道', 'BAQ-YFL-20241106180344', '', 1);
INSERT INTO `inspection_record` VALUES (1854102374433533953, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/D5F270D8E2984A51A5A8E9EC5E176584.jpg', 3, NULL, '2024-11-06 18:03:48', '2024-11-09 17:18:08', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.80486', '22.676905', '永福路', '福海街道', 'BAQ-YFL-20241106180348', '', 1);
INSERT INTO `inspection_record` VALUES (1854102517119561730, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/9AB9E25C6446421281737DD2DC820770.jpg', 3, NULL, '2024-11-06 18:04:22', '2024-11-09 17:18:08', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.80486', '22.676905', '永福路', '福海街道', 'BAQ-YFL-20241106180422', '', 1);
INSERT INTO `inspection_record` VALUES (1854105216267431937, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/F8F6D578ADAA4C7082D07198397A2659.jpg', 3, NULL, '2024-11-06 18:15:04', '2024-11-09 17:18:08', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.804774', '22.677', '永福路', '福海街道', 'BAQ-YFL-20241106181504', '', 1);
INSERT INTO `inspection_record` VALUES (1854401668919177217, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/26E4EF30FEFA44FD8CB35F962EFEEF4F.jpg', 1, NULL, '2024-11-07 13:53:04', '2024-11-09 17:18:08', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804863', '22.676951', '永福路', '福海街道', 'BAQ-YFL-20241107135304', '', 1);
INSERT INTO `inspection_record` VALUES (1854401691392258050, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/90536292C84D4605A49737F85ED7C110.jpg', 4, NULL, '2024-11-07 13:53:10', '2024-11-09 17:18:08', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804863', '22.676951', '永福路', '福海街道', 'BAQ-YFL-20241107135310', '', 1);
INSERT INTO `inspection_record` VALUES (1854403759880384514, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/18835E6E05FA44C98F1B526930D38EE6.jpg', 11, NULL, '2024-11-07 14:01:22', '2024-11-09 17:18:08', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804759', '22.676977', '永福路', '福海街道', 'BAQ-YFL-20241107140122', '', 1);
INSERT INTO `inspection_record` VALUES (1854404083835842562, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/328BFA940B0A48D08A7F27F5BD349209.jpg', 7, NULL, '2024-11-07 14:02:39', '2024-11-09 17:18:08', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.80475', '22.677043', '永福路', '福海街道', 'BAQ-YFL-20241107140239', '', 1);
INSERT INTO `inspection_record` VALUES (1854404780622983170, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/D926E60EAF884F8495E3EB6C3B05101F.jpg', 13, NULL, '2024-11-07 14:05:26', '2024-11-09 17:18:08', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804757', '22.677005', '永福路', '福海街道', 'BAQ-YFL-20241107140526', '', 1);
INSERT INTO `inspection_record` VALUES (1854405041739378689, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/584E75CAFF544A6381CAE54764465DE1.jpg', 14, NULL, '2024-11-07 14:06:29', '2024-11-09 17:18:08', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804771', '22.676979', '永福路', '福海街道', 'BAQ-YFL-20241107140629', '', 1);
INSERT INTO `inspection_record` VALUES (1854405218378297345, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/0237DD556B1D4566A85FFE8FA639C03F.jpg', 14, NULL, '2024-11-07 14:07:10', '2024-11-09 17:18:08', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.804771', '22.676979', '永福路', '福海街道', 'BAQ-YFL-20241107140710', '', 1);
INSERT INTO `inspection_record` VALUES (1854405638672723969, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/B92A238FA72D4D64ADDFD159932BF385.jpg', 14, NULL, '2024-11-07 14:08:51', '2024-11-09 17:18:08', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.80476', '22.677029', '永福路', '福海街道', 'BAQ-YFL-20241107140851', '', 1);
INSERT INTO `inspection_record` VALUES (1854408123625877505, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/76913F21873642168174DFFA10FDEB35.jpg', 11, NULL, '2024-11-07 14:18:44', '2024-11-09 17:18:08', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.804766', '22.677006', '永福路', '福海街道', 'BAQ-YFL-20241107141844', '', 1);
INSERT INTO `inspection_record` VALUES (1854411157860888578, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/DB31BDFAD0224734AD93716AC8EBE547.jpg', 11, NULL, '2024-11-07 14:30:46', '2024-11-09 17:18:08', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.804765', '22.677033', '永福路', '福海街道', 'BAQ-YFL-20241107143046', '', 1);
INSERT INTO `inspection_record` VALUES (1854412054259150850, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/D302F8E601184B1DA4CEE10AFB0183F4.jpg', 11, NULL, '2024-11-07 14:34:20', '2024-11-09 17:18:08', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.804778', '22.677042', '永福路', '福海街道', 'BAQ-YFL-20241107143420', '', 1);
INSERT INTO `inspection_record` VALUES (1854422569056317442, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/9FFDB9FAAAB74D79889F3F7631378F71.jpg', 1, NULL, '2024-11-07 15:16:07', '2024-11-09 17:18:08', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804757', '22.677009', '永福路', '福海街道', 'BAQ-YFL-20241107151607', '', 1);
INSERT INTO `inspection_record` VALUES (1854423224139493377, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/51AE86958C5E4DEBB474A3538FE4F625.jpg', 1, NULL, '2024-11-07 15:18:44', '2024-11-09 17:18:08', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804763', '22.677024', '永福路', '福海街道', 'BAQ-YFL-20241107151844', '', 1);
INSERT INTO `inspection_record` VALUES (1854423878820016129, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/22E4A51E871B4F21B37310208695EE22.jpg', 1, NULL, '2024-11-07 15:21:18', '2024-11-09 17:18:08', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804747', '22.677041', '永福路', '福海街道', 'BAQ-YFL-20241107152118', '', 1);
INSERT INTO `inspection_record` VALUES (1854427286750736386, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/8DA0677D3CBC44978BCA9BE54DA1AD8C.jpg', 7, NULL, '2024-11-07 15:34:53', '2024-11-09 17:18:08', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804764', '22.677046', '永福路', '福海街道', 'BAQ-YFL-20241107153453', '', 1);
INSERT INTO `inspection_record` VALUES (1854445748038512641, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/7F59C706561E4BF78B54EDF9EEAC789F.jpg', 1, NULL, '2024-11-07 16:48:14', '2024-11-09 17:18:08', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804775', '22.676985', '永福路', '福海街道', 'BAQ-YFL-20241107164814', '', 1);
INSERT INTO `inspection_record` VALUES (1854445775406346241, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/8B1E6550BC994A8984E74FF5E3670650.jpg', 2, NULL, '2024-11-07 16:48:20', '2024-11-09 17:18:08', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804775', '22.676985', '永福路', '福海街道', 'BAQ-YFL-20241107164820', '', 1);
INSERT INTO `inspection_record` VALUES (1854445798244331521, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/88225C4DBF7E43249A3D62610B0C2843.jpg', 3, NULL, '2024-11-07 16:48:25', '2024-11-09 17:18:08', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804775', '22.676985', '永福路', '福海街道', 'BAQ-YFL-20241107164825', '', 1);
INSERT INTO `inspection_record` VALUES (1854445817953366018, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/9DE862EA75B1489DB76D70FF855F1EA3.jpg', 4, NULL, '2024-11-07 16:48:30', '2024-11-09 17:18:08', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804775', '22.676985', '永福路', '福海街道', 'BAQ-YFL-20241107164830', '', 1);
INSERT INTO `inspection_record` VALUES (1854445834319540226, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/E9FA15A0478845B8AC5E77F91FC73BB4.jpg', 5, NULL, '2024-11-07 16:48:35', '2024-11-09 17:18:08', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804775', '22.676985', '永福路', '福海街道', 'BAQ-YFL-20241107164835', '', 1);
INSERT INTO `inspection_record` VALUES (1854445856041840641, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/723827015A934533BBC60EA23E6BB108.jpg', 6, NULL, '2024-11-07 16:48:39', '2024-11-09 17:18:08', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804775', '22.676985', '永福路', '福海街道', 'BAQ-YFL-20241107164839', '', 1);
INSERT INTO `inspection_record` VALUES (1854445873230098433, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/1E58761CE5C041F5843DD50064481FE2.jpg', 7, NULL, '2024-11-07 16:48:43', '2024-11-09 17:18:08', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804775', '22.676985', '永福路', '福海街道', 'BAQ-YFL-20241107164843', '', 1);
INSERT INTO `inspection_record` VALUES (1854445884676354050, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/A5510C6FBEB9444D934F100C659CD009.jpg', 8, NULL, '2024-11-07 16:48:47', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804775', '22.676985', '永福路', '福海街道', 'BAQ-YFL-20241107164847', '', 1);
INSERT INTO `inspection_record` VALUES (1854445901138997250, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/F536FA99E35545B195997F0EA242F21F.jpg', 9, NULL, '2024-11-07 16:48:50', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804775', '22.676985', '永福路', '福海街道', 'BAQ-YFL-20241107164850', '', 1);
INSERT INTO `inspection_record` VALUES (1854445911536676866, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/11C0DBA1375E45A8B16270143F1EF902.jpg', 10, NULL, '2024-11-07 16:48:53', '2024-11-09 17:18:09', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.804775', '22.676985', '永福路', '福海街道', 'BAQ-YFL-20241107164853', '', 1);
INSERT INTO `inspection_record` VALUES (1854445926359347202, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/45FE516CD8A34C0E9A30AEB410CDF33A.jpg', 11, NULL, '2024-11-07 16:48:56', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804775', '22.676985', '永福路', '福海街道', 'BAQ-YFL-20241107164856', '', 1);
INSERT INTO `inspection_record` VALUES (1854445935926554625, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/E36265EA29A1457A93C75143887274B8.jpg', 12, NULL, '2024-11-07 16:48:59', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804775', '22.676985', '永福路', '福海街道', 'BAQ-YFL-20241107164859', '', 1);
INSERT INTO `inspection_record` VALUES (1854445949453185025, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/00275C8FD00148C5A0B8745A3345A32D.jpg', 13, NULL, '2024-11-07 16:49:02', '2024-11-09 17:18:09', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.804775', '22.676985', '永福路', '福海街道', 'BAQ-YFL-20241107164902', '', 1);
INSERT INTO `inspection_record` VALUES (1854445963395051522, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/6815626EC4B84B26A24416625D454432.jpg', 14, NULL, '2024-11-07 16:49:05', '2024-11-09 17:18:09', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.804775', '22.676985', '永福路', '福海街道', 'BAQ-YFL-20241107164905', '', 1);
INSERT INTO `inspection_record` VALUES (1854445972576382978, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/7423A03F500D412AB63D23C327E06154.jpg', 15, NULL, '2024-11-07 16:49:08', '2024-11-09 17:18:09', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.804775', '22.676985', '永福路', '福海街道', 'BAQ-YFL-20241107164908', '', 1);
INSERT INTO `inspection_record` VALUES (1854445987742986241, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/E4C2E14F29FC443F96DB062BA5C749A0.jpg', 16, NULL, '2024-11-07 16:49:11', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804775', '22.676985', '永福路', '福海街道', 'BAQ-YFL-20241107164911', '', 1);
INSERT INTO `inspection_record` VALUES (1854446001592578049, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/A097D09516DC41FAB375E45F886CF013.jpg', 17, NULL, '2024-11-07 16:49:14', '2024-11-09 17:18:09', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.804859', '22.676927', '永福路', '福海街道', 'BAQ-YFL-20241107164914', '', 1);
INSERT INTO `inspection_record` VALUES (1854447481837957122, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/D8EF8BECAAA4458889907DBFA25553D9.jpg', 3, NULL, '2024-11-07 16:55:07', '2024-11-09 17:18:09', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.804764', '22.676985', '永福路', '福海街道', 'BAQ-YFL-20241107165507', '', 1);
INSERT INTO `inspection_record` VALUES (1854448149067837441, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/A5DDA2966E5942CA85E1769ED34910C4.jpg', 3, NULL, '2024-11-07 16:57:46', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.80477', '22.677', '永福路', '福海街道', 'BAQ-YFL-20241107165746', '', 1);
INSERT INTO `inspection_record` VALUES (1854448490115084290, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/5A7E464EC9DD468B87152FCE5C1DC125.jpg', 15, NULL, '2024-11-07 16:59:07', '2024-11-09 17:18:09', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.804852', '22.676967', '永福路', '福海街道', 'BAQ-YFL-20241107165907', '', 1);
INSERT INTO `inspection_record` VALUES (1854448601654210561, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/2A45B0EC94104255801021C9D858FB2B.jpg', 3, NULL, '2024-11-07 16:59:34', '2024-11-09 17:18:09', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.804852', '22.676967', '永福路', '福海街道', 'BAQ-YFL-20241107165934', '', 1);
INSERT INTO `inspection_record` VALUES (1854449861660880898, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/6330A3C292F5469B8C7F4EEFC1FF21B0.jpg', 1, NULL, '2024-11-07 17:04:34', '2024-11-09 17:18:09', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.804764', '22.676986', '永福路', '福海街道', 'BAQ-YFL-20241107170434', '', 1);
INSERT INTO `inspection_record` VALUES (1854712672385449986, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/AF361877487F409E912843D592B7EB04.jpg', 1, NULL, '2024-11-08 10:28:52', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804755', '22.677013', '永福路', '福海街道', 'BAQ-YFL-20241108102852', '', 1);
INSERT INTO `inspection_record` VALUES (1854714230430973953, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/5CBC98E945CA4DF7969BC3717D2308BA.jpg', 1, NULL, '2024-11-08 10:35:04', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804772', '22.677033', '永福路', '福海街道', 'BAQ-YFL-20241108103504', '', 1);
INSERT INTO `inspection_record` VALUES (1854789472968945665, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/DBD6D8C80BF54A4AAB35D5598135375B.jpg', 1, NULL, '2024-11-08 15:34:04', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804766', '22.676966', '永福路', '福海街道', 'BAQ-YFL-20241108153404', '', 1);
INSERT INTO `inspection_record` VALUES (1854789708776910849, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/882ACE435B934E028C2A4A7CD29A54C9.jpg', 1, NULL, '2024-11-08 15:35:00', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804772', '22.677038', '永福路', '福海街道', 'BAQ-YFL-20241108153500', '', 1);
INSERT INTO `inspection_record` VALUES (1854789985500311553, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/D8DA92781B9941D3B862EDCA39C18D3D.jpg', 13, NULL, '2024-11-08 15:36:06', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804765', '22.676971', '永福路', '福海街道', 'BAQ-YFL-20241108153606', '', 1);
INSERT INTO `inspection_record` VALUES (1854790012683595777, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/5879B6B0BB8347EAA00162860022F12B.jpg', 13, NULL, '2024-11-08 15:36:12', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804765', '22.676971', '永福路', '福海街道', 'BAQ-YFL-20241108153612', '', 1);
INSERT INTO `inspection_record` VALUES (1854790065896730625, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/FCF88A9E95584047A5FF1EA7C2CB8CF8.jpg', 13, NULL, '2024-11-08 15:36:25', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804765', '22.676971', '永福路', '福海街道', 'BAQ-YFL-20241108153625', '', 1);
INSERT INTO `inspection_record` VALUES (1854790184184492033, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/3ECA0A945E9D40D5A04098D42DC78813.jpg', 13, NULL, '2024-11-08 15:36:54', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804766', '22.676933', '永福路', '福海街道', 'BAQ-YFL-20241108153654', '', 1);
INSERT INTO `inspection_record` VALUES (1854790273279897601, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/9ECA7C12D0D74877916A750354F55B81.jpg', 13, NULL, '2024-11-08 15:37:14', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804765', '22.676973', '永福路', '福海街道', 'BAQ-YFL-20241108153714', '', 1);
INSERT INTO `inspection_record` VALUES (1854790365902712833, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/1624139B98384A51A1ECDBC1104FAC1E.jpg', 13, NULL, '2024-11-08 15:37:36', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804765', '22.676973', '永福路', '福海街道', 'BAQ-YFL-20241108153736', '', 1);
INSERT INTO `inspection_record` VALUES (1854790399247429633, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/F28D4FC777684B798CDF710E13F889E6.jpg', 13, NULL, '2024-11-08 15:37:45', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.80477', '22.676954', '永福路', '福海街道', 'BAQ-YFL-20241108153745', '', 1);
INSERT INTO `inspection_record` VALUES (1854790434282450946, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/B61E1B5CD6524BFAA134C21A63DED9A8.jpg', 13, NULL, '2024-11-08 15:37:53', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.80477', '22.676954', '永福路', '福海街道', 'BAQ-YFL-20241108153753', '', 1);
INSERT INTO `inspection_record` VALUES (1854790458546499585, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/8823F65733624BA394F660877AB5AC7B.jpg', 13, NULL, '2024-11-08 15:37:59', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.80477', '22.676954', '永福路', '福海街道', 'BAQ-YFL-20241108153759', '', 1);
INSERT INTO `inspection_record` VALUES (1854793232881463298, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/967EB410C70D49A9A14A4391B1379D26.jpg', 1, NULL, '2024-11-08 15:49:00', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804758', '22.676961', '永福路', '福海街道', 'BAQ-YFL-20241108154900', '', 1);
INSERT INTO `inspection_record` VALUES (1854816149444845569, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/293D04F9DD39433DAF2C879948ACF04C.jpg', 1, NULL, '2024-11-08 17:20:04', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804764', '22.676993', '永福路', '福海街道', 'BAQ-YFL-20241108172004', '', 1);
INSERT INTO `inspection_record` VALUES (1854816209276592129, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/B7B037C496D1452CB6E835464D2F853B.jpg', 1, NULL, '2024-11-08 17:20:19', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804764', '22.676993', '永福路', '福海街道', 'BAQ-YFL-20241108172019', '', 1);
INSERT INTO `inspection_record` VALUES (1854816293296889857, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/4A72803D038344E9B91B8A5757913247.jpg', 1, NULL, '2024-11-08 17:20:39', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804764', '22.676993', '永福路', '福海街道', 'BAQ-YFL-20241108172039', '', 1);
INSERT INTO `inspection_record` VALUES (1854816406786367490, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/E755B26984994F349EDA4AD8FDE4D66F.jpg', 1, NULL, '2024-11-08 17:21:05', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804759', '22.676975', '永福路', '福海街道', 'BAQ-YFL-20241108172105', '', 1);
INSERT INTO `inspection_record` VALUES (1854816732289523714, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/7B7E4683D7C949C6B795E2979416D972.jpg', 1, NULL, '2024-11-08 17:22:23', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804764', '22.676993', '永福路', '福海街道', 'BAQ-YFL-20241108172223', '', 1);
INSERT INTO `inspection_record` VALUES (1854816980663623681, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/C380A99CA7D148169A7FE01674EC594A.jpg', 1, NULL, '2024-11-08 17:23:19', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804767', '22.676928', '永福路', '福海街道', 'BAQ-YFL-20241108172319', '', 1);
INSERT INTO `inspection_record` VALUES (1854817175610679298, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/4AF49195C52A40ED8AD648178DE53948.jpg', 1, NULL, '2024-11-08 17:24:07', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804863', '22.676764', '永福路', '福海街道', 'BAQ-YFL-20241108172407', '', 1);
INSERT INTO `inspection_record` VALUES (1854817320771346434, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/A9E6860E076F424B9A13B00676EA8ECB.jpg', 1, NULL, '2024-11-08 17:24:42', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804765', '22.677006', '永福路', '福海街道', 'BAQ-YFL-20241108172442', '', 1);
INSERT INTO `inspection_record` VALUES (1854817370561929218, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/F5FEF0B227D848989348BD0423B60B70.jpg', 1, NULL, '2024-11-08 17:24:55', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804771', '22.677011', '永福路', '福海街道', 'BAQ-YFL-20241108172455', '', 1);
INSERT INTO `inspection_record` VALUES (1854817545955139586, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/81A733C2D6784CD49BEFBF99C2998369.jpg', 1, NULL, '2024-11-08 17:25:35', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.80484', '22.676995', '永福路', '福海街道', 'BAQ-YFL-20241108172535', '', 1);
INSERT INTO `inspection_record` VALUES (1854817733771878402, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/751E3C43A1BC4BD7929D9D073A1DAA9E.jpg', 1, NULL, '2024-11-08 17:26:21', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804762', '22.676953', '永福路', '福海街道', 'BAQ-YFL-20241108172621', '', 1);
INSERT INTO `inspection_record` VALUES (1854817772158148610, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/344BAD9CEFFD48678A81B6C6CA296740.jpg', 1, NULL, '2024-11-08 17:26:30', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804764', '22.676991', '永福路', '福海街道', 'BAQ-YFL-20241108172630', '', 1);
INSERT INTO `inspection_record` VALUES (1854817869294034945, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/96AF0B8F679B4368AA6D6818E089AB84.jpg', 1, NULL, '2024-11-08 17:26:54', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804762', '22.67697', '永福路', '福海街道', 'BAQ-YFL-20241108172654', '', 1);
INSERT INTO `inspection_record` VALUES (1854817887577006082, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/AA3E8F52F11445D9B4192780A14DA2C5.jpg', 1, NULL, '2024-11-08 17:26:58', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804755', '22.676994', '永福路', '福海街道', 'BAQ-YFL-20241108172658', '', 1);
INSERT INTO `inspection_record` VALUES (1854817905054670850, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/6017846C59AB4DDA9CF6EA070646CAB6.jpg', 1, NULL, '2024-11-08 17:27:02', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804755', '22.676994', '永福路', '福海街道', 'BAQ-YFL-20241108172702', '', 1);
INSERT INTO `inspection_record` VALUES (1854817921768972289, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/FE82267ED08C426F9939D94C6445EE1D.jpg', 1, NULL, '2024-11-08 17:27:06', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804755', '22.676994', '永福路', '福海街道', 'BAQ-YFL-20241108172706', '', 1);
INSERT INTO `inspection_record` VALUES (1854828209656471554, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/FDB90A54F94446149F76B298FB501FE8.jpg', 1, NULL, '2024-11-08 18:08:00', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804761', '22.676986', '永福路', '福海街道', 'BAQ-YFL-20241108180800', '', 1);
INSERT INTO `inspection_record` VALUES (1854829013289312258, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/9F5DBE99BFF84185B3FEAD044227D52D.jpg', 1, NULL, '2024-11-08 18:11:12', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804765', '22.677028', '永福路', '福海街道', 'BAQ-YFL-20241108181112', '', 1);
INSERT INTO `inspection_record` VALUES (1854829299315679233, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/74E1FE5F4E7D47BD992D50CFB5844148.jpg', 1, NULL, '2024-11-08 18:12:19', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804753', '22.676997', '永福路', '福海街道', 'BAQ-YFL-20241108181219', '', 1);
INSERT INTO `inspection_record` VALUES (1854829471546384386, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/9A7024479AF04215B10B2F79C4B2588B.jpg', 1, NULL, '2024-11-08 18:13:00', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804753', '22.676997', '永福路', '福海街道', 'BAQ-YFL-20241108181300', '', 1);
INSERT INTO `inspection_record` VALUES (1854829722382508033, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/D132D88A38A94F398AD71D4C63AFD8FE.jpg', 1, NULL, '2024-11-08 18:14:01', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804755', '22.676955', '永福路', '福海街道', 'BAQ-YFL-20241108181401', '', 1);
INSERT INTO `inspection_record` VALUES (1854830025987203073, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/32A085532436432C85E18DB8681F264F.jpg', 1, NULL, '2024-11-08 18:15:13', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804746', '22.677001', '永福路', '福海街道', 'BAQ-YFL-20241108181513', '', 1);
INSERT INTO `inspection_record` VALUES (1854830062465064961, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/4D43545DE6C942B59D246C919FB5E101.jpg', 1, NULL, '2024-11-08 18:15:21', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804746', '22.677001', '永福路', '福海街道', 'BAQ-YFL-20241108181521', '', 1);
INSERT INTO `inspection_record` VALUES (1854830532092895234, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/2AB2B81F27EC4587A641C9240DE06F5D.jpg', 1, NULL, '2024-11-08 18:17:13', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804749', '22.676982', '永福路', '福海街道', 'BAQ-YFL-20241108181713', '', 1);
INSERT INTO `inspection_record` VALUES (1854830559230042113, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/D7DDAE1B24EE475B909BF6B09AE2EF4E.jpg', 1, NULL, '2024-11-08 18:17:19', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804749', '22.676982', '永福路', '福海街道', 'BAQ-YFL-20241108181719', '', 1);
INSERT INTO `inspection_record` VALUES (1854830579886989314, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/2D50EEA75AE54966B081CE5EE0E50F5A.jpg', 1, NULL, '2024-11-08 18:17:23', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804755', '22.676955', '永福路', '福海街道', 'BAQ-YFL-20241108181723', '', 1);
INSERT INTO `inspection_record` VALUES (1854835135857434625, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/B5A4A19DD88E4DD0A29AAA2C7954D5CB.jpg', 1, NULL, '2024-11-08 18:35:31', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804752', '22.676988', '永福路', '福海街道', 'BAQ-YFL-20241108183531', '', 1);
INSERT INTO `inspection_record` VALUES (1854835842656378882, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/BB855EB4E0D043619096823DD956F30F.jpg', 1, NULL, '2024-11-08 18:38:19', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804758', '22.677013', '永福路', '福海街道', 'BAQ-YFL-20241108183819', '', 1);
INSERT INTO `inspection_record` VALUES (1854840886789349377, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/B2E245C46C1548BD9B6E4429995D4DEE.jpg', 1, NULL, '2024-11-08 18:58:22', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804831', '22.676938', '永福路', '福海街道', 'BAQ-YFL-20241108185822', '', 1);
INSERT INTO `inspection_record` VALUES (1854841027046875138, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/7B735895883D4BF8A5D650F4A0CA016C.jpg', 1, NULL, '2024-11-08 18:58:56', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804831', '22.676938', '永福路', '福海街道', 'BAQ-YFL-20241108185856', '', 1);
INSERT INTO `inspection_record` VALUES (1854841061029126146, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/4DBCBAC7E36B483CA77EE7B727C0ACDF.jpg', 1, NULL, '2024-11-08 18:59:03', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804861', '22.676942', '永福路', '福海街道', 'BAQ-YFL-20241108185903', '', 1);
INSERT INTO `inspection_record` VALUES (1854853999349669889, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/47FB6C10868B4046A069CFADD702491B.jpg', 3, NULL, '2024-11-08 19:50:29', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804762', '22.677002', '永福路', '福海街道', 'BAQ-YFL-20241108195029', '', 1);
INSERT INTO `inspection_record` VALUES (1855081118719639553, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/D34282F6322F4B679B0B79C5A46FBDE9.jpg', 1, NULL, '2024-11-09 10:52:56', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804843', '22.677012', '永福路', '福海街道', 'BAQ-YFL-20241109105256', '', 1);
INSERT INTO `inspection_record` VALUES (1855081183970426882, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/6C4699DBD3CB4DBDA6045936CC33E8A6.jpg', 1, NULL, '2024-11-09 10:53:12', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804843', '22.677012', '永福路', '福海街道', 'BAQ-YFL-20241109105312', '', 1);
INSERT INTO `inspection_record` VALUES (1855081287783645185, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/C368C1A4649840DAAEA80F2A990B7B31.jpg', 1, NULL, '2024-11-09 10:53:37', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804764', '22.677045', '永福路', '福海街道', 'BAQ-YFL-20241109105337', '', 1);
INSERT INTO `inspection_record` VALUES (1855081308037939202, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/E5603AAADCEB4594BC62D53B8C0370A8.jpg', 1, NULL, '2024-11-09 10:53:42', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804803', '22.676993', '永福路', '福海街道', 'BAQ-YFL-20241109105342', '', 1);
INSERT INTO `inspection_record` VALUES (1855081359892119553, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/ABE8B5FC23F8413D8702B0607572B732.jpg', 1, NULL, '2024-11-09 10:53:54', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804803', '22.676993', '永福路', '福海街道', 'BAQ-YFL-20241109105354', '', 1);
INSERT INTO `inspection_record` VALUES (1855081379508879362, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/54D3F5299B974ECFB2DEE0B19481C8FC.jpg', 1, NULL, '2024-11-09 10:53:59', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804862', '22.676929', '永福路', '福海街道', 'BAQ-YFL-20241109105359', '', 1);
INSERT INTO `inspection_record` VALUES (1855081396479033346, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/1089D7B902EC4A1780734127FF854B6D.jpg', 1, NULL, '2024-11-09 10:54:03', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804862', '22.676929', '永福路', '福海街道', 'BAQ-YFL-20241109105403', '', 1);
INSERT INTO `inspection_record` VALUES (1855081536178716673, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/0B05B5A2E78A4F5187E921768B7262E9.jpg', 1, NULL, '2024-11-09 10:54:36', '2024-11-09 17:18:09', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804862', '22.676929', '永福路', '福海街道', 'BAQ-YFL-20241109105436', '', 1);
INSERT INTO `inspection_record` VALUES (1855081555141165058, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/6BA5CBC12E38489F841CFDC6ACF0BA44.jpg', 1, NULL, '2024-11-09 10:54:41', '2024-11-09 17:18:10', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804757', '22.677039', '永福路', '福海街道', 'BAQ-YFL-20241109105441', '', 1);
INSERT INTO `inspection_record` VALUES (1855081576649555970, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/19346776873E4943B07758CFCE8DFFEE.jpg', 1, NULL, '2024-11-09 10:54:46', '2024-11-09 17:18:10', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804757', '22.677039', '永福路', '福海街道', 'BAQ-YFL-20241109105446', '', 1);
INSERT INTO `inspection_record` VALUES (1855081595641364481, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/350AB780E0574FF6AB19160A94A157A7.jpg', 1, NULL, '2024-11-09 10:54:50', '2024-11-09 17:18:10', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804814', '22.676966', '永福路', '福海街道', 'BAQ-YFL-20241109105450', '', 1);
INSERT INTO `inspection_record` VALUES (1855081613068697602, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/0923277C2D53493787C1D8A7E6FDD9CC.jpg', 1, NULL, '2024-11-09 10:54:54', '2024-11-09 17:18:10', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804814', '22.676966', '永福路', '福海街道', 'BAQ-YFL-20241109105454', '', 1);
INSERT INTO `inspection_record` VALUES (1855171875921780738, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/1645BCA6D9534EB1AC327F5D1D54D351.jpg', 3, NULL, '2024-11-09 16:53:35', '2024-11-09 17:18:10', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804767', '22.677022', '永福路', '福海街道', 'BAQ-YFL-20241109165335', '', 1);
INSERT INTO `inspection_record` VALUES (1855171979764359170, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/7353CA1F3C074FD99AF36EDC0853F819.jpg', 3, NULL, '2024-11-09 16:54:00', '2024-11-09 17:18:10', '粤A88888', 0, 1844669233467969538, '测试路线2', '113.804767', '22.677022', '永福路', '福海街道', 'BAQ-YFL-20241109165400', '', 1);
INSERT INTO `inspection_record` VALUES (1855172553125715969, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/B46BC899E31949B3BE6330D94B02023F.jpg', 3, NULL, '2024-11-09 16:56:18', '2024-11-09 17:18:10', '粤A88888', 1, 1844669233467969538, '测试路线2', '113.804763', '22.677006', '永福路', '福海街道', 'BAQ-YFL-20241109165618', '', 1);
INSERT INTO `inspection_record` VALUES (1855183865022500865, '测试设备', '88887777', '1855133471796375554', 'http://192.168.34.155:6679/image/CE19881BE4964548B00939AAC832A836.jpg', 1, NULL, '2024-11-09 17:41:14', '2024-11-09 17:41:15', '粤A88888', 1, 1855171411314532353, '测试', '113.804752', '22.677037', '永福路', '福海街道', 'BAQ-YFL-20241109174114', '', 1);
INSERT INTO `inspection_record` VALUES (1855939254793986049, '测速设备', '.001', '1855938062860869634', 'http://192.168.34.155:6679/image/71D4D7BFC5314C7F998C891F0D287A21.jpg', 1, NULL, '2024-11-11 19:42:54', '2024-11-11 19:42:54', '粤BH25957', 0, 1855938325554323457, '小林-杨工', '113.80477', '22.677048', '永福路', '福海街道', 'BAQ-YFL-20241111194254', '', 4);
INSERT INTO `inspection_record` VALUES (1855939332493467649, '测速设备', '.001', '1855938062860869634', 'http://192.168.34.155:6679/image/2E0314F5D2E542CC8747504F810A8231.jpg', 1, NULL, '2024-11-11 19:43:11', '2024-11-11 19:43:13', '粤BH25957', 0, 1855938325554323457, '小林-杨工', '113.80477', '22.677048', '永福路', '福海街道', 'BAQ-YFL-20241111194311', '', 4);
INSERT INTO `inspection_record` VALUES (1856146006995034114, '测速设备', '.001', '1855938062860869634', 'http://192.168.34.155:6679/image/9431F457EF234509802A87F154A03218.jpg', 1, NULL, '2024-11-12 09:24:27', '2024-11-12 09:24:28', '粤BH25957', 0, 1855938325554323457, '小林-杨工', '113.804773', '22.677016', '永福路', '福海街道', 'BAQ-YFL-20241112092427', '', 4);
INSERT INTO `inspection_record` VALUES (1856146100066639873, '测速设备', '.001', '1855938062860869634', 'http://192.168.34.155:6679/image/29975B5C9DC14E908A0D385CE7FA177B.jpg', 1, NULL, '2024-11-12 09:24:49', '2024-11-12 09:24:50', '粤BH25957', 0, 1855938325554323457, '小林-杨工', '113.804773', '22.677016', '永福路', '福海街道', 'BAQ-YFL-20241112092449', '', 4);
INSERT INTO `inspection_record` VALUES (1856146319705563138, '测速设备', '.001', '1855938062860869634', 'http://192.168.34.155:6679/image/6B6D73136B2046298E13B59C4EFDB15D.jpg', 1, NULL, '2024-11-12 09:25:40', '2024-11-12 09:25:42', '粤BH25957', 0, 1855938325554323457, '小林-杨工', '113.804767', '22.677303', '永福路', '福海街道', 'BAQ-YFL-20241112092540', '', 4);
-- ----------------------------
-- Table structure for inspection_route
-- ----------------------------
DROP TABLE IF EXISTS `inspection_route`;
CREATE TABLE `inspection_route` (
`id` bigint(35) NOT NULL COMMENT '路线ID',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '路线名称',
`extent` decimal(20, 5) NULL DEFAULT NULL COMMENT '路线长度',
`route_config` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '路线配置',
`inspection_user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '巡检人员',
`inspection_dev_id` bigint(35) NULL DEFAULT NULL COMMENT '巡检设备ID',
`street` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属街道',
`region` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属区域',
`tenant_id` int(11) NULL DEFAULT NULL COMMENT '租户ID',
`create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人ID',
`inspection_num` int(11) NULL DEFAULT 0 COMMENT '巡检次数',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of inspection_route
-- ----------------------------
INSERT INTO `inspection_route` VALUES (1855908364210663425, '佳信捷-1', 3510.62000, '[{\"Q\":22.557884257029404,\"R\":113.88409467861055,\"lng\":113.884095,\"lat\":22.557884},{\"Q\":22.567237090992514,\"R\":113.89460893794893,\"lng\":113.894609,\"lat\":22.567237},{\"Q\":22.563353364075063,\"R\":113.89808508083223,\"lng\":113.898085,\"lat\":22.563353},{\"Q\":22.554911825282403,\"R\":113.88735624477266,\"lng\":113.887356,\"lat\":22.554912}]', '1855908044717944833', NULL, '福永街道-1', '宝安区', 1, '1855902726956965889', 0);
INSERT INTO `inspection_route` VALUES (1855908536877576194, '佳信捷-2', 5162.97000, '[{\"Q\":22.55519431804188,\"R\":114.07229992076753,\"lng\":114.0723,\"lat\":22.555194},{\"Q\":22.555669910451723,\"R\":114.10491558238863,\"lng\":114.104916,\"lat\":22.55567},{\"Q\":22.539419574250488,\"R\":114.10448642894625,\"lng\":114.104486,\"lat\":22.53942}]', '1855908185780776962', NULL, '福永街道-2', '宝安区', 1, '1855902726956965889', 0);
INSERT INTO `inspection_route` VALUES (1855909697915449346, '太和广业-1', 5060.67000, '[{\"Q\":22.555035786874225,\"R\":114.07401653453707,\"lng\":114.074017,\"lat\":22.555036},{\"Q\":22.556383295992045,\"R\":114.10508724376558,\"lng\":114.105087,\"lat\":22.556383},{\"Q\":22.539657397844124,\"R\":114.10448642894625,\"lng\":114.104486,\"lat\":22.539657}]', '1855909479882944513', NULL, '福永街道', '宝安区', 2, '1855901544855298049', 0);
INSERT INTO `inspection_route` VALUES (1855909786578841602, '太和广业', 4856.22000, '[{\"Q\":22.554877255524396,\"R\":114.07264324352144,\"lng\":114.072643,\"lat\":22.554877},{\"Q\":22.540133043802335,\"R\":114.07341571971773,\"lng\":114.073416,\"lat\":22.540133},{\"Q\":22.54076723586402,\"R\":114.1046580903232,\"lng\":114.104658,\"lat\":22.540767}]', '1855909573738885122', NULL, '福永街道', '宝安区', 2, '1855901544855298049', 0);
INSERT INTO `inspection_route` VALUES (1855938325554323457, '小林-杨工', 481.43000, '[{\"Q\":22.557215578174972,\"R\":113.87787194967268,\"lng\":113.877872,\"lat\":22.557216},{\"Q\":22.560069066223004,\"R\":113.88139100790022,\"lng\":113.881391,\"lat\":22.560069}]', '1855938062860869634', 1855938922928070658, '福永大道', '宝安区', 4, '1855937468725125121', 0);
INSERT INTO `inspection_route` VALUES (1857267225156890626, '测试-2', 4107.48000, '[{\"Q\":22.721947164351956,\"R\":113.76485438928012,\"lng\":113.764854,\"lat\":22.721947},{\"Q\":22.685682782987424,\"R\":113.7722358284891,\"lng\":113.772236,\"lat\":22.685683}]', '1855902726956965889', NULL, '福永街道', '宝安区', 1, '1', 0);
-- ----------------------------
-- Table structure for inspection_user
-- ----------------------------
DROP TABLE IF EXISTS `inspection_user`;
CREATE TABLE `inspection_user` (
`id` bigint(35) NOT NULL COMMENT '巡检人员ID',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '巡检人员姓名',
`unit` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所在单位',
`phone_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号',
`email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱',
`state` int(1) NULL DEFAULT NULL COMMENT '状态',
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
`tenant_id` int(11) NULL DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of inspection_user
-- ----------------------------
-- ----------------------------
-- Table structure for project
-- ----------------------------
DROP TABLE IF EXISTS `project`;
CREATE TABLE `project` (
`id` bigint(35) NOT NULL AUTO_INCREMENT COMMENT '项目ID',
`p_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目名称',
`lng` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '经度',
`lat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '纬度',
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
`update_time` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of project
-- ----------------------------
INSERT INTO `project` VALUES (1, '佳信捷', NULL, NULL, '2024-11-11 16:32:48', '2024-11-11 17:00:58');
INSERT INTO `project` VALUES (2, '123', NULL, NULL, '2024-11-11 17:14:01', NULL);
INSERT INTO `project` VALUES (4, '林工项目', NULL, NULL, '2024-11-11 19:35:06', NULL);
-- ----------------------------
-- Table structure for system_config
-- ----------------------------
DROP TABLE IF EXISTS `system_config`;
CREATE TABLE `system_config` (
`config_id` int(5) NOT NULL AUTO_INCREMENT COMMENT '参数主键',
`config_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '参数名称',
`config_key` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '参数键名',
`config_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '参数分类',
`config_value_type` int(1) NULL DEFAULT NULL COMMENT '参数值类型（1:文字描述;2:图片）',
`config_value` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '参数键值',
`remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
`tenant_id` int(11) NULL DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (`config_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 191 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '参数配置表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of system_config
-- ----------------------------
INSERT INTO `system_config` VALUES (190, '是否接收推送', 'iot-mqtt', NULL, 1, '{\"a\":true,\"b\":true,\"c\":0.00035}', NULL, 1);
-- ----------------------------
-- Table structure for system_dict_data
-- ----------------------------
DROP TABLE IF EXISTS `system_dict_data`;
CREATE TABLE `system_dict_data` (
`dict_code` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典编码',
`dict_sort` int(4) NULL DEFAULT 0 COMMENT '字典排序',
`dict_label` int(11) NULL DEFAULT NULL COMMENT '字典标签',
`dict_value` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '字典名称',
`dict_type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '字典类型（代码中用此字段取值）',
`is_default` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'N' COMMENT '是否默认（Y是 N否）',
`status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '状态（0停用 1正常）',
`remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`dict_code`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 38 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '字典数据表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of system_dict_data
-- ----------------------------
INSERT INTO `system_dict_data` VALUES (1, 1, 1, '坑洞', 'alarm_type', 'N', '1', '', '2023-11-28 16:50:52');
INSERT INTO `system_dict_data` VALUES (2, 2, 2, '鳄鱼裂缝', 'alarm_type', 'N', '1', '', '2023-11-30 14:08:23');
INSERT INTO `system_dict_data` VALUES (3, 3, 3, '纵向裂纹', 'alarm_type', 'N', '1', '', '2023-11-30 14:08:23');
INSERT INTO `system_dict_data` VALUES (4, 4, 4, '斜裂纹', 'alarm_type', 'N', '1', '', '2023-11-30 14:08:23');
INSERT INTO `system_dict_data` VALUES (5, 5, 5, '修补', 'alarm_type', 'N', '1', '', '2023-11-30 14:08:23');
INSERT INTO `system_dict_data` VALUES (6, 6, 6, '横向裂纹', 'alarm_type', 'N', '1', '', '2023-11-30 14:08:23');
INSERT INTO `system_dict_data` VALUES (7, 7, 7, '路面异物', 'alarm_type', 'N', '1', '', '2023-11-30 14:08:23');
INSERT INTO `system_dict_data` VALUES (8, 8, 8, '异常井盖', 'alarm_type', 'N', '1', '', '2023-11-30 14:08:23');
INSERT INTO `system_dict_data` VALUES (9, 9, 9, '沉陷/积水', 'alarm_type', 'N', '1', '', '2023-11-30 14:08:23');
INSERT INTO `system_dict_data` VALUES (10, 10, 10, '异常减速带', 'alarm_type', 'N', '1', '', '2023-11-30 14:08:23');
INSERT INTO `system_dict_data` VALUES (11, 11, 11, '标志牌', 'alarm_type', 'N', '1', '', '2023-11-30 14:08:23');
INSERT INTO `system_dict_data` VALUES (12, 12, 12, '车道线', 'alarm_type', 'N', '1', '', '2023-11-30 14:08:23');
INSERT INTO `system_dict_data` VALUES (13, 13, 13, '信号灯', 'alarm_type', 'N', '1', '', '2023-11-30 14:08:23');
INSERT INTO `system_dict_data` VALUES (14, 14, 14, '护栏', 'alarm_type', 'N', '1', '', '2023-11-30 14:08:23');
INSERT INTO `system_dict_data` VALUES (15, 15, 15, '隔离墩', 'alarm_type', 'N', '1', '', '2023-11-30 14:08:23');
INSERT INTO `system_dict_data` VALUES (16, 16, 16, '网碎', 'alarm_type', 'N', '1', '', '2023-11-30 14:08:23');
INSERT INTO `system_dict_data` VALUES (17, 17, 17, '路缘石', 'alarm_type', 'N', '1', '', '2023-11-30 14:08:23');
INSERT INTO `system_dict_data` VALUES (18, 1, 1, '一般', 'urgency_type', 'N', '1', '', '2024-11-05 14:48:45');
INSERT INTO `system_dict_data` VALUES (19, 2, 2, '严重', 'urgency_type', 'N', '1', '', '2024-11-05 14:48:45');
INSERT INTO `system_dict_data` VALUES (20, 3, 3, '紧急', 'urgency_type', 'N', '1', '', '2024-11-05 14:48:45');
INSERT INTO `system_dict_data` VALUES (21, 1, 1, '车辆巡检', 'poll_type', 'N', '1', '', '2024-11-05 14:48:45');
INSERT INTO `system_dict_data` VALUES (22, 2, 2, '人工巡检', 'poll_type', 'N', '1', '', '2023-11-28 16:50:52');
INSERT INTO `system_dict_data` VALUES (31, 4, 4, 'ceshi', 'urgency_type', 'N', '0', '', '2024-11-11 16:09:41');
INSERT INTO `system_dict_data` VALUES (33, 2, 1, '已维养', 'protect_type', 'N', '0', '', '2024-11-11 16:18:30');
INSERT INTO `system_dict_data` VALUES (34, 2, 2, '待维养', 'protect_type', 'N', '0', '', '2024-11-11 16:18:52');
INSERT INTO `system_dict_data` VALUES (36, 0, 1, 'AI盒子', 'eq_type', 'N', '0', '', '2024-11-11 18:02:13');
INSERT INTO `system_dict_data` VALUES (37, 1, 1, '佳信捷团队', 'team_type', 'N', '0', '', '2024-11-11 18:04:38');
-- ----------------------------
-- Table structure for system_dict_type
-- ----------------------------
DROP TABLE IF EXISTS `system_dict_type`;
CREATE TABLE `system_dict_type` (
`dict_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典主键',
`dict_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '字典名称',
`dict_type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '字典类型（代码中用此字段取值）',
`status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '状态（0停用 1正常）',
`remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`dict_id`) USING BTREE,
UNIQUE INDEX `dict_type`(`dict_type`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '字典类型表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of system_dict_type
-- ----------------------------
INSERT INTO `system_dict_type` VALUES (1, '预警类型', 'alarm_type', '1', NULL, '2024-11-11 16:12:10');
INSERT INTO `system_dict_type` VALUES (2, '紧急程度', 'urgency_type', '1', NULL, '2024-11-05 14:48:22');
INSERT INTO `system_dict_type` VALUES (3, '巡检类型', 'poll_type', '1', NULL, '2024-11-05 14:48:22');
INSERT INTO `system_dict_type` VALUES (8, '维养状态', 'protect_type', '0', '', '2024-11-11 16:08:36');
INSERT INTO `system_dict_type` VALUES (9, '设备类型', 'eq_type', '0', '', '2024-11-11 18:01:22');
INSERT INTO `system_dict_type` VALUES (10, '团队管理', 'team_type', '0', '', '2024-11-11 18:04:18');
-- ----------------------------
-- Table structure for system_user
-- ----------------------------
DROP TABLE IF EXISTS `system_user`;
CREATE TABLE `system_user` (
`user_id` bigint(35) NOT NULL COMMENT '主键',
`account` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录账号',
`password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录密码',
`show_password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '明文密码',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`real_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '人员姓名',
`user_tel` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '人员电话',
`sn` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '政务、企业或项目sn',
`external_account` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '外部第三方账号',
`client_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机唯一识别码id',
`is_manager` tinyint(1) NULL DEFAULT 0 COMMENT '是否为管理员账号',
`state` int(2) NULL DEFAULT 1 COMMENT '状态(0:停用；1:启用)',
`sex` int(1) NULL DEFAULT NULL COMMENT '性别(0女;1男)',
`remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',
`create_by` bigint(35) NULL DEFAULT NULL COMMENT '创建人ID',
`tenant_id` int(11) NULL DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (`user_id`) USING BTREE,
UNIQUE INDEX `account_idx`(`account`) USING BTREE,
INDEX `idx_sn`(`sn`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统用户表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of system_user
-- ----------------------------
INSERT INTO `system_user` VALUES (1, 'admin', 'YKiZTpvXjW7gSOXmLR+m0A==', '123456', '2023-10-13 15:02:38', '管理员', '17373337333', NULL, NULL, '1', 1, 1, 1, '', NULL, 1);
INSERT INTO `system_user` VALUES (2, 'sadmin', '123456', '123456', '2023-10-13 15:02:38', '超级管理员', '17373337333', NULL, NULL, '1', 1, 1, NULL, '', NULL, NULL);
INSERT INTO `system_user` VALUES (1855900049237757953, 'pj', 'YKiZTpvXjW7gSOXmLR+m0A==', '123456', '2024-11-11 17:07:07', '彭工', '15222222222', NULL, NULL, NULL, 1, 1, 1, '', 2, 1);
INSERT INTO `system_user` VALUES (1855901544855298049, 'tmj', 'YKiZTpvXjW7gSOXmLR+m0A==', '123456', '2024-11-11 17:13:04', '汤工', '15222222222', NULL, NULL, NULL, 1, 1, 1, '', 2, 2);
INSERT INTO `system_user` VALUES (1855901619010592770, 'tl', 'YKiZTpvXjW7gSOXmLR+m0A==', '123456', '2024-11-11 17:13:22', '田雷', '15222222222', NULL, NULL, NULL, 1, 1, 1, '', 2, 2);
INSERT INTO `system_user` VALUES (1855902726956965889, 'qxh', 'YKiZTpvXjW7gSOXmLR+m0A==', '123456', '2024-11-11 17:17:46', '秦学海', '15220121111', NULL, NULL, NULL, 1, 1, 1, '', 2, 1);
INSERT INTO `system_user` VALUES (1855908044717944833, 'qxh1', 'YKiZTpvXjW7gSOXmLR+m0A==', '123456', '2024-11-11 17:38:54', '秦学海', '15220730439', NULL, NULL, NULL, 0, 1, 1, '', 1855902726956965889, 1);
INSERT INTO `system_user` VALUES (1855908185780776962, 'qxh2', 'YKiZTpvXjW7gSOXmLR+m0A==', '123456', '2024-11-11 17:39:27', '秦学海-2', '15222222222', NULL, NULL, NULL, 0, 1, 1, '', 1855902726956965889, 1);
INSERT INTO `system_user` VALUES (1855909479882944513, 'tmj1', 'YKiZTpvXjW7gSOXmLR+m0A==', '123456', '2024-11-11 17:44:36', '汤工-1', '15222222221', NULL, NULL, NULL, 0, 1, 1, '', 1855901544855298049, 2);
INSERT INTO `system_user` VALUES (1855909573738885122, 'tmj2', 'YKiZTpvXjW7gSOXmLR+m0A==', '123456', '2024-11-11 17:44:58', '唐工-2', '15222222201', NULL, NULL, NULL, 0, 1, 1, '', 1855901544855298049, 2);
INSERT INTO `system_user` VALUES (1855918213195550722, 'pj1', 'YKiZTpvXjW7gSOXmLR+m0A==', '123456', '2024-11-11 18:19:18', '彭工1', '15220212522', NULL, NULL, NULL, 0, 1, 1, '', 1855900049237757953, 1);
INSERT INTO `system_user` VALUES (1855937468725125121, 'lg', 'YKiZTpvXjW7gSOXmLR+m0A==', '123456', '2024-11-11 19:35:49', '林工-admin', '15223333333', NULL, NULL, NULL, 1, 1, 1, '', 2, 4);
INSERT INTO `system_user` VALUES (1855938062860869634, 'yj', 'YKiZTpvXjW7gSOXmLR+m0A==', '123456', '2024-11-11 19:38:11', '杨工', '15223222222', NULL, NULL, NULL, 0, 1, 0, '', 1855937468725125121, 4);
SET FOREIGN_KEY_CHECKS = 1;
Reference in New Issue Copy Permalink