数据包与数据库表对应关系
<h2>巡检系统主动下发的命令</h2>
<h3>1. J.5.2 机器人控制指令 (暂时不做)</h3>
<h3>2. J.5.3 无人机控制指令 (暂时不做)</h3>
<h3>3. J.5.4 任务控制指令</h3>
<h3>4. J.5.5 模型同步指令</h3>
<h3>5. J.5.6 任务下发指令 type=101 任务下发</h3>
<h3>7. J.5.6 任务下发指令 type=102 联动任务下发</h3>
<h3>8. J.5.7 检修区域下发指令</h3>
<hr />
<h2>无人机、机器人系统主动上报</h2>
<h3>1. J.4.2 注册指令</h3>
<h4>表结构</h4>
<ul>
<li>表名 <code>tran_smartdevice_system_config</code></li>
</ul>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>是否必填</th>
<th>默认值</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td>sysCode</td>
<td>varchar(50)</td>
<td>是</td>
<td> </td>
<td>给该系统分配的编码,附录J中的机器人及无人机巡视系统唯一标识</td>
</tr>
<tr>
<td>sysType</td>
<td>tinyint</td>
<td>否</td>
<td> </td>
<td>对接系统类型,1=无人机系统,2=机器人系统。。。</td>
</tr>
<tr>
<td>stationId</td>
<td>varchar(50)</td>
<td>否</td>
<td> </td>
<td>stationID</td>
</tr>
<tr>
<td>sysName</td>
<td>varchar(30)</td>
<td>否</td>
<td> </td>
<td>对接系统名称</td>
</tr>
<tr>
<td>manufactor</td>
<td>varchar(50)</td>
<td>否</td>
<td> </td>
<td>系统厂家名称</td>
</tr>
<tr>
<td>createBy</td>
<td>varchar(64)</td>
<td>否</td>
<td> </td>
<td>创建者</td>
</tr>
<tr>
<td>createTime</td>
<td>datetime</td>
<td>否</td>
<td>CURRENT_TIMESTAMP</td>
<td>创建时间</td>
</tr>
<tr>
<td>updateBy</td>
<td>varchar(64)</td>
<td>否</td>
<td> </td>
<td>更新者</td>
</tr>
<tr>
<td>updateTime</td>
<td>datetime</td>
<td>否</td>
<td>CURRENT_TIMESTAMP</td>
<td>更新时间</td>
</tr>
<tr>
<td>heartBeatInterval</td>
<td>tinyint</td>
<td>否</td>
<td> </td>
<td>心跳秒</td>
</tr>
<tr>
<td>patroldeviceRunInterval</td>
<td>tinyint</td>
<td>否</td>
<td> </td>
<td>巡视设备运行数据间隔 秒</td>
</tr>
<tr>
<td>nestRunInterval</td>
<td>tinyint</td>
<td>否</td>
<td> </td>
<td>无人机机巢运行数据间隔 秒 (sysType=2时不需要响应该字段)</td>
</tr>
<tr>
<td>envInterval</td>
<td>tinyint</td>
<td>否</td>
<td> </td>
<td>环境数据间隔 秒</td>
</tr>
<tr>
<td>status</td>
<td>tinyint</td>
<td>否</td>
<td>2</td>
<td>机器人无人机系统状态,1在线,2下线,默认值2</td>
</tr>
<tr>
<td>regStatus</td>
<td>tinyint</td>
<td>否</td>
<td>3</td>
<td>注册状态1成功,2失败,3未注册过,默认值3</td>
</tr>
<tr>
<td>heartBeatTime</td>
<td>datetime</td>
<td>否</td>
<td>CURRENT_TIMESTAMP</td>
<td>上一次心跳时间</td>
</tr>
</tbody>
</table>
<h3>2. J.4.3 心跳指令</h3>
<h4>表结构</h4>
<ul>
<li>无</li>
</ul>
<h3>3. J.6.2 巡视设备状态数据</h3>
<h4>表结构</h4>
<ul>
<li><code>表名:tran_smartdevice_status</code></li>
</ul>
<table>
<thead>
<tr>
<th>字段名</th>
<th>类型</th>
<th>描述</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td>自增主键</td>
</tr>
<tr>
<td>sysCode</td>
<td>varchar(50)</td>
<td>无人机、机器人系统编号</td>
</tr>
<tr>
<td>stationId</td>
<td>varchar(50)</td>
<td>stationID</td>
</tr>
<tr>
<td>patrolDeviceCode</td>
<td>varchar(50)</td>
<td>无人机、机器人编号</td>
</tr>
<tr>
<td>patrolDeviceName</td>
<td>varchar(50)</td>
<td>无人机、机器人名称</td>
</tr>
<tr>
<td>time</td>
<td>varchar(20)</td>
<td>时间</td>
</tr>
<tr>
<td>batteryStatus</td>
<td>tinyint</td>
<td>电池电量,0正常,1电量低,适用机器人和无人机</td>
</tr>
<tr>
<td>batteryUnit</td>
<td>varchar(20)</td>
<td>电池电量单位</td>
</tr>
<tr>
<td>comStatus</td>
<td>tinyint</td>
<td>通信状态,0正常,1异常,适用机器人和无人机</td>
</tr>
<tr>
<td>comUnit</td>
<td>varchar(20)</td>
<td>通信状态单位</td>
</tr>
<tr>
<td>superSonic</td>
<td>tinyint</td>
<td>超声停障, 0正常,1异常,适用于机器人</td>
</tr>
<tr>
<td>superSonicUnit</td>
<td>varchar(20)</td>
<td>超声停障单位</td>
</tr>
<tr>
<td>driveStatus</td>
<td>tinyint</td>
<td>驱动异常 0正常,1异常,适用机器人和无人机</td>
</tr>
<tr>
<td>driveUnit</td>
<td>varchar(20)</td>
<td>驱动异常单位</td>
</tr>
<tr>
<td>faultWarnningStatus</td>
<td>tinyint</td>
<td>故障报警 0正常,1报警,适用机器人和无人机</td>
</tr>
<tr>
<td>faultWarnningUnit</td>
<td>varchar(20)</td>
<td>故障报警单位</td>
</tr>
<tr>
<td>runStatus</td>
<td>tinyint</td>
<td>运行状态 空闲=1,巡视状态=2,充电状态=3,检修状态=4,适用机器人和无人机</td>
</tr>
<tr>
<td>controlModal</td>
<td>tinyint</td>
<td>控制模式 任务模式=1,紧急定位模式=2,后台遥控模式=3,手持遥控模式=4 适用机器人和无人机</td>
</tr>
<tr>
<td>controlModalUnit</td>
<td>varchar(20)</td>
<td>控制模式单位</td>
</tr>
<tr>
<td>controlRightStatus</td>
<td>tinyint</td>
<td>控制权状态 空闲=0,获得=1 适用机器人和无人机</td>
</tr>
<tr>
<td>controlRightUnit</td>
<td>varchar(20)</td>
<td>控制权状态单位</td>
</tr>
<tr>
<td>rotationStatus</td>
<td>tinyint</td>
<td>轮转状态 空闲=0,值班=1 适用机器人</td>
</tr>
<tr>
<td>rotationUnit</td>
<td>varchar(20)</td>
<td>轮转状态单位</td>
</tr>
<tr>
<td>flyStatus</td>
<td>tinyint</td>
<td>飞行状态 待命=1,准备起飞=2,飞行中=3,返航=4,着陆=5 适用无人机</td>
</tr>
<tr>
<td>flyUnit</td>
<td>varchar(20)</td>
<td>飞行状态单位</td>
</tr>
<tr>
<td>createTime</td>
<td>datetime</td>
<td>报文时间</td>
</tr>
</tbody>
</table>
<h3>4. J.6.3 巡视设备运行数据</h3>
<h4>表结构</h4>
<ul>
<li><code>表名:tran_smartdevice_run_info</code></li>
</ul>
<table>
<thead>
<tr>
<th>字段名</th>
<th>类型</th>
<th>描述</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td>自增主键</td>
</tr>
<tr>
<td>stationId</td>
<td>varchar(50)</td>
<td>stationId</td>
</tr>
<tr>
<td>sysCode</td>
<td>varchar(50)</td>
<td>无人机、机器人系统编码</td>
</tr>
<tr>
<td>patrolDeviceCode</td>
<td>varchar(50)</td>
<td>无人机、机器人编号</td>
</tr>
<tr>
<td>patrolDeviceName</td>
<td>varchar(50)</td>
<td>无人机、机器人编号</td>
</tr>
<tr>
<td>time</td>
<td>varchar(20)</td>
<td>报文时间</td>
</tr>
<tr>
<td>speed</td>
<td>varchar(10)</td>
<td>适用机器人和无人机:水平速度 type=1</td>
</tr>
<tr>
<td>speedUnit</td>
<td>varchar(20)</td>
<td></td>
</tr>
<tr>
<td>mileage</td>
<td>varchar(20)</td>
<td>适用机器人和无人机: 行驶里程 type=2</td>
</tr>
<tr>
<td>mileageUnit</td>
<td>varchar(20)</td>
<td></td>
</tr>
<tr>
<td>battery</td>
<td>varchar(20)</td>
<td>适用机器人和无人机: 电量 type=3</td>
</tr>
<tr>
<td>batteryUnit</td>
<td>varchar(20)</td>
<td></td>
</tr>
<tr>
<td>vSpeed</td>
<td>varchar(20)</td>
<td>适用无人机 : 垂直速度 type=4</td>
</tr>
<tr>
<td>vSpeedUnit</td>
<td>varchar(20)</td>
<td></td>
</tr>
<tr>
<td>distance</td>
<td>varchar(20)</td>
<td>适用于无人机:飞行距离 type=5</td>
</tr>
<tr>
<td>distanceUnit</td>
<td>varchar(20)</td>
<td></td>
</tr>
<tr>
<td>height</td>
<td>varchar(20)</td>
<td>适用于无人机:飞行高度 type=6</td>
</tr>
<tr>
<td>heightUnit</td>
<td>varchar(20)</td>
<td></td>
</tr>
<tr>
<td>duration</td>
<td>varchar(20)</td>
<td>适用于无人机:飞行时长 type=7</td>
</tr>
<tr>
<td>durationUnit</td>
<td>varchar(20)</td>
<td></td>
</tr>
<tr>
<td>ptzUp</td>
<td>varchar(20)</td>
<td>适用于无人机和机器人:云台俯仰角度 type=8</td>
</tr>
<tr>
<td>ptzUpUnit</td>
<td>varchar(20)</td>
<td></td>
</tr>
<tr>
<td>ptzRoll</td>
<td>varchar(20)</td>
<td>适用于无人机和机器人:云台横滚角度 type=9</td>
</tr>
<tr>
<td>ptzRollUnit</td>
<td>varchar(20)</td>
<td></td>
</tr>
<tr>
<td>ptzYaw</td>
<td>varchar(20)</td>
<td>适用于无人机和机器人:云台偏航角度 type=10</td>
</tr>
<tr>
<td>ptzYawUnit</td>
<td>varchar(20)</td>
<td></td>
</tr>
<tr>
<td>current</td>
<td>varchar(20)</td>
<td>适用机器人 : 充电电流 type=11</td>
</tr>
<tr>
<td>currentUnit</td>
<td>varchar(20)</td>
<td></td>
</tr>
<tr>
<td>createTime</td>
<td>datetime</td>
<td>创建时间</td>
</tr>
</tbody>
</table>
<h3>5. J.6.4 无人机机巢状态数据</h3>
<h4>表结构</h4>
<ul>
<li><code>表名:tran_smartdevice_drone_nest_status</code></li>
</ul>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>是否可为空</th>
<th>默认值</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td>否</td>
<td>NULL</td>
<td>自增主键</td>
</tr>
<tr>
<td>stationId</td>
<td>varchar(50)</td>
<td>是</td>
<td>NULL</td>
<td>stationId</td>
</tr>
<tr>
<td>sysCode</td>
<td>varchar(50)</td>
<td>是</td>
<td>NULL</td>
<td>无人机、机器人系统编码</td>
</tr>
<tr>
<td>nestCode</td>
<td>varchar(50)</td>
<td>是</td>
<td>NULL</td>
<td>无人机、机器人编号</td>
</tr>
<tr>
<td>nestName</td>
<td>varchar(50)</td>
<td>是</td>
<td>NULL</td>
<td>无人机、机器人编号</td>
</tr>
<tr>
<td>time</td>
<td>varchar(20)</td>
<td>是</td>
<td>NULL</td>
<td>报文时间</td>
</tr>
<tr>
<td>runStatus</td>
<td>tinyint</td>
<td>是</td>
<td>NULL</td>
<td>运行状态,0初始化,1自检中,2等待重置,3重置中,4待机,5异常</td>
</tr>
<tr>
<td>runStatusUnit</td>
<td>varchar(20)</td>
<td>是</td>
<td>NULL</td>
<td>运行状态单位</td>
</tr>
<tr>
<td>hatchStatus</td>
<td>tinyint</td>
<td>是</td>
<td>NULL</td>
<td>舱门状态,0关闭,1启动</td>
</tr>
<tr>
<td>hatchStatusUnit</td>
<td>varchar(20)</td>
<td>是</td>
<td>NULL</td>
<td>舱门状态单位</td>
</tr>
<tr>
<td>platformStatus</td>
<td>tinyint</td>
<td>是</td>
<td>NULL</td>
<td>平台状态 0关闭,1启动</td>
</tr>
<tr>
<td>platformStatusUnit</td>
<td>varchar(20)</td>
<td>是</td>
<td>NULL</td>
<td>平台状态单位</td>
</tr>
<tr>
<td>chargeStatus</td>
<td>tinyint</td>
<td>是</td>
<td>NULL</td>
<td>充电状态 0未充电,1充电中,2充电完成</td>
</tr>
<tr>
<td>chargeStatusUnit</td>
<td>varchar(20)</td>
<td>是</td>
<td>NULL</td>
<td>充电状态单位</td>
</tr>
<tr>
<td>acStatus</td>
<td>tinyint</td>
<td>是</td>
<td>NULL</td>
<td>空调状态,0关闭,1启动,2异常</td>
</tr>
<tr>
<td>acStatusUnit</td>
<td>varchar(20)</td>
<td>是</td>
<td>NULL</td>
<td>空调状态单位</td>
</tr>
<tr>
<td>createTime</td>
<td>datetime</td>
<td>是</td>
<td>NULL</td>
<td>插入时间</td>
</tr>
</tbody>
</table>
<h3>6. J.6.5 无人机机巢运行数据</h3>
<h4>表结构</h4>
<ul>
<li><code>表名:tran_smartdevice_drone_nest_run_info</code></li>
</ul>
<table>
<thead>
<tr>
<th>字段名</th>
<th>类型</th>
<th>描述</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td>主键</td>
</tr>
<tr>
<td>stationId</td>
<td>varchar(50)</td>
<td>stationId</td>
</tr>
<tr>
<td>sysCode</td>
<td>varchar(50)</td>
<td>无人机、机器人系统编码</td>
</tr>
<tr>
<td>nestCode</td>
<td>varchar(50)</td>
<td>无人机、机器人编号</td>
</tr>
<tr>
<td>nestName</td>
<td>varchar(50)</td>
<td>无人机、机器人编号</td>
</tr>
<tr>
<td>moduleNo</td>
<td>varchar(20)</td>
<td>模块序号</td>
</tr>
<tr>
<td>battery</td>
<td>varchar(20)</td>
<td>电池电量type=1</td>
</tr>
<tr>
<td>batteryUnit</td>
<td>varchar(20)</td>
<td> </td>
</tr>
<tr>
<td>batteryRunState</td>
<td>tinyint</td>
<td>电池使用状态 type=2 1=充电中,2=使用中</td>
</tr>
<tr>
<td>batteryRunStateUnit</td>
<td>varchar(20)</td>
<td> </td>
</tr>
<tr>
<td>batteryState</td>
<td>tinyint</td>
<td>电池状态 type=3 1正常,2异常</td>
</tr>
<tr>
<td>batteryStateUnit</td>
<td>varchar(20)</td>
<td> </td>
</tr>
<tr>
<td>voltage</td>
<td>varchar(20)</td>
<td>电池电压 type=4</td>
</tr>
<tr>
<td>voltageUnit</td>
<td>varchar(20)</td>
<td>电池电压</td>
</tr>
<tr>
<td>temp</td>
<td>varchar(20)</td>
<td>舱内温度 type=5</td>
</tr>
<tr>
<td>tempUnit</td>
<td>varchar(20)</td>
<td> </td>
</tr>
<tr>
<td>wetness</td>
<td>varchar(20)</td>
<td>舱内湿度 type =6</td>
</tr>
<tr>
<td>wetnessUnit</td>
<td>varchar(20)</td>
<td> </td>
</tr>
<tr>
<td>createTime</td>
<td>datetime</td>
<td>插入时间</td>
</tr>
</tbody>
</table>
<h3>7. J.6.6 巡视设备坐标</h3>
<h4>表结构</h4>
<ul>
<li><code>表名:tran_smartdevice_coordinate</code></li>
</ul>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>是否必填</th>
<th>默认值</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td>是</td>
<td> </td>
<td>自增主键</td>
</tr>
<tr>
<td>stationId</td>
<td>varchar(50)</td>
<td>否</td>
<td> </td>
<td>stationId</td>
</tr>
<tr>
<td>sysCode</td>
<td>varchar(50)</td>
<td>否</td>
<td> </td>
<td>系统编号</td>
</tr>
<tr>
<td>dataType</td>
<td>tinyint</td>
<td>否</td>
<td> </td>
<td>1为巡视坐标,一条记录,2为巡视路线,多条记录</td>
</tr>
<tr>
<td>patrolDeviceCode</td>
<td>varchar(50)</td>
<td>否</td>
<td> </td>
<td>无人机、机器人编号</td>
</tr>
<tr>
<td>patrolDeviceName</td>
<td>varchar(50)</td>
<td>否</td>
<td> </td>
<td>无人机、机器人名称</td>
</tr>
<tr>
<td>time</td>
<td>varchar(20)</td>
<td>否</td>
<td> </td>
<td>时间</td>
</tr>
<tr>
<td>coordinatePixel</td>
<td>varchar(100)</td>
<td>否</td>
<td> </td>
<td>坐标 格式:”x,y,z,a”,x、y、z为地图文件的坐标,a为巡视设备航向角</td>
</tr>
<tr>
<td>coordinateGeography</td>
<td>varchar(100)</td>
<td>否</td>
<td> </td>
<td>经纬度,格式:”x,y”</td>
</tr>
<tr>
<td>createTime</td>
<td>datetime</td>
<td>否</td>
<td>CURRENT_TIMESTAMP</td>
<td>创建时间</td>
</tr>
</tbody>
</table>
<h3>8. J.6.7 巡视路线</h3>
<h4>表结构</h4>
<ul>
<li>同上<7. J.6.6 巡视设备坐标></li>
<li>通过dataType区分</li>
</ul>
<h3>9. J.6.8 巡视设备异常告警数据</h3>
<h4>表结构</h4>
<ul>
<li><code>表名:tran_smartdevice_warning</code></li>
</ul>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>是否为空</th>
<th>默认值</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td>否</td>
<td>NULL</td>
<td>自增主键</td>
</tr>
<tr>
<td>sysCode</td>
<td>varchar(50)</td>
<td>是</td>
<td>NULL</td>
<td>无人机、机器人系统编号</td>
</tr>
<tr>
<td>stationId</td>
<td>varchar(50)</td>
<td>是</td>
<td>NULL</td>
<td>stationId</td>
</tr>
<tr>
<td>patrolDeviceCode</td>
<td>varchar(50)</td>
<td>是</td>
<td>NULL</td>
<td>无人机、机器人编号</td>
</tr>
<tr>
<td>patrolDeviceName</td>
<td>varchar(50)</td>
<td>是</td>
<td>NULL</td>
<td>无人机、机器人名称</td>
</tr>
<tr>
<td>time</td>
<td>varchar(20)</td>
<td>是</td>
<td>NULL</td>
<td>报文时间</td>
</tr>
<tr>
<td>content</td>
<td>varchar(1000)</td>
<td>是</td>
<td>NULL</td>
<td>报警内容</td>
</tr>
<tr>
<td>createTime</td>
<td>datetime</td>
<td>否</td>
<td>CURRENT_TIMESTAMP</td>
<td>创建时间</td>
</tr>
</tbody>
</table>
<h3>10. J.6.9 环境数据</h3>
<h4>表结构</h4>
<ul>
<li><code>表名:tran_smartdevice_env</code></li>
</ul>
<table>
<thead>
<tr>
<th>字段名</th>
<th>类型</th>
<th>描述</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td>主键</td>
</tr>
<tr>
<td>sysCode</td>
<td>varchar(50)</td>
<td>无人机、机器人系统编号</td>
</tr>
<tr>
<td>stationId</td>
<td>varchar(50)</td>
<td>stationId</td>
</tr>
<tr>
<td>patrolDeviceCode</td>
<td>varchar(50)</td>
<td>无人机、机器人编号</td>
</tr>
<tr>
<td>patrolDeviceName</td>
<td>varchar(50)</td>
<td> </td>
</tr>
<tr>
<td>time</td>
<td>varchar(20)</td>
<td>报文时间</td>
</tr>
<tr>
<td>temp</td>
<td>varchar(20)</td>
<td>环境温度,适用机器人和无人机</td>
</tr>
<tr>
<td>tempUnit</td>
<td>varchar(20)</td>
<td> </td>
</tr>
<tr>
<td>wetness</td>
<td>varchar(20)</td>
<td>环境湿度,适用机器人和无人机</td>
</tr>
<tr>
<td>wetnessUnit</td>
<td>varchar(20)</td>
<td> </td>
</tr>
<tr>
<td>windSpeed</td>
<td>varchar(20)</td>
<td>风速,适用机器人和无人机</td>
</tr>
<tr>
<td>windSpeedUnit</td>
<td>varchar(20)</td>
<td> </td>
</tr>
<tr>
<td>rain</td>
<td>varchar(20)</td>
<td>雨量,适用机器人和无人机</td>
</tr>
<tr>
<td>rainUnit</td>
<td>varchar(20)</td>
<td> </td>
</tr>
<tr>
<td>wind</td>
<td>varchar(20)</td>
<td>风向,适用机器人和无人机</td>
</tr>
<tr>
<td>windUnit</td>
<td>varchar(20)</td>
<td> </td>
</tr>
<tr>
<td>pressure</td>
<td>varchar(20)</td>
<td>气压,适用机器人和无人机</td>
</tr>
<tr>
<td>pressureUnit</td>
<td>varchar(20)</td>
<td> </td>
</tr>
<tr>
<td>oxygen</td>
<td>varchar(20)</td>
<td>氧气,适用于机器人</td>
</tr>
<tr>
<td>oxygenUnit</td>
<td>varchar(20)</td>
<td> </td>
</tr>
<tr>
<td>sf</td>
<td>varchar(20)</td>
<td>sf6,适用于机器人</td>
</tr>
<tr>
<td>sfUnit</td>
<td>varchar(20)</td>
<td> </td>
</tr>
<tr>
<td>createTime</td>
<td>datetime</td>
<td>添加时间</td>
</tr>
</tbody>
</table>
<h3>11. J.6.10 任务状态数据</h3>
<h4>表结构</h4>
<ul>
<li><code>表名:tran_smartdevice_task_status</code></li>
</ul>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>是否为空</th>
<th>默认值</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td>否</td>
<td>NULL</td>
<td>主键</td>
</tr>
<tr>
<td>taskPatrolledId</td>
<td>varchar(50)</td>
<td>是</td>
<td>NULL</td>
<td>任务Id</td>
</tr>
<tr>
<td>taskName</td>
<td>varchar(50)</td>
<td>是</td>
<td>NULL</td>
<td>任务名称</td>
</tr>
<tr>
<td>taskCode</td>
<td>varchar(50)</td>
<td>是</td>
<td>NULL</td>
<td>任务编码</td>
</tr>
<tr>
<td>taskState</td>
<td>varchar(255)</td>
<td>是</td>
<td>NULL</td>
<td>任务状态 1已执行,2正在执行,3暂停,4终止,5未执行,6超期</td>
</tr>
<tr>
<td>planStartTime</td>
<td>varchar(20)</td>
<td>是</td>
<td>NULL</td>
<td>计划开始时间</td>
</tr>
<tr>
<td>startTime</td>
<td>varchar(20)</td>
<td>是</td>
<td>NULL</td>
<td>开始时间</td>
</tr>
<tr>
<td>taskProgress</td>
<td>varchar(20)</td>
<td>是</td>
<td>NULL</td>
<td>任务进度</td>
</tr>
<tr>
<td>taskEstimatedTime</td>
<td>varchar(20)</td>
<td>是</td>
<td>NULL</td>
<td>剩余时间</td>
</tr>
<tr>
<td>description</td>
<td>varchar(200)</td>
<td>是</td>
<td>NULL</td>
<td>描述</td>
</tr>
<tr>
<td>createTime</td>
<td>datetime</td>
<td>是</td>
<td>CURRENT_TIMESTAMP</td>
<td>创建时间</td>
</tr>
</tbody>
</table>
<h3>12. J.6.11 巡视结果</h3>
<h4>表结构</h4>
<ul>
<li><code>表名:tran_smartdevice_task_result</code></li>
</ul>
<table>
<thead>
<tr>
<th>字段名</th>
<th>类型</th>
<th>描述</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td>主键</td>
</tr>
<tr>
<td>sysCode</td>
<td>varchar(50)</td>
<td>无人机、机器人系统编号</td>
</tr>
<tr>
<td>stationId</td>
<td>varchar(50)</td>
<td>stationId</td>
</tr>
<tr>
<td>patrolDeviceName</td>
<td>varchar(50)</td>
<td>巡视设备名称</td>
</tr>
<tr>
<td>patrolDeviceCode</td>
<td>varchar(50)</td>
<td>无人机、机器人编号</td>
</tr>
<tr>
<td>taskPatrolledId</td>
<td>varchar(50)</td>
<td>任务Id</td>
</tr>
<tr>
<td>taskName</td>
<td>varchar(50)</td>
<td>任务名称</td>
</tr>
<tr>
<td>taskCode</td>
<td>varchar(50)</td>
<td>任务编码</td>
</tr>
<tr>
<td>deviceName</td>
<td>varchar(50)</td>
<td>设备点位名称</td>
</tr>
<tr>
<td>deviceId</td>
<td>varchar(50)</td>
<td>设备点位id</td>
</tr>
<tr>
<td>valueType</td>
<td>tinyint</td>
<td>0默认类型,11局放放电频次,12局放信号峰值,13局放信号均值</td>
</tr>
<tr>
<td>valueData</td>
<td>varchar(20)</td>
<td>值</td>
</tr>
<tr>
<td>valueUnit</td>
<td>varchar(30)</td>
<td>带值单位</td>
</tr>
<tr>
<td>unit</td>
<td>varchar(20)</td>
<td>单位</td>
</tr>
<tr>
<td>time</td>
<td>varchar(20)</td>
<td>报文时间</td>
</tr>
<tr>
<td>recognitionType</td>
<td>tinyint</td>
<td>识别类型: 1表记读取,2位置状态识别,3设备外观查看,4红外测温,5声音检测,6闪烁检测,11局放超声波检测,12局放地电压检测,13局放特高频检测,101环境温度检测,102环境湿度检测,103氧气浓度检测,104 SF6浓度检测</td>
</tr>
<tr>
<td>fileType</td>
<td>tinyint</td>
<td>采集文件类型 1红外图谱,2可见光照片,3音频,4视频,存在多个文件,文件类型用逗号分隔</td>
</tr>
<tr>
<td>filePath</td>
<td>varchar(2000)</td>
<td>文件名,多个逗号分割</td>
</tr>
<tr>
<td>rectangle</td>
<td>varchar(255)</td>
<td>格式:x1,y1;x2,y2;x3,y3;x4,y4,x1等为图片文件的像素点</td>
</tr>
<tr>
<td>valid</td>
<td>tinyint</td>
<td>0为失败,1为成功,2为判别异常</td>
</tr>
<tr>
<td>createTime</td>
<td>datetime</td>
<td>创建时间</td>
</tr>
</tbody>
</table>