附录J无人机、机器人对接相关内容

附录J无人机、机器人对接


数据包与数据库表对应关系

<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>同上&lt;7. J.6.6 巡视设备坐标&gt;</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>

页面列表

ITEM_HTML