admin/wisdomsite_road_java
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
wisdomsite_road_java/wisdomsite_road.sql
admin 875008b05a 数据库信息
2025-04-01 16:54:49 +08:00

536 lines
121 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

/*
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 View Git Blame Copy Permalink