SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for b_data
-- ----------------------------
DROP TABLE IF EXISTS `b_data`;
CREATE TABLE `b_data`  (
  `ID` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `version` int(11) NULL DEFAULT 1,
  `deleted` tinyint(4) NULL DEFAULT 0,
  `create_time` datetime NULL DEFAULT NULL,
  `fun_no` enum('F01','F02','F03','F04') CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '功能码',
  `value` varchar(5000) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '值'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '原始数据' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for b_machine
-- ----------------------------
DROP TABLE IF EXISTS `b_machine`;
CREATE TABLE `b_machine`  (
  `machine_pk` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `code` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `memo` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '备注',
  `slave` int(4) NULL DEFAULT NULL COMMENT '服务id',
  `ip` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT 'IP地址',
  `port` int(5) NULL DEFAULT NULL COMMENT '端口',
  `version` int(11) NULL DEFAULT 1,
  `deleted` tinyint(4) NULL DEFAULT 0,
  `create_time` datetime NULL DEFAULT NULL,
  `coils_offset` int(11) NULL DEFAULT NULL COMMENT '线圈开始',
  `coils_quantity` int(11) NULL DEFAULT NULL COMMENT '线圈长度',
  `dis_offset` int(11) NULL DEFAULT NULL COMMENT '输入状态开始',
  `dis_quantity` int(11) NULL DEFAULT NULL COMMENT '输入状态长度',
  `hold_offset` int(11) NULL DEFAULT NULL COMMENT '寄存器开始',
  `hold_quantity` int(11) NULL DEFAULT NULL COMMENT '寄存器长度',
  `reg_offset` int(11) NULL DEFAULT NULL COMMENT '输入寄存器开始',
  `reg_quantity` int(11) NULL DEFAULT NULL COMMENT '输入寄存器长度',
  PRIMARY KEY (`machine_pk`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '机器信息' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for b_plc
-- ----------------------------
DROP TABLE IF EXISTS `b_plc`;
CREATE TABLE `b_plc`  (
  `point_pk` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `offset` int(11) NULL DEFAULT NULL COMMENT '位置信息',
  `local` int(11) NULL DEFAULT NULL COMMENT 'bit在字节中位置',
  `type` enum('BIT','INT','FLOAT') CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '数据类型',
  `byte_len` int(11) NULL DEFAULT NULL COMMENT 'bit位长度',
  `cat_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '列表名称',
  `create_time` datetime NULL DEFAULT NULL,
  `version` int(11) NULL DEFAULT 1,
  `deleted` tinyint(4) NULL DEFAULT 0,
  `fun_no` enum('F01','F02','F03','F04') CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '功能码',
  `cate_pk` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `range_up` int(32) NULL DEFAULT NULL COMMENT '正常值上限',
  `range_down` int(32) NULL DEFAULT NULL COMMENT '正常值下限',
  `feed_back` int(255) NULL DEFAULT NULL COMMENT '记录故障标识',
  `type_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`point_pk`) USING BTREE,
  INDEX `FK_Reference_3`(`cate_pk`) USING BTREE,
  CONSTRAINT `FK_Reference_3` FOREIGN KEY (`cate_pk`) REFERENCES `b_plc_category` (`cate_pk`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '点位信息' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for b_plc_data
-- ----------------------------
DROP TABLE IF EXISTS `b_plc_data`;
CREATE TABLE `b_plc_data`  (
  `point_data_pk` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `offset` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '位置信息',
  `local` int(11) NULL DEFAULT NULL COMMENT 'bit在字节中的位置',
  `type` enum('BIT','INT','FLOAT') CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '数据类型',
  `byte_len` int(11) NULL DEFAULT NULL COMMENT 'bit位长度',
  `cat_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '列表名称',
  `create_time` datetime NULL DEFAULT NULL,
  `version` int(11) NULL DEFAULT 1,
  `deleted` tinyint(4) NULL DEFAULT 0,
  `value` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `point_pk` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cate_pk` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `is_error` varchar(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '0' COMMENT '0 不是错误 1错误',
  PRIMARY KEY (`point_data_pk`) USING BTREE,
  INDEX `FK_Reference_1`(`point_pk`) USING BTREE,
  INDEX `FK_Reference_2`(`cate_pk`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '采集数据' ROW_FORMAT = Compact;

SET FOREIGN_KEY_CHECKS = 1;