-- MySQL dump 10.13 Distrib 8.0.19, for Win64 (x86_64) -- -- Host: 192.168.11.102 Database: cmfpid2.0 -- ------------------------------------------------------ -- Server version 5.7.13-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!50503 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `biz_outfield_group_detail` -- DROP TABLE IF EXISTS `biz_outfield_group_detail`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `biz_outfield_group_detail` ( `id` char(32) NOT NULL, `outfield_id` varchar(100) DEFAULT NULL COMMENT '输出字段的ID', `unit` varchar(50) DEFAULT NULL COMMENT '输出字段的计量单位', `outfield_sn` double DEFAULT '0' COMMENT '输出字段的顺序', `group_info_id` char(32) DEFAULT NULL COMMENT '分组信息的ID', `chinesename` varchar(100) DEFAULT NULL COMMENT '中文名称', `formula` varchar(200) DEFAULT NULL, `data_type` varchar(1) DEFAULT NULL COMMENT '数据的类型（1:日期时间(yyyy-MM-dd HH:mm:ss),2:数字枚举,3:数据,4:其他,5:文本枚举,6:文本多枚举,7:多字段组合多枚举值,NULL 直接返回原始值）', `field_name` varchar(50) DEFAULT NULL COMMENT '此字段仅起显示作用', `decimals` varchar(10) DEFAULT NULL COMMENT '保留几位小数，默认值可为空', `data_map` varchar(1255) DEFAULT NULL COMMENT '需要根据 data_type 类型，采用不同的数据转换方式', `is_analysable` int(11) DEFAULT '0' COMMENT '是否可用来进行数据分析，以对车辆进行问题排查。一般情况下，是具有一定意义的数据或状态值，多指标对比来分析问题。\\n0、不可分析；1、可分析；2、默认分析项', `is_delete` int(11) DEFAULT '0' COMMENT '是否删除 0、未删除；1、已删除', `isAlarm` varchar(1) DEFAULT '0' COMMENT '是否为软件报警项：1-报警项 0-非报警项', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `biz_outfield_group_detail` -- LOCK TABLES `biz_outfield_group_detail` WRITE; /*!40000 ALTER TABLE `biz_outfield_group_detail` DISABLE KEYS */; INSERT INTO `biz_outfield_group_detail` VALUES ('003adfedd79d11e9b2f2000c29140042','4250','%',4,'31','摩擦扭矩',NULL,'3',NULL,NULL,NULL,1,0,'0'),('003adfedd79d11e9b2f2000c2914004c','4250','%',4,'25','摩擦扭矩',NULL,'3',NULL,NULL,NULL,1,0,'0'),('00739ad16edc11e9a45b000c2914004c','4177','℃',11,'24','发动机冷却水温度',NULL,NULL,'发动机冷却水温度',NULL,NULL,0,0,'0'),('0260a12b8c4bebb38205331d49412e5e','3014',NULL,7,'49',NULL,NULL,'1','GPS时间',NULL,NULL,1,0,'0'),('045a0b78b448167505e8d853e82ce3e3','4182','',15,'50','主离合状态','','2','mainClutchState','','0-脱开,1-结合,2-错误,3-无效',1,0,'0'),('04a4cb19d79d11e9b2f2000c29140043','4101','rpm',5,'31','发动机转速',NULL,'3',NULL,NULL,NULL,1,0,'0'),('04a4cb19d79d11e9b2f2000c2914004c','4101','rpm',5,'25','发动机转速',NULL,'3',NULL,NULL,NULL,1,0,'0'),('0692dab5d10b11e8a45b000c29140015','4288','%',21,'30','发动机负荷系数',NULL,'3','发动机负荷系数',NULL,NULL,1,0,'0'),('0692dab5d10b11e8a45b000c2914004c','4288','%',21,'20','发动机负荷系数',NULL,'3','发动机负荷系数',NULL,NULL,1,0,'0'),('07cac9c4950045de96c98733e045dc12','4100','℃',3,'338698becb2b4b38ac6d5cecc29dbe99','冷却水温','','3','coolantTemp','0','',1,0,'1'),('08c3e6dbd79d11e9b2f2000c29140044','6039','L/h',6,'31','发动机燃料流量',NULL,'3',NULL,NULL,NULL,1,0,'0'),('08c3e6dbd79d11e9b2f2000c2914004c','6039','L/h',6,'25','发动机燃料流量',NULL,'3',NULL,NULL,NULL,1,0,'0'),('08e3189232fe7b829635f5b5c1308465','4002',NULL,2,'52','开关量状态-MOTO',NULL,'2',NULL,NULL,'0-有启动信号,1-无启动信号',1,0,'0'),('0a72a3318b1a416f85cd6ac1b28b6617','4113','%',14,'338698becb2b4b38ac6d5cecc29dbe99','燃油位','','3','fuelLevel','0','',1,0,'1'),('0ac97cced79e11e9b2f2000c2914004c','6000',NULL,1,'26','诊断协议',NULL,'2',NULL,NULL,'0-ISO 15765,1-ISO 27145,2-SAE J1939,3-ISO 15031,254-无效',1,0,'0'),('0ac97cced79e11e9b2f2000c29140059','6000',NULL,1,'32','诊断协议',NULL,'2',NULL,NULL,'0-ISO 15765,1-ISO 27145,2-SAE J1939,3-ISO 15031,254-无效',1,0,'0'),('0c01280d91fb4113af3960b175c53dd6','4118','H',10,'338698becb2b4b38ac6d5cecc29dbe99','工作时间','x/10','3','workTime','1','',1,0,'1'),('0cf4087fd79d11e9b2f2000c29140045','6040','ppm',7,'31','SCR上游NOx传感器输出值',NULL,'3',NULL,NULL,NULL,1,0,'0'),('0cf4087fd79d11e9b2f2000c2914004c','6040','ppm',7,'25','SCR上游NOx传感器输出值',NULL,'3',NULL,NULL,NULL,1,0,'0'),('0df58102d893253d204cb442b4b4e4bc','-1',NULL,4,'49','当前位置',NULL,NULL,'当前位置(xml文件中不存在)',NULL,NULL,0,0,'0'),('0e8e0984b39e942d1a215e046ca82526','3019',NULL,5,'49',NULL,NULL,NULL,'GPS模块状态',NULL,NULL,1,0,'0'),('0fc4f481d79e11e9b2f2000c2914004c','4347',NULL,2,'26','MIL报警灯状态',NULL,'2',NULL,NULL,'0-未点亮,1-点亮',1,0,'0'),('0fc4f481d79e11e9b2f2000c29140060','4347',NULL,2,'32','MIL报警灯状态',NULL,'2',NULL,NULL,'0-未点亮,1-点亮',1,0,'0'),('1','2602',NULL,1,'1',NULL,NULL,NULL,'经度',NULL,NULL,0,0,'0'),('10','3012',NULL,10,'1',NULL,NULL,NULL,'方向',NULL,NULL,0,0,'0'),('10b79b86c97e11e9bab7d0946600e1f1','2601',NULL,5,'17','定位状态',NULL,'2','定位状态',NULL,'0-已定位,1-未定位',1,0,'0'),('11','4163','H',30,'2',NULL,'x/3600',NULL,'发动机工作时间',NULL,NULL,0,0,'0'),('110','2602',NULL,1,'8',NULL,NULL,NULL,'经度',NULL,NULL,0,0,'0'),('110b3229d79d11e9b2f2000c29140046','6041','ppm',8,'31','SCR下游NOx传感器输出值',NULL,'3',NULL,NULL,NULL,1,0,'0'),('110b3229d79d11e9b2f2000c2914004c','6041','ppm',8,'25','SCR下游NOx传感器输出值',NULL,'3',NULL,NULL,NULL,1,0,'0'),('111','2603',NULL,2,'8',NULL,NULL,NULL,'纬度',NULL,NULL,0,0,'0'),('11110ef06edb11e9a45b000c2914004c','4284','KPa',3,'24','发动机进气压力',NULL,NULL,'发动机进气压力',NULL,NULL,0,0,'0'),('112','-1',NULL,3,'8','当前位置',NULL,NULL,'当前位置(xml文件中不存在)',NULL,NULL,0,0,'0'),('113','3019',NULL,4,'8',NULL,NULL,NULL,'GPS模块状态',NULL,NULL,0,0,'0'),('114','2204',NULL,5,'8','GPS速度',NULL,NULL,'GPS速度',NULL,NULL,0,0,'0'),('115','3014',NULL,6,'8',NULL,NULL,'1','GPS时间',NULL,NULL,0,0,'0'),('116','TIME',NULL,7,'8','回传时间',NULL,'1','接收时间',NULL,NULL,0,0,'0'),('117','4014',NULL,8,'8',NULL,NULL,NULL,'水平精度因子',NULL,NULL,0,0,'0'),('118','3012',NULL,9,'8',NULL,NULL,NULL,'方向',NULL,NULL,0,0,'0'),('119','4030',NULL,10,'8','作业车辆状态',NULL,NULL,'车辆状态',NULL,NULL,0,0,'0'),('12','4101',NULL,31,'2',NULL,NULL,NULL,'发动机转速',NULL,NULL,0,0,'0'),('120','4031',NULL,11,'8',NULL,NULL,NULL,'作业标识',NULL,NULL,0,0,'0'),('121','4032',NULL,12,'8',NULL,NULL,NULL,'实时亩数',NULL,NULL,0,0,'0'),('122','4033',NULL,13,'8',NULL,NULL,NULL,'作业时长',NULL,NULL,0,0,'0'),('123','4193',NULL,14,'8',NULL,NULL,NULL,'实时深度',NULL,NULL,0,0,'0'),('124','4194',NULL,15,'8',NULL,NULL,NULL,'实时合格率',NULL,NULL,0,0,'0'),('125','4195',NULL,16,'8',NULL,NULL,NULL,'深松传感器通讯故障',NULL,NULL,0,0,'0'),('125978f009a911eab2f2000c2914004c','2601',NULL,5,'39','GPS定位状态',NULL,'2','定位状态',NULL,'0-有效定位,1-无效定位',1,0,'0'),('125a632a09a911eab2f2000c2914004c','4350',NULL,0,'39','数据加密',NULL,'2','数据加密',NULL,'1-数据不加密,2-数据经过RSA算法加密,3-数据经过国密SM2算法加密,254-异常,255-无效',0,0,'0'),('125a649609a911eab2f2000c2914004c','2602',NULL,1,'39',NULL,NULL,'3','经度',NULL,NULL,1,0,'0'),('125a656a09a911eab2f2000c2914004c','3012',NULL,8,'39',NULL,NULL,'3','方向',NULL,NULL,1,0,'0'),('125a661b09a911eab2f2000c2914004c','2603',NULL,2,'39',NULL,NULL,'3','纬度',NULL,NULL,1,0,'0'),('125a66d109a911eab2f2000c2914004c','-1',NULL,14,'39','当前位置',NULL,NULL,'当前位置(xml文件中不存在)',NULL,NULL,0,0,'0'),('125a677f09a911eab2f2000c2914004c','3019',NULL,6,'39','GPS模块状态',NULL,'2','GPS模块状态',NULL,'0- 模块正常,1-模块异常',1,0,'0'),('125a682809a911eab2f2000c2914004c','2204',NULL,7,'39','GPS速度',NULL,'3','GPS速度',NULL,NULL,1,0,'0'),('125a68cb09a911eab2f2000c2914004c','3014',NULL,3,'39',NULL,NULL,'1','GPS时间',NULL,NULL,1,0,'0'),('125a696e09a911eab2f2000c2914004c','TIME',NULL,4,'39','回传时间',NULL,'1','接收时间',NULL,NULL,1,0,'0'),('125a6a1409a911eab2f2000c2914004c','4014',NULL,9,'39',NULL,NULL,'3','水平精度因子',NULL,NULL,1,0,'0'),('125a6b1009a911eab2f2000c2914004c','3013','m',11,'39','海拔高度',NULL,'3','海拔高度',NULL,NULL,1,0,'0'),('125a6c4b09a911eab2f2000c2914004c','3015',NULL,12,'39','使用卫星数',NULL,'3','使用卫星数',NULL,NULL,1,0,'0'),('125a6e0909a911eab2f2000c2914004c','3016',NULL,13,'39','可视卫星数',NULL,'3','可视卫星数',NULL,NULL,1,0,'0'),('126','4196',NULL,17,'8',NULL,NULL,NULL,'深松传感器角度值错误',NULL,NULL,0,0,'0'),('13','4100',NULL,32,'2',NULL,NULL,NULL,'冷却水温',NULL,NULL,0,0,'0'),('139b40e411bd11eab2f2000c2914004c','2601',NULL,5,'44','GPS定位状态',NULL,'2','定位状态',NULL,'0-有效定位,1-无效定位',1,0,'0'),('139c39cb11bd11eab2f2000c2914004c','4350',NULL,0,'44','数据加密',NULL,'2','数据加密',NULL,'1-数据不加密,2-数据经过RSA算法加密,3-数据经过国密SM2算法加密,254-异常,255-无效',0,0,'0'),('139c3b1411bd11eab2f2000c2914004c','2602',NULL,1,'44',NULL,NULL,'3','经度',NULL,NULL,1,0,'0'),('139c3bd211bd11eab2f2000c2914004c','3012',NULL,8,'44',NULL,NULL,'3','方向',NULL,NULL,1,0,'0'),('139c3c8811bd11eab2f2000c2914004c','2603',NULL,2,'44',NULL,NULL,'3','纬度',NULL,NULL,1,0,'0'),('139c3d2a11bd11eab2f2000c2914004c','-1',NULL,14,'44','当前位置',NULL,NULL,'当前位置(xml文件中不存在)',NULL,NULL,0,0,'0'),('139c3dd911bd11eab2f2000c2914004c','3019',NULL,6,'44','GPS模块状态',NULL,'2','GPS模块状态',NULL,'0- 模块正常,1-模块异常',1,0,'0'),('139c3ec311bd11eab2f2000c2914004c','2204',NULL,7,'44','GPS速度',NULL,'3','GPS速度',NULL,NULL,1,0,'0'),('139c3fa411bd11eab2f2000c2914004c','3014',NULL,3,'44',NULL,NULL,'1','GPS时间',NULL,NULL,1,0,'0'),('139c404a11bd11eab2f2000c2914004c','TIME',NULL,4,'44','回传时间',NULL,'1','接收时间',NULL,NULL,1,0,'0'),('139c40eb11bd11eab2f2000c2914004c','4014',NULL,9,'44',NULL,NULL,'3','水平精度因子',NULL,NULL,1,0,'0'),('139c42bd11bd11eab2f2000c2914004c','3013','m',11,'44','海拔高度',NULL,'3','海拔高度',NULL,NULL,1,0,'0'),('139c43a111bd11eab2f2000c2914004c','3015',NULL,12,'44','使用卫星数',NULL,'3','使用卫星数',NULL,NULL,1,0,'0'),('139c444611bd11eab2f2000c2914004c','3016',NULL,13,'44','可视卫星数',NULL,'3','可视卫星数',NULL,NULL,1,0,'0'),('13e5b17cd79e11e9b2f2000c2914004c','6037',NULL,3,'26','故障码总数',NULL,'3',NULL,NULL,NULL,1,0,'0'),('13e5b17cd79e11e9b2f2000c29140061','6037',NULL,3,'32','故障码总数',NULL,'3',NULL,NULL,NULL,1,0,'0'),('14','4173','℃',33,'2',NULL,NULL,NULL,'变速箱油温',NULL,NULL,0,0,'0'),('14a5375a488f4e45815e4658a116eaba','4261',NULL,19,'18','冷启动加热状态',NULL,'2','冷启动加热状态',NULL,'0-正常,1-不正常',1,0,'0'),('15','4176',NULL,34,'2',NULL,NULL,NULL,'环境温度',NULL,NULL,0,0,'0'),('15593f94d27911e8a45b000c29140016','4291',NULL,25,'30','车身故障DM1',NULL,NULL,'车身故障DM1',NULL,NULL,0,0,'0'),('15593f94d27911e8a45b000c2914004c','4291',NULL,25,'20','车身故障DM1',NULL,NULL,'车身故障DM1',NULL,NULL,0,0,'0'),('155b8093d79d11e9b2f2000c29140047','6042','%',9,'31','反应剂余量',NULL,'3',NULL,NULL,NULL,1,0,'0'),('155b8093d79d11e9b2f2000c2914004c','6042','%',9,'25','反应剂余量',NULL,'3',NULL,NULL,NULL,1,0,'0'),('16','4108','MPa',35,'2',NULL,'x/1000',NULL,'机油压力',NULL,NULL,0,0,'0'),('17','4109',NULL,36,'2',NULL,NULL,NULL,'大气压力',NULL,NULL,0,0,'0'),('17cc1636164644e5956c6005cc6c8171','3040','KM/H',16,'18','行驶速度',NULL,'3','CAN速度',NULL,NULL,1,0,'0'),('18','3040',NULL,37,'2',NULL,NULL,NULL,'CAN速度',NULL,NULL,0,0,'0'),('18095e17d79e11e9b2f2000c2914004c','6038',NULL,4,'26','故障码信息列表',NULL,'6',NULL,NULL,'separator-|,EG03100003117010001-冷却液高温报警,EG03100003117010101-发动机高温报警,EG03100003117010201-制动系统报警,EG03100003117010301-发动机超速报警,EG03100003117010401-发动机堵转报警,EG03100003117010501-加速踏板信号故障报警,EG03100003117010601-进气压力感知器线路报警,EG03100003117010701-进气温度感知器线路报警,EG03100003117010801-引擎增压系统故障报警,EG03100003117010901-引擎多缸失火报警',0,0,'0'),('18095e17d79e11e9b2f2000c29140062','6038',NULL,4,'32','故障码信息列表',NULL,'6',NULL,NULL,'separator-|,EG03100003117010001-冷却液高温报警,EG03100003117010101-发动机高温报警,EG03100003117010201-制动系统报警,EG03100003117010301-发动机超速报警,EG03100003117010401-发动机堵转报警,EG03100003117010501-加速踏板信号故障报警,EG03100003117010601-进气压力感知器线路报警,EG03100003117010701-进气温度感知器线路报警,EG03100003117010801-引擎增压系统故障报警,EG03100003117010901-引擎多缸失火报警',0,0,'0'),('19','4174',NULL,38,'2',NULL,NULL,NULL,'燃油消耗总量',NULL,NULL,0,0,'0'),('19231b41d79d11e9b2f2000c29140048','6043','kg/h',10,'31','进气量',NULL,'3',NULL,NULL,NULL,1,0,'0'),('19231b41d79d11e9b2f2000c2914004c','6043','kg/h',10,'25','进气量',NULL,'3',NULL,NULL,NULL,1,0,'0'),('1b7ff154753efa236506a784d609a89a','4010','V',12,'52','输入电压 2','x/1000','3',NULL,NULL,NULL,1,0,'0'),('1bfc422c13065f92f5f3a04a61a6beb2','4184','kN',27,'50','提升器右提升力','','3','rightLiftingFource','','',1,0,'0'),('1cd7beaad10b11e8a45b000c29140017','4289','%',22,'30','实际最大可用发动机-扭矩百分比',NULL,'3','实际最大可用发动机-扭矩百分比',NULL,NULL,1,0,'0'),('1cd7beaad10b11e8a45b000c2914004c','4289','%',22,'20','实际最大可用发动机-扭矩百分比',NULL,'3','实际最大可用发动机-扭矩百分比',NULL,NULL,1,0,'0'),('1cf0d67ad79d11e9b2f2000c29140049','6044','℃',11,'31','SCR入口温度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('1cf0d67ad79d11e9b2f2000c2914004c','6044','℃',11,'25','SCR入口温度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('1d91a33011bd11eab2f2000c2914004c','4288','%',21,'45','发动机负荷系数',NULL,'3','发动机负荷系数',NULL,NULL,1,0,'0'),('1d91a8cb11bd11eab2f2000c2914004c','4291',NULL,25,'45','车身故障DM1',NULL,NULL,'车身故障DM1',NULL,NULL,0,0,'0'),('1d91aa9611bd11eab2f2000c2914004c','4289','%',22,'45','实际最大可用发动机-扭矩百分比',NULL,'3','实际最大可用发动机-扭矩百分比',NULL,NULL,1,0,'0'),('1d91ac3711bd11eab2f2000c2914004c','4175','L/h',7,'45','燃油消耗率',NULL,'3','小时油耗',NULL,NULL,1,0,'0'),('1d91add411bd11eab2f2000c2914004c','4292',NULL,26,'45','车身故障DM2',NULL,NULL,'车身故障DM2',NULL,NULL,0,0,'0'),('1d91af4c11bd11eab2f2000c2914004c','4279','rpm',1,'45','理想发动机转速',NULL,'3','理想发动机转速',NULL,NULL,1,0,'0'),('1d91b0bc11bd11eab2f2000c2914004c','4110','kPa',15,'45','发动机增压压力',NULL,'3','增压压力',NULL,NULL,1,0,'0'),('1d945ec611bd11eab2f2000c2914004c','4280',NULL,3,'45','发动机等待启动灯',NULL,'2','发动机等待启动灯',NULL,'0-关闭,1-打开',1,0,'0'),('1d947aa711bd11eab2f2000c2914004c','4281',NULL,5,'45','发动机保护系统已关闭发动机',NULL,'2','发动机保护系统已关闭发动机',NULL,'0-关闭未激活,1-关闭已激活',1,0,'0'),('1d94861e11bd11eab2f2000c2914004c','4250','%',23,'45','标准摩擦-扭矩百分比',NULL,'3','摩擦扭矩百分比',NULL,NULL,1,0,'0'),('1d94878811bd11eab2f2000c2914004c','4282','KM/L',8,'45','即时燃油经济性',NULL,'3','即时燃油经济性',NULL,NULL,1,0,'0'),('1d9488a911bd11eab2f2000c2914004c','4290','%',24,'45','估计的发动机寄生损失-扭矩百分比',NULL,'3','估计的发动机寄生损失-扭矩百分比',NULL,NULL,1,0,'0'),('1d95a98011bd11eab2f2000c2914004c','4283','°C',13,'45','发动机进气管温度',NULL,'3','发动机进气管温度',NULL,NULL,1,0,'0'),('1d95ac1e11bd11eab2f2000c2914004c','4284','kPa',16,'45','发动机进气压力',NULL,'3','发动机进气压力',NULL,NULL,1,0,'0'),('1d95ad9f11bd11eab2f2000c2914004c','4243','℃',10,'45','发动机机油温度',NULL,'3','机油温度',NULL,NULL,1,0,'0'),('1d95af0c11bd11eab2f2000c2914004c','4023','L',6,'45','发动机总燃油量',NULL,'3','累计油耗',NULL,NULL,1,0,'0'),('1d95b07911bd11eab2f2000c2914004c','4101','rpm',0,'45','发动机转速',NULL,'3','发动机转速',NULL,NULL,2,0,'0'),('1d95b1c011bd11eab2f2000c2914004c','4108','mPa',4,'45','发动机机油压力','x/1000','3','机油压力',NULL,NULL,1,0,'0'),('1d95b32b11bd11eab2f2000c2914004c','4163','h',2,'45','发动机总工作小时数','x/3600','3','发动机工作时间',NULL,NULL,2,0,'0'),('1d95b52f11bd11eab2f2000c2914004c','4103','%',19,'45','实际发动机-扭矩百分比',NULL,'3','发动机实际扭矩',NULL,NULL,1,0,'0'),('1d95b6a811bd11eab2f2000c2914004c','4109','kPa',14,'45','大气压力',NULL,'3','大气压力',NULL,NULL,1,0,'0'),('1d95b8fc11bd11eab2f2000c2914004c','4112','°C',12,'45','空气进气温度',NULL,'3','进气温度',NULL,NULL,1,0,'0'),('1d95ba8711bd11eab2f2000c2914004c','4245','℃',11,'45','外界温度',NULL,'3','大气温度',NULL,NULL,1,0,'0'),('1d95bba711bd11eab2f2000c2914004c','4177','°C',9,'45','发动机冷却液温度',NULL,'3','冷却水温度',NULL,NULL,1,0,'0'),('1d95bca811bd11eab2f2000c2914004c','4285',NULL,17,'45','发动机扭矩模式',NULL,'3','发动机扭矩模式',NULL,NULL,1,0,'0'),('1d95be7d11bd11eab2f2000c2914004c','DATE_TYPE',NULL,-1,'45',NULL,NULL,NULL,NULL,NULL,NULL,0,0,'0'),('1d95bf9011bd11eab2f2000c2914004c','4286','%',18,'45','驾驶员要求的发动机-扭矩百分比',NULL,'3','驾驶员要求的发动机-扭矩百分比',NULL,NULL,1,0,'0'),('1d95c07b11bd11eab2f2000c2914004c','4287','%',20,'45','发动机需求-扭矩百分比',NULL,'3','发动机需求-扭矩百分比',NULL,NULL,1,0,'0'),('2','2603',NULL,2,'1',NULL,NULL,NULL,'纬度',NULL,NULL,0,0,'0'),('20','4162',NULL,39,'2','燃油量',NULL,NULL,'燃油量（液位）',NULL,NULL,0,0,'0'),('200','2602',NULL,1,'9',NULL,NULL,NULL,'经度',NULL,NULL,0,0,'0'),('201','2603',NULL,1,'9',NULL,NULL,NULL,'纬度',NULL,NULL,0,0,'0'),('202','-1',NULL,4,'9','当前位置',NULL,NULL,'当前位置(xml文件中不存在)',NULL,NULL,0,0,'0'),('203','3019',NULL,5,'9',NULL,NULL,NULL,'GPS模块状态',NULL,NULL,0,0,'0'),('204','2204',NULL,6,'9','GPS速度',NULL,NULL,'GPS速度',NULL,NULL,0,0,'0'),('205','3014',NULL,7,'9',NULL,NULL,'1','GPS时间',NULL,NULL,0,0,'0'),('20565d2dd11011e8a45b000c29140018','4175','L/h',7,'30','燃油消耗率',NULL,'3','小时油耗',NULL,NULL,1,0,'0'),('20565d2dd11011e8a45b000c2914004c','4175','L/h',7,'20','燃油消耗率',NULL,'3','小时油耗',NULL,NULL,1,0,'0'),('206','TIME',NULL,8,'9','回传时间',NULL,'1','接收时间',NULL,NULL,0,0,'0'),('207','4014',NULL,9,'9',NULL,NULL,NULL,'水平精度因子',NULL,NULL,0,0,'0'),('208','3012',NULL,10,'9',NULL,NULL,NULL,'方向',NULL,NULL,0,0,'0'),('209','4030',NULL,76,'9','作业车辆状态',NULL,NULL,'车辆状态',NULL,NULL,0,0,'0'),('21','4022',NULL,40,'2',NULL,NULL,NULL,'单次油耗',NULL,NULL,0,0,'0'),('210','4031',NULL,77,'9',NULL,NULL,NULL,'作业标识',NULL,NULL,0,0,'0'),('211','4032',NULL,78,'9',NULL,NULL,NULL,'实时亩数',NULL,NULL,0,0,'0'),('212','4033',NULL,79,'9',NULL,NULL,NULL,'作业时长',NULL,NULL,0,0,'0'),('213','4101',NULL,31,'10',NULL,NULL,NULL,'发动机转速',NULL,NULL,0,0,'0'),('214','4100',NULL,32,'10',NULL,NULL,NULL,'冷却水温',NULL,NULL,0,0,'0'),('215','4108','MPa',35,'10',NULL,'x/1000',NULL,'机油压力',NULL,NULL,0,0,'0'),('216','4162',NULL,39,'10','燃油量',NULL,NULL,'燃油量（液位）',NULL,NULL,0,0,'0'),('218','4164',NULL,42,'10',NULL,NULL,NULL,'系统电压',NULL,NULL,0,0,'0'),('219','3040',NULL,80,'10','行驶速度',NULL,NULL,'CAN速度',NULL,NULL,0,0,'0'),('22','4175','L/h',41,'2','每小时油耗',NULL,NULL,'瞬时油耗',NULL,NULL,0,0,'0'),('220','2205',NULL,53,'10',NULL,NULL,NULL,'总里程',NULL,NULL,0,0,'0'),('221','4182',NULL,68,'10',NULL,NULL,NULL,'主离合状态',NULL,NULL,0,0,'0'),('222','4183',NULL,81,'10',NULL,NULL,NULL,'提升器左提升力',NULL,NULL,0,0,'0'),('22260a822cbfe8350cedef9aa9887d0f','4354',NULL,17,'52','开壳告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('223','4184',NULL,82,'10',NULL,NULL,NULL,'提升器右提升力',NULL,NULL,0,0,'0'),('224','4185',NULL,83,'10',NULL,NULL,NULL,'机具离地高度',NULL,NULL,0,0,'0'),('225','4186',NULL,84,'10',NULL,NULL,NULL,'POT转速',NULL,NULL,0,0,'0'),('226','4187',NULL,85,'10',NULL,NULL,NULL,'液压系统压力',NULL,NULL,0,0,'0'),('22cf42fc21e259f203812e4612fd4028','4108','kPa',6,'50','机油压力','','3','engineOilPressure','','',1,0,'0'),('23','4164',NULL,42,'2',NULL,NULL,NULL,'系统电压',NULL,NULL,0,0,'0'),('24','4178','KN',43,'2','传感器1拉力值','(x-2.5)*25',NULL,'传感器1电压',NULL,NULL,0,0,'0'),('25','4179','KN',44,'2','传感器2拉力值','(x-2.5)*25',NULL,'传感器2电压',NULL,NULL,0,0,'0'),('27','3014',NULL,46,'2',NULL,NULL,'1','GPS时间',NULL,NULL,0,0,'0'),('277e7a3e11bd11eab2f2000c2914004c','4250','%',4,'46','摩擦扭矩',NULL,'3',NULL,NULL,NULL,1,0,'0'),('277e7dec11bd11eab2f2000c2914004c','4101','rpm',5,'46','发动机转速',NULL,'3',NULL,NULL,NULL,1,0,'0'),('278015fe11bd11eab2f2000c2914004c','6039','L/h',6,'46','发动机燃料流量',NULL,'3',NULL,NULL,NULL,1,0,'0'),('2780194711bd11eab2f2000c2914004c','6040','ppm',7,'46','SCR上游NOx传感器输出值',NULL,'3',NULL,NULL,NULL,1,0,'0'),('27801a1611bd11eab2f2000c2914004c','6041','ppm',8,'46','SCR下游NOx传感器输出值',NULL,'3',NULL,NULL,NULL,1,0,'0'),('27801aad11bd11eab2f2000c2914004c','6042','%',9,'46','反应剂余量',NULL,'3',NULL,NULL,NULL,1,0,'0'),('27801b4511bd11eab2f2000c2914004c','6043','kg/h',10,'46','进气量',NULL,'3',NULL,NULL,NULL,1,0,'0'),('27801be611bd11eab2f2000c2914004c','6044','℃',11,'46','SCR入口温度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('27801c7d11bd11eab2f2000c2914004c','6045','℃',12,'46','SCR出口温度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('27801d0b11bd11eab2f2000c2914004c','6046','kPa',13,'46','DPF压差',NULL,'3',NULL,NULL,NULL,1,0,'0'),('27801d9611bd11eab2f2000c2914004c','4177','℃',14,'46','发动机冷却液温度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('27801e2c11bd11eab2f2000c2914004c','4162','%',15,'46','油箱液位',NULL,'3',NULL,NULL,NULL,1,0,'0'),('27801ebb11bd11eab2f2000c2914004c','4348','%',16,'46','实际EGR阀开度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('27801f6211bd11eab2f2000c2914004c','4349','%',17,'46','设定的EGR阀开度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('27801ff211bd11eab2f2000c2914004c','3040','km/h',1,'46','车速',NULL,'3',NULL,NULL,NULL,1,0,'0'),('2780208311bd11eab2f2000c2914004c','4109','kPa',2,'46','大气压力',NULL,'3',NULL,NULL,NULL,1,0,'0'),('2780210b11bd11eab2f2000c2914004c','4103','%',3,'46','发动机净输出扭矩',NULL,'3',NULL,NULL,NULL,1,0,'0'),('27f9c48e469c89377e296896a3fb5ffa','3014','',8,'4b0bcd3b652b4f078f46cc5ef7768a8b','','','1','GPS时间','0','',1,0,'1'),('28','TIME',NULL,47,'2','回传时间',NULL,'1','接收时间',NULL,NULL,0,0,'0'),('29','4021',NULL,48,'2','FMI',NULL,NULL,'故障码MFI列表',NULL,NULL,0,0,'0'),('2aa73fb4d79d11e9b2f2000c2914004c','6045','℃',12,'25','SCR出口温度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('2aa73fb4d79d11e9b2f2000c29140050','6045','℃',12,'31','SCR出口温度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('2c133a156edb11e9a45b000c2914004c','4247','%',4,'24','发动机负荷',NULL,NULL,'发动机负荷',NULL,NULL,0,0,'0'),('2c707a4cdeff134704b2090405a979fe','4253','%',5,'50','机油液位','','3','oilLevel','','',1,0,'0'),('2ecaa220d79d11e9b2f2000c2914004c','6046','kPa',13,'25','DPF压差',NULL,'3',NULL,NULL,NULL,1,0,'0'),('2ecaa220d79d11e9b2f2000c29140051','6046','kPa',13,'31','DPF压差',NULL,'3',NULL,NULL,NULL,1,0,'0'),('2f5fa399455a82b6789ca2bad718d962','4186','RPM',16,'50','PTO转速','','3','POTRevs','','',1,0,'0'),('30','4020',NULL,49,'2','SPN',NULL,NULL,'故障码SPN列表',NULL,NULL,0,0,'0'),('3020f8e4d27911e8a45b000c29140019','4292',NULL,26,'30','车身故障DM2',NULL,NULL,'车身故障DM2',NULL,NULL,0,0,'0'),('3020f8e4d27911e8a45b000c2914004c','4292',NULL,26,'20','车身故障DM2',NULL,NULL,'车身故障DM2',NULL,NULL,0,0,'0'),('30b88bf111bd11eab2f2000c2914004c','6000',NULL,1,'47','诊断协议',NULL,'2',NULL,NULL,'0-ISO 15765,1-ISO 27145,2-SAE J1939,3-ISO 15031,254-无效',1,0,'0'),('30b890c411bd11eab2f2000c2914004c','4347',NULL,2,'47','MIL报警灯状态',NULL,'2',NULL,NULL,'0-未点亮,1-点亮',1,0,'0'),('30b891b811bd11eab2f2000c2914004c','6037',NULL,3,'47','故障码总数',NULL,'3',NULL,NULL,NULL,1,0,'0'),('30b8926811bd11eab2f2000c2914004c','6038',NULL,4,'47','故障码信息列表',NULL,'6',NULL,NULL,'separator-|,EG03100003117010001-冷却液高温报警,EG03100003117010101-发动机高温报警,EG03100003117010201-制动系统报警,EG03100003117010301-发动机超速报警,EG03100003117010401-发动机堵转报警,EG03100003117010501-加速踏板信号故障报警,EG03100003117010601-进气压力感知器线路报警,EG03100003117010701-进气温度感知器线路报警,EG03100003117010801-引擎增压系统故障报警,EG03100003117010901-引擎多缸失火报警',0,0,'0'),('31','4180',NULL,73,'2','行驶里程',NULL,NULL,'行驶里程',NULL,NULL,0,0,'0'),('31fecf73eb41beda59c4404be76c6fe4','4176','℃',21,'50','环境温度','','3','ambientTemp','','',1,0,'0'),('331bae64d79d11e9b2f2000c2914004c','4177','℃',14,'25','发动机冷却液温度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('331bae64d79d11e9b2f2000c29140052','4177','℃',14,'31','发动机冷却液温度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3570caa0d10a11e8a45b000c29140020','4279','rpm',1,'30','理想发动机转速',NULL,'3','理想发动机转速',NULL,NULL,1,0,'0'),('3570caa0d10a11e8a45b000c2914004c','4279','rpm',1,'20','理想发动机转速',NULL,'3','理想发动机转速',NULL,NULL,1,0,'0'),('36bfafcad79d11e9b2f2000c2914004c','4162','%',15,'25','油箱液位',NULL,'3',NULL,NULL,NULL,1,0,'0'),('36bfafcad79d11e9b2f2000c29140053','4162','%',15,'31','油箱液位',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3755280fafd94ecd4ee424081e5ed834','3013','M',11,'49','海拔高度',NULL,'3','海拔高度',NULL,NULL,0,0,'0'),('37fdd43111bd11eab2f2000c2914004c','4001',NULL,1,'48','开关量状态-ACC',NULL,'2',NULL,NULL,'0-电钥匙关闭,1- 电钥匙打开',1,0,'0'),('37fdd7f811bd11eab2f2000c2914004c','4002',NULL,2,'48','开关量状态-MOTO',NULL,'2',NULL,NULL,'0-有启动信号,1-无启动信号',1,0,'0'),('37fdd91211bd11eab2f2000c2914004c','4003',NULL,3,'48','开关量状态-电平 1',NULL,'2',NULL,NULL,'0-低电平,1-高电平',1,0,'0'),('37fdda2e11bd11eab2f2000c2914004c','4004',NULL,4,'48','开关量状态-电平 2',NULL,'2',NULL,NULL,'0-低电平,1- 高电平',1,0,'0'),('37fddb2a11bd11eab2f2000c2914004c','3020',NULL,5,'48','ACC状态',NULL,'5',NULL,NULL,'电钥匙打开-打开-1,电钥匙关闭-关闭-0',1,0,'0'),('37fddcd311bd11eab2f2000c2914004c','3021',NULL,6,'48','终端 MOTO 状态',NULL,NULL,NULL,NULL,NULL,1,0,'0'),('37fddd9e11bd11eab2f2000c2914004c','4005','Hz',7,'48','FRQ1 输入',NULL,'3',NULL,NULL,NULL,1,0,'0'),('37fdde4411bd11eab2f2000c2914004c','4006','Hz',8,'48','FRQ2 输入',NULL,'3',NULL,NULL,NULL,1,0,'0'),('37fddee411bd11eab2f2000c2914004c','4007','Hz',9,'48','PWM1 输出频率',NULL,'3',NULL,NULL,NULL,1,0,'0'),('37fddf8611bd11eab2f2000c2914004c','4008','Hz',10,'48','PWM2 输出频率',NULL,'3',NULL,NULL,NULL,1,0,'0'),('37fde02211bd11eab2f2000c2914004c','4009','mv',11,'48','输入电压 1',NULL,'3',NULL,NULL,NULL,1,0,'0'),('37fde17b11bd11eab2f2000c2914004c','4010','mv',12,'48','输入电压 2',NULL,'3',NULL,NULL,NULL,1,0,'0'),('37fde2ce11bd11eab2f2000c2914004c','4011','mv',13,'48','输入电源电压',NULL,'3',NULL,NULL,NULL,1,0,'0'),('37fde40411bd11eab2f2000c2914004c','4012','mv',14,'48','输入电池电压',NULL,'3',NULL,NULL,NULL,1,0,'0'),('37fde53f11bd11eab2f2000c2914004c','3006',NULL,20,'48','固件版本号',NULL,NULL,NULL,NULL,NULL,1,0,'0'),('37fde6a311bd11eab2f2000c2914004c','3007',NULL,21,'48','硬件版本号',NULL,NULL,NULL,NULL,NULL,1,0,'0'),('37fde80b11bd11eab2f2000c2914004c','4352',NULL,15,'48','外壳状态',NULL,'2',NULL,NULL,'0-外壳关闭,1-外壳打开',1,0,'0'),('37fde94b11bd11eab2f2000c2914004c','4353',NULL,16,'48','拆除告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('37fdeaad11bd11eab2f2000c2914004c','4354',NULL,17,'48','开壳告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('37fdebe811bd11eab2f2000c2914004c','4355',NULL,18,'48','GPS 天线告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('37fe756f11bd11eab2f2000c2914004c','4356',NULL,19,'48','CAN 异常告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('3860a15fb7fda08f83c972f9b67fa960','4012','V',3,'0ad4727a2920487cb436822b9da78c1a','备用电池电压','x/1000','3','输入电池电压',NULL,NULL,1,0,'0'),('3ab4d2cad79d11e9b2f2000c2914004c','4348','%',16,'25','实际EGR阀开度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3ab4d2cad79d11e9b2f2000c29140054','4348','%',16,'31','实际EGR阀开度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3c2682c409a911eab2f2000c2914004c','4288','%',21,'40','发动机负荷系数',NULL,'3','发动机负荷系数',NULL,NULL,1,0,'0'),('3c26897c09a911eab2f2000c2914004c','4291',NULL,25,'40','车身故障DM1',NULL,NULL,'车身故障DM1',NULL,NULL,0,0,'0'),('3c268af209a911eab2f2000c2914004c','4289','%',22,'40','实际最大可用发动机-扭矩百分比',NULL,'3','实际最大可用发动机-扭矩百分比',NULL,NULL,1,0,'0'),('3c268bbb09a911eab2f2000c2914004c','4175','L/h',7,'40','燃油消耗率',NULL,'3','小时油耗',NULL,NULL,1,0,'0'),('3c268c8009a911eab2f2000c2914004c','4292',NULL,26,'40','车身故障DM2',NULL,NULL,'车身故障DM2',NULL,NULL,0,0,'0'),('3c268d9f09a911eab2f2000c2914004c','4279','rpm',1,'40','理想发动机转速',NULL,'3','理想发动机转速',NULL,NULL,1,0,'0'),('3c268e9b09a911eab2f2000c2914004c','4110','kPa',15,'40','发动机增压压力',NULL,'3','增压压力',NULL,NULL,1,0,'0'),('3c268fd509a911eab2f2000c2914004c','4280',NULL,3,'40','发动机等待启动灯',NULL,'2','发动机等待启动灯',NULL,'0-关闭,1-打开',1,0,'0'),('3c26909d09a911eab2f2000c2914004c','4281',NULL,5,'40','发动机保护系统已关闭发动机',NULL,'2','发动机保护系统已关闭发动机',NULL,'0-关闭未激活,1-关闭已激活',1,0,'0'),('3c2691b309a911eab2f2000c2914004c','4250','%',23,'40','标准摩擦-扭矩百分比',NULL,'3','摩擦扭矩百分比',NULL,NULL,1,0,'0'),('3c26931609a911eab2f2000c2914004c','4282','KM/L',8,'40','即时燃油经济性',NULL,'3','即时燃油经济性',NULL,NULL,1,0,'0'),('3c26941909a911eab2f2000c2914004c','4290','%',24,'40','估计的发动机寄生损失-扭矩百分比',NULL,'3','估计的发动机寄生损失-扭矩百分比',NULL,NULL,1,0,'0'),('3c2694c809a911eab2f2000c2914004c','4283','°C',13,'40','发动机进气管温度',NULL,'3','发动机进气管温度',NULL,NULL,1,0,'0'),('3c26956909a911eab2f2000c2914004c','4284','kPa',16,'40','发动机进气压力',NULL,'3','发动机进气压力',NULL,NULL,1,0,'0'),('3c26961609a911eab2f2000c2914004c','4243','℃',10,'40','发动机机油温度',NULL,'3','机油温度',NULL,NULL,1,0,'0'),('3c2696b709a911eab2f2000c2914004c','4023','L',6,'40','发动机总燃油量',NULL,'3','累计油耗',NULL,NULL,1,0,'0'),('3c26975a09a911eab2f2000c2914004c','4101','rpm',0,'40','发动机转速',NULL,'3','发动机转速',NULL,NULL,2,0,'0'),('3c2697fa09a911eab2f2000c2914004c','4108','mPa',4,'40','发动机机油压力','x/1000','3','机油压力',NULL,NULL,1,0,'0'),('3c2698a109a911eab2f2000c2914004c','4163','h',2,'40','发动机总工作小时数','x/3600','3','发动机工作时间',NULL,NULL,2,0,'0'),('3c26995309a911eab2f2000c2914004c','4103','%',19,'40','实际发动机-扭矩百分比',NULL,'3','发动机实际扭矩',NULL,NULL,1,0,'0'),('3c269a7609a911eab2f2000c2914004c','4109','kPa',14,'40','大气压力',NULL,'3','大气压力',NULL,NULL,1,0,'0'),('3c269bca09a911eab2f2000c2914004c','4112','°C',12,'40','空气进气温度',NULL,'3','进气温度',NULL,NULL,1,0,'0'),('3c269d2a09a911eab2f2000c2914004c','4245','℃',11,'40','外界温度',NULL,'3','大气温度',NULL,NULL,1,0,'0'),('3c269e2409a911eab2f2000c2914004c','4177','°C',9,'40','发动机冷却液温度',NULL,'3','冷却水温度',NULL,NULL,1,0,'0'),('3c269ecd09a911eab2f2000c2914004c','4285',NULL,17,'40','发动机扭矩模式',NULL,'3','发动机扭矩模式',NULL,NULL,1,0,'0'),('3c269f6909a911eab2f2000c2914004c','DATE_TYPE',NULL,-1,'40',NULL,NULL,NULL,NULL,NULL,NULL,0,0,'0'),('3c26a00a09a911eab2f2000c2914004c','4286','%',18,'40','驾驶员要求的发动机-扭矩百分比',NULL,'3','驾驶员要求的发动机-扭矩百分比',NULL,NULL,1,0,'0'),('3c26a0ab09a911eab2f2000c2914004c','4287','%',20,'40','发动机需求-扭矩百分比',NULL,'3','发动机需求-扭矩百分比',NULL,NULL,1,0,'0'),('3c80be21da0111e9b2f2000c2914004c','4001',NULL,1,'27','开关量状态-ACC',NULL,'2',NULL,NULL,'0-电钥匙关闭,1- 电钥匙打开',1,0,'0'),('3c80be21da0111e9b2f2000c29140063','4001',NULL,1,'33','开关量状态-ACC',NULL,'2',NULL,NULL,'0-电钥匙关闭,1- 电钥匙打开',1,0,'0'),('3c80be4cda0111e9b2f2000c2914004c','4002',NULL,2,'27','开关量状态-MOTO',NULL,'2',NULL,NULL,'0-有启动信号,1-无启动信号',1,0,'0'),('3c80be4cda0111e9b2f2000c29140064','4002',NULL,2,'33','开关量状态-MOTO',NULL,'2',NULL,NULL,'0-有启动信号,1-无启动信号',1,0,'0'),('3c80be56da0111e9b2f2000c2914004c','4003',NULL,3,'27','开关量状态-电平 1',NULL,'2',NULL,NULL,'0-低电平,1-高电平',1,0,'0'),('3c80be56da0111e9b2f2000c29140065','4003',NULL,3,'33','开关量状态-电平 1',NULL,'2',NULL,NULL,'0-低电平,1-高电平',1,0,'0'),('3c80be61da0111e9b2f2000c2914004c','4004',NULL,4,'27','开关量状态-电平 2',NULL,'2',NULL,NULL,'0-低电平,1- 高电平',1,0,'0'),('3c80be61da0111e9b2f2000c29140066','4004',NULL,4,'33','开关量状态-电平 2',NULL,'2',NULL,NULL,'0-低电平,1- 高电平',1,0,'0'),('3c80be68da0111e9b2f2000c2914004c','3020',NULL,5,'27','ACC状态',NULL,'5',NULL,NULL,'电钥匙打开-打开-1,电钥匙关闭-关闭-0',2,0,'0'),('3c80be68da0111e9b2f2000c29140067','3020',NULL,5,'33','ACC状态',NULL,'5',NULL,NULL,'电钥匙打开-打开-1,电钥匙关闭-关闭-0',1,0,'0'),('3c80be6eda0111e9b2f2000c2914004c','3021',NULL,6,'27','终端 MOTO 状态',NULL,NULL,NULL,NULL,NULL,1,0,'0'),('3c80be6eda0111e9b2f2000c29140068','3021',NULL,6,'33','终端 MOTO 状态',NULL,NULL,NULL,NULL,NULL,1,0,'0'),('3c80be75da0111e9b2f2000c2914004c','4005','Hz',7,'27','FRQ1 输入',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3c80be75da0111e9b2f2000c29140069','4005','Hz',7,'33','FRQ1 输入',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3c80be7bda0111e9b2f2000c2914004c','4006','Hz',8,'27','FRQ2 输入',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3c80be7bda0111e9b2f2000c29140070','4006','Hz',8,'33','FRQ2 输入',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3c80be81da0111e9b2f2000c2914004c','4007','Hz',9,'27','PWM1 输出频率',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3c80be81da0111e9b2f2000c29140071','4007','Hz',9,'33','PWM1 输出频率',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3c80be87da0111e9b2f2000c2914004c','4008','Hz',10,'27','PWM2 输出频率',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3c80be87da0111e9b2f2000c29140072','4008','Hz',10,'33','PWM2 输出频率',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3c80be8eda0111e9b2f2000c2914004c','4009','mv',11,'27','输入电压 1',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3c80be8eda0111e9b2f2000c29140073','4009','mv',11,'33','输入电压 1',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3c80be94da0111e9b2f2000c2914004c','4010','mv',12,'27','输入电压 2',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3c80be94da0111e9b2f2000c29140074','4010','mv',12,'33','输入电压 2',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3c80be9ada0111e9b2f2000c2914004c','4011','mv',13,'27','输入电源电压',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3c80be9ada0111e9b2f2000c29140075','4011','mv',13,'33','输入电源电压',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3c80bea0da0111e9b2f2000c2914004c','4012','mv',14,'27','输入电池电压',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3c80bea0da0111e9b2f2000c29140076','4012','mv',14,'33','输入电池电压',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3d815fb1d8f811e9b2f2000c29140001','2601',NULL,5,'29','GPS定位状态',NULL,'2','定位状态',NULL,'0-有效定位,1-无效定位',1,0,'0'),('3d815fb1d8f811e9b2f2000c2914004c','2601',NULL,5,'19','GPS定位状态',NULL,'2','定位状态',NULL,'0-有效定位,1-无效定位',1,0,'0'),('3ea97f04d79d11e9b2f2000c2914004c','4349','%',17,'25','设定的EGR阀开度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3ea97f04d79d11e9b2f2000c29140055','4349','%',17,'31','设定的EGR阀开度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('4','-1',NULL,4,'1','当前位置',NULL,NULL,'当前位置(xml文件中不存在)',NULL,NULL,0,0,'0'),('405f457c09a911eab2f2000c2914004c','4250','%',4,'41','摩擦扭矩',NULL,'3',NULL,NULL,NULL,1,0,'0'),('405f496809a911eab2f2000c2914004c','4101','rpm',5,'41','发动机转速',NULL,'3',NULL,NULL,NULL,1,0,'0'),('4062836609a911eab2f2000c2914004c','6039','L/h',6,'41','发动机燃料流量',NULL,'3',NULL,NULL,NULL,1,0,'0'),('4062850409a911eab2f2000c2914004c','6040','ppm',7,'41','SCR上游NOx传感器输出值',NULL,'3',NULL,NULL,NULL,1,0,'0'),('4065759e09a911eab2f2000c2914004c','6041','ppm',8,'41','SCR下游NOx传感器输出值',NULL,'3',NULL,NULL,NULL,1,0,'0'),('4065772809a911eab2f2000c2914004c','6042','%',9,'41','反应剂余量',NULL,'3',NULL,NULL,NULL,1,0,'0'),('4065782309a911eab2f2000c2914004c','6043','kg/h',10,'41','进气量',NULL,'3',NULL,NULL,NULL,1,0,'0'),('40657d7309a911eab2f2000c2914004c','6044','℃',11,'41','SCR入口温度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('40657ea009a911eab2f2000c2914004c','6045','℃',12,'41','SCR出口温度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('40657fff09a911eab2f2000c2914004c','6046','kPa',13,'41','DPF压差',NULL,'3',NULL,NULL,NULL,1,0,'0'),('406580f109a911eab2f2000c2914004c','4177','℃',14,'41','发动机冷却液温度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('406581c609a911eab2f2000c2914004c','4162','%',15,'41','油箱液位',NULL,'3',NULL,NULL,NULL,1,0,'0'),('4065828d09a911eab2f2000c2914004c','4348','%',16,'41','实际EGR阀开度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('4065837c09a911eab2f2000c2914004c','4349','%',17,'41','设定的EGR阀开度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('4065844f09a911eab2f2000c2914004c','3040','km/h',1,'41','车速',NULL,'3',NULL,NULL,NULL,1,0,'0'),('4065851109a911eab2f2000c2914004c','4109','kPa',2,'41','大气压力',NULL,'3',NULL,NULL,NULL,1,0,'0'),('406585dc09a911eab2f2000c2914004c','4103','%',3,'41','发动机净输出扭矩',NULL,'3',NULL,NULL,NULL,1,0,'0'),('408715c30cc811cbed4f9135675f3ab0','2603',NULL,2,'49',NULL,NULL,NULL,'纬度',NULL,NULL,0,0,'0'),('40b77f80869acc95579732abf6fbcb75','4022','L',20,'50','单次油耗','','3','tripFuelConsumption','','',1,0,'0'),('41','2602',NULL,1,'3',NULL,NULL,NULL,'经度',NULL,NULL,0,0,'0'),('42','2603',NULL,1,'3',NULL,NULL,NULL,'纬度',NULL,NULL,0,0,'0'),('42c7b37fb84b851a345a6bd093d3f46a','4014',NULL,9,'49',NULL,NULL,'3','水平精度因子',NULL,NULL,1,0,'0'),('43','-1',NULL,4,'3','当前位置',NULL,NULL,'当前位置(xml文件中不存在)',NULL,NULL,0,0,'0'),('432df538773f6b67a33caa69fde3237e','3040','km/h',13,'50','行驶速度','','3','CANSpeed','','',1,0,'0'),('4399ce8f6edb11e9a45b000c2914004c','4101','rpm',5,'24','发动机转速',NULL,NULL,'发动机转速',NULL,NULL,0,0,'0'),('43edf40309a911eab2f2000c2914004c','6000',NULL,1,'42','诊断协议',NULL,'2',NULL,NULL,'0-ISO 15765,1-ISO 27145,2-SAE J1939,3-ISO 15031,254-无效',1,0,'0'),('43edf79709a911eab2f2000c2914004c','4347',NULL,2,'42','MIL报警灯状态',NULL,'2',NULL,NULL,'0-未点亮,1-点亮',1,0,'0'),('43edf89309a911eab2f2000c2914004c','6037',NULL,3,'42','故障码总数',NULL,'3',NULL,NULL,NULL,1,0,'0'),('43ee8ba109a911eab2f2000c2914004c','6038',NULL,4,'42','故障码信息列表',NULL,'6',NULL,NULL,'separator-|,EG03100003117010001-冷却液高温报警,EG03100003117010101-发动机高温报警,EG03100003117010201-制动系统报警,EG03100003117010301-发动机超速报警,EG03100003117010401-发动机堵转报警,EG03100003117010501-加速踏板信号故障报警,EG03100003117010601-进气压力感知器线路报警,EG03100003117010701-进气温度感知器线路报警,EG03100003117010801-引擎增压系统故障报警,EG03100003117010901-引擎多缸失火报警',0,0,'0'),('44','3019',NULL,5,'3',NULL,NULL,NULL,'GPS模块状态',NULL,NULL,0,0,'0'),('444c8de1848a3fdae242d907b973b10f','4101','RPM',2,'50','发动机转速','','3','engineSpeed','','',1,0,'0'),('45','2204',NULL,6,'3','GPS速度',NULL,NULL,'GPS速度',NULL,NULL,0,0,'0'),('453b337f7e7e5879c849d15e170e96f3','3020',NULL,5,'52','ACC状态',NULL,'5',NULL,NULL,'0-电钥匙关闭,1-电钥匙打开',2,0,'0'),('46','3014',NULL,7,'3',NULL,NULL,'1','GPS时间',NULL,NULL,0,0,'0'),('47','TIME',NULL,8,'3','回传时间',NULL,'1','接收时间',NULL,NULL,0,0,'0'),('478b4b6d09a911eab2f2000c2914004c','4001',NULL,1,'43','开关量状态-ACC',NULL,'2',NULL,NULL,'0-电钥匙关闭,1- 电钥匙打开',1,0,'0'),('478b4efd09a911eab2f2000c2914004c','4002',NULL,2,'43','开关量状态-MOTO',NULL,'2',NULL,NULL,'0-有启动信号,1-无启动信号',1,0,'0'),('478b4ff809a911eab2f2000c2914004c','4003',NULL,3,'43','开关量状态-电平 1',NULL,'2',NULL,NULL,'0-低电平,1-高电平',1,0,'0'),('478b50b109a911eab2f2000c2914004c','4004',NULL,4,'43','开关量状态-电平 2',NULL,'2',NULL,NULL,'0-低电平,1- 高电平',1,0,'0'),('478b515d09a911eab2f2000c2914004c','3020',NULL,5,'43','ACC状态',NULL,'5',NULL,NULL,'电钥匙打开-打开-1,电钥匙关闭-关闭-0',1,0,'0'),('478b521109a911eab2f2000c2914004c','3021',NULL,6,'43','终端 MOTO 状态',NULL,NULL,NULL,NULL,NULL,1,0,'0'),('478b52b809a911eab2f2000c2914004c','4005','Hz',7,'43','FRQ1 输入',NULL,'3',NULL,NULL,NULL,1,0,'0'),('478bd6b809a911eab2f2000c2914004c','4006','Hz',8,'43','FRQ2 输入',NULL,'3',NULL,NULL,NULL,1,0,'0'),('478bd7de09a911eab2f2000c2914004c','4007','Hz',9,'43','PWM1 输出频率',NULL,'3',NULL,NULL,NULL,1,0,'0'),('478bd8a409a911eab2f2000c2914004c','4008','Hz',10,'43','PWM2 输出频率',NULL,'3',NULL,NULL,NULL,1,0,'0'),('478bd95009a911eab2f2000c2914004c','4009','mv',11,'43','输入电压 1',NULL,'3',NULL,NULL,NULL,1,0,'0'),('478bda0a09a911eab2f2000c2914004c','4010','mv',12,'43','输入电压 2',NULL,'3',NULL,NULL,NULL,1,0,'0'),('478bdaaf09a911eab2f2000c2914004c','4011','mv',13,'43','输入电源电压',NULL,'3',NULL,NULL,NULL,1,0,'0'),('478bdb5209a911eab2f2000c2914004c','4012','mv',14,'43','输入电池电压',NULL,'3',NULL,NULL,NULL,1,0,'0'),('478bdbf209a911eab2f2000c2914004c','3006',NULL,20,'43','固件版本号',NULL,NULL,NULL,NULL,NULL,1,0,'0'),('478bdd7d09a911eab2f2000c2914004c','3007',NULL,21,'43','硬件版本号',NULL,NULL,NULL,NULL,NULL,1,0,'0'),('478bde2709a911eab2f2000c2914004c','4352',NULL,15,'43','外壳状态',NULL,'2',NULL,NULL,'0-外壳关闭,1-外壳打开',1,0,'0'),('478bdec709a911eab2f2000c2914004c','4353',NULL,16,'43','拆除告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('478bdf5e09a911eab2f2000c2914004c','4354',NULL,17,'43','开壳告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('478be00909a911eab2f2000c2914004c','4355',NULL,18,'43','GPS 天线告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('478be13109a911eab2f2000c2914004c','4356',NULL,19,'43','CAN 异常告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('48','4014',NULL,9,'3',NULL,NULL,NULL,'水平精度因子',NULL,NULL,0,0,'0'),('49','3012',NULL,10,'3',NULL,NULL,NULL,'方向',NULL,NULL,0,0,'0'),('5','3019',NULL,5,'1',NULL,NULL,NULL,'GPS模块状态',NULL,NULL,0,0,'0'),('50','4030',NULL,76,'3','作业车辆状态',NULL,NULL,'车辆状态',NULL,NULL,0,0,'0'),('503a34db510542a8a65c38d9ad7354d8','4101','rpm',0,'338698becb2b4b38ac6d5cecc29dbe99','发动机转速','','3','engineSpeed','0','',2,0,'1'),('51','4031',NULL,77,'3',NULL,NULL,NULL,'作业标识',NULL,NULL,0,0,'0'),('511bdd08d11011e8a45b000c29140021','4110','kPa',15,'30','发动机增压压力',NULL,'3','增压压力',NULL,NULL,1,0,'0'),('511bdd08d11011e8a45b000c2914004c','4110','kPa',15,'20','发动机增压压力',NULL,'3','增压压力',NULL,NULL,1,0,'0'),('52','4032',NULL,78,'3',NULL,NULL,NULL,'实时亩数',NULL,NULL,0,0,'0'),('53d3c3ffd82411e9b2f2000c29140002','4350',NULL,0,'29','数据加密',NULL,'2','数据加密',NULL,'1-数据不加密,2-数据经过RSA算法加密,3-数据经过国密SM2算法加密,254-异常,255-无效',0,0,'0'),('53d3c3ffd82411e9b2f2000c2914004c','4350',NULL,0,'19','数据加密',NULL,'2','数据加密',NULL,'1-数据不加密,2-数据经过RSA算法加密,3-数据经过国密SM2算法加密,254-异常,255-无效',0,0,'0'),('54','4033',NULL,79,'3',NULL,NULL,NULL,'作业时长',NULL,NULL,0,0,'0'),('55','4101',NULL,31,'4',NULL,NULL,NULL,'发动机转速',NULL,NULL,0,0,'0'),('56','4100',NULL,32,'4',NULL,NULL,NULL,'冷却水温',NULL,NULL,0,0,'0'),('57','4108','MPa',35,'4',NULL,'x/1000',NULL,'机油压力',NULL,NULL,0,0,'0'),('58','4162',NULL,39,'4','燃油量',NULL,NULL,'燃油量（液位）',NULL,NULL,0,0,'0'),('59','4163','H',30,'4',NULL,'x/3600',NULL,'发动机工作时间',NULL,NULL,0,0,'0'),('59718122d10a11e8a45b000c29140022','4280',NULL,3,'30','发动机等待启动灯',NULL,'2','发动机等待启动灯',NULL,'0-关闭,1-打开',1,0,'0'),('59718122d10a11e8a45b000c2914004c','4280',NULL,3,'20','发动机等待启动灯',NULL,'2','发动机等待启动灯',NULL,'0-关闭,1-打开',1,0,'0'),('6','2204',NULL,6,'1','GPS速度',NULL,NULL,'GPS速度',NULL,NULL,0,0,'0'),('60','4164',NULL,42,'4',NULL,NULL,NULL,'系统电压',NULL,NULL,0,0,'0'),('609ee82c6edb11e9a45b000c2914004c','4301','V',6,'24','电瓶电压',NULL,NULL,'电瓶电压',NULL,NULL,0,0,'0'),('61','3040',NULL,80,'4','行驶速度',NULL,NULL,'CAN速度',NULL,NULL,0,0,'0'),('62','2205',NULL,53,'4',NULL,NULL,NULL,'总里程',NULL,NULL,0,0,'0'),('63','4182',NULL,68,'4',NULL,NULL,NULL,'主离合状态',NULL,NULL,0,0,'0'),('64','4183',NULL,81,'4',NULL,NULL,NULL,'提升器左提升力',NULL,NULL,0,0,'0'),('65','4184',NULL,82,'4',NULL,NULL,NULL,'提升器右提升力',NULL,NULL,0,0,'0'),('66','4185',NULL,83,'4',NULL,NULL,NULL,'机具离地高度',NULL,NULL,0,0,'0'),('67','4186',NULL,84,'4',NULL,NULL,NULL,'POT转速',NULL,NULL,0,0,'0'),('68','4187',NULL,85,'4',NULL,NULL,NULL,'液压系统压力',NULL,NULL,0,0,'0'),('6bba5172d10a11e8a45b000c29140023','4281',NULL,5,'30','发动机保护系统已关闭发动机',NULL,'2','发动机保护系统已关闭发动机',NULL,'0-关闭未激活,1-关闭已激活',1,0,'0'),('6bba5172d10a11e8a45b000c2914004c','4281',NULL,5,'20','发动机保护系统已关闭发动机',NULL,'2','发动机保护系统已关闭发动机',NULL,'0-关闭未激活,1-关闭已激活',1,0,'0'),('6bfc64ba4bc9fe35d1083e8f3584fda5','4005','Hz',7,'52','FRQ1 输入',NULL,'3',NULL,NULL,NULL,1,0,'0'),('6fba8c0afa0b11e9b2f2000c2914004c','4020,4021',NULL,24,'18','SPN_FMI 故障码',NULL,'7','SPN_FMI 故障码',NULL,NULL,0,0,'0'),('7','3014',NULL,7,'1',NULL,NULL,'1','GPS时间',NULL,NULL,0,0,'0'),('70601b58d11011e8a45b000c29140024','4250','%',23,'30','标准摩擦-扭矩百分比',NULL,'3','摩擦扭矩百分比',NULL,NULL,1,0,'0'),('70601b58d11011e8a45b000c2914004c','4250','%',23,'20','标准摩擦-扭矩百分比',NULL,'3','摩擦扭矩百分比',NULL,NULL,1,0,'0'),('72442cef6eda11e9a45b000c2914004c','2602',NULL,1,'23',NULL,NULL,NULL,'经度',NULL,NULL,0,0,'0'),('724432436eda11e9a45b000c2914004c','3012',NULL,5,'23',NULL,NULL,NULL,'方向',NULL,NULL,0,0,'0'),('724434986eda11e9a45b000c2914004c','2603',NULL,2,'23',NULL,NULL,NULL,'纬度',NULL,NULL,0,0,'0'),('724435506eda11e9a45b000c2914004c','-1',NULL,3,'23','当前位置',NULL,NULL,'当前位置(xml文件中不存在)',NULL,NULL,0,0,'0'),('724439b86eda11e9a45b000c2914004c','3019',NULL,7,'23',NULL,NULL,NULL,'GPS模块状态',NULL,NULL,0,0,'0'),('72443a896eda11e9a45b000c2914004c','2204',NULL,4,'23','GPS速度',NULL,NULL,'GPS速度',NULL,NULL,0,0,'0'),('72443b726eda11e9a45b000c2914004c','3014',NULL,8,'23',NULL,NULL,'1','GPS时间',NULL,NULL,0,0,'0'),('72443c4c6eda11e9a45b000c2914004c','TIME',NULL,9,'23','回传时间',NULL,'1','接收时间',NULL,NULL,0,0,'0'),('72443d006eda11e9a45b000c2914004c','4014',NULL,6,'23',NULL,NULL,NULL,'水平精度因子',NULL,NULL,0,0,'0'),('733e16b8b7754150a4ee472a0912a5d6','4272',NULL,21,'18',NULL,NULL,NULL,'车辆报警状态 2',NULL,NULL,1,0,'0'),('7b95c4dea46018cc9a83709168e0b7b1','4008','Hz',10,'52','PWM2 输出频率',NULL,'3',NULL,NULL,NULL,1,0,'0'),('7d19fa9e19c6146dcaaf0ca0e2173867','4009','V',11,'52','输入电压 1','x/1000','3',NULL,NULL,NULL,1,0,'0'),('7dce79edd10a11e8a45b000c29140025','4282','KM/L',8,'30','即时燃油经济性',NULL,'3','即时燃油经济性',NULL,NULL,1,0,'0'),('7dce79edd10a11e8a45b000c2914004c','4282','KM/L',8,'20','即时燃油经济性',NULL,'3','即时燃油经济性',NULL,NULL,1,0,'0'),('7f08f1217ea511e8a594000c292ded3c','4101',NULL,31,'15',NULL,NULL,NULL,'发动机转速',NULL,NULL,0,0,'0'),('7f08f5457ea511e8a594000c292ded3c','4100',NULL,32,'15',NULL,NULL,NULL,'冷却水温',NULL,NULL,0,0,'0'),('7f08f6627ea511e8a594000c292ded3c','4108','MPa',35,'15',NULL,'x/1000',NULL,'机油压力',NULL,NULL,0,0,'0'),('7f08f7427ea511e8a594000c292ded3c','4162',NULL,39,'15','燃油量',NULL,NULL,'燃油量（液位）',NULL,NULL,0,0,'0'),('7f08f8147ea511e8a594000c292ded3c','4163','H',30,'15',NULL,'x/3600',NULL,'发动机工作时间',NULL,NULL,0,0,'0'),('7f08f8e97ea511e8a594000c292ded3c','4164',NULL,42,'15',NULL,NULL,NULL,'系统电压',NULL,NULL,0,0,'0'),('7f08f9a47ea511e8a594000c292ded3c','3040',NULL,80,'15','行驶速度',NULL,NULL,'CAN速度',NULL,NULL,0,0,'0'),('7f08fa5d7ea511e8a594000c292ded3c','2205',NULL,53,'15',NULL,NULL,NULL,'总里程',NULL,NULL,0,0,'0'),('7f08fb137ea511e8a594000c292ded3c','4182',NULL,68,'15',NULL,NULL,NULL,'主离合状态',NULL,NULL,0,0,'0'),('7f08fbca7ea511e8a594000c292ded3c','4183',NULL,81,'15',NULL,NULL,NULL,'提升器左提升力',NULL,NULL,0,0,'0'),('7f08fc817ea511e8a594000c292ded3c','4184',NULL,82,'15',NULL,NULL,NULL,'提升器右提升力',NULL,NULL,0,0,'0'),('7f08fd397ea511e8a594000c292ded3c','4185',NULL,83,'15',NULL,NULL,NULL,'机具离地高度',NULL,NULL,0,0,'0'),('7f08fded7ea511e8a594000c292ded3c','4186',NULL,84,'15',NULL,NULL,NULL,'POT转速',NULL,NULL,0,0,'0'),('7f08fea97ea511e8a594000c292ded3c','4187',NULL,85,'15',NULL,NULL,NULL,'液压系统压力',NULL,NULL,0,0,'0'),('7f5dc3b66edb11e9a45b000c2914004c','4302',NULL,7,'24','SPN',NULL,NULL,'SPN',NULL,NULL,0,0,'0'),('7fc8d47e964411e89b79000c292ded3c','4103',NULL,12,'18',NULL,NULL,'3','发动机实际扭矩',NULL,NULL,1,0,'0'),('7fd6c04128727d73359b1f13074fef36','4012','V',14,'52','输入电池电压','x/1000','3',NULL,NULL,NULL,1,0,'0'),('8','TIME',NULL,8,'1','回传时间',NULL,'1','接收时间',NULL,NULL,0,0,'0'),('80','2602',NULL,1,'5',NULL,NULL,NULL,'经度',NULL,NULL,0,0,'0'),('800461b26cec89b0158546b12f416be0','4006','Hz',8,'52','FRQ2 输入',NULL,'3',NULL,NULL,NULL,1,0,'0'),('81','2603',NULL,1,'5',NULL,NULL,NULL,'纬度',NULL,NULL,0,0,'0'),('814efdfc6f2e8cac8fcbeb58f886b6da','3020',NULL,1,'0ad4727a2920487cb436822b9da78c1a','电锁状态',NULL,'5',NULL,NULL,'电钥匙打开-打开-1,电钥匙关闭-关闭-0',2,0,'0'),('82','-1',NULL,4,'5','当前位置',NULL,NULL,'当前位置(xml文件中不存在)',NULL,NULL,0,0,'0'),('82079ebde2826f079cd7d9e111caceca','3016',NULL,13,'49','可视卫星数',NULL,'3','可视卫星数',NULL,NULL,0,0,'0'),('83','3019',NULL,5,'5',NULL,NULL,NULL,'GPS模块状态',NULL,NULL,0,0,'0'),('84','2204',NULL,6,'5','GPS速度',NULL,NULL,'GPS速度',NULL,NULL,0,0,'0'),('85','3014',NULL,7,'5',NULL,NULL,'1','GPS时间',NULL,NULL,0,0,'0'),('86','TIME',NULL,8,'5','回传时间',NULL,'1','接收时间',NULL,NULL,0,0,'0'),('8695726524174d20a762358df2830613','4258',NULL,6,'18','GPS 监控功能',NULL,'2','GPS监控功能',NULL,'0-关闭,1-打开',1,0,'0'),('87','4014',NULL,9,'5',NULL,NULL,NULL,'水平精度因子',NULL,NULL,0,0,'0'),('873d59983cfd54632529895893a8ce8d','TIME','',9,'4b0bcd3b652b4f078f46cc5ef7768a8b','回传时间','','1','接收时间','0','',1,0,'1'),('88','3012',NULL,10,'5',NULL,NULL,NULL,'方向',NULL,NULL,0,0,'0'),('886fa9c9964411e89b79000c292ded3c','4106',NULL,9,'18',NULL,NULL,'3','燃油温度',NULL,NULL,1,0,'0'),('89','4030',NULL,76,'5','作业车辆状态',NULL,NULL,'车辆状态',NULL,NULL,0,0,'0'),('8b5627273cecb05b39cbd2e4908e5076','4141','℃',28,'50','液压油温','','3','hydraulicOilTemperature','','',1,0,'0'),('8bd5c291d10711e8a45b000c29140003','2602',NULL,1,'29',NULL,NULL,'3','经度',NULL,NULL,1,0,'0'),('8bd5c291d10711e8a45b000c2914004c','2602',NULL,1,'19',NULL,NULL,'3','经度',NULL,NULL,1,0,'0'),('8bd5c964d10711e8a45b000c29140004','3012',NULL,8,'29',NULL,NULL,'3','方向',NULL,NULL,1,0,'0'),('8bd5c964d10711e8a45b000c2914004c','3012',NULL,8,'19',NULL,NULL,'3','方向',NULL,NULL,1,0,'0'),('8bd5ca9fd10711e8a45b000c29140005','2603',NULL,2,'29',NULL,NULL,'3','纬度',NULL,NULL,1,0,'0'),('8bd5ca9fd10711e8a45b000c2914004c','2603',NULL,2,'19',NULL,NULL,'3','纬度',NULL,NULL,1,0,'0'),('8bd5cb7dd10711e8a45b000c29140006','-1',NULL,14,'29','当前位置',NULL,NULL,'当前位置(xml文件中不存在)',NULL,NULL,0,0,'0'),('8bd5cb7dd10711e8a45b000c2914004c','-1',NULL,14,'19','当前位置',NULL,NULL,'当前位置(xml文件中不存在)',NULL,NULL,0,0,'0'),('8bd5cc57d10711e8a45b000c29140007','3019',NULL,6,'29','GPS模块状态',NULL,'2','GPS模块状态',NULL,'0- 模块正常,1-模块异常',1,0,'0'),('8bd5cc57d10711e8a45b000c2914004c','3019',NULL,6,'19','GPS模块状态',NULL,'2','GPS模块状态',NULL,'0- 模块正常,1-模块异常',1,0,'0'),('8bd5cd26d10711e8a45b000c29140008','2204',NULL,7,'29','GPS速度',NULL,'3','GPS速度',NULL,NULL,1,0,'0'),('8bd5cd26d10711e8a45b000c2914004c','2204',NULL,7,'19','GPS速度',NULL,'3','GPS速度',NULL,NULL,1,0,'0'),('8bd5cdebd10711e8a45b000c29140009','3014',NULL,3,'29',NULL,NULL,'1','GPS时间',NULL,NULL,1,0,'0'),('8bd5cdebd10711e8a45b000c2914004c','3014',NULL,3,'19',NULL,NULL,'1','GPS时间',NULL,NULL,1,0,'0'),('8bd5ceb3d10711e8a45b000c29140010','TIME',NULL,4,'29','回传时间',NULL,'1','接收时间',NULL,NULL,1,0,'0'),('8bd5ceb3d10711e8a45b000c2914004c','TIME',NULL,4,'19','回传时间',NULL,'1','接收时间',NULL,NULL,1,0,'0'),('8bd5cf7dd10711e8a45b000c29140011','4014',NULL,9,'29',NULL,NULL,'3','水平精度因子',NULL,NULL,1,0,'0'),('8bd5cf7dd10711e8a45b000c2914004c','4014',NULL,9,'19',NULL,NULL,'3','水平精度因子',NULL,NULL,1,0,'0'),('8be24551799211ea82d10894ef147327','4401','',25,'50','变速箱压力状态','','2','4401','','0-无压力,1-有压力',1,0,'0'),('8bebe2f6799211ea82d10894ef147327','4183','kN',26,'50','提升器左提升力','','3','LeftLiftingFource','','',1,0,'0'),('8bfc5fc6799211ea82d10894ef147327','4179','V',30,'50','传感器2电压',NULL,'3','sensorVoltage2',NULL,NULL,1,0,'0'),('8c05d3b0799211ea82d10894ef147327','4178','V',29,'50','传感器1电压',NULL,'3','sensorVoltage1',NULL,NULL,1,0,'0'),('8cb9b1fc401ec94897d96f30ce47d034','4320','%',3,'50','油门踏板位置','','3','4320','','',1,0,'0'),('8e29533aaa4e4e14b4e0804e1117519c','4163','时',4,'18',NULL,'x/3600','3','发动机工作时间','2',NULL,2,0,'0'),('8e59cf8e964411e89b79000c292ded3c','4109','MPa',13,'18',NULL,'x/1000','3','大气压力',NULL,NULL,1,0,'0'),('8f5d4529a890836193d2008fcb475587','2601','',5,'4b0bcd3b652b4f078f46cc5ef7768a8b','定位状态','','2','定位状态','0','0-已定位,1-未定位',1,0,'1'),('9','4014',NULL,9,'1',NULL,NULL,NULL,'水平精度因子',NULL,NULL,0,0,'0'),('90','4031',NULL,77,'5',NULL,NULL,NULL,'作业标识',NULL,NULL,0,0,'0'),('90f28143e26a11e9b2f2000c2914004c','2601',NULL,5,'34','GPS定位状态',NULL,'2','定位状态',NULL,'0-有效定位,1-无效定位',0,0,'0'),('90f28631e26a11e9b2f2000c2914004c','4350',NULL,0,'34','数据加密',NULL,'2','数据加密',NULL,'1-数据不加密,2-数据经过RSA算法加密,3-数据经过国密SM2算法加密,254-异常,255-无效',0,0,'0'),('90f3b153e26a11e9b2f2000c2914004c','2602',NULL,1,'34',NULL,NULL,NULL,'经度',NULL,NULL,0,0,'0'),('90f3b25ce26a11e9b2f2000c2914004c','3012',NULL,8,'34',NULL,NULL,NULL,'方向',NULL,NULL,0,0,'0'),('90f3b2fce26a11e9b2f2000c2914004c','2603',NULL,2,'34',NULL,NULL,NULL,'纬度',NULL,NULL,0,0,'0'),('90f3b383e26a11e9b2f2000c2914004c','-1',NULL,14,'34','当前位置',NULL,NULL,'当前位置(xml文件中不存在)',NULL,NULL,0,0,'0'),('90f3b413e26a11e9b2f2000c2914004c','3019',NULL,6,'34','GPS模块状态',NULL,NULL,'GPS模块状态',NULL,'0- 模块正常,1-模块异常',0,0,'0'),('90f3b49ee26a11e9b2f2000c2914004c','2204',NULL,7,'34','GPS速度',NULL,NULL,'GPS速度',NULL,NULL,0,0,'0'),('90f4e6cae26a11e9b2f2000c2914004c','3014',NULL,3,'34',NULL,NULL,'1','GPS时间',NULL,NULL,0,0,'0'),('90f4e7c8e26a11e9b2f2000c2914004c','TIME',NULL,4,'34','回传时间',NULL,'1','接收时间',NULL,NULL,0,0,'0'),('90f4e860e26a11e9b2f2000c2914004c','4014',NULL,9,'34',NULL,NULL,NULL,'水平精度因子',NULL,NULL,0,0,'0'),('90f4e933e26a11e9b2f2000c2914004c','3013','m',11,'34','海拔高度',NULL,NULL,'海拔高度',NULL,NULL,0,0,'0'),('90f4e9dce26a11e9b2f2000c2914004c','3015',NULL,12,'34','使用卫星数',NULL,NULL,'使用卫星数',NULL,NULL,0,0,'0'),('90f4ea65e26a11e9b2f2000c2914004c','3016',NULL,13,'34','可视卫星数',NULL,NULL,'可视卫星数',NULL,NULL,0,0,'0'),('91','4032',NULL,78,'5',NULL,NULL,NULL,'实时亩数',NULL,NULL,0,0,'0'),('92','4033',NULL,79,'5',NULL,NULL,NULL,'作业时长',NULL,NULL,0,0,'0'),('92facac71156f2bb46f1c82c76531561','4103','%',0,'50','发动机实际扭矩','','3','actualEngineTorque','','',1,0,'0'),('939761fb7ea511e8a594000c292ded3c','2602',NULL,1,'16',NULL,NULL,NULL,'经度',NULL,NULL,0,0,'0'),('939765d97ea511e8a594000c292ded3c','3012',NULL,10,'16',NULL,NULL,NULL,'方向',NULL,NULL,0,0,'0'),('939766ec7ea511e8a594000c292ded3c','2603',NULL,2,'16',NULL,NULL,NULL,'纬度',NULL,NULL,0,0,'0'),('939767c37ea511e8a594000c292ded3c','-1',NULL,4,'16','当前位置',NULL,NULL,'当前位置(xml文件中不存在)',NULL,NULL,0,0,'0'),('9397688f7ea511e8a594000c292ded3c','3019',NULL,5,'16',NULL,NULL,NULL,'GPS模块状态',NULL,NULL,0,0,'0'),('939769617ea511e8a594000c292ded3c','2204',NULL,6,'16','GPS速度',NULL,NULL,'GPS速度',NULL,NULL,0,0,'0'),('93976b717ea511e8a594000c292ded3c','3014',NULL,7,'16',NULL,NULL,'1','GPS时间',NULL,NULL,0,0,'0'),('93976c687ea511e8a594000c292ded3c','TIME',NULL,8,'16','回传时间',NULL,'1','接收时间',NULL,NULL,0,0,'0'),('93976d307ea511e8a594000c292ded3c','4014',NULL,9,'16',NULL,NULL,NULL,'水平精度因子',NULL,NULL,0,0,'0'),('950255d5be80b0d9b38886eda037d8e5','3015',NULL,12,'49','使用卫星数',NULL,'3','使用卫星数',NULL,NULL,0,0,'0'),('962ca748d11011e8a45b000c29140026','4290','%',24,'30','估计的发动机寄生损失-扭矩百分比',NULL,'3','估计的发动机寄生损失-扭矩百分比',NULL,NULL,1,0,'0'),('962ca748d11011e8a45b000c2914004c','4290','%',24,'20','估计的发动机寄生损失-扭矩百分比',NULL,'3','估计的发动机寄生损失-扭矩百分比',NULL,NULL,1,0,'0'),('998981b8d79c11e9b2f2000c2914004c','3040','km/h',1,'25','车速',NULL,'3',NULL,NULL,NULL,1,0,'0'),('998981b8d79c11e9b2f2000c29140056','3040','km/h',1,'31','车速',NULL,'3',NULL,NULL,NULL,1,0,'0'),('9b31d77cd10a11e8a45b000c29140027','4283','°C',13,'30','发动机进气管温度',NULL,'3','发动机进气管温度',NULL,NULL,1,0,'0'),('9b31d77cd10a11e8a45b000c2914004c','4283','°C',13,'20','发动机进气管温度',NULL,'3','发动机进气管温度',NULL,NULL,1,0,'0'),('9b48341798ca1e033b06ae4f8f417cf3','3012',NULL,10,'49',NULL,NULL,'3','方向',NULL,NULL,0,0,'0'),('9b4f48f9e26a11e9b2f2000c2914004c','4288','%',21,'35','发动机负荷系数',NULL,'3','发动机负荷系数',NULL,NULL,0,0,'0'),('9b4f4c44e26a11e9b2f2000c2914004c','4291',NULL,25,'35','车身故障DM1',NULL,NULL,'车身故障DM1',NULL,NULL,0,0,'0'),('9b4f4d24e26a11e9b2f2000c2914004c','4289','%',22,'35','实际最大可用发动机-扭矩百分比',NULL,'3','实际最大可用发动机-扭矩百分比',NULL,NULL,0,0,'0'),('9b4f4dbee26a11e9b2f2000c2914004c','4175','L/h',7,'35','燃油消耗率',NULL,'3','小时油耗',NULL,NULL,0,0,'0'),('9b4f4f81e26a11e9b2f2000c2914004c','4292',NULL,26,'35','车身故障DM2',NULL,NULL,'车身故障DM2',NULL,NULL,0,0,'0'),('9b4f503be26a11e9b2f2000c2914004c','4279','rpm',1,'35','理想发动机转速',NULL,'3','理想发动机转速',NULL,NULL,0,0,'0'),('9b4f50c9e26a11e9b2f2000c2914004c','4110','kPa',15,'35','发动机增压压力',NULL,'3','增压压力',NULL,NULL,0,0,'0'),('9b4f514de26a11e9b2f2000c2914004c','4280',NULL,3,'35','发动机等待启动灯',NULL,'2','发动机等待启动灯',NULL,'0-关闭,1-打开',0,0,'0'),('9b4f524fe26a11e9b2f2000c2914004c','4281',NULL,5,'35','发动机保护系统已关闭发动机',NULL,'2','发动机保护系统已关闭发动机',NULL,'0-关闭未激活,1-关闭已激活',0,0,'0'),('9b4f52e8e26a11e9b2f2000c2914004c','4250','%',23,'35','标准摩擦-扭矩百分比',NULL,'3','摩擦扭矩百分比',NULL,NULL,0,0,'0'),('9b4f536ae26a11e9b2f2000c2914004c','4282','KM/L',8,'35','即时燃油经济性',NULL,'3','即时燃油经济性',NULL,NULL,0,0,'0'),('9b4f53e4e26a11e9b2f2000c2914004c','4290','%',24,'35','估计的发动机寄生损失-扭矩百分比',NULL,'3','估计的发动机寄生损失-扭矩百分比',NULL,NULL,0,0,'0'),('9b4f5466e26a11e9b2f2000c2914004c','4283','°C',13,'35','发动机进气管温度',NULL,'3','发动机进气管温度',NULL,NULL,0,0,'0'),('9b4f54e7e26a11e9b2f2000c2914004c','4284','kPa',16,'35','发动机进气压力',NULL,'3','发动机进气压力',NULL,NULL,0,0,'0'),('9b4f555ee26a11e9b2f2000c2914004c','4243','℃',10,'35','发动机机油温度',NULL,'3','机油温度',NULL,NULL,0,0,'0'),('9b4f55d6e26a11e9b2f2000c2914004c','4023','L',6,'35','发动机总燃油量',NULL,'3','累计油耗',NULL,NULL,0,0,'0'),('9b4f56d2e26a11e9b2f2000c2914004c','4101','rpm',0,'35','发动机转速',NULL,'3','发动机转速',NULL,NULL,0,0,'0'),('9b4f5775e26a11e9b2f2000c2914004c','4108','mPa',4,'35','发动机机油压力','x/1000','3','机油压力',NULL,NULL,0,0,'0'),('9b4f5802e26a11e9b2f2000c2914004c','4163','h',2,'35','发动机总工作小时数','x/3600','3','发动机工作时间',NULL,NULL,0,0,'0'),('9b4f5895e26a11e9b2f2000c2914004c','4103','%',19,'35','实际发动机-扭矩百分比',NULL,'3','发动机实际扭矩',NULL,NULL,0,0,'0'),('9b4f5920e26a11e9b2f2000c2914004c','4109','kPa',14,'35','大气压力',NULL,'3','大气压力',NULL,NULL,0,0,'0'),('9b4f59a0e26a11e9b2f2000c2914004c','4112','°C',12,'35','空气进气温度',NULL,'3','进气温度',NULL,NULL,0,0,'0'),('9b4f5a20e26a11e9b2f2000c2914004c','4245','℃',11,'35','外界温度',NULL,'3','大气温度',NULL,NULL,0,0,'0'),('9b4f5a9ce26a11e9b2f2000c2914004c','4177','°C',9,'35','发动机冷却液温度',NULL,'3','冷却水温度',NULL,NULL,0,0,'0'),('9b4f5b1de26a11e9b2f2000c2914004c','4285',NULL,17,'35','发动机扭矩模式',NULL,'3','发动机扭矩模式',NULL,NULL,0,0,'0'),('9b4f5b9ae26a11e9b2f2000c2914004c','4286','%',18,'35','驾驶员要求的发动机-扭矩百分比',NULL,'3','驾驶员要求的发动机-扭矩百分比',NULL,NULL,0,0,'0'),('9b4f5c1ce26a11e9b2f2000c2914004c','4287','%',20,'35','发动机需求-扭矩百分比',NULL,'3','发动机需求-扭矩百分比',NULL,NULL,0,0,'0'),('9f34eaf12b72c111d8ee59d9e63e8c98','2603','',2,'4b0bcd3b652b4f078f46cc5ef7768a8b','','','3','纬度','7','',1,0,'1'),('a0e3b28e4634414c925869d888713cb1','4247',NULL,15,'18',NULL,NULL,'3','发动机负荷',NULL,NULL,1,0,'0'),('a0e655e76ddaf5664680ea3d5ee6dfff','4164','V',22,'50','系统电压','','3','systemVoltage','','',1,0,'0'),('a1ee7059964411e89b79000c292ded3c','4112',NULL,14,'18',NULL,NULL,'3','进气温度',NULL,NULL,1,0,'0'),('a22ca1d5d645a11ab3b63b54833eea81','4353',NULL,16,'52','拆除告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('a3789933d79c11e9b2f2000c2914004c','4109','kPa',2,'25','大气压力',NULL,'3',NULL,NULL,NULL,1,0,'0'),('a3789933d79c11e9b2f2000c29140057','4109','kPa',2,'31','大气压力',NULL,'3',NULL,NULL,NULL,1,0,'0'),('a514399d6edb11e9a45b000c2914004c','4163','小时',8,'24','发动机累计工作时间','x/3600',NULL,'发动机累计工作时间',NULL,NULL,0,0,'0'),('a715ce22a98348c7dc4cdbc8ffaabb85','4173','℃',19,'50','变速箱油温','','3','gearBoxOilTemp','','',1,0,'0'),('a897d2fc896a44189245a8edd563762e','4253',NULL,10,'18',NULL,NULL,'3','机油液位',NULL,NULL,1,0,'0'),('a8a26e7411922ee69a4a32b9fca6f043','2602',NULL,1,'49',NULL,NULL,NULL,'经度',NULL,NULL,0,0,'0'),('a8de70fbeb3411e9b2f2000c2914004c','DATE_TYPE',NULL,-1,'20',NULL,NULL,NULL,NULL,NULL,NULL,0,0,'0'),('a9193819e26a11e9b2f2000c2914004c','4250','%',4,'36','摩擦扭矩',NULL,'3',NULL,NULL,NULL,0,0,'0'),('a9193ca1e26a11e9b2f2000c2914004c','4101','rpm',5,'36','发动机转速',NULL,'3',NULL,NULL,NULL,0,0,'0'),('a9193e33e26a11e9b2f2000c2914004c','6039','L/h',6,'36','发动机燃料流量',NULL,'3',NULL,NULL,NULL,0,0,'0'),('a9193ed8e26a11e9b2f2000c2914004c','6040','ppm',7,'36','SCR上游NOx传感器输出值',NULL,'3',NULL,NULL,NULL,0,0,'0'),('a9193f5fe26a11e9b2f2000c2914004c','6041','ppm',8,'36','SCR下游NOx传感器输出值',NULL,'3',NULL,NULL,NULL,0,0,'0'),('a9193fe5e26a11e9b2f2000c2914004c','6042','%',9,'36','反应剂余量',NULL,'3',NULL,NULL,NULL,0,0,'0'),('a919405de26a11e9b2f2000c2914004c','6043','kg/h',10,'36','进气量',NULL,'3',NULL,NULL,NULL,0,0,'0'),('a919414ae26a11e9b2f2000c2914004c','6044','℃',11,'36','SCR入口温度',NULL,'3',NULL,NULL,NULL,0,0,'0'),('a91941e2e26a11e9b2f2000c2914004c','6045','℃',12,'36','SCR出口温度',NULL,'3',NULL,NULL,NULL,0,0,'0'),('a9194266e26a11e9b2f2000c2914004c','6046','kPa',13,'36','DPF压差',NULL,'3',NULL,NULL,NULL,0,0,'0'),('a91942dbe26a11e9b2f2000c2914004c','4177','℃',14,'36','发动机冷却液温度',NULL,'3',NULL,NULL,NULL,0,0,'0'),('a9194355e26a11e9b2f2000c2914004c','4162','%',15,'36','油箱液位',NULL,'3',NULL,NULL,NULL,0,0,'0'),('a91943cae26a11e9b2f2000c2914004c','4348','%',16,'36','实际EGR阀开度',NULL,'3',NULL,NULL,NULL,0,0,'0'),('a919444ce26a11e9b2f2000c2914004c','4349','%',17,'36','设定的EGR阀开度',NULL,'3',NULL,NULL,NULL,0,0,'0'),('a91944c8e26a11e9b2f2000c2914004c','3040','km/h',1,'36','车速',NULL,'3',NULL,NULL,NULL,0,0,'0'),('a919762fe26a11e9b2f2000c2914004c','4109','kPa',2,'36','大气压力',NULL,'3',NULL,NULL,NULL,0,0,'0'),('a9197730e26a11e9b2f2000c2914004c','4319','%',3,'36','发动机净输出扭矩',NULL,'3',NULL,NULL,NULL,0,0,'0'),('ac402727a6ffc186629430b96cc5988e','4004',NULL,4,'52','开关量状态-电平 2',NULL,'2',NULL,NULL,'0-低电平,1- 高电平',1,0,'0'),('ada1f0ba6eda11e9a45b000c2914004c','4175','L/H',1,'24','小时油耗',NULL,NULL,'小时油耗',NULL,NULL,0,0,'0'),('ae1f4238dff9417baccbdf142d537ebc','4271',NULL,20,'18',NULL,NULL,NULL,'车辆报警状态 1',NULL,NULL,1,0,'0'),('ae66dc74483b4fb1ab36ffe80b3fdd04','4249','MPa',11,'18',NULL,'x/1000','3','绝对机油压力',NULL,NULL,1,0,'0'),('ae82ddd094cc12d612e89bcb972a2126','4106','℃',8,'50','燃油温度','','3','fuelOilTemperature','','',1,0,'0'),('b0dd6b0f614b31e7f62d3274336fb6d9','4162','%',12,'50','燃油量（液位）','','3','quantityOfFuel','','',1,0,'0'),('b28ea1c6dcff7f53ef44129bbf007c40','4023','L',10,'50','累计油耗','','3','totalFuelConsumption','','',1,0,'0'),('b66f5678d10a11e8a45b000c29140028','4284','kPa',16,'30','发动机进气压力',NULL,'3','发动机进气压力',NULL,NULL,1,0,'0'),('b66f5678d10a11e8a45b000c2914004c','4284','kPa',16,'20','发动机进气压力',NULL,'3','发动机进气压力',NULL,NULL,1,0,'0'),('b7a2bfd4f95911e9bab7d0946600e1f1','3006',NULL,8,'28','固件版本号',NULL,NULL,NULL,NULL,NULL,1,0,'0'),('b7a2bfd4f95911e9bab7d0946615e1f1','3006',NULL,20,'33','固件版本号',NULL,NULL,NULL,NULL,NULL,1,0,'0'),('b7a2bfd4f95911e9bab7d0946619e1f1','3006',NULL,20,'27','固件版本号',NULL,NULL,NULL,NULL,NULL,1,0,'0'),('b7a2bfd4f95911e9bab7d0946625e1f1','3007',NULL,21,'33','硬件版本号',NULL,NULL,NULL,NULL,NULL,1,0,'0'),('b7a2bfd4f95911e9bab7d0946635e1f1','3007',NULL,21,'27','硬件版本号',NULL,NULL,NULL,NULL,NULL,1,0,'0'),('b8968db397d9bf14cb6ec6ef31ddd688','4011','V',2,'0ad4727a2920487cb436822b9da78c1a','供电电压','x/1000','3','输入电源电压',NULL,NULL,1,0,'0'),('b98e35db963e11e89b79000c292ded3c','2602',NULL,1,'17',NULL,NULL,'3','经度',NULL,NULL,1,0,'0'),('b98e39c0963e11e89b79000c292ded3c','3012',NULL,11,'17',NULL,NULL,'3','方向',NULL,NULL,1,0,'0'),('b98e3a93963e11e89b79000c292ded3c','2603',NULL,2,'17',NULL,NULL,'3','纬度',NULL,NULL,1,0,'0'),('b98e3b18963e11e89b79000c292ded3c','-1',NULL,4,'17','当前位置',NULL,NULL,'当前位置(xml文件中不存在)',NULL,NULL,0,0,'0'),('b98e3c2b963e11e89b79000c292ded3c','2204',NULL,7,'17','GPS速度',NULL,'3','GPS速度',NULL,NULL,1,0,'0'),('b98e3ca2963e11e89b79000c292ded3c','3014',NULL,8,'17',NULL,NULL,'1','GPS时间',NULL,NULL,1,0,'0'),('b98e3d1a963e11e89b79000c292ded3c','TIME',NULL,9,'17','回传时间',NULL,'1','接收时间',NULL,NULL,1,0,'0'),('b98e3d99963e11e89b79000c292ded3c','4014',NULL,10,'17',NULL,NULL,'3','水平精度因子',NULL,NULL,1,0,'0'),('ba0d1fe0e26a11e9b2f2000c2914004c','6000',NULL,1,'37','诊断协议',NULL,'2',NULL,NULL,'0-ISO 15765,1-ISO 27145,2-SAE J1939,3-ISO 15031,254-无效',0,0,'0'),('ba0d2561e26a11e9b2f2000c2914004c','4347',NULL,2,'37','MIL报警灯状态',NULL,'2',NULL,NULL,'0-未点亮,1-点亮',0,0,'0'),('ba0d26b0e26a11e9b2f2000c2914004c','6037',NULL,3,'37','故障码总数',NULL,NULL,NULL,NULL,NULL,0,0,'0'),('ba0d27abe26a11e9b2f2000c2914004c','6038',NULL,4,'37','故障码信息列表',NULL,NULL,NULL,NULL,NULL,0,0,'0'),('bbb9d476d10911e8a45b000c29140029','4243','℃',10,'30','发动机机油温度',NULL,'3','机油温度',NULL,NULL,1,0,'0'),('bbb9d476d10911e8a45b000c2914004c','4243','℃',10,'20','发动机机油温度',NULL,'3','机油温度',NULL,NULL,1,0,'0'),('bbb9d7bed10911e8a45b000c29140030','4023','L',6,'30','发动机总燃油量',NULL,'3','累计油耗',NULL,NULL,1,0,'0'),('bbb9d7bed10911e8a45b000c2914004c','4023','L',6,'20','发动机总燃油量',NULL,'3','累计油耗',NULL,NULL,1,0,'0'),('bbb9d890d10911e8a45b000c29140031','4101','rpm',0,'30','发动机转速',NULL,'3','发动机转速',NULL,NULL,2,0,'0'),('bbb9d890d10911e8a45b000c2914004c','4101','rpm',0,'20','发动机转速',NULL,'3','发动机转速',NULL,NULL,1,0,'0'),('bbb9d913d10911e8a45b000c29140032','4108','mPa',4,'30','发动机机油压力','x/1000','3','机油压力',NULL,NULL,1,0,'0'),('bbb9d913d10911e8a45b000c2914004c','4108','mPa',4,'20','发动机机油压力','x/1000','3','机油压力',NULL,NULL,1,0,'0'),('bbb9d997d10911e8a45b000c29140033','4163','h',2,'30','发动机总工作小时数','x/3600','3','发动机工作时间',NULL,NULL,2,0,'0'),('bbb9d997d10911e8a45b000c2914004c','4163','h',2,'20','发动机总工作小时数','x/3600','3','发动机工作时间',NULL,NULL,1,0,'0'),('bbb9da1ed10911e8a45b000c29140034','4103','%',19,'30','实际发动机-扭矩百分比',NULL,'3','发动机实际扭矩',NULL,NULL,1,0,'0'),('bbb9da1ed10911e8a45b000c2914004c','4103','%',19,'20','实际发动机-扭矩百分比',NULL,'3','发动机实际扭矩',NULL,NULL,1,0,'0'),('bbb9daa1d10911e8a45b000c29140035','4109','kPa',14,'30','大气压力',NULL,'3','大气压力',NULL,NULL,1,0,'0'),('bbb9daa1d10911e8a45b000c2914004c','4109','kPa',14,'20','大气压力',NULL,'3','大气压力',NULL,NULL,1,0,'0'),('bbb9db15d10911e8a45b000c29140036','4112','°C',12,'30','空气进气温度',NULL,'3','进气温度',NULL,NULL,1,0,'0'),('bbb9db15d10911e8a45b000c2914004c','4112','°C',12,'20','空气进气温度',NULL,'3','进气温度',NULL,NULL,1,0,'0'),('bbb9db86d10911e8a45b000c29140037','4245','℃',11,'30','外界温度',NULL,'3','大气温度',NULL,NULL,1,0,'0'),('bbb9db86d10911e8a45b000c2914004c','4245','℃',11,'20','外界温度',NULL,'3','大气温度',NULL,NULL,1,0,'0'),('bbb9dbfcd10911e8a45b000c29140038','4177','°C',9,'30','发动机冷却液温度',NULL,'3','冷却水温度',NULL,NULL,1,0,'0'),('bbb9dbfcd10911e8a45b000c2914004c','4177','°C',9,'20','发动机冷却液温度',NULL,'3','冷却水温度',NULL,NULL,1,0,'0'),('bf805636677111ea82d10894ef147327','2601',NULL,5.1,'49','GPS定位状态',NULL,'2','定位状态',NULL,'0-已定位,1-未定位',1,0,'0'),('c250ee80d79c11e9b2f2000c2914004c','4103','%',3,'25','发动机净输出扭矩',NULL,'3',NULL,NULL,NULL,1,0,'0'),('c250ee80d79c11e9b2f2000c29140058','4103','%',3,'31','发动机净输出扭矩',NULL,'3',NULL,NULL,NULL,1,0,'0'),('c3b09bb0e26a11e9b2f2000c2914004c','4001',NULL,1,'38','开关量状态-ACC',NULL,'2',NULL,NULL,'0-电钥匙关闭,1- 电钥匙打开',0,0,'0'),('c3b0a00ee26a11e9b2f2000c2914004c','4002',NULL,2,'38','开关量状态-MOTO',NULL,'2',NULL,NULL,'0-有启动信号,1-无启动信号',0,0,'0'),('c3b0a15ee26a11e9b2f2000c2914004c','4003',NULL,3,'38','开关量状态-电平 1',NULL,'2',NULL,NULL,'0-低电平,1-高电平',0,0,'0'),('c3b0a255e26a11e9b2f2000c2914004c','4004',NULL,4,'38','开关量状态-电平 2',NULL,'2',NULL,NULL,'0-低电平,1- 高电平',0,0,'0'),('c3b0a336e26a11e9b2f2000c2914004c','3020',NULL,5,'38','ACC状态',NULL,'',NULL,NULL,'',0,0,'0'),('c3b0a3fee26a11e9b2f2000c2914004c','3021',NULL,6,'38','终端 MOTO 状态',NULL,NULL,NULL,NULL,NULL,0,0,'0'),('c3b0a4cee26a11e9b2f2000c2914004c','4005','Hz',7,'38','FRQ1 输入',NULL,'3',NULL,NULL,NULL,0,0,'0'),('c3b0a598e26a11e9b2f2000c2914004c','4006','Hz',8,'38','FRQ2 输入',NULL,'3',NULL,NULL,NULL,0,0,'0'),('c3b0a671e26a11e9b2f2000c2914004c','4007','Hz',9,'38','PWM1 输出频率',NULL,'3',NULL,NULL,NULL,0,0,'0'),('c3b0a74ce26a11e9b2f2000c2914004c','4008','Hz',10,'38','PWM2 输出频率',NULL,'3',NULL,NULL,NULL,0,0,'0'),('c3b0a812e26a11e9b2f2000c2914004c','4009','mv',11,'38','输入电压 1',NULL,'3',NULL,NULL,NULL,0,0,'0'),('c3b0a8cde26a11e9b2f2000c2914004c','4010','mv',12,'38','输入电压 2',NULL,'3',NULL,NULL,NULL,0,0,'0'),('c3b0a9aae26a11e9b2f2000c2914004c','4011','mv',13,'38','输入电源电压',NULL,'3',NULL,NULL,NULL,0,0,'0'),('c3b0aa81e26a11e9b2f2000c2914004c','4012','mv',14,'38','输入电池电压',NULL,'3',NULL,NULL,NULL,0,0,'0'),('c3b0ab47e26a11e9b2f2000c2914004c','4352',NULL,15,'38','外壳状态',NULL,'2',NULL,NULL,'0-外壳关闭,1-外壳打开',0,0,'0'),('c3b0abf8e26a11e9b2f2000c2914004c','4353',NULL,16,'38','拆除告警',NULL,'2',NULL,NULL,'0-正常,1-告警',0,0,'0'),('c3b0aceee26a11e9b2f2000c2914004c','4354',NULL,17,'38','开壳告警',NULL,'2',NULL,NULL,'0-正常,1-告警',0,0,'0'),('c3b0adbfe26a11e9b2f2000c2914004c','4355',NULL,18,'38','GPS 天线告警',NULL,'2',NULL,NULL,'0-正常,1-告警',0,0,'0'),('c3b0ae87e26a11e9b2f2000c2914004c','4356',NULL,19,'38','CAN 异常告警',NULL,'2',NULL,NULL,'0-正常,1-告警',0,0,'0'),('c444ca00523cf2a50ecaf82f9a175a34','2204',NULL,6,'49','GPS速度',NULL,'3','GPS速度',NULL,NULL,1,0,'0'),('c45059cfdb7411e9b2f2000c2914004c','3020',NULL,1,'28','电锁状态',NULL,'5',NULL,NULL,'电钥匙打开-打开-1,电钥匙关闭-关闭-0',2,0,'0'),('c4505dd4db7411e9b2f2000c2914004c','4011','V',2,'28','供电电压','x/1000','3','输入电源电压',NULL,NULL,1,0,'0'),('c4505e50db7411e9b2f2000c2914004c','4012','V',3,'28','备用电池电压','x/1000','3','输入电池电压',NULL,NULL,1,0,'0'),('c4505ed2db7411e9b2f2000c2914004c','4352',NULL,15,'281','外壳状态',NULL,'2',NULL,NULL,'0-外壳关闭,1-外壳打开',0,0,'0'),('c45062cedb7411e9b2f2000c2914004c','4354',NULL,5,'28','开壳报警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('c4506380db7411e9b2f2000c2914004c','4355',NULL,18,'281','GPS 天线告警',NULL,'2',NULL,NULL,'0-正常,1-告警',0,0,'0'),('c45064b5db7411e9b2f2000c2914004c','4356',NULL,19,'281','CAN 异常告警',NULL,'2',NULL,NULL,'0-正常,1-告警',0,0,'0'),('c6dffe7c2398096b32eea1280b83056b','4356',NULL,19,'52','CAN 异常告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('c7f43f11fd43876e365ddf20ed9bcc0a','4007','Hz',9,'52','PWM1 输出频率',NULL,'3',NULL,NULL,NULL,1,0,'0'),('ca0b62826edb11e9a45b000c2914004c','4303','kPa',9,'24','燃油压力',NULL,NULL,'燃油压力',NULL,NULL,0,0,'0'),('cb41e53fd10a11e8a45b000c29140039','4285',NULL,17,'30','发动机扭矩模式',NULL,'3','发动机扭矩模式',NULL,NULL,1,0,'0'),('cb41e53fd10a11e8a45b000c2914004c','4285',NULL,17,'20','发动机扭矩模式',NULL,'3','发动机扭矩模式',NULL,NULL,1,0,'0'),('cb716d72f3190f1229bec7663d2c6046','2602','',1,'4b0bcd3b652b4f078f46cc5ef7768a8b','','','3','经度','7','',1,0,'1'),('cc875ed065b6b06cefd728f5d1048b70','4352',NULL,15,'52','外壳状态',NULL,'2',NULL,NULL,'0-外壳关闭,1-外壳打开',1,0,'0'),('ccd6f3ea885798de6a357bd8b595b32a','4355',NULL,18,'52','GPS 天线告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('ccfd84a43b614964bfecc225d3ca507c','4260',NULL,8,'18','GPS ID 匹配状态',NULL,'2','GPSID匹配状态',NULL,'0-不匹配,1-匹配',1,0,'0'),('cda517a90a7811e9bab7d0946600e1f1','4257','',5,'18','锁车状态','','2','锁车状态','','0-未锁车,1-一级锁车,2-二级锁车,9-待锁车',1,0,'0'),('cfe3c279607da123ccd44b090c024933','3012','',11,'4b0bcd3b652b4f078f46cc5ef7768a8b','','','3','方向','0','',1,0,'1'),('d330b620f32e45809c30243c7198c5c9','4108','kPa',5,'338698becb2b4b38ac6d5cecc29dbe99','机油压力','','3','engineOilPressure','0','',1,0,'1'),('d4103687f2d1d978b8975ecd58f88da4','4011','V',13,'52','输入电源电压','x/1000','3',NULL,NULL,NULL,1,0,'0'),('d562db0cf21c4cd4a13401bac08c0421','4254','MPa',18,'18',NULL,'x/1000','3','曲轴箱压力',NULL,NULL,1,0,'0'),('d80e535054fbf441892d1e6a52e655c2','4187','MPa',17,'50','液压系统压力','','3','hydraulicSystemPressure','','',1,0,'0'),('d87a76519673d4b14e390ad6b17de098','2205','km',14,'50','总里程','','3','totalMileage','','',1,0,'0'),('d882f7c70ff11f53928294de2dc391ed','4001',NULL,1,'52','开关量状态-ACC',NULL,'2',NULL,NULL,'0-电钥匙关闭,1- 电钥匙打开',1,0,'0'),('d8d6edf0a2d7e7f2633bdeb84430fcda','-1','',4,'4b0bcd3b652b4f078f46cc5ef7768a8b','当前位置','','4','当前位置(xml文件中不存在)','0','',0,0,'0'),('da3e9cb39cbb6c52c5496afc08b7070c','4003',NULL,3,'52','开关量状态-电平 1',NULL,'2',NULL,NULL,'0-低电平,1-高电平',1,0,'0'),('dbb9dd7f7d7b5c730bf46a1bf1b858dd','3006',NULL,8,'0ad4727a2920487cb436822b9da78c1a','固件版本号',NULL,NULL,NULL,NULL,NULL,1,0,'0'),('dc6a99d5eee011e8a45b000c2914004c','2602',NULL,1,'21',NULL,NULL,'3','经度',NULL,NULL,1,0,'0'),('dc6aa4e5eee011e8a45b000c2914004c','3012',NULL,5,'21',NULL,NULL,'3','方向',NULL,NULL,1,0,'0'),('dc6aa8caeee011e8a45b000c2914004c','2603',NULL,2,'21',NULL,NULL,'3','纬度',NULL,NULL,1,0,'0'),('dc6aaabeeee011e8a45b000c2914004c','-1',NULL,3,'21','当前位置',NULL,NULL,'当前位置(xml文件中不存在)',NULL,NULL,0,0,'0'),('dc6aad2deee011e8a45b000c2914004c','3019',NULL,7,'21',NULL,NULL,'2','GPS模块状态',NULL,'0- 模块正常,1-模块异常',1,0,'0'),('dc6aaed3eee011e8a45b000c2914004c','2204',NULL,4,'21','GPS速度',NULL,'3','GPS速度',NULL,NULL,1,0,'0'),('dc6ab044eee011e8a45b000c2914004c','3014',NULL,8,'21',NULL,NULL,'1','GPS时间',NULL,NULL,1,0,'0'),('dc6ab1a3eee011e8a45b000c2914004c','TIME',NULL,9,'21','回传时间',NULL,'1','接收时间',NULL,NULL,1,0,'0'),('dc6ab30deee011e8a45b000c2914004c','4014',NULL,6,'21',NULL,NULL,'3','水平精度因子',NULL,NULL,1,0,'0'),('ded7a5ad4c7545e8ba27e3b87cf49e0e','4259',NULL,7,'18','GPS Key 验证码',NULL,'2','Key验证码',NULL,'0-不正确,1-正确',1,0,'0'),('dfef5536eb3411e9b2f2000c2914004c','DATE_TYPE',NULL,-1,'30',NULL,NULL,NULL,NULL,NULL,NULL,0,0,'0'),('e08c033cd10a11e8a45b000c29140040','4286','%',18,'30','驾驶员要求的发动机-扭矩百分比',NULL,'3','驾驶员要求的发动机-扭矩百分比',NULL,NULL,1,0,'0'),('e08c033cd10a11e8a45b000c2914004c','4286','%',18,'20','驾驶员要求的发动机-扭矩百分比',NULL,'3','驾驶员要求的发动机-扭矩百分比',NULL,NULL,1,0,'0'),('e112bd84799311ea82d10894ef147327','3014',NULL,-0.1,'50','GPS时间',NULL,'1','GPS时间',NULL,NULL,1,0,'0'),('e31504ef6edb11e9a45b000c2914004c','4108','kPa',10,'24','机油压力',NULL,NULL,'机油压力',NULL,NULL,0,0,'0'),('e39efcc591b71381db6e46150c5fc2bb','3021',NULL,6,'52','终端 MOTO 状态',NULL,NULL,NULL,NULL,NULL,1,0,'0'),('e83fc3bbe76868fdb90ac5d05c70d8e7','4303','kPa',4,'50','燃油压力','','3','4303','','',1,0,'0'),('e8baa4adda0411e9b2f2000c29140012','3013','m',11,'29','海拔高度',NULL,'3','海拔高度',NULL,NULL,1,0,'0'),('e8baa4adda0411e9b2f2000c2914004c','3013','m',11,'19','海拔高度',NULL,'3','海拔高度',NULL,NULL,1,0,'0'),('e8baa4d7da0411e9b2f2000c29140013','3015',NULL,12,'29','使用卫星数',NULL,'3','使用卫星数',NULL,NULL,1,0,'0'),('e8baa4d7da0411e9b2f2000c2914004c','3015',NULL,12,'19','使用卫星数',NULL,'3','使用卫星数',NULL,NULL,1,0,'0'),('e8baa4dfda0411e9b2f2000c29140014','3016',NULL,13,'29','可视卫星数',NULL,'3','可视卫星数',NULL,NULL,1,0,'0'),('e8baa4dfda0411e9b2f2000c2914004c','3016',NULL,13,'19','可视卫星数',NULL,'3','可视卫星数',NULL,NULL,1,0,'0'),('e8c887ffeee011e8a45b000c2914004c','4288','%',21,'22','发动机负荷系数',NULL,'3','发动机负荷系数',NULL,NULL,1,0,'0'),('e8c88ff8eee011e8a45b000c2914004c','4291',NULL,25,'22','车身故障DM1',NULL,NULL,'车身故障DM1',NULL,NULL,0,0,'0'),('e8c89259eee011e8a45b000c2914004c','4289','%',22,'22','实际最大可用发动机-扭矩百分比',NULL,'3','实际最大可用发动机-扭矩百分比',NULL,NULL,1,0,'0'),('e8c893e9eee011e8a45b000c2914004c','4175','L/H',7,'22','燃油消耗率',NULL,'3','小时油耗',NULL,NULL,1,0,'0'),('e8c89564eee011e8a45b000c2914004c','4292',NULL,26,'22','车身故障DM2',NULL,NULL,'车身故障DM2',NULL,NULL,0,0,'0'),('e8c896bdeee011e8a45b000c2914004c','4279','RPM',1,'22','理想发动机转速',NULL,'3','理想发动机转速',NULL,NULL,2,0,'0'),('e8c89815eee011e8a45b000c2914004c','4110','Kpa',15,'22','发动机增压压力',NULL,'3','增压压力',NULL,NULL,1,0,'0'),('e8c89970eee011e8a45b000c2914004c','4280',NULL,3,'22','发动机等待启动灯',NULL,'3','发动机等待启动灯',NULL,NULL,1,0,'0'),('e8c89ac1eee011e8a45b000c2914004c','4281',NULL,5,'22','发动机保护系统已关闭发动机',NULL,'3','发动机保护系统已关闭发动机',NULL,NULL,1,0,'0'),('e8c89c12eee011e8a45b000c2914004c','4250','%',23,'22','标准摩擦-扭矩百分比',NULL,'3','摩擦扭矩百分比',NULL,NULL,1,0,'0'),('e8c89d55eee011e8a45b000c2914004c','4282','KM/L',8,'22','即时燃油经济性',NULL,'3','即时燃油经济性',NULL,NULL,1,0,'0'),('e8c89ec5eee011e8a45b000c2914004c','4290','%',24,'22','估计的发动机寄生损失-扭矩百分比',NULL,'3','估计的发动机寄生损失-扭矩百分比',NULL,NULL,1,0,'0'),('e8c8a029eee011e8a45b000c2914004c','4283','°C',13,'22','发动机进气管温度',NULL,'3','发动机进气管温度',NULL,NULL,1,0,'0'),('e8c8a179eee011e8a45b000c2914004c','4284','Kpa',16,'22','发动机进气压力',NULL,'3','发动机进气压力',NULL,NULL,1,0,'0'),('e8c8a2beeee011e8a45b000c2914004c','4243','℃',10,'22','发动机机油温度',NULL,'3','机油温度',NULL,NULL,1,0,'0'),('e8c8a40deee011e8a45b000c2914004c','4023','L',6,'22','发动机总燃油量',NULL,'3','累计油耗',NULL,NULL,1,0,'0'),('e8c8a6a7eee011e8a45b000c2914004c','4101','RPM',0,'22','发动机速度',NULL,'3','发动机转速',NULL,NULL,1,0,'0'),('e8c8a867eee011e8a45b000c2914004c','4108','MPa',4,'22','发动机机油压力','x/1000','3','机油压力',NULL,NULL,1,0,'0'),('e8c8a9bbeee011e8a45b000c2914004c','4163','H',2,'22','发动机总工作小时数','x/3600','3','发动机工作时间','2',NULL,2,0,'0'),('e8c8ab12eee011e8a45b000c2914004c','4103','%',19,'22','实际发动机-扭矩百分比',NULL,'3','发动机实际扭矩',NULL,NULL,1,0,'0'),('e8c8ac5beee011e8a45b000c2914004c','4109','Kpa',14,'22','大气压力',NULL,'3','大气压力',NULL,NULL,1,0,'0'),('e8c8adcbeee011e8a45b000c2914004c','4112','°C',12,'22','空气进气温度',NULL,'3','进气温度',NULL,NULL,1,0,'0'),('e8c8af2deee011e8a45b000c2914004c','4245','℃',11,'22','外界温度',NULL,'3','大气温度',NULL,NULL,1,0,'0'),('e8c8b089eee011e8a45b000c2914004c','4177','°C',9,'22','发动机冷却液温度',NULL,'3','冷却水温度',NULL,NULL,1,0,'0'),('e8c8b248eee011e8a45b000c2914004c','4285',NULL,17,'22','发动机扭矩模式',NULL,'3','发动机扭矩模式',NULL,NULL,1,0,'0'),('e8c8b4dbeee011e8a45b000c2914004c','4286','%',18,'22','驾驶员要求的发动机-扭矩百分比',NULL,'3','驾驶员要求的发动机-扭矩百分比',NULL,NULL,1,0,'0'),('e8c8b64ceee011e8a45b000c2914004c','4287','%',20,'22','发动机需求-扭矩百分比',NULL,'3','发动机需求-扭矩百分比',NULL,NULL,1,0,'0'),('e9fffc6785418627dcf3e7fc6398e31a','4175','L/h',9,'50','小时油耗','','3','instanFuel','','',1,0,'0'),('eb0f443f6eda11e9a45b000c2914004c','4023','L',2,'24','总耗油量',NULL,NULL,'总耗油量',NULL,NULL,0,0,'0'),('eb2d9f3f963e11e89b79000c292ded3c','4101','RPM',3,'18',NULL,NULL,'3','发动机转速',NULL,NULL,1,0,'0'),('eb2da81c963e11e89b79000c292ded3c','4100',NULL,2,'18',NULL,NULL,'3','冷却水温度',NULL,NULL,1,0,'0'),('eb2daabe963e11e89b79000c292ded3c','3026','V',1,'18',NULL,NULL,'3','电源电压',NULL,NULL,1,0,'0'),('eb3b41c93f114920b525b96bf6292357','4252','MPa',17,'18',NULL,'x/1000','3','绝对增压压力',NULL,NULL,1,0,'0'),('eb5711d2fc5a31259f5040dcb6b84c58','TIME',NULL,8,'49','回传时间',NULL,'1','接收时间',NULL,NULL,1,0,'0'),('ed772e1cabd7fa37a75a8e223b1ee777','4109','kPa',18,'50','大气压力','','3','atmosphericPressure','','',1,0,'0'),('f0b9eff33ff8c6ea2238661e8fbd639f','4014','',10,'4b0bcd3b652b4f078f46cc5ef7768a8b','','','3','水平精度因子','0','',1,0,'1'),('f26801f0afcad5dfcaab4eddf0903acc','4250','%',24,'50','摩擦扭矩百分比','','3','frictionTorqueTercentage','','',1,0,'0'),('f2c29afad10a11e8a45b000c29140041','4287','%',20,'30','发动机需求-扭矩百分比',NULL,'3','发动机需求-扭矩百分比',NULL,NULL,1,0,'0'),('f2c29afad10a11e8a45b000c2914004c','4287','%',20,'20','发动机需求-扭矩百分比',NULL,'3','发动机需求-扭矩百分比',NULL,NULL,1,0,'0'),('f30c677bdab911e9b2f2000c2914004c','4352',NULL,15,'27','外壳状态',NULL,'2',NULL,NULL,'0-外壳关闭,1-外壳打开',1,0,'0'),('f30c677bdab911e9b2f2000c29140077','4352',NULL,15,'33','外壳状态',NULL,'2',NULL,NULL,'0-外壳关闭,1-外壳打开',1,0,'0'),('f30c67a0dab911e9b2f2000c2914004c','4353',NULL,16,'27','拆除告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('f30c67a0dab911e9b2f2000c29140078','4353',NULL,16,'33','拆除告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('f30c67a6dab911e9b2f2000c2914004c','4354',NULL,17,'27','开壳告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('f30c67a6dab911e9b2f2000c29140079','4354',NULL,17,'33','开壳告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('f30c67abdab911e9b2f2000c2914004c','4355',NULL,18,'27','GPS 天线告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('f30c67abdab911e9b2f2000c29140080','4355',NULL,18,'33','GPS 天线告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('f30c67afdab911e9b2f2000c2914004c','4356',NULL,19,'27','CAN 异常告警',NULL,'2',NULL,NULL,'0-正常,1-告警',0,0,'0'),('f30c67afdab911e9b2f2000c29140081','4356',NULL,19,'33','CAN 异常告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('f48805efb2d2376760c0262fb6e95a6c','4177','℃',7,'50','冷却水温度','','3','coolingWaterTemp','','',1,0,'0'),('f584ece9bddfbb86500421cb0b08ef9e','4163','H',11,'50','发动机工作时间','x/3600','3','engineWorkTime','','',1,0,'0'),('f8a9cdc52344cb128391d6e38d8683d2','4247','%',23,'50','发动机负荷','','3','engineLoad','','',1,0,'0'),('fbd94907db7411e9b2f2000c2914004c','4358',NULL,6,'28','定位天线断开报警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('fbd9490ddb7411e9b2f2000c2914004c','4359',NULL,7,'28','定位天线短路报警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('fbd94913db7411e9b2f2000c2914004c','3205',NULL,4,'28','电源断开报警',NULL,'',NULL,NULL,'',1,0,'0'),('fcaa7c395f4aa000be0050ff1fa7f8b8','2204','',7,'4b0bcd3b652b4f078f46cc5ef7768a8b','GPS速度','','3','GPS速度','0','',2,0,'1'); /*!40000 ALTER TABLE `biz_outfield_group_detail` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `biz_outfield_group_info` -- DROP TABLE IF EXISTS `biz_outfield_group_info`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `biz_outfield_group_info` ( `id` char(32) NOT NULL, `group_name` varchar(255) DEFAULT NULL COMMENT '组的名称（TAB页的名称）', `group_sn` int(11) DEFAULT '0' COMMENT '组的序列号（TAB页的顺序）', `remark` varchar(255) DEFAULT NULL COMMENT '备注信息 \\n0:常规信息；1：CAN信息;2：国四监控信息，3：诊断信息，4：设备信息', `agreement_id` char(32) DEFAULT NULL COMMENT '协议ID', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `biz_outfield_group_info` -- LOCK TABLES `biz_outfield_group_info` WRITE; /*!40000 ALTER TABLE `biz_outfield_group_info` DISABLE KEYS */; INSERT INTO `biz_outfield_group_info` VALUES ('0884e85a3b434d69946908651dbe8013','指令下发',2,'2','0bdf887d7d4d40b5975c04d31b655ce6'),('0ad4727a2920487cb436822b9da78c1a','设备信息',5,'5','0bdf887d7d4d40b5975c04d31b655ce6'),('1','常规信息',2,'0','7ef5fd7a538940b3a59e1c8c93016eef'),('10','CAN信息',1,'1','24fc65c5d94846333630a3dc3ca83142'),('11','常规信息',2,'0','3e14d204ae8c40f0801c0e0054dfc427'),('12','CAN信息',1,'1','3e14d204ae8c40f0801c0e0054dfc427'),('13','常规信息',2,'0','db92e9fdcacb433eba576d39d8a22424'),('14','CAN信息',1,'1','db92e9fdcacb433eba576d39d8a22424'),('15','CAN信息',1,'1','92be613241774effbac31e63119f00d8'),('16','常规信息',2,'0','92be613241774effbac31e63119f00d8'),('17','常规信息',2,'0','4810d5cf9d2c4e9da2e77215a2946d77'),('18','CAN信息',1,'1','4810d5cf9d2c4e9da2e77215a2946d77'),('19','常规信息',2,'0','9244dee5c44446f7829fecf1eb98a34f'),('2','CAN信息',1,'1','7ef5fd7a538940b3a59e1c8c93016eef'),('20','车身CAN信息',1,'1','9244dee5c44446f7829fecf1eb98a34f'),('21','常规信息',2,'0','e26779bb6ea44bf0bd7e8e504a5cafe8'),('22','CAN信息',1,'1','e26779bb6ea44bf0bd7e8e504a5cafe8'),('23','常规信息',2,'0','6143c92d4e9d478eb089a25dc98ea354'),('24','CAN信息',1,'1','6143c92d4e9d478eb089a25dc98ea354'),('25','国四监控信息',3,'2','9244dee5c44446f7829fecf1eb98a34f'),('26','诊断信息',4,'3','9244dee5c44446f7829fecf1eb98a34f'),('27','设备信息',5,'4','9244dee5c44446f7829fecf1eb98a34f'),('28','设备信息',5,'4','4810d5cf9d2c4e9da2e77215a2946d77'),('29','常规信息',2,'0','de9f0b6503ce43248a4a7e50cf97d115'),('3','常规信息',2,'0','24fc65c5d94846038670a3dc3ca83142'),('30','车身CAN信息',1,'1','de9f0b6503ce43248a4a7e50cf97d115'),('31','国四监控信息',3,'2','de9f0b6503ce43248a4a7e50cf97d115'),('32','诊断信息',4,'3','de9f0b6503ce43248a4a7e50cf97d115'),('33','设备信息',5,'4','de9f0b6503ce43248a4a7e50cf97d115'),('338698becb2b4b38ac6d5cecc29dbe99','CAN信息',1,'1','0bdf887d7d4d40b5975c04d31b655ce6'),('34','常规信息',2,'0','a91f789e70c545768dd2ff95c57fb88c'),('35','车身CAN信息',1,'1','a91f789e70c545768dd2ff95c57fb88c'),('36','国四监控信息',3,'2','a91f789e70c545768dd2ff95c57fb88c'),('37','诊断信息',4,'3','a91f789e70c545768dd2ff95c57fb88c'),('38','设备信息',5,'4','a91f789e70c545768dd2ff95c57fb88c'),('39','常规信息',2,'0','20e7d4fa4e104fde89d8c1408ba8942c'),('4','CAN信息',1,'1','24fc65c5d94846038670a3dc3ca83142'),('40','车身CAN信息',1,'1','20e7d4fa4e104fde89d8c1408ba8942c'),('41','国四监控信息',3,'2','20e7d4fa4e104fde89d8c1408ba8942c'),('42','诊断信息',4,'3','20e7d4fa4e104fde89d8c1408ba8942c'),('43','设备信息',5,'4','20e7d4fa4e104fde89d8c1408ba8942c'),('44','常规信息',2,'0','0abbabba314b45a797eec940edd2c8bf'),('45','车身CAN信息',1,'1','0abbabba314b45a797eec940edd2c8bf'),('46','国四监控信息',3,'2','0abbabba314b45a797eec940edd2c8bf'),('47','诊断信息',4,'3','0abbabba314b45a797eec940edd2c8bf'),('48','设备信息',5,'4','0abbabba314b45a797eec940edd2c8bf'),('49','常规信息',1,'0','03fb72169c5a4e10889e85d685c4008d'),('4b0bcd3b652b4f078f46cc5ef7768a8b','常规信息',0,'0','0bdf887d7d4d40b5975c04d31b655ce6'),('5','常规信息',1,'0','e08e3c73d76443f58ad5e9d2645dbd65'),('50','CAN信息',2,'1','03fb72169c5a4e10889e85d685c4008d'),('51','指令下发',3,'2','03fb72169c5a4e10889e85d685c4008d'),('52','设备信息',4,'5','03fb72169c5a4e10889e85d685c4008d'),('8','常规信息',1,'0','e08e3c73d764ddf58dd5e9d2645dbd65'),('9','常规信息',2,'0','24fc65c5d94846333630a3dc3ca83142'); /*!40000 ALTER TABLE `biz_outfield_group_info` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `biz_vehicle_type` -- DROP TABLE IF EXISTS `biz_vehicle_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `biz_vehicle_type` ( `type_id` char(32) NOT NULL, `type_name` varchar(50) NOT NULL COMMENT '代码', `org_id` varchar(45) NOT NULL COMMENT '机构ID', `mark` int(1) DEFAULT NULL COMMENT '模板标识 0:公共模板；1私有模板', `brand` varchar(50) DEFAULT NULL COMMENT '品牌', `model_name` varchar(45) DEFAULT NULL COMMENT '型号名称', `powerrating` int(6) DEFAULT NULL COMMENT '额定功率', `classify` varchar(50) DEFAULT NULL COMMENT '所属分类', `size` varchar(45) DEFAULT NULL COMMENT '尺寸', `in_use` int(1) DEFAULT NULL COMMENT '0:未使用；1：使用', `v_org_id` varchar(45) DEFAULT NULL COMMENT '车型的机构ID', `is_intelligent` int(11) DEFAULT NULL COMMENT '是否是智能终端，已弃用', `is_filter_missing_column` bit(1) DEFAULT NULL COMMENT '是否过滤丢失字段\\\\\\\\n0、不过滤；1、过滤', PRIMARY KEY (`type_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `biz_vehicle_type` -- LOCK TABLES `biz_vehicle_type` WRITE; /*!40000 ALTER TABLE `biz_vehicle_type` DISABLE KEYS */; INSERT INTO `biz_vehicle_type` VALUES ('03fb72169c5a4e10889e85d685c4008d','临工车辆类型','a2c1c88cdba246bca14671cfd62b7bb0',1,NULL,NULL,0,NULL,NULL,1,NULL,NULL,NULL),('052a63d8cb4a4f36a2cccd8429e7ba6e','收割机','61727e241f814593942a5bfbb720d649',1,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL),('0abbabba314b45a797eec940edd2c8bf','卡特彼勒内部测试车型','194ac518db9147b1a7fadf843b9546a4',1,NULL,NULL,0,NULL,NULL,1,NULL,NULL,NULL),('0bdf887d7d4d40b5975c04d31b655ce6','挖机','b49830825cd842d1b65e913b12d5f0e5',1,NULL,NULL,0,NULL,NULL,1,NULL,NULL,NULL),('20e7d4fa4e104fde89d8c1408ba8942c','长征测试机型','b72650b7a85545a0b1d5c9693e98e7f5',1,NULL,NULL,0,NULL,NULL,1,NULL,NULL,NULL),('24fc65c5d94846038670a3dc3ca83142','农机慧眼一体机CAN','000022dafc444b949af0684538b85e08',0,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL),('24fc65c5d94846333630a3dc3ca83142','农机慧眼一体机CAN-时风','e1ba1d0f36a9467a9369e92003fe998a',0,NULL,NULL,0,NULL,NULL,1,NULL,NULL,NULL),('4810d5cf9d2c4e9da2e77215a2946d77','装载机-英轩重工','a036e9986b6f4c4fa9a27c7b442c129a',1,NULL,NULL,0,NULL,NULL,1,NULL,NULL,NULL),('5da491a0cb9744bca07a6751606faf5b','深翻机','61727e241f814593942a5bfbb720d649',1,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL),('6143c92d4e9d478eb089a25dc98ea354','安百拓车型','819c20240c984a4e8de6bfd8c89a2358',1,NULL,NULL,0,NULL,NULL,1,NULL,NULL,NULL),('65978071b5084857b494c1169389c7d4','履带式拖拉机','34bac7f643844259898ca92875762c96',1,NULL,NULL,0,NULL,NULL,1,NULL,NULL,NULL),('7ef5fd7a538940b3a59e1c8c93016eef','拖拉机车辆类型','34bac7f643844259898ca92875762c96',1,NULL,NULL,0,NULL,NULL,1,NULL,NULL,NULL),('807cfd3dda2c47f390812e9f1790c808','lucky','be2ac410ceb04a83b8671d6e27ce3a23',1,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL),('9244dee5c44446f7829fecf1eb98a34f','卡特彼勒测试机型','b8721c2d62a7422d9cd18e1ae318649c',1,NULL,NULL,0,NULL,NULL,1,NULL,NULL,NULL),('92be613241774effbac31e63119f00d8','挖掘机-嘉和','70320d7d2c1c4a97a5371ec4da32b736',1,NULL,NULL,0,NULL,NULL,1,NULL,NULL,NULL),('a91f789e70c545768dd2ff95c57fb88c','玉柴发动机','af4fe7c7854246269bd338cf761c827d',1,NULL,NULL,0,NULL,NULL,1,NULL,NULL,NULL),('b149a489fcb94ee4874503f48ba53144','111','61727e241f814593942a5bfbb720d649',1,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL),('b41c896c036c45979d7cacb878841535','sky','be2ac410ceb04a83b8671d6e27ce3a23',1,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL),('de9f0b6503ce43248a4a7e50cf97d115','卡特彼勒测试专用机型','d70c987fd05e43a3a479f41ff84792a9',1,NULL,NULL,0,NULL,NULL,1,NULL,NULL,NULL),('e08e3c73d76443f58ad5e9d2645dbd65','农机慧眼一体机','34bac7f643844259898ca92875762c96',0,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL),('e08e3c73d764ddf58dd5e9d2645dbd65','农机慧眼深松一体机','34bac7f643844259898ca92875762c96',0,NULL,NULL,0,NULL,NULL,1,NULL,NULL,NULL),('e26779bb6ea44bf0bd7e8e504a5cafe8','卡特彼勒测试机型','a4afab015f8d49c58e4accb25b012059',1,NULL,NULL,0,NULL,NULL,1,NULL,NULL,NULL); /*!40000 ALTER TABLE `biz_vehicle_type` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sys_organization` -- DROP TABLE IF EXISTS `sys_organization`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `sys_organization` ( `id` char(32) NOT NULL, `org_name` varchar(50) DEFAULT NULL, `org_ids` varchar(2000) DEFAULT NULL, `parent_id` char(32) DEFAULT NULL, `create_time` datetime DEFAULT NULL, `update_time` datetime DEFAULT NULL, `update_user_id` char(32) DEFAULT NULL, `in_use` int(1) DEFAULT '0' COMMENT '0不\n\n可用1可用', `is_manufacturer` int(1) DEFAULT NULL COMMENT '组织机构类型,0、企业；1、厂商；3、代理商；4、经销商；5、其他；-1、平台节点', `manufacturer_id` char(32) DEFAULT NULL COMMENT '所属厂商', `province` char(50) DEFAULT NULL, `city` char(50) DEFAULT NULL, `county` char(100) DEFAULT NULL, `province_code` char(10) DEFAULT NULL, `county_code` char(10) DEFAULT NULL, `city_code` char(10) DEFAULT NULL, `old_org_ids` varchar(2000) DEFAULT NULL, `new_org_ids` varchar(2000) DEFAULT NULL, `order_id` int(11) DEFAULT '0', `domain_name` varchar(45) DEFAULT '', `login_url` varchar(200) DEFAULT '', `home_url` varchar(200) DEFAULT '', `LogoFile` blob COMMENT 'logo文件', `FileNameExtension` varchar(10) DEFAULT '' COMMENT '文件扩展名', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sys_organization` -- LOCK TABLES `sys_organization` WRITE; /*!40000 ALTER TABLE `sys_organization` DISABLE KEYS */; INSERT INTO `sys_organization` VALUES (''00f96888f1f84d268d92b4de455b20a0'',''机构测试2'',''#19dee55f0cc54a7f9b39bfc9c4ded670#34bac7f643844259898ca92875762c96#9403c348216f4152bc626dea1f447755#9418e3d6246f49e6aeb11c3e3bb22b6c#00f96888f1f84d268d92b4de455b20a0#'',''9418e3d6246f49e6aeb11c3e3bb22b6c'',''2018-08-23 08:57:30'',NULL,NULL,0,4,''34bac7f643844259898ca92875762c96'',''天津市'',''市辖区'',''河东区'',''120000'',''120102'',''120100'',''00010001000200020004'',NULL,1,'''','''','''',NULL,''''),(''04f1bbcd4531455d839f0ecc5fc860fa'',''嘉和烟台代理'',''#19dee55f0cc54a7f9b39bfc9c4ded670#70320d7d2c1c4a97a5371ec4da32b736#04f1bbcd4531455d839f0ecc5fc860fa#'',''70320d7d2c1c4a97a5371ec4da32b736'',''2018-08-22 10:57:49'',NULL,NULL,1,3,''70320d7d2c1c4a97a5371ec4da32b736'',''山东省'',''烟台市'',''市辖区'',''370000'',''370601'',''370600'',''000100150004'',NULL,3,'''','''',''/summary/index'',NULL,''.png''),(''064a6a1609d54bed8546e23d28eecb3e'',''工程机械-经销商'',''#19dee55f0cc54a7f9b39bfc9c4ded670#a036e9986b6f4c4fa9a27c7b442c129a#86837a29ef3f4593a71aaf619a3a1212#064a6a1609d54bed8546e23d28eecb3e#'',''86837a29ef3f4593a71aaf619a3a1212'',''2019-09-19 17:32:08'',NULL,NULL,1,0,''a036e9986b6f4c4fa9a27c7b442c129a'',''山东省'',''潍坊市'',''昌乐县'',''370000'',''370725'',''370700'',''0001002300010004'',NULL,1,'''','''','''',NULL,''''),(''0bb68199267f42969e602498c061b13c'',''嘉和菏泽代理'',''#19dee55f0cc54a7f9b39bfc9c4ded670#70320d7d2c1c4a97a5371ec4da32b736#0bb68199267f42969e602498c061b13c#'',''70320d7d2c1c4a97a5371ec4da32b736'',''2018-08-22 10:53:53'',NULL,NULL,1,3,''70320d7d2c1c4a97a5371ec4da32b736'',''山东省'',''德州市'',''东城区'',''370000'',''110101'',''371400'',''000100150003'',NULL,2,'''','''',''/summary/index'',NULL,''.png''),(''194ac518db9147b1a7fadf843b9546a4'',''卡特彼勒博创内部测试'',''#19dee55f0cc54a7f9b39bfc9c4ded670#194ac518db9147b1a7fadf843b9546a4#'',''19dee55f0cc54a7f9b39bfc9c4ded670'',''2019-11-28 17:01:21'',NULL,NULL,1,1,''194ac518db9147b1a7fadf843b9546a4'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''00010038'',NULL,9,'''','''','''',NULL,''''),(''19dee55f0cc54a7f9b39bfc9c4ded670'',''工程机械生产管理平台'',''#19dee55f0cc54a7f9b39bfc9c4ded670#'',NULL,NULL,''2016-09-09 15:03:00'',''0c008d48110e420c9a1ff48e51860156'',1,-1,NULL,''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''0001'',''#19dee55f0cc54a7f9b39bfc9c4ded670#'',0,'''','''','''',NULL,''.png''),(''34bac7f643844259898ca92875762c96'',''山东五征集团'',''#19dee55f0cc54a7f9b39bfc9c4ded670#34bac7f643844259898ca92875762c96#'',''19dee55f0cc54a7f9b39bfc9c4ded670'',''2017-10-31 15:54:42'',NULL,NULL,1,1,''34bac7f643844259898ca92875762c96'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''00010001'',NULL,-1,'''','''','''',NULL,''.png''),(''62edc42e3d73485b9b7021f9492ba40f'',''英轩重工长时间测试'',''#19dee55f0cc54a7f9b39bfc9c4ded670#a036e9986b6f4c4fa9a27c7b442c129a#62edc42e3d73485b9b7021f9492ba40f#'',''a036e9986b6f4c4fa9a27c7b442c129a'',''2020-06-01 09:36:24'',NULL,NULL,1,0,''a036e9986b6f4c4fa9a27c7b442c129a'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''000100230004'',NULL,2,'''','''','''',NULL,''''),(''64545bcba3d34fb28edd8849a05d9d05'',''经销商演示机构'',''#19dee55f0cc54a7f9b39bfc9c4ded670#a4afab015f8d49c58e4accb25b012059#64545bcba3d34fb28edd8849a05d9d05#'',''a4afab015f8d49c58e4accb25b012059'',''2020-04-03 09:40:11'',NULL,NULL,1,4,''a4afab015f8d49c58e4accb25b012059'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''000100300001'',NULL,0,'''','''','''',NULL,''''),(''6983646475dc4242a79a17fea9893a34'',''英轩测试子企业的子企业'',''#19dee55f0cc54a7f9b39bfc9c4ded670#a036e9986b6f4c4fa9a27c7b442c129a#9e1ba94554af4656bc5a4954cddd7ece#6983646475dc4242a79a17fea9893a34#'',''9e1ba94554af4656bc5a4954cddd7ece'',''2018-11-29 15:55:01'',NULL,NULL,1,0,''a036e9986b6f4c4fa9a27c7b442c129a'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''0001002300030001'',NULL,0,'''','''','''','''',NULL),(''6ab1fa8091104f54951c292beb6d91d0'',''嘉和济宁代理'',''#19dee55f0cc54a7f9b39bfc9c4ded670#70320d7d2c1c4a97a5371ec4da32b736#6ab1fa8091104f54951c292beb6d91d0#'',''70320d7d2c1c4a97a5371ec4da32b736'',''2018-08-22 15:39:04'',NULL,NULL,1,3,''70320d7d2c1c4a97a5371ec4da32b736'',''山东省'',''济宁市'',''市辖区'',''370000'',''370801'',''370800'',''000100150005'',NULL,4,'''','''','''',NULL,''''),(''70320d7d2c1c4a97a5371ec4da32b736'',''泰安嘉和重工'',''#19dee55f0cc54a7f9b39bfc9c4ded670#70320d7d2c1c4a97a5371ec4da32b736#'',''19dee55f0cc54a7f9b39bfc9c4ded670'',''2018-07-03 11:31:14'',NULL,NULL,1,1,''70320d7d2c1c4a97a5371ec4da32b736'',''山东省'',''泰安市'',''泰山区'',''370000'',''370902'',''370900'',''00010015'',NULL,4,'''','''','''',NULL,''''),(''7dabc93eb2bf413283d24ef7c3a8cf73'',''企业0625'',''#19dee55f0cc54a7f9b39bfc9c4ded670#34bac7f643844259898ca92875762c96#7dabc93eb2bf413283d24ef7c3a8cf73#'',''34bac7f643844259898ca92875762c96'',''2019-06-25 10:50:57'',NULL,NULL,0,0,''34bac7f643844259898ca92875762c96'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''000100010006'',NULL,4,'''','''','''',NULL,''''),(''819c20240c984a4e8de6bfd8c89a2358'',''安百拓'',''#19dee55f0cc54a7f9b39bfc9c4ded670#819c20240c984a4e8de6bfd8c89a2358#'',''19dee55f0cc54a7f9b39bfc9c4ded670'',''2019-05-05 10:07:48'',NULL,NULL,1,1,''819c20240c984a4e8de6bfd8c89a2358'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''00010034'',NULL,10,'''','''','''',NULL,''''),(''84f7e24f4251457981583878b61c712b'',''泰安嘉和代理商'',''#19dee55f0cc54a7f9b39bfc9c4ded670#70320d7d2c1c4a97a5371ec4da32b736#84f7e24f4251457981583878b61c712b#'',''70320d7d2c1c4a97a5371ec4da32b736'',''2018-08-21 20:12:58'',NULL,NULL,1,3,''70320d7d2c1c4a97a5371ec4da32b736'',''山东省'',''泰安市'',''东城区'',''370000'',''110101'',''370900'',''000100150001'',NULL,0,'''','''','''',NULL,''''),(''86837a29ef3f4593a71aaf619a3a1212'',''工程机械事业部'',''#19dee55f0cc54a7f9b39bfc9c4ded670#a036e9986b6f4c4fa9a27c7b442c129a#86837a29ef3f4593a71aaf619a3a1212#'',''a036e9986b6f4c4fa9a27c7b442c129a'',''2018-08-21 11:14:54'',NULL,NULL,1,0,''a036e9986b6f4c4fa9a27c7b442c129a'',''山东省'',''潍坊市'',''昌乐县'',''370000'',''370725'',''370700'',''000100230001'',NULL,0,'''','''','''',NULL,''''),(''8d197c67f44440f6948d1508b1f817b5'',''代理商演示机构'',''#19dee55f0cc54a7f9b39bfc9c4ded670#a4afab015f8d49c58e4accb25b012059#64545bcba3d34fb28edd8849a05d9d05#8d197c67f44440f6948d1508b1f817b5#'',''64545bcba3d34fb28edd8849a05d9d05'',''2020-04-03 09:40:22'',NULL,NULL,1,3,''a4afab015f8d49c58e4accb25b012059'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''0001003000010001'',NULL,0,'''','''','''',NULL,''''),(''9403c348216f4152bc626dea1f447755'',''五征子机构测试'',''#19dee55f0cc54a7f9b39bfc9c4ded670#34bac7f643844259898ca92875762c96#9403c348216f4152bc626dea1f447755#'',''34bac7f643844259898ca92875762c96'',''2018-08-21 14:02:22'',NULL,NULL,1,0,''34bac7f643844259898ca92875762c96'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''000100010002'',NULL,1,'''','''',''/'',NULL,''''),(''9418e3d6246f49e6aeb11c3e3bb22b6c'',''子机构下新增子机构测试'',''#19dee55f0cc54a7f9b39bfc9c4ded670#34bac7f643844259898ca92875762c96#9403c348216f4152bc626dea1f447755#9418e3d6246f49e6aeb11c3e3bb22b6c#'',''9403c348216f4152bc626dea1f447755'',''2018-08-21 14:39:01'',NULL,NULL,0,4,''34bac7f643844259898ca92875762c96'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''0001000100020002'',NULL,0,'''','''',''/'',NULL,''''),(''9737a00ff14a43a4881d895d4db38aad'',''1111'',''#19dee55f0cc54a7f9b39bfc9c4ded670#34bac7f643844259898ca92875762c96#9403c348216f4152bc626dea1f447755#9737a00ff14a43a4881d895d4db38aad#'',''9403c348216f4152bc626dea1f447755'',''2019-10-14 16:37:28'',NULL,NULL,0,4,''34bac7f643844259898ca92875762c96'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''0001000100020003'',NULL,0,'''','''','''',NULL,''''),(''9bd00cc36c0a4815af1eb133f9f8637f'',''工程机械-厂内'',''#19dee55f0cc54a7f9b39bfc9c4ded670#a036e9986b6f4c4fa9a27c7b442c129a#86837a29ef3f4593a71aaf619a3a1212#9bd00cc36c0a4815af1eb133f9f8637f#'',''86837a29ef3f4593a71aaf619a3a1212'',''2019-09-19 17:32:27'',NULL,NULL,1,0,''a036e9986b6f4c4fa9a27c7b442c129a'',''山东省'',''潍坊市'',''昌乐县'',''370000'',''370725'',''370700'',''0001002300010005'',NULL,2,'''','''','''',NULL,''''),(''9e1ba94554af4656bc5a4954cddd7ece'',''车队'',''#19dee55f0cc54a7f9b39bfc9c4ded670#a036e9986b6f4c4fa9a27c7b442c129a#9e1ba94554af4656bc5a4954cddd7ece#'',''a036e9986b6f4c4fa9a27c7b442c129a'',''2018-11-29 15:54:14'',NULL,NULL,1,0,''a036e9986b6f4c4fa9a27c7b442c129a'',''山东省'',''潍坊市'',''昌乐县'',''370000'',''370725'',''370700'',''000100230003'',NULL,2,'''','''','''','''',NULL),(''a036e9986b6f4c4fa9a27c7b442c129a'',''英轩集团'',''#19dee55f0cc54a7f9b39bfc9c4ded670#a036e9986b6f4c4fa9a27c7b442c129a#'',''19dee55f0cc54a7f9b39bfc9c4ded670'',''2018-08-02 18:01:46'',NULL,NULL,1,1,''a036e9986b6f4c4fa9a27c7b442c129a'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''00010023'',NULL,7,'''','''','''',NULL,''yxpng''),(''a1275580fcbe48428bdd348975c1dacc'',''英轩重工'',''#19dee55f0cc54a7f9b39bfc9c4ded670#a036e9986b6f4c4fa9a27c7b442c129a#62edc42e3d73485b9b7021f9492ba40f#a1275580fcbe48428bdd348975c1dacc#'',''62edc42e3d73485b9b7021f9492ba40f'',''2020-10-28 16:19:18'',NULL,NULL,1,0,''a036e9986b6f4c4fa9a27c7b442c129a'',''山东省'',''潍坊市'',''市辖区'',''370000'',''370701'',''370700'',''0001002300040001'',NULL,0,'''','''','''',NULL,''''),(''a1d8e0bc767c46babad028be98266a9c'',''五征代理商'',''#19dee55f0cc54a7f9b39bfc9c4ded670#34bac7f643844259898ca92875762c96#a1d8e0bc767c46babad028be98266a9c#'',''34bac7f643844259898ca92875762c96'',''2018-08-21 11:38:26'',NULL,NULL,1,3,''34bac7f643844259898ca92875762c96'',''山东省'',''济南市'',''市辖区'',''370000'',''370101'',''370100'',''000100010001'',NULL,0,'''','''','''',NULL,''''),(''a2c1c88cdba246bca14671cfd62b7bb0'',''临工'',''#19dee55f0cc54a7f9b39bfc9c4ded670#a2c1c88cdba246bca14671cfd62b7bb0#'',''19dee55f0cc54a7f9b39bfc9c4ded670'',''2020-04-10 17:13:01'',NULL,NULL,1,1,''a2c1c88cdba246bca14671cfd62b7bb0'',''山东省'',''济南市'',''市辖区'',''370000'',''370101'',''370100'',''00010039'',NULL,10,'''','''','''',NULL,''''),(''a4afab015f8d49c58e4accb25b012059'',''演示专用机构'',''#19dee55f0cc54a7f9b39bfc9c4ded670#a4afab015f8d49c58e4accb25b012059#'',''19dee55f0cc54a7f9b39bfc9c4ded670'',''2018-11-23 11:44:46'',NULL,NULL,1,1,''a4afab015f8d49c58e4accb25b012059'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''00010030'',NULL,6,'''','''','''','''',NULL),(''af4fe7c7854246269bd338cf761c827d'','' 广西玉柴机器集团有限公司'',''#19dee55f0cc54a7f9b39bfc9c4ded670#af4fe7c7854246269bd338cf761c827d#'',''19dee55f0cc54a7f9b39bfc9c4ded670'',''2019-09-29 11:36:14'',NULL,NULL,1,1,''af4fe7c7854246269bd338cf761c827d'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''00010036'',NULL,7,'''','''','''',NULL,''''),(''b1068cde7d8044b2b5f4f8685a1a57ba'',''测试'',''#19dee55f0cc54a7f9b39bfc9c4ded670#34bac7f643844259898ca92875762c96#b1068cde7d8044b2b5f4f8685a1a57ba#'',''34bac7f643844259898ca92875762c96'',''2018-11-30 14:18:50'',NULL,NULL,0,0,''34bac7f643844259898ca92875762c96'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''000100010004'',NULL,2,'''','''','''',NULL,''''),(''b2d8bd21fd154876bc4a0f3b37e8fbbb'',''嘉和日照代理'',''#19dee55f0cc54a7f9b39bfc9c4ded670#70320d7d2c1c4a97a5371ec4da32b736#b2d8bd21fd154876bc4a0f3b37e8fbbb#'',''70320d7d2c1c4a97a5371ec4da32b736'',''2018-08-22 15:40:31'',NULL,NULL,1,3,''70320d7d2c1c4a97a5371ec4da32b736'',''山东省'',''日照市'',''市辖区'',''370000'',''371101'',''371100'',''000100150006'',NULL,5,'''','''','''',NULL,''''),(''b49623570d4e4f8f8f519c0a8861abfa'',''99999999999999999999999999999999999999999999999999'',''#19dee55f0cc54a7f9b39bfc9c4ded670#34bac7f643844259898ca92875762c96#9403c348216f4152bc626dea1f447755#9418e3d6246f49e6aeb11c3e3bb22b6c#b49623570d4e4f8f8f519c0a8861abfa#'',''9418e3d6246f49e6aeb11c3e3bb22b6c'',''2019-06-18 16:13:53'',NULL,NULL,0,3,''34bac7f643844259898ca92875762c96'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''00010001000200020005'',NULL,2,'''','''','''',NULL,''''),(''b49830825cd842d1b65e913b12d5f0e5'',''山东泽圳机电有限公司'',''#19dee55f0cc54a7f9b39bfc9c4ded670#b49830825cd842d1b65e913b12d5f0e5#'',''19dee55f0cc54a7f9b39bfc9c4ded670'',''2020-06-17 15:43:18'',NULL,NULL,1,1,''b49830825cd842d1b65e913b12d5f0e5'',''山东省'',''临沂市'',''临沭县'',''370000'',''371329'',''371300'',''00010040'',NULL,11,'''','''','''',NULL,''''),(''b72650b7a85545a0b1d5c9693e98e7f5'',''河北长征汽车制造有限公司'',''#19dee55f0cc54a7f9b39bfc9c4ded670#b72650b7a85545a0b1d5c9693e98e7f5#'',''19dee55f0cc54a7f9b39bfc9c4ded670'',''2019-11-18 09:50:25'',NULL,NULL,1,1,''b72650b7a85545a0b1d5c9693e98e7f5'',''河北省'',''邢台市'',''邢台县'',''130000'',''130521'',''130500'',''00010037'',NULL,8,'''','''','''',NULL,''''),(''b8721c2d62a7422d9cd18e1ae318649c'',''卡特彼勒'',''#19dee55f0cc54a7f9b39bfc9c4ded670#b8721c2d62a7422d9cd18e1ae318649c#'',''19dee55f0cc54a7f9b39bfc9c4ded670'',''2018-10-16 13:39:49'',NULL,NULL,1,1,''b8721c2d62a7422d9cd18e1ae318649c'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''00010024'',NULL,3,'''','''','''','''',NULL),(''c11905a497e4499b817f33b763e10235'',''兴旺经销商'',''#19dee55f0cc54a7f9b39bfc9c4ded670#a036e9986b6f4c4fa9a27c7b442c129a#86837a29ef3f4593a71aaf619a3a1212#064a6a1609d54bed8546e23d28eecb3e#c11905a497e4499b817f33b763e10235#'',''064a6a1609d54bed8546e23d28eecb3e'',''2020-04-07 14:09:27'',NULL,NULL,1,4,''a036e9986b6f4c4fa9a27c7b442c129a'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''00010023000100040002'',NULL,1,'''','''','''',NULL,''''),(''c6d3dfb7afc548438989aa6f6b472071'',''嘉和德州代理'',''#19dee55f0cc54a7f9b39bfc9c4ded670#70320d7d2c1c4a97a5371ec4da32b736#c6d3dfb7afc548438989aa6f6b472071#'',''70320d7d2c1c4a97a5371ec4da32b736'',''2018-08-22 09:44:44'',NULL,NULL,1,3,''70320d7d2c1c4a97a5371ec4da32b736'',''山东省'',''德州市'',''市辖区'',''370000'',''371401'',''371400'',''000100150002'',NULL,1,'''','''','''',NULL,''''),(''c9fce339f5a24283a573c6c12b44187a'',''测试0620'',''#19dee55f0cc54a7f9b39bfc9c4ded670#34bac7f643844259898ca92875762c96#c9fce339f5a24283a573c6c12b44187a#'',''34bac7f643844259898ca92875762c96'',''2019-06-20 17:22:10'',NULL,NULL,0,0,''34bac7f643844259898ca92875762c96'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''000100010005'',NULL,3,'''','''','''',NULL,''''),(''cb35ca1e984c4172b7824ea9dd4cf440'',''子机构测试'',''#19dee55f0cc54a7f9b39bfc9c4ded670#34bac7f643844259898ca92875762c96#9403c348216f4152bc626dea1f447755#9418e3d6246f49e6aeb11c3e3bb22b6c#cb35ca1e984c4172b7824ea9dd4cf440#'',''9418e3d6246f49e6aeb11c3e3bb22b6c'',''2018-08-23 08:55:51'',NULL,NULL,0,4,''34bac7f643844259898ca92875762c96'',''北京市'',''市辖区'',''西城区'',''110000'',''110102'',''110100'',''00010001000200020003'',NULL,0,'''','''','''',NULL,''''),(''d70c987fd05e43a3a479f41ff84792a9'',''卡特彼勒测试'',''#19dee55f0cc54a7f9b39bfc9c4ded670#d70c987fd05e43a3a479f41ff84792a9#'',''19dee55f0cc54a7f9b39bfc9c4ded670'',''2019-09-25 08:42:25'',NULL,NULL,1,1,''d70c987fd05e43a3a479f41ff84792a9'',''北京市'',''市辖区'',''西城区'',''110000'',''110102'',''110100'',''00010035'',NULL,6,'''','''','''',NULL,''''),(''dbe7ce06e2bd4311b329c161c84bfeb3'',''小经销商'',''#19dee55f0cc54a7f9b39bfc9c4ded670#b8721c2d62a7422d9cd18e1ae318649c#fa4d7df7634e4c83b19b8c42d583cdb9#dbe7ce06e2bd4311b329c161c84bfeb3#'',''fa4d7df7634e4c83b19b8c42d583cdb9'',''2018-11-26 10:44:38'',NULL,NULL,1,4,''b8721c2d62a7422d9cd18e1ae318649c'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''0001002400010001'',NULL,0,'''','''','''','''',NULL),(''dfcdb40807944bd1aec8dd49b49cc2bb'',''经销商0625-2'',''#19dee55f0cc54a7f9b39bfc9c4ded670#34bac7f643844259898ca92875762c96#dfcdb40807944bd1aec8dd49b49cc2bb#'',''34bac7f643844259898ca92875762c96'',''2019-06-25 11:02:17'',NULL,NULL,1,4,''34bac7f643844259898ca92875762c96'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''000100010007'',NULL,5,'''','''','''',NULL,''''),(''e2a76a9522c7483eba93e7bf9962116c'',''英轩经销商'',''#19dee55f0cc54a7f9b39bfc9c4ded670#a036e9986b6f4c4fa9a27c7b442c129a#86837a29ef3f4593a71aaf619a3a1212#064a6a1609d54bed8546e23d28eecb3e#e2a76a9522c7483eba93e7bf9962116c#'',''064a6a1609d54bed8546e23d28eecb3e'',''2019-09-19 17:32:57'',NULL,NULL,1,4,''a036e9986b6f4c4fa9a27c7b442c129a'',''山东省'',''潍坊市'',''昌乐县'',''370000'',''370725'',''370700'',''00010023000100040001'',NULL,0,'''','''','''',NULL,''''),(''fa4d7df7634e4c83b19b8c42d583cdb9'',''卡特下属代理'',''#19dee55f0cc54a7f9b39bfc9c4ded670#b8721c2d62a7422d9cd18e1ae318649c#fa4d7df7634e4c83b19b8c42d583cdb9#'',''b8721c2d62a7422d9cd18e1ae318649c'',''2018-11-20 14:36:47'',NULL,NULL,1,3,''b8721c2d62a7422d9cd18e1ae318649c'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''000100240001'',NULL,0,'''','''','''','''',NULL); /*!40000 ALTER TABLE `sys_organization` ENABLE KEYS */; -- -- Table structure for table `biz_command_config` -- DROP TABLE IF EXISTS `biz_command_config`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `biz_command_config` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `commandName` varchar(45) DEFAULT NULL COMMENT '指令名称', `url` varchar(45) DEFAULT '', `description` varchar(255) DEFAULT NULL COMMENT '指令描述', `renderTemplate` varchar(255) DEFAULT NULL, `paramTemplate` varchar(255) DEFAULT NULL, `defaultValue` varchar(255) DEFAULT NULL COMMENT '控件默认值', `groupType` int(11) DEFAULT NULL COMMENT '分组类型，用于前端渲染处理', `isDelete` int(11) DEFAULT '0' COMMENT '0、未删除；1、已删除', `createTime` datetime(6) DEFAULT NULL, `updateTime` datetime(6) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='指令配置表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `biz_command_config` -- LOCK TABLES `biz_command_config` WRITE; /*!40000 ALTER TABLE `biz_command_config` DISABLE KEYS */; INSERT INTO `biz_command_config` VALUES (1,'设置宽幅','/command/api/farm/setParams','设置宽幅','输入宽幅|setWidth|input','setWidth={setWidth}','',0,0,NULL,'2020-06-28 05:50:54.859553'),(2,'设置终端休眠时间','/command/api/farm/setParams','设置终端休眠时间','输入休眠时间|terminalSleepTime|input','terminalSleepTime={terminalSleepTime}','',0,0,'2020-05-14 09:25:02.330064','2020-06-28 05:50:51.851002'),(3,'设置网关','/command/api/farm/setParams','设置网关','域名|platformDomainName|input,端口|platformPort|input','platformDomainName={platformDomainName}|platformPort={platformPort}','',0,0,'2020-06-03 05:28:17.823309','2020-06-28 05:50:48.460262'),(4,'清除亩数','/command/api/farm/setParams','清除亩数','输入亩数|clearArea|input','clearArea={clearArea}','',0,0,'2020-06-03 05:32:39.399659','2020-06-28 05:50:58.625486'),(5,'清除里程','/command/api/farm/setParams','清除里程','输入里程|clearMileage|input','clearMileage={clearMileage}','',0,0,'2020-06-03 05:33:24.175212','2020-06-28 05:51:01.768004'),(6,'FTP服务器-远程升级','/command/api/farm/remoteUpgrade','请填写服务器相关信息','用户名|userName|input,密码|psd|input,IP地址|upDataIp|input,端口|upDataPor|input,文件名称|file|input,升级模块|model|input','{upDataIp},{upDataPor},{userName},{psd},{file},0&model={model}','',0,0,'2020-06-15 02:41:38.674139','2020-06-28 05:45:42.636477'); /*!40000 ALTER TABLE `biz_command_config` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `biz_terminaltype_cmdcfg_rel` -- DROP TABLE IF EXISTS `biz_terminaltype_cmdcfg_rel`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `biz_terminaltype_cmdcfg_rel` ( `id` char(32) NOT NULL, `commandConfigId` bigint(20) DEFAULT NULL COMMENT '指令配置ID', `terminalTypeId` char(32) DEFAULT NULL COMMENT '终端类型ID', `realtionTime` datetime DEFAULT NULL COMMENT '关联时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='终端类型与指令配置关联表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `biz_terminaltype_cmdcfg_rel` -- LOCK TABLES `biz_terminaltype_cmdcfg_rel` WRITE; /*!40000 ALTER TABLE `biz_terminaltype_cmdcfg_rel` DISABLE KEYS */; INSERT INTO `biz_terminaltype_cmdcfg_rel` VALUES ('3a4e498b888146e2a08d3f874910310b',2,'19c89c708e42499fae7ee4cde54daf2b','2020-05-16 11:01:46'),('96885e7d303148cc8c075c1a882ff5c8',1,'19c89c708e42499fae7ee4cde54daf2b','2020-05-16 11:01:46'),('d0b7471da3c5464395a0d6ed77dbc549',2,'e17b1ff6e3d3445fb020e0f4d094ad04','2020-08-05 10:13:20'); /*!40000 ALTER TABLE `biz_terminaltype_cmdcfg_rel` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2020-12-04 18:49:06