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

马铃薯_

已于 2024-06-12 14:33:41 修改

阅读量584

点赞数 19

分类专栏：水务运维系统 MYSQL 文章标签：运维 mysql android

于 2024-06-12 12:58:25 首次发布

本文链接：https://blog.csdn.net/guanyonggui/article/details/139623637

版权

水务运维系统同时被 2 个专栏收录

15 篇文章 1 订阅

订阅专栏

MYSQL

6 篇文章 0 订阅

订阅专栏

protocolframe：通讯协议结构体，存放各种协议结构体

/*
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 12:56:02
Name:马铃薯
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for protocolframe
-- ----------------------------
DROP TABLE IF EXISTS `protocolframe`;
CREATE TABLE `protocolframe` (
`id` int NOT NULL AUTO_INCREMENT COMMENT '自动编号',
`PG_id` int NULL DEFAULT NULL COMMENT '协议组ID',
`ProtocolEncoding` varchar(20) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL COMMENT '协议编码',
`PtorocolName` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL COMMENT '协议名称',
`FrameEncoding` varchar(20) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL COMMENT '帧编码',
`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 '帧代码',
`FrameSorting` int 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 = 694 CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci COMMENT = '协议帧格式顺序' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of protocolframe
-- ----------------------------
INSERT INTO `protocolframe` VALUES (685, 3, '100001', 'CJ-T188-2004《户用计量仪表数据传输技术条件》', '100001_00', '前导帧', 'FEFEFE', 0, 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocolframe` VALUES (686, 3, '100001', 'CJ-T188-2004《户用计量仪表数据传输技术条件》', '100001_01', '起始帧', '68', 1, 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocolframe` VALUES (687, 3, '100001', 'CJ-T188-2004《户用计量仪表数据传输技术条件》', '100001_02', '仪表类型', 'T', 2, 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocolframe` VALUES (688, 3, '100001', 'CJ-T188-2004《户用计量仪表数据传输技术条件》', '100001_03', '地址域', 'A0-A6', 3, 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocolframe` VALUES (689, 3, '100001', 'CJ-T188-2004《户用计量仪表数据传输技术条件》', '100001_04', '控制码', 'C', 4, 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocolframe` VALUES (690, 3, '100001', 'CJ-T188-2004《户用计量仪表数据传输技术条件》', '100001_05', '数据长度', 'L', 5, 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocolframe` VALUES (691, 3, '100001', 'CJ-T188-2004《户用计量仪表数据传输技术条件》', '100001_06', '数据域', 'DATA', 6, 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocolframe` VALUES (692, 3, '100001', 'CJ-T188-2004《户用计量仪表数据传输技术条件》', '100001_07', '效验码', 'CS', 7, 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);
INSERT INTO `protocolframe` VALUES (693, 3, '100001', 'CJ-T188-2004《户用计量仪表数据传输技术条件》', '100001_08', '结束帧', '16', 8, 0, 0, 0, '2024-06-11 00:00:00.000000', 'a1', '管理员', NULL, NULL, NULL, NULL, 0);

SET FOREIGN_KEY_CHECKS = 1;

内容结果：