IOT/Db/cems_server_config.sql

/*
Navicat MySQL Data Transfer

Source Server         : 192.168.0.22
Source Server Version : 50735
Source Host           : 192.168.0.22:3306
Source Database       : cems_server_config

Target Server Type    : MYSQL
Target Server Version : 50735
File Encoding         : 65001

Date: 2022-01-20 13:57:15
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for t_parse_type
-- ----------------------------
DROP TABLE IF EXISTS `t_parse_type`;
CREATE TABLE `t_parse_type` (
  `appid` varchar(30) CHARACTER SET utf8 NOT NULL,
  `name` varchar(20) CHARACTER SET utf8 NOT NULL COMMENT '参数名',
  `colName` varchar(20) CHARACTER SET utf8 DEFAULT NULL COMMENT '列名',
  `length` int(11) DEFAULT NULL COMMENT '长度',
  `terminalAppend` varchar(5) CHARACTER SET utf8 DEFAULT '' COMMENT '设备编码扩展',
  `tableName` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT '表名',
  `rate` decimal(12,6) DEFAULT '1.000000' COMMENT '倍率',
  `javaType` int(1) DEFAULT '0' COMMENT '0:bigdemical,1:string',
  PRIMARY KEY (`appid`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of t_parse_type
-- ----------------------------
INSERT INTO `t_parse_type` VALUES ('1', 'S10006-Rtd', 'ia', null, 'S1', 'online_data_electric', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('1', 'S20006-Rtd', 'ia', null, 'S2', 'online_data_electric', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('1', 'S30001-Rtd', 'flue_temp', null, 'S3', 'online_data_lampblack', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('1', 'S30002-Rtd', 'flue_humidity', null, 'S3', 'online_data_lampblack', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('1', 'S30003-Rtd', 'smoke_density', null, 'S3', 'online_data_lampblack', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('1', 'S30004-Rtd', 'voc_density', null, 'S3', 'online_data_lampblack', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('1', 'S30005-Rtd', 'pm25', null, 'S3', 'online_data_lampblack', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('1', 'S30020-Rtd', 'longitude', null, 'S3', 'online_data_lampblack', '1.000000', '1');
INSERT INTO `t_parse_type` VALUES ('1', 'S30021-Rtd', 'latitude', null, 'S3', 'online_data_lampblack', '1.000000', '1');
INSERT INTO `t_parse_type` VALUES ('1', 'S30022-Rtd', 'smoke_total', null, 'S3', 'online_data_lampblack', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('1', 'S30023-Rtd', 'voc_total', null, 'S3', 'online_data_lampblack', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('1', 'S30024-Rtd', 'pm25_total', null, 'S3', 'online_data_lampblack', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('2', 'R01-Rtd', 'ia', null, 'S1', 'online_data_electric', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('2', 'R02-Rtd', 'ia', null, 'S2', 'online_data_electric', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('2', 'R03-Rtd', 'ia', null, 'S1', 'online_data_electric', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('2', 'R04-Rtd', 'ia', null, 'S2', 'online_data_electric', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('2', 'S101-Rtd', 'smoke_density', null, 'S3', 'online_data_lampblack', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('2', 'S102-Rtd', 'flue_temp', null, 'S3', 'online_data_lampblack', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('2', 'S103-Rtd', 'flue_humidity', null, 'S3', 'online_data_lampblack', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('2', 'S104-Rtd', 'pm25', null, 'S3', 'online_data_lampblack', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('2', 'S105-Rtd', 'voc_density', null, 'S3', 'online_data_lampblack', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('2', 'S201-Rtd', 'smoke_density', null, 'S3', 'online_data_lampblack', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('2', 'S202-Rtd', 'flue_temp', null, 'S3', 'online_data_lampblack', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('2', 'S203-Rtd', 'flue_humidity', null, 'S3', 'online_data_lampblack', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('3', 'a24088-Rtd', 'voc_density', null, 'S3', 'online_data_lampblack', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('3', 'a34001-Rtd', 'pm25', null, 'S3', 'online_data_lampblack', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('3', 'b02Rtd', 'smoke_density', null, 'S3', 'online_data_lampblack', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('3', 'fanCurrent', 'ia', null, 'S2', 'online_data_electric', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('3', 'purifierCurrent', 'ia', null, 'S1', 'online_data_electric', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('4', 'a01001-Rtd', 'flue_temp', null, 'S3', 'online_data_lampblack', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('4', 'a01002-Rtd', 'flue_humidity', null, 'S3', 'online_data_lampblack', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('4', 'a24088-Rtd', 'voc_density', null, 'S3', 'online_data_lampblack', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('4', 'a34001-Rtd', 'pm25', null, 'S3', 'online_data_lampblack', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('4', 'a34099-Rtd', 'smoke_density', null, 'S3', 'online_data_lampblack', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('4', 'g12001-Rtd', 'ia', null, 'S2', 'online_data_electric', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('4', 'g12002-Rtd', 'ia', null, 'S1', 'online_data_electric', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('4', 'g12100-Rtd', 'longitude', null, 'S3', 'online_data_lampblack', '1.000000', '1');
INSERT INTO `t_parse_type` VALUES ('4', 'g12101-Rtd', 'latitude', null, 'S3', 'online_data_lampblack', '1.000000', '1');
INSERT INTO `t_parse_type` VALUES ('5', 'a24088-Rtd', 'voc_density', null, 'S3', 'online_data_lampblack', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('5', 'a34001-Rtd', 'pm25', null, 'S3', 'online_data_lampblack', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('5', 'b02-Rtd', 'smoke_density', null, 'S3', 'online_data_lampblack', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('5', 'fanCurrent-Rtd', 'ia', null, 'S2', 'online_data_electric', '1.000000', '0');
INSERT INTO `t_parse_type` VALUES ('5', 'purifierCurrent-Rtd', 'ia', null, 'S1', 'online_data_electric', '1.000000', '0');