Server/fbs_code/db_script/cems_server_config.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 120.25.176.175-mysql
 Source Server Type    : MySQL
 Source Server Version : 80028
 Source Host           : 120.25.176.175:3306
 Source Schema         : cems_server_config

 Target Server Type    : MySQL
 Target Server Version : 80028
 File Encoding         : 65001

 Date: 25/04/2023 10:38:46
*/

SET NAMES utf8mb4;
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 COLLATE utf8_general_ci NOT NULL,
  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '参数名',
  `colName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '列名',
  `length` int NULL DEFAULT NULL COMMENT '长度',
  `terminalAppend` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '设备编码扩展',
  `tableName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '表名',
  `rate` decimal(12, 6) NULL DEFAULT 1.000000 COMMENT '倍率',
  `javaType` int NULL DEFAULT 0 COMMENT '0:bigdemical,1:string',
  PRIMARY KEY (`appid`, `name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- 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);

SET FOREIGN_KEY_CHECKS = 1;