80 lines
4.2 KiB
MySQL
80 lines
4.2 KiB
MySQL
|
/*
|
||
|
|
Navicat MySQL Data Transfer
|
||
|
|
|
||
|
|
Source Server : localhost
|
||
|
|
Source Server Version : 80031
|
||
|
|
Source Host : localhost:3306
|
||
|
|
Source Database : wangxiang
|
||
|
|
|
||
|
|
Target Server Type : MYSQL
|
||
|
|
Target Server Version : 80031
|
||
|
|
File Encoding : 65001
|
||
|
|
|
||
|
|
Date: 2022-11-17 11:15:31
|
||
|
|
*/
|
||
|
|
|
||
|
|
SET FOREIGN_KEY_CHECKS=0;
|
||
|
|
|
||
|
|
-- ----------------------------
|
||
|
|
-- Table structure for ztms_observe_wangxiang_data
|
||
|
|
-- ----------------------------
|
||
|
|
DROP TABLE IF EXISTS `ztms_observe_wangxiang_data`;
|
||
|
|
CREATE TABLE `ztms_observe_wangxiang_data` (
|
||
|
|
`idd` int NOT NULL AUTO_INCREMENT,
|
||
|
|
`id` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '' COMMENT 'id',
|
||
|
|
`project_id` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '' COMMENT '所属站点id',
|
||
|
|
`node_id` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '' COMMENT '所属节点id',
|
||
|
|
`terminal_equipment_type` int DEFAULT NULL COMMENT '终端设备类型',
|
||
|
|
`terminal_equipment_id` int DEFAULT NULL COMMENT '终端设备id',
|
||
|
|
`version_number` int DEFAULT NULL COMMENT '版本号',
|
||
|
|
`device_id` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '' COMMENT '所属设备id/消息id',
|
||
|
|
`device_idd` varchar(255) DEFAULT NULL,
|
||
|
|
`record_time` datetime(6) DEFAULT NULL COMMENT '记录时间',
|
||
|
|
`device_name` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '设备名称',
|
||
|
|
`device_number` int DEFAULT NULL COMMENT '设备编号',
|
||
|
|
`device_status` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '设备状态',
|
||
|
|
`cycle_time` int DEFAULT NULL COMMENT '心跳周期',
|
||
|
|
`sync_time` bigint DEFAULT NULL COMMENT '服务器时间',
|
||
|
|
`temperature` float(8,2) DEFAULT NULL COMMENT '水温/温度',
|
||
|
|
`conductivity` float(8,2) DEFAULT NULL COMMENT '电导率',
|
||
|
|
`ph` float(8,2) DEFAULT NULL COMMENT '酸碱度',
|
||
|
|
`oxygen` float(8,2) DEFAULT NULL COMMENT '溶解氧',
|
||
|
|
`turbidity` float(8,2) DEFAULT NULL COMMENT '浊度',
|
||
|
|
`salinity` float(8,2) DEFAULT NULL COMMENT '盐度',
|
||
|
|
`chlorophyll` float(8,2) DEFAULT NULL COMMENT '叶绿素',
|
||
|
|
`blue_green_algae` float(8,2) DEFAULT NULL COMMENT '蓝绿藻',
|
||
|
|
`water_depth` float(8,2) DEFAULT NULL COMMENT '水深',
|
||
|
|
`oil` float(8,2) DEFAULT NULL COMMENT '水中油',
|
||
|
|
`cod` float(8,2) DEFAULT NULL COMMENT '化学需氧量',
|
||
|
|
`orp` float(8,2) DEFAULT NULL COMMENT '氧化还原电位',
|
||
|
|
`ammonia_nitrogen` float(8,2) DEFAULT NULL COMMENT '氨氮',
|
||
|
|
`nitrate_nitrogen` float(8,2) DEFAULT NULL COMMENT '硝态氮',
|
||
|
|
`nitrous_nitrogen` float(8,2) DEFAULT NULL COMMENT '亚硝氮',
|
||
|
|
`phosphate` float(8,2) DEFAULT NULL COMMENT '磷酸盐',
|
||
|
|
`total_nitrogen` float(8,2) DEFAULT NULL COMMENT '总氮',
|
||
|
|
`total_phosphorus` float(8,2) DEFAULT NULL COMMENT '总磷',
|
||
|
|
`phenol` float(8,2) DEFAULT NULL COMMENT '挥发酚',
|
||
|
|
`carbon` float(8,2) DEFAULT NULL COMMENT '二氧化碳',
|
||
|
|
`methane` float(8,2) DEFAULT NULL COMMENT '甲烷',
|
||
|
|
`flow_speed` float(8,2) DEFAULT NULL COMMENT '总磷',
|
||
|
|
`flow_decretion` float(8,2) DEFAULT NULL COMMENT '流向',
|
||
|
|
`water_level` float(8,2) DEFAULT NULL COMMENT '水位',
|
||
|
|
`video` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '视频路径',
|
||
|
|
`voltage` float(8,2) DEFAULT NULL COMMENT '电压',
|
||
|
|
`electricity` float(8,2) DEFAULT NULL COMMENT '电流',
|
||
|
|
`device_temperature` float(8,2) DEFAULT NULL COMMENT '设备温度',
|
||
|
|
`HZ` float(8,2) DEFAULT NULL COMMENT '频率',
|
||
|
|
`model` varchar(16) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '设备型号',
|
||
|
|
`gps` varchar(16) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '经纬度',
|
||
|
|
`power` float(8,2) DEFAULT NULL COMMENT '功率',
|
||
|
|
`energy` float(8,2) DEFAULT NULL COMMENT '电能',
|
||
|
|
`humidity` float(8,2) DEFAULT NULL COMMENT '湿度',
|
||
|
|
`chroma` int DEFAULT NULL COMMENT '色度',
|
||
|
|
`contrast` int DEFAULT NULL COMMENT '对比度',
|
||
|
|
`luminance` int DEFAULT NULL COMMENT '亮度',
|
||
|
|
`voltage48` float(8,2) DEFAULT NULL COMMENT '48V电压',
|
||
|
|
`voltage24` float(8,2) DEFAULT NULL COMMENT '24V电压',
|
||
|
|
`voltage12` float(8,2) DEFAULT NULL COMMENT '12V电压',
|
||
|
|
PRIMARY KEY (`idd`)
|
||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=3668 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
|