DevOpsWaterOS-水务物联网设备运维管理系统通讯篇之Mysql,通讯协议配置-4

protocoldataframe：通讯协议DTAT域的结构

/*
 Navicat Premium Data Transfer

 Source Server         : root
 Source Server Type    : MySQL
 Source Server Version : 80400 (8.4.0)
 Source Host           : localhost:3306
 Source Schema         : devopsos

 Target Server Type    : MySQL
 Target Server Version : 80400 (8.4.0)
 File Encoding         : 65001

 Date: 12/06/2024 13:03:44
 Name：马铃薯
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for protocoldataframe
-- ----------------------------
DROP TABLE IF EXISTS `protocoldataframe`;
CREATE TABLE `protocoldataframe`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '自动编号',
  `PG_id` int NULL DEFAULT NULL COMMENT '协议组ID',
  `PF_id` int NULL DEFAULT NULL COMMENT '帧协议ID',
  `PFF_id` int NULL DEFAULT NULL COMMENT '帧协议DATA域ID',
  `FrameName` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL COMMENT '帧名称',
  `FrameCode` varchar(20) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL COMMENT '帧代码',
  `FrameLength` int NULL DEFAULT NULL COMMENT '长度',
  `FrameSorting` int NULL DEFAULT NULL COMMENT '顺序',
  `CRCflag` bit(1) NULL DEFAULT NULL COMMENT '产于校验标记',
  `Frameflag` bit(1) NULL DEFAULT NULL COMMENT '标记',
  `IsLocked` int NOT NULL COMMENT '锁定',
  `Status` int NOT NULL COMMENT '状态',
  `IsDeleted` int NOT NULL COMMENT '删除',
  `CreatedOn` datetime(6) NOT NULL COMMENT '创建时间',
  `CreatedByUserGuid` char(36) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT '创建者Guid',
  `CreatedByUserName` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '创建者',
  `ModifiedOn` datetime(6) NULL DEFAULT NULL COMMENT '修改时间',
  `ModifiedByUserGuid` char(36) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL COMMENT '修改者Guid',
  `ModifiedByUserName` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '修改者',
  `Description` varchar(800) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '描述',
  `IsSeed` int NULL DEFAULT 0 COMMENT '种子',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1593 CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci COMMENT = '协议数据域帧格式顺序' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of protocoldataframe
-- ----------------------------
INSERT INTO `protocoldataframe` VALUES (1560, 691, 3, 3708, '数据标识DI1DI2', '901F', 4, 1, b'1', b'0', 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocoldataframe` VALUES (1561, 691, 3, 3708, '序列号', '00', 2, 2, b'1', b'0', 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocoldataframe` VALUES (1562, 691, 3, 3717, '数据标识DI1DI2', '901F', 4, 1, b'1', b'0', 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocoldataframe` VALUES (1563, 691, 3, 3717, '序列号', '00', 2, 2, b'1', b'0', 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocoldataframe` VALUES (1564, 691, 3, 3717, '当前累计流量', '10001000', 8, 3, b'1', b'1', 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocoldataframe` VALUES (1565, 691, 3, 3717, '吨', '2C', 2, 4, b'1', b'0', 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocoldataframe` VALUES (1566, 691, 3, 3717, '日累计流量', '10001000', 8, 5, b'1', b'1', 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocoldataframe` VALUES (1567, 691, 3, 3717, '吨', '2C', 2, 6, b'1', b'0', 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocoldataframe` VALUES (1568, 691, 3, 3717, '实时时间', '00000000000000', 14, 7, b'1', b'1', 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocoldataframe` VALUES (1569, 691, 3, 3717, '状态1', '00', 2, 8, b'1', b'1', 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocoldataframe` VALUES (1570, 691, 3, 3717, '状态2', 'FF', 2, 9, b'1', b'0', 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocoldataframe` VALUES (1571, 691, 3, 3726, '数据标识DI1DI2', 'A016', 4, 1, b'1', b'0', 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocoldataframe` VALUES (1572, 691, 3, 3726, '序列号', '00', 2, 2, b'1', b'0', 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocoldataframe` VALUES (1573, 691, 3, 3726, '单位代码', '00', 2, 3, b'1', b'0', 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocoldataframe` VALUES (1574, 691, 3, 3726, '设置累计流量', '00000000', 8, 4, b'1', b'1', 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocoldataframe` VALUES (1575, 691, 3, 3735, '数据标识DI1DI2', 'A016', 2, 1, b'1', b'0', 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocoldataframe` VALUES (1576, 691, 3, 3735, '序列号', '00', 1, 2, b'1', b'0', 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocoldataframe` VALUES (1577, 691, 3, 3735, '状态1', '00', 2, 3, b'1', b'1', 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocoldataframe` VALUES (1578, 691, 3, 3735, '状态2', 'FF', 2, 4, b'1', b'0', 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocoldataframe` VALUES (1579, 691, 3, 3744, '数据标识DI1DI2', '810A', 4, 1, b'1', b'0', 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocoldataframe` VALUES (1580, 691, 3, 3744, '序列号', '00', 2, 2, b'1', b'0', 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocoldataframe` VALUES (1581, 691, 3, 3753, '数据标识DI1DI2', '810A', 2, 1, b'1', b'0', 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocoldataframe` VALUES (1582, 691, 3, 3753, '序列号', '00', 2, 2, b'1', b'0', 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocoldataframe` VALUES (1583, 691, 3, 3762, '数据标识DI1DI2', 'A018', 4, 1, b'1', b'0', 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocoldataframe` VALUES (1584, 691, 3, 3762, '序列号', '00', 2, 2, b'1', b'0', 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocoldataframe` VALUES (1585, 691, 3, 3762, '新地址', '12000000000000', 14, 2, b'1', b'1', 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocoldataframe` VALUES (1586, 691, 3, 3771, '数据标识DI1DI2', 'A018', 2, 1, b'1', b'0', 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocoldataframe` VALUES (1587, 691, 3, 3771, '序列号', '00', 2, 2, b'1', b'0', 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocoldataframe` VALUES (1588, 691, 3, 3780, '数据标识DI1DI2', 'A017', 4, 1, b'1', b'0', 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocoldataframe` VALUES (1589, 691, 3, 3780, '序列号', '00', 2, 2, b'1', b'0', 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocoldataframe` VALUES (1590, 691, 3, 3780, '开', '55', 2, 2, b'1', b'0', 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocoldataframe` VALUES (1591, 691, 3, 3789, '数据标识DI1DI2', 'A017', 2, 1, b'1', b'0', 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocoldataframe` VALUES (1592, 691, 3, 3789, '序列号', '00', 2, 2, b'1', b'0', 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);

SET FOREIGN_KEY_CHECKS = 1;

结果：