216 lines
12 KiB
SQL
216 lines
12 KiB
SQL
/*
|
|
Navicat Premium Data Transfer
|
|
|
|
Source Server : 开发环境
|
|
Source Server Type : MySQL
|
|
Source Server Version : 80029
|
|
Source Host : 192.168.10.211:3306
|
|
Source Schema : dev_cloud
|
|
|
|
Target Server Type : MySQL
|
|
Target Server Version : 80029
|
|
File Encoding : 65001
|
|
|
|
Date: 06/06/2022 15:23:17
|
|
*/
|
|
|
|
SET NAMES utf8mb4;
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for dev_bind_relation
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `dev_bind_relation`;
|
|
CREATE TABLE `dev_bind_relation` (
|
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
|
`dev_id` bigint NULL DEFAULT NULL COMMENT '设备id',
|
|
`tenant_id` bigint NULL DEFAULT NULL COMMENT '租户id',
|
|
`server_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '服务编码',
|
|
`application_id` bigint NULL DEFAULT NULL COMMENT '应用id',
|
|
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '设备-应用-关联表' ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for dev_info
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `dev_info`;
|
|
CREATE TABLE `dev_info` (
|
|
`id` bigint NOT NULL COMMENT 'id',
|
|
`access_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '设备接入id',
|
|
`sn` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '设备sn',
|
|
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '设备名称',
|
|
`template_id` bigint NULL DEFAULT NULL COMMENT '设备模板id',
|
|
`tenant_id` bigint NULL DEFAULT NULL COMMENT '所属租户',
|
|
`longitude` double(50, 6) NULL DEFAULT NULL COMMENT '设备位置经度',
|
|
`latitude` double(50, 6) NULL DEFAULT NULL COMMENT '设备位置纬度',
|
|
`remark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
|
|
`online` tinyint(1) NULL DEFAULT NULL COMMENT '设备在线状态(0-离线,1-在线)',
|
|
`firmware_ver` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '固件版本',
|
|
`auth_conf` json NULL COMMENT '认证配置',
|
|
`work_info` json NULL COMMENT '工况信息',
|
|
`creator_id` bigint NULL DEFAULT NULL COMMENT '创建人id',
|
|
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '设备信息表' ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for dev_log
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `dev_log`;
|
|
CREATE TABLE `dev_log` (
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`dev_id` bigint NULL DEFAULT NULL COMMENT '设备id',
|
|
`log_type` int NULL DEFAULT NULL COMMENT '日志类型',
|
|
`log_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '日志内容',
|
|
`month` int NULL DEFAULT NULL COMMENT '年月',
|
|
`log_time` datetime NULL DEFAULT NULL COMMENT '日志时间',
|
|
`create_time` datetime NULL DEFAULT NULL COMMENT '入库时间',
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '设备日志' ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for dev_product
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `dev_product`;
|
|
CREATE TABLE `dev_product` (
|
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
|
|
`product_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品名称',
|
|
`product_code` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品型号',
|
|
`product_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品类型',
|
|
`industry` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属行业',
|
|
`remark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品说明',
|
|
`pic_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品图片',
|
|
`status` tinyint(1) NULL DEFAULT NULL COMMENT '状态(0-未发布,1-已发布)',
|
|
`creator_id` bigint NULL DEFAULT NULL COMMENT '创建人id',
|
|
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '产品信息表' ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for dev_protocol
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `dev_protocol`;
|
|
CREATE TABLE `dev_protocol` (
|
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
|
|
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '协议名称',
|
|
`type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '协议类型',
|
|
`version` float NULL DEFAULT NULL COMMENT '最新版本号',
|
|
`remark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '协议说明',
|
|
`creator_id` bigint NULL DEFAULT NULL COMMENT '创建人id',
|
|
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '协议信息表' ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for dev_protocol_version
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `dev_protocol_version`;
|
|
CREATE TABLE `dev_protocol_version` (
|
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
|
|
`protecol_id` bigint NOT NULL COMMENT '协议id',
|
|
`version` float(10, 2) NULL DEFAULT NULL COMMENT '版本号',
|
|
`status` tinyint(1) NULL DEFAULT NULL COMMENT '协议状态(0-未发布,1-已发布)',
|
|
`remark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '协议说明',
|
|
`file_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '协议文件路径',
|
|
`content` json NULL COMMENT '协议内容',
|
|
`creator_id` bigint NULL DEFAULT NULL COMMENT '创建人id',
|
|
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '协议历史版本表' ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for dev_sys_dict
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `dev_sys_dict`;
|
|
CREATE TABLE `dev_sys_dict` (
|
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
|
`type_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '类型标识符',
|
|
`type_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '类型名称',
|
|
`order_no` int NULL DEFAULT 0 COMMENT '排序号',
|
|
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '数据字典类型表' ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for dev_sys_dict_item
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `dev_sys_dict_item`;
|
|
CREATE TABLE `dev_sys_dict_item` (
|
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
|
`type_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '类型标识符',
|
|
`value_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '字典值标识符',
|
|
`value_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '字典值显示名称',
|
|
`order_no` int NULL DEFAULT 0 COMMENT '排序号',
|
|
`remark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
|
|
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '数据字典值表' ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for dev_template
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `dev_template`;
|
|
CREATE TABLE `dev_template` (
|
|
`id` bigint NOT NULL COMMENT 'id',
|
|
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '模板名称',
|
|
`remark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '模板说明',
|
|
`product_id` bigint NULL DEFAULT NULL COMMENT '所属产品',
|
|
`protocol_version_id` bigint NULL DEFAULT NULL COMMENT '协议版本id',
|
|
`status` tinyint(1) NULL DEFAULT NULL COMMENT '状态(0-未发布,1-已发布)',
|
|
`publish_time` datetime NULL DEFAULT NULL COMMENT '发布时间',
|
|
`creator_id` bigint NULL DEFAULT NULL COMMENT '创建人id',
|
|
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '设备模板表' ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for dev_template_factor_conf_release
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `dev_template_factor_conf_release`;
|
|
CREATE TABLE `dev_template_factor_conf_release` (
|
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
|
|
`template_id` bigint NULL DEFAULT NULL COMMENT '设备模板id',
|
|
`identifier` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '要素标识符',
|
|
`name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '要素名称',
|
|
`unit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '计量单位',
|
|
`data_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '数据类型',
|
|
`accuracy` int NULL DEFAULT NULL COMMENT '精度',
|
|
`range_start` double NULL DEFAULT NULL COMMENT '量程开始',
|
|
`range_end` double NULL DEFAULT NULL COMMENT '量程结束',
|
|
`publish_time` datetime NULL DEFAULT NULL COMMENT '发布时间',
|
|
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '设备模板监测要素配置-发布版' ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for dev_template_factor_conf_snap
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `dev_template_factor_conf_snap`;
|
|
CREATE TABLE `dev_template_factor_conf_snap` (
|
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
|
|
`template_id` bigint NULL DEFAULT NULL COMMENT '设备模板id',
|
|
`identifier` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '要素标识符',
|
|
`name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '要素名称',
|
|
`unit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '计量单位',
|
|
`data_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '数据类型',
|
|
`accuracy` int NULL DEFAULT NULL COMMENT '精度',
|
|
`range_start` double NULL DEFAULT NULL COMMENT '量程开始',
|
|
`range_end` double NULL DEFAULT NULL COMMENT '量程结束',
|
|
`used` tinyint(1) NULL DEFAULT 0 COMMENT '是否配置(0-否,1-是)',
|
|
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '设备模板监测要素配置-快照版' ROW_FORMAT = Dynamic;
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|