巡检系统机器人模块交接内容
<h1>巡检系统中智能设备对接模块所使用相关技术介绍</h1>
<h2>巡视主机与智能设备交互流程</h2>
<p>下图摘抄自国网规范。</p>
<p><img src="https://www.showdoc.com.cn/server/api/attachment/visitFile?sign=876cfc8bd7914c6611a4cf6347cfc851&amp;file=file.png" alt="" /></p>
<h3>必要条件</h3>
<ul>
<li>和智能设备对接,必须开放10011端口给智能设备系统,固定不变。</li>
<li>智能设备所拍摄的照片、视频、音频、同步点位模型全部使用FTP方式发给巡检系统的10012端口,固定不变。</li>
<li>需要针对接入的智能设备系统开放相应的FTP账号和指定的空间。</li>
</ul>
<h3>信息类型</h3>
<p>大致分为以下几类:</p>
<ul>
<li>
<p>智能设备系统主动上报消息</p>
<ul>
<li>J.4.2 注册指令</li>
<li>J.4.3 心跳指令</li>
<li>监视类消息:</li>
<li>J.6.2 巡视设备状态数据</li>
<li>J.6.3 巡视设备运行数据</li>
<li>J.6.4 无人机机巢状态数据</li>
<li>J.6.5 无人机机巢运行数据</li>
<li>J.6.6 巡视设备坐标</li>
<li>J.6.7 巡视路线</li>
<li>J.6.8 巡视设备异常告警数据</li>
<li>J.6.9 环境数据</li>
<li>J.6.10 任务状态数据</li>
<li>J.6.11 巡视结果</li>
</ul>
</li>
<li>巡检系统下发给智能设备系统的下行消息
<ul>
<li>J.5.5 模型同步指令</li>
<li>J.5.2 机器人控制指令</li>
<li>J.5.3 无人机控制指令</li>
<li>J.5.4 任务控制指令</li>
<li>J.5.6 任务下发指令</li>
<li>J.5.7 检修区域下发指令</li>
</ul></li>
</ul>
<p>无论谁主动上报,对方收到后都会响应。尤其是巡检系统主动下发命令给智能设备系统时,通常都是请求某种资源,此时,智能设备系统会响应响应的资源给巡检系统,比如,响应报文中包含了某种资源的ftp文件相对路径,或者是某种要求智能设备系统执行操作的响应结果。</p>
<h2>巡检系统智能设备对接模块所使用技术</h2>
<p>整个巡检系统所使用的时web应通过springcloud搭建,只针对对接智能设备可以使用非springboot,纯spring+netty的方式搭建,但是为了更好的提供feign接口给其他服务,智能设备对接模块使用springboot来开发。</p>
<h2>代码简介</h2>
<h3>启动类</h3>
<p>启动类1:<code>com.cloud.smartdevice.Application</code>
无需多言,整个springboot项目的启动类,实现CommandLineRunner接口,重写run方法,在springboot程序启动完毕后,调用run方法,启动netty服务端程序,用于监控10011端口号。
启动类2:<code>com.cloud.smartdevice.NettyServer</code>
该类是个netty项目的模板类,就这么写,</p>
<h3>Feign接口类</h3>
<p>任务相关:<code>com.cloud.smartdevice.controller.TaskController</code>
机器人自身告警相关:<code>com.cloud.smartdevice.controller.SmartDeviceRobotMonitorWarnController(只有最后一个方法重要)</code>
机器人点位操作相关:
<code>com.cloud.smartdevice.controller.SmartDeviceModelSyncController ; com.cloud.smartdevice.controller.TranSmartDeviceModelPointController</code></p>
<p>机器人上报天气查询操作相关:<code>com.cloud.smartdevice.controller.SmartDeviceEnvController</code></p>
<h3>NettyServer类(无需改动)</h3>
<p>作为整个机器人对接TCP服务器的启动类,主要关注以下三行</p>
<pre><code class="language-java">//注册解码类(接收数据需要该类解码)
socketChannel.pipeline().addLast(new NettyDecoder());
//注册编码类(发送数据、响应对方发送的数据,需要它编码)
socketChannel.pipeline().addLast(new NettyEncoder());
//Handler类,所有接收到的消息,的业务逻辑处理入口,在这里判断是什么类型的数据,然后调用各自的方法进行业务逻辑处理。
socketChannel.pipeline().addLast(new SmartDeviceHandler());</code></pre>
<h3>解码类(无需改动)</h3>
<p>com.cloud.smartdevice.netty.coder.NettyDecoder</p>
<p>继承自ByteToMessageDecoder。主要任务是负责解析机器人系统上报的消息数据包、毡包粘包。
它把数据包解析成对象,交给SmartDeviceHandler处理具体业务</p>
<h3>编码类(无需改动)</h3>
<p>com.cloud.smartdevice.netty.coder.NettyEncoder</p>
<p>继承自MessageToByteEncoder。发送数据对应的Java对象解析成byte数组。</p>
<h3>SmartDeviceHandler类(可能需要完善)</h3>
<p>com.cloud.smartdevice.netty.handler.SmartDeviceHandler
NettyDecoder处理完的对象交给他来进行具体业务处理。
无人机相关操作、无人机机巢相关操作当时没有涉及到,日后如果有需要,在这里面扩展(参照其它响应数据处理方式)。</p>
<h2>表结构</h2>
<p>每一个表结构对应的都是 附录J中的一个报文的所对应的相关业务,具体字段和含义可以看数据库或者附录J,再次不再复述。</p>
<ul>
<li>tran_smartdevice_system_config 智能设备巡视系统配置表
<ul>
<li>该表内容需要在对接机器人系统之前维护好对应机器人系统的编码,以及要求对方上报 心跳、运行数据、环境数据、无人机机巢数据(如果有)的间隔频率,编码线下和对方对接。</li>
</ul></li>
</ul>
<pre><code class="language-sql"> CREATE TABLE `tran_smartdevice_system_config` (
`sysCode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '给该系统分配的编码,附录J中的机器人及无人机巡视系统唯一标识',
`sysType` tinyint DEFAULT NULL COMMENT '对接系统类型,1=无人机系统,2=机器人系统。。。',
`stationId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '变电站ID',
`sysName` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '对接系统名称',
`manufactor` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '系统厂家名称',
`createBy` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '创建者',
`createTime` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updateBy` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '更新者',
`updateTime` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`heartBeatInterval` tinyint DEFAULT NULL COMMENT '心跳秒',
`patroldeviceRunInterval` tinyint DEFAULT NULL COMMENT '巡视设备运行数据间隔 秒',
`nestRunInterval` tinyint DEFAULT NULL COMMENT '无人机机巢运行数据间隔 秒 (sysType=2时不需要响应该字段)',
`envInterval` tinyint DEFAULT NULL COMMENT '环境数据间隔 秒',
`status` tinyint DEFAULT '2' COMMENT '机器人无人机系统状态,1在线,2下线,默认值2',
`regStatus` tinyint DEFAULT '3' COMMENT '注册状态1成功,2失败,3未注册过,默认值3',
`heartBeatTime` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '上一次心跳时间',
PRIMARY KEY (`sysCode`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='智能设备巡视系统配置表';</code></pre>
<ul>
<li>tran_smartdevice_env 机器人系统上报的环境数据</li>
</ul>
<pre><code class="language-sql">CREATE TABLE `tran_smartdevice_env` (
`id` bigint NOT NULL AUTO_INCREMENT,
`sysCode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '无人机、机器人系统编号',
`stationId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '变电站ID',
`patrolDeviceCode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '无人机、机器人编号',
`patrolDeviceName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '报文时间',
`temp` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '环境温度,适用机器人和无人机',
`tempUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`wetness` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '环境湿度,适用机器人和无人机',
`wetnessUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`windSpeed` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '风速,适用机器人和无人机',
`windSpeedUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`rain` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '雨量,适用机器人和无人机',
`rainUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`wind` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '风向,适用机器人和无人机',
`windUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`pressure` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '气压,适用机器人和无人机',
`pressureUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`oxygen` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT ' 氧气 适用于机器人',
`oxygenUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`sf` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'sf6 氧气 适用于机器人',
`sfUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`createTime` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2804 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='J.6.9 环境数据';</code></pre>
<ul>
<li>tran_smartdevice_model_point 机器人点位同步表</li>
</ul>
<pre><code class="language-sql">CREATE TABLE `tran_smartdevice_model_point` (
`deviceId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '点位id',
`stationName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '变电站名称',
`stationId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '变电站编码',
`areaId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '区域 ID',
`areaName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '区域名称',
`bayId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '间隔 ID',
`bayName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '间隔名称',
`mainDeviceId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '主设备 ID',
`mainDeviceName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '主设备名称',
`componentId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '部件 ID',
`componentName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '部件名称',
`deviceName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '设备点位名称',
`deviceType` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '主设备类型',
`meterType` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '表计类型',
`appearanceType` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '辅助设施类型',
`saveTypeList` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '采集/保存文件类型列表',
`recognitionTypeList` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '识别类型列表',
`phase` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '相位',
`deviceInfo` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '备注信息',
`dataType` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '设备点位支持的数据来源',
`lowerValue` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '正常范围下限',
`upperValue` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '正常范围上限',
`videoPos` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '关联视频编码及预置位',
`createTime` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`pointId` int DEFAULT NULL COMMENT '祥云点位ID对应上面deviceId',
`partId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '祥云部位Id对应上面componentId',
`powerId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '祥云台账id对应上面mainDeviceId',
`unitId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '祥云间隔id对应上面bayId',
`xyAreaId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '祥云区域ID对应上面areaId',
`sysCode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '无人机、机器人系统Id',
`initPic` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '导入zip压缩包中的初始化图片',
PRIMARY KEY (`deviceId`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='机器人与无人机点位与预设点关联关系(两张表)';</code></pre>
<ul>
<li>tran_smartdevice_areaof_maintenance 检修区域表</li>
</ul>
<pre><code class="language-sql">CREATE TABLE `tran_smartdevice_areaof_maintenance` (
`areaOfMaintenanceId` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
`configCode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '检修区域配置编码',
`enable` int DEFAULT NULL COMMENT '是否有效 1设置检修区域,0取消检修区域',
`startTime` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '检修开始时间 enable为1时,有效',
`endTime` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '检修结束时间 enable为1时,有效',
`deviceLevel` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '&lt;1&gt;: = 间隔 &lt;2&gt;: = 主设备 &lt;3&gt;: = 设备点位 &lt;4&gt;: = 部件',
`deviceList` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '检修设备列表 格式:多个ID,采用“,”分隔',
`coordinatePixel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '坐标框(像素点) 格式: x1,y1,z1; x2,y2,z2; x3,y3,z3; x4,y4,z4',
`stationId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '变电站id',
`createTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '插入时间',
`sysCode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '机器人、无人机系统编码\r\n',
`maintenancePlanId` bigint DEFAULT NULL COMMENT '检修计划id',
PRIMARY KEY (`areaOfMaintenanceId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='检修区域下发指令';</code></pre>
<ul>
<li>tran_smartdevice_coordinate 机器人位置和巡视路线表,巡视路线是一段连贯的机器人坐标,dataType是2,codereview后发现缺少一个一对多的id或者什么标识,匹配巡视路线的记录。</li>
</ul>
<pre><code class="language-sql">CREATE TABLE `tran_smartdevice_coordinate` (
`id` bigint NOT NULL AUTO_INCREMENT,
`stationId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`sysCode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`dataType` tinyint DEFAULT NULL COMMENT '1为巡视坐标,一条记录,2为巡视路线,多条记录',
`patrolDeviceCode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '无人机、机器人编号',
`patrolDeviceName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '无人机、机器人编号',
`time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`coordinatePixel` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '坐标 格式:”x,y,z,a”,x、y、z为地图文件的坐标,a为巡视设备航向角',
`coordinateGeography` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '经纬度,格式:”x,y”',
`createTime` datetime DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=110206 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='J.6.6 巡视设备坐标和 J.6.7 巡视路线 ,dataType=1代表设备坐标,dataType=2代表巡视路线,是一个列表多条记录';</code></pre>
<ul>
<li>tran_smartdevice_drone_nest_run_info 无人机机巢运行信息</li>
</ul>
<pre><code class="language-sql">CREATE TABLE `tran_smartdevice_drone_nest_run_info` (
`id` bigint NOT NULL AUTO_INCREMENT,
`stationId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '变电站id',
`sysCode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '无人机、机器人系统编码',
`nestCode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '无人机、机器人编号',
`nestName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '无人机、机器人名称',
`moduleNo` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '模块序号',
`battery` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '电池电量type=1',
`batteryUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`batteryRunState` tinyint DEFAULT NULL COMMENT '电池使用状态 type=2 1=充电中,2=使用中',
`batteryRunStateUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`batteryState` tinyint DEFAULT NULL COMMENT '电池状态 type=3 1正常,2异常',
`batteryStateUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`voltage` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '电池电压 type=4',
`voltageUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '电池电压',
`temp` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '舱内温度 type=5',
`tempUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`wetness` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '舱内湿度 type =6',
`wetnessUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`createTime` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '插入时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='J.6.5 无人机机巢运行数据';</code></pre>
<ul>
<li>tran_smartdevice_drone_nest_status 无人机机巢运行状态</li>
</ul>
<pre><code class="language-sql">CREATE TABLE `tran_smartdevice_drone_nest_status` (
`id` bigint NOT NULL AUTO_INCREMENT,
`stationId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '变电站id',
`sysCode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '无人机、机器人系统编码',
`nestCode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '无人机、机器人编号',
`nestName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '无人机、机器人编号',
`time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '报文时间',
`runStatus` tinyint DEFAULT NULL COMMENT '运行状态,0初始化,1自检中,2等待重置,3重置中,4待机,5异常',
`runStatusUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`hatchStatus` tinyint DEFAULT NULL COMMENT '舱门状态,0关闭,1启动',
`hatchStatusUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`platformStatus` tinyint DEFAULT NULL COMMENT '平台状态 0关闭,1启动',
`platformStatusUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`chargeStatus` tinyint DEFAULT NULL COMMENT '充电状态 0未充电,1充电中,2充电完成',
`chargeStatusUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`acStatus` tinyint DEFAULT NULL COMMENT '空调状态,0关闭,1启动,2异常',
`acStatusUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`createTime` datetime DEFAULT NULL COMMENT '插入时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='J.6.4 无人机机巢状态数据\r\n';</code></pre>
<ul>
<li>tran_smartdevice_run_info 巡视设备(机器人、无人机)运行信息</li>
</ul>
<pre><code class="language-sql">CREATE TABLE `tran_smartdevice_run_info` (
`id` bigint NOT NULL AUTO_INCREMENT,
`stationId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '变电站id',
`sysCode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '无人机、机器人系统编码',
`patrolDeviceCode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '无人机、机器人编号',
`patrolDeviceName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '无人机、机器人编号',
`time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '报文时间',
`speed` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '适用机器人和无人机:水平速度 type=1',
`speedUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`mileage` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '适用机器人和无人机: 行驶里程 type=2',
`mileageUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`battery` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '适用机器人和无人机: 电量 type=3',
`batteryUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`vSpeed` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '适用无人机 : 垂直速度 type=4',
`vSpeedUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`distance` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '适用于无人机:飞行距离 type=5',
`distanceUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`height` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '适用于无人机:飞行高度 type=6',
`heightUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`duration` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '适用于无人机:飞行时长 type=7',
`durationUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`ptzUp` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '适用于无人机和机器人:云台俯仰角度 type=8',
`ptzUpUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`ptzRoll` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '适用于无人机和机器人:云台横滚角度 type=9',
`ptzRollUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`ptzYaw` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '适用于无人机和机器人:云台偏航角度 type=10',
`ptzYawUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`current` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '适用机器人 : 充电电流 type=11',
`currentUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`createTime` datetime DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='J.6.3 巡视设备运行数据';</code></pre>
<ul>
<li>tran_smartdevice_status 巡视设备(机器人、无人机)运行状态</li>
</ul>
<pre><code class="language-sql">CREATE TABLE `tran_smartdevice_status` (
`id` bigint NOT NULL AUTO_INCREMENT,
`sysCode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '无人机、机器人系统编号',
`stationId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '变电站ID',
`patrolDeviceCode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '无人机、机器人编号',
`patrolDeviceName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`batteryStatus` tinyint DEFAULT NULL COMMENT '电池电量,0正常,1电量低,适用机器人和无人机',
`batteryUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`comStatus` tinyint DEFAULT NULL COMMENT '通信状态,0正常,1异常,适用机器人和无人机',
`comUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`superSonic` tinyint DEFAULT NULL COMMENT '超声停障, 0正常,1异常,适用于机器人',
`superSonicUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`driveStatus` tinyint DEFAULT NULL COMMENT '驱动异常 0正常,1异常,适用机器人和无人机',
`driveUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`faultWarnningStatus` tinyint DEFAULT NULL COMMENT '故障报警 0正常,1报警,适用机器人和无人机',
`faultWarnningUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`runStatus` tinyint DEFAULT NULL COMMENT '运行状态 空闲=1,巡视状态=2,充电状态=3,检修状态=4,适用机器人和无人机',
`controlModal` tinyint DEFAULT NULL COMMENT '控制模式 任务模式=1,紧急定位模式=2,后台遥控模式=3,手持遥控模式=4 适用机器人和无人机',
`controlModalUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`controlRightStatus` tinyint DEFAULT NULL COMMENT '控制权状态 空闲=0,获得=1 适用机器人和无人机',
`controlRightUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`rotationStatus` tinyint DEFAULT NULL COMMENT '轮转状态 空闲=0,值班=1 适用机器人',
`rotationUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`flyStatus` tinyint DEFAULT NULL COMMENT '飞行状态 待命=1,准备起飞=2,飞行中=3,返航=4,着陆=5 适用无人机',
`flyUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`createTime` datetime DEFAULT NULL COMMENT '报文时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=14572 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='对应附录 J.6.2 巡视设备状态数据';</code></pre>
<ul>
<li>tran_smartdevice_task 智能设备巡视任务表
<ul>
<li>当在巡视i系统创建一个巡视任务,并且涉及到机器人点位的时候,tour才会调用feign接口调用机器人系统的任务下发接口,并写入次表记录。</li>
</ul></li>
</ul>
<pre><code class="language-sql">CREATE TABLE `tran_smartdevice_task` (
`taskCode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '任务编码',
`sysCode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '无人机机器人系统code',
`type` tinyint DEFAULT NULL COMMENT '巡视类型 (&lt;1&gt;: = 例行巡视 &lt;2&gt;: = 特殊巡视 &lt;3&gt;: = 专项巡视 &lt;4&gt;: = 自定义巡视 )',
`taskName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '任务名称',
`priority` tinyint DEFAULT NULL COMMENT '优先级 (&lt;1&gt;: = 优先级1,优先级最低 &lt;2&gt;: = 优先级2 &lt;3&gt;: = 优先级3 &lt;4&gt;: = 优先级4,优先级最高)',
`deviceLevel` tinyint DEFAULT NULL COMMENT '设备层级 (&lt;1&gt;: = 间隔 &lt;2&gt;: = 主设备 &lt;3&gt;: = 设备点位 &lt;4&gt;: = 部件 )',
`deviceList` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '设备列表 格式:多个ID,采用“,”分隔',
`fixedStartTime` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '定期开始时间 格式:yyyy-MM-dd HH:mm:ss',
`cycleMonth` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '周期(月) 格式:多个月,采用“,”分隔',
`cycleWeek` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '周期(周) 格式:多个周,采用“,”分隔',
`cycleExecuteTime` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '周期(执行时间) 格式:HH:mm:ss',
`cycleStartTime` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '周期开始时间 格式:yyyy-MM-dd HH:mm:ss',
`cycleEndTime` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '周期结束时间 格式:yyyy-MM-dd HH:mm:ss',
`intervalNumber` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '间隔(数量)',
`intervalType` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '间隔(类型) (&lt;1&gt;: = 小时 &lt;2&gt;: = 天)',
`intervalExecuteTime` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '间隔(执行时间) 格式:HH:mm:ss',
`intervalStartTime` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '间隔开始时间 格式:yyyy-MM-dd HH:mm:ss',
`intervalEndTime` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '间隔结束时间 格式:yyyy-MM-dd HH:mm:ss',
`invalidStartTime` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '不可用开始时间 格式:yyyy-MM-dd HH:mm:ss',
`invalidEndTime` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '不可用结束时间 格式:yyyy-MM-dd HH:mm:ss',
`isEnable` tinyint DEFAULT NULL COMMENT '是否可用 (&lt;0&gt;: = 启用 &lt;1&gt;: = 禁用 )',
`creator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '编制人',
`createTime` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '编制时间',
`status` tinyint DEFAULT NULL COMMENT '响应状态',
`errorCode` tinyint DEFAULT NULL COMMENT '失败原因 (&lt;0&gt;: = 成功 &lt;1&gt;: = 巡视设备异常 &lt;2&gt;: = 无权限(或高优先级任务存在) &lt;3&gt;: = 其它异常)',
`taskPatrolledId` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '任务Id',
PRIMARY KEY (`taskCode`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;</code></pre>
<ul>
<li>tran_smartdevice_task_controll 智能设备任务控制记录</li>
</ul>
<pre><code class="language-sql">CREATE TABLE `tran_smartdevice_task_controll` (
`id` bigint NOT NULL AUTO_INCREMENT,
`stationId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'stationId',
`sysCode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '无人机、机器人系统id',
`command` tinyint DEFAULT NULL COMMENT '1.任务启动,2任务暂停,3任务继续,4任务停止',
`code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '当控制类型为任务启动时,CODE 为任务 ID,其他控制类型时,CODE 为任务\r\n执行 ID',
`taskPatrolledId` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '任务Id',
`createTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
`createBy` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建人',
`updateTime` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
`updateBy` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '操作人',
`status` int NOT NULL DEFAULT '0' COMMENT '100需重发,200成功,400拒绝,500错误,0初始化',
PRIMARY KEY (`id`,`status`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='J.5.4 任务控制指令,巡视主机向机器人及无人机巡视系统发起巡视任务控制请求,机器人及无人机巡视系统收到请求后开展巡视作业并发送响应消息';</code></pre>
<ul>
<li>tran_smartdevice_task_result 任务结果表
<ul>
<li>巡视任务结果 只有整个巡视任务中,机器人点位的记录</li>
</ul></li>
</ul>
<pre><code class="language-sql">CREATE TABLE `tran_smartdevice_task_result` (
`id` bigint NOT NULL AUTO_INCREMENT,
`sysCode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '无人机、机器人系统编号',
`stationId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '变电站ID',
`patrolDeviceName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`patrolDeviceCode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '无人机、机器人编号',
`taskPatrolledId` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '任务Id',
`taskName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '任务名称',
`taskCode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '任务编码',
`deviceName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '设备点位名称',
`deviceId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '设备点位id',
`valueType` tinyint DEFAULT NULL COMMENT '0默认类型,11局放放电频次,12局放信号峰值,13局放信号均值',
`valueData` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '值',
`valueUnit` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '带值单位',
`unit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '单位',
`time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '报文时间',
`recognitionType` tinyint DEFAULT NULL COMMENT '识别类型: 1表记读取,2位置状态识别,3设备外观查看,4红外测温,5声音检测,6闪烁检测,11局放超声波检测,12局放地电压检测,13局放特高频检测,101环境温度检测,102环境湿度检测,103氧气浓度检测,104 SF6浓度检测',
`fileType` tinyint DEFAULT NULL COMMENT '采集文件类型 1红外图谱,2可见光照片,3音频,4视频,存在多个文件,文件类型用逗号分隔',
`filePath` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '文件名,多个逗号分割',
`rectangle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '格式:x1,y1;x2,y2;x3,y3;x4,y4,x1等为图片文件的像素点',
`valid` tinyint DEFAULT NULL COMMENT '0为失败,1为成功,2为判别异常',
`createTime` datetime DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=395 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='J.6.11 巡视结果';</code></pre>
<ul>
<li>tran_smartdevice_task_status 智能设备巡视状态表,包含巡视任务执行百分比</li>
</ul>
<pre><code class="language-sql">CREATE TABLE `tran_smartdevice_task_status` (
`id` bigint NOT NULL AUTO_INCREMENT,
`stationId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '变电站ID',
`taskPatrolledId` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '任务Id',
`taskName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '任务名称',
`taskCode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '任务编码',
`taskState` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '任务状态 1已执行,2正在执行,3暂停,4终止,5未执行,6超期',
`planStartTime` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '计划开始时间',
`startTime` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '开始时间',
`taskProgress` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '任务进度',
`taskEstimatedTime` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '剩余时间',
`description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '描述',
`createTime` datetime DEFAULT CURRENT_TIMESTAMP,
`sysCode` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '系统编号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=742 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='J.6.10 任务状态数据';</code></pre>
<ul>
<li>tran_smartdevice_warning 智能设备自身的报警、告警信息。</li>
</ul>
<pre><code class="language-sql">CREATE TABLE `tran_smartdevice_warning` (
`id` bigint NOT NULL AUTO_INCREMENT,
`sysCode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '无人机、机器人系统编号',
`stationId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '变电站ID',
`patrolDeviceCode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '无人机、机器人编号',
`patrolDeviceName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '报文时间',
`content` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '报警内容',
`createTime` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '报文时间',
PRIMARY KEY (`id`) USING BTREE,
KEY `idx_patrolDeviceName` (`patrolDeviceName`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5012 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='对应附录 J.6.8 巡视设备异常告警数据';</code></pre>
<h2>最后</h2>
<p>整个smartdevice项目是围绕着SmartDeviceHandler和上面提到的controller编写的,所有的业务逻辑需要查看《国网设备部关于印发《500(330)千伏及 以上变电站远程智能巡视系统技术规范 (试行)》等四项规范的通知》的 <附 录 J> 的内容</p>