XuMin/20221221_WX_upperpc
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Log
20221221_WX_upperpc/wangxiang_V1.4_log/wangxiang.sql

491 lines
22 KiB
MySQL
Raw Permalink Normal View History

网箱项目Log版本
2023-07-26 01:38:50 +00:00
/*
Navicat MySQL Data Transfer
Source Server : localhost
Source Server Version : 80031
Source Host : 127.0.0.1:3306
Source Database : wangxiang
Target Server Type : MYSQL
Target Server Version : 80031
File Encoding : 65001
Date: 2022-12-21 11:53:43
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for buoy_sensor_adcpmodel
-- ----------------------------
DROP TABLE IF EXISTS `buoy_sensor_adcpmodel`;
CREATE TABLE `buoy_sensor_adcpmodel` (
`id` int NOT NULL AUTO_INCREMENT,
`datetime` datetime DEFAULT NULL,
`datetime_Sensor` datetime DEFAULT NULL,
`Adcp_Pre` int DEFAULT NULL,
`Adcp_Ysb` int DEFAULT NULL,
`Adcp_VD` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1754 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for buoy_sensor_attitudemodel
-- ----------------------------
DROP TABLE IF EXISTS `buoy_sensor_attitudemodel`;
CREATE TABLE `buoy_sensor_attitudemodel` (
`id` int NOT NULL AUTO_INCREMENT,
`datetime` datetime DEFAULT NULL,
`attitude_sensor` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for buoy_sensor_othmodel
-- ----------------------------
DROP TABLE IF EXISTS `buoy_sensor_othmodel`;
CREATE TABLE `buoy_sensor_othmodel` (
`id` int NOT NULL AUTO_INCREMENT,
`datetime` datetime DEFAULT NULL,
`datetime_Sensor` datetime DEFAULT NULL,
`CH4_Pre` float(11,2) DEFAULT NULL,
`CH4_Con` float(11,2) DEFAULT NULL,
`CO2_Pre` float(11,2) DEFAULT NULL,
`CO2_Con` float(11,2) DEFAULT NULL,
`METS_Meth` float(11,2) DEFAULT NULL,
`METS_Tem` float(11,2) DEFAULT NULL,
`Air_Tem` float(11,2) DEFAULT NULL,
`Air_Hum` float(11,2) DEFAULT NULL,
`Air_Pre` float(11,2) DEFAULT NULL,
`Wind_Dir` float(11,2) DEFAULT NULL,
`Wind_Speed` float(11,2) DEFAULT NULL,
`Wind_Speed_Max` float(11,2) DEFAULT NULL,
`Fzd` float(11,2) DEFAULT NULL,
`RainFall` float(11,2) DEFAULT NULL,
`Go_sailing_CH4_Dry` float(11,2) DEFAULT NULL,
`Go_sailing_CH4_H2O` float(11,2) DEFAULT NULL,
`Go_sailing_CH4_C2H6` float(11,2) DEFAULT NULL,
`Tem` float(11,2) DEFAULT NULL,
`Hum` float(11,2) DEFAULT NULL,
`Vol_24_in` float(11,2) DEFAULT NULL,
`Cur_24_in` float(11,2) DEFAULT NULL,
`Vol_48_out` float(11,2) DEFAULT NULL,
`Vol_95_out` float(11,2) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=51333 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for conbox_sensor_adcpmodel
-- ----------------------------
DROP TABLE IF EXISTS `conbox_sensor_adcpmodel`;
CREATE TABLE `conbox_sensor_adcpmodel` (
`id` int NOT NULL AUTO_INCREMENT,
`datetime` datetime DEFAULT NULL,
`datetime_Sensor` datetime DEFAULT NULL,
`Adcp_Pre` int DEFAULT NULL,
`Adcp_Ysb` int DEFAULT NULL,
`Adcp_VD` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1399 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for conbox_sensor_othmodel
-- ----------------------------
DROP TABLE IF EXISTS `conbox_sensor_othmodel`;
CREATE TABLE `conbox_sensor_othmodel` (
`id` int NOT NULL AUTO_INCREMENT,
`datetime` datetime DEFAULT NULL,
`datetime_Sensor` datetime DEFAULT NULL,
`CH4_Pre` float(11,2) DEFAULT NULL,
`CH4_Con` float(11,2) DEFAULT NULL,
`CO2_Pre` float(11,2) DEFAULT NULL,
`CO2_Con` float(11,2) DEFAULT NULL,
`METS_Meth` float(11,2) DEFAULT NULL,
`METS_Tem` float(11,2) DEFAULT NULL,
`CTD_Tem` float(11,2) DEFAULT NULL,
`CTD_Con` float(11,2) DEFAULT NULL,
`CTD_Pre` float(11,2) DEFAULT NULL,
`Angle_sensor_x` float(11,2) DEFAULT NULL,
`Angle_sensor_y` float(11,2) DEFAULT NULL,
`Angle_sensor_z` float(11,2) DEFAULT NULL,
`CTD_YLS` float(11,2) DEFAULT NULL,
`CTD_ZD` float(11,2) DEFAULT NULL,
`CTD_Rjy` float(11,2) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10210 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for configs
-- ----------------------------
DROP TABLE IF EXISTS `configs`;
CREATE TABLE `configs` (
`id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`expire` int DEFAULT NULL COMMENT '时间戳',
`note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for enviroment_model
-- ----------------------------
DROP TABLE IF EXISTS `enviroment_model`;
CREATE TABLE `enviroment_model` (
`id` int NOT NULL AUTO_INCREMENT,
`datetime` datetime DEFAULT NULL,
`FB_Tem` float(11,2) DEFAULT NULL,
`FB_Hum` float(11,2) DEFAULT NULL,
`FB_Vol_24_in` float(11,2) DEFAULT NULL,
`FB_Cur_24_in` float(11,2) DEFAULT NULL,
`FB_Vol_48_out` float(11,2) DEFAULT NULL,
`FB_Vol_95_out` float(11,2) DEFAULT NULL,
`QB_Tem1` float(11,2) DEFAULT NULL,
`QB_Tem2` float(11,2) DEFAULT NULL,
`QB_Hum` float(11,2) DEFAULT NULL,
`QB_Leak` float(11,2) DEFAULT NULL,
`JBH_Tem1` float(11,2) DEFAULT NULL,
`JBH_Tem2` float(11,2) DEFAULT NULL,
`JBH_Hum` float(11,2) DEFAULT NULL,
`JBH_Leak` float(11,2) DEFAULT NULL,
`JBH_Vol_24V_out` float(11,2) DEFAULT NULL,
`JBH_Cur_24V_out` float(11,2) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=36299 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for gps
-- ----------------------------
DROP TABLE IF EXISTS `gps`;
CREATE TABLE `gps` (
`id` int NOT NULL AUTO_INCREMENT,
`datetime` datetime DEFAULT NULL,
`datetime_sensor` datetime DEFAULT NULL,
`jd` float(11,2) DEFAULT NULL,
`wd` float(11,2) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=171 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for heart_time_restart_table
-- ----------------------------
DROP TABLE IF EXISTS `heart_time_restart_table`;
CREATE TABLE `heart_time_restart_table` (
`id` int NOT NULL AUTO_INCREMENT,
`message_id` varchar(255) DEFAULT NULL,
`terminal_equipment_type` int DEFAULT NULL,
`terminal_equipment_id` int DEFAULT NULL,
`version_number` int DEFAULT NULL,
`messagebody_serial_number` int DEFAULT NULL,
`cycle_time` int DEFAULT NULL,
`sync_time` bigint DEFAULT NULL,
`result` int DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=618 DEFAULT CHARSET=utf8mb3;
-- ----------------------------
-- Table structure for lattarget_sensor_adcp150model
-- ----------------------------
DROP TABLE IF EXISTS `lattarget_sensor_adcp150model`;
CREATE TABLE `lattarget_sensor_adcp150model` (
`id` int NOT NULL AUTO_INCREMENT,
`datetime` datetime DEFAULT NULL,
`datetime_Sensor` datetime DEFAULT NULL,
`Adcp_Pre` int DEFAULT NULL,
`Adcp_Ysb` int DEFAULT NULL,
`Adcp_VD` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=167 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for lattarget_sensor_adcp300model
-- ----------------------------
DROP TABLE IF EXISTS `lattarget_sensor_adcp300model`;
CREATE TABLE `lattarget_sensor_adcp300model` (
`id` int NOT NULL AUTO_INCREMENT,
`datetime` datetime DEFAULT NULL,
`datetime_Sensor` datetime DEFAULT NULL,
`Adcp_Pre` int DEFAULT NULL,
`Adcp_Ysb` int DEFAULT NULL,
`Adcp_VD` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1281 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for lattarget_sensor_othmodel
-- ----------------------------
DROP TABLE IF EXISTS `lattarget_sensor_othmodel`;
CREATE TABLE `lattarget_sensor_othmodel` (
`id` int NOT NULL AUTO_INCREMENT,
`datetime` datetime DEFAULT NULL,
`datetime_Sensor` datetime DEFAULT NULL,
`CO2_Pre` float(8,2) DEFAULT NULL,
`CO2_Con` float(8,2) DEFAULT NULL,
`METS_Meth` float(8,2) DEFAULT NULL,
`METS_Tem` float(8,2) DEFAULT NULL,
`CTD_Tem` float(8,2) DEFAULT NULL,
`CTD_Con` float(8,2) DEFAULT NULL,
`CTD_Pre` float(8,2) DEFAULT NULL,
`CTD_YLS` float(8,2) DEFAULT NULL,
`CTD_ZD` float(8,2) DEFAULT NULL,
`CTD_Rjy` float(8,2) DEFAULT NULL,
`CTD_Rjy_Vol` float(8,2) DEFAULT NULL,
`Angle_sensor_x` float(8,2) DEFAULT NULL,
`Angle_sensor_y` float(8,2) DEFAULT NULL,
`Angle_sensor_z` float(8,2) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9686 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for many_data_table
-- ----------------------------
DROP TABLE IF EXISTS `many_data_table`;
CREATE TABLE `many_data_table` (
`id` int NOT NULL AUTO_INCREMENT,
`message_id` varchar(225) DEFAULT NULL,
`terminal_equipment_type` int DEFAULT NULL,
`terminal_equipment_id` int DEFAULT NULL,
`version_number` int DEFAULT NULL,
`messagebody_serial_number` int DEFAULT NULL,
`number` int DEFAULT NULL,
`state` int DEFAULT NULL,
`recordtime` datetime DEFAULT NULL,
`coltage` float(8,2) DEFAULT NULL,
`current` float(8,2) DEFAULT NULL,
`power` float(8,2) DEFAULT NULL,
`energy` float(8,2) DEFAULT NULL,
`temperature` float(8,2) DEFAULT NULL,
`ph` float(8,2) DEFAULT NULL,
`conductivity` float(8,2) DEFAULT NULL,
`dissolved_oxygen` float(8,2) DEFAULT NULL,
`turbidity` float(8,2) DEFAULT NULL,
`humidity` float(8,2) DEFAULT NULL,
`result` int DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=874 DEFAULT CHARSET=utf8mb3;
-- ----------------------------
-- Table structure for nantong_wx_sensor_data
-- ----------------------------
DROP TABLE IF EXISTS `nantong_wx_sensor_data`;
CREATE TABLE `nantong_wx_sensor_data` (
`id` bigint NOT NULL AUTO_INCREMENT,
`data_time` datetime NOT NULL COMMENT '时间',
`Tem_Quality` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '水质温度',
`PH` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'PH值',
`Turbidity` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '浊度',
`conductivity` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '电导率',
`Oxygen` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '溶解氧',
`Hum` float(10,2) DEFAULT NULL COMMENT '湿度',
`Tem_equipment` float(10,2) DEFAULT NULL COMMENT '设备温度',
`Voltage` float(10,2) DEFAULT NULL COMMENT '电压',
`Current` float(10,2) DEFAULT NULL COMMENT '电流',
PRIMARY KEY (`id`,`data_time`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for normal_video_table
-- ----------------------------
DROP TABLE IF EXISTS `normal_video_table`;
CREATE TABLE `normal_video_table` (
`id` int NOT NULL AUTO_INCREMENT,
`message_id` varchar(255) DEFAULT NULL,
`terminal_equipment_type` int DEFAULT NULL,
`terminal_equipment_id` int DEFAULT NULL,
`version_number` int DEFAULT NULL,
`messagebody_serial_number` int DEFAULT NULL,
`messagebody_id` varchar(255) DEFAULT NULL,
`number` int DEFAULT NULL,
`instruction` int DEFAULT NULL,
`chroma` tinyint DEFAULT NULL,
`contrast` tinyint DEFAULT NULL,
`luminance` tinyint DEFAULT NULL,
`mode` int DEFAULT NULL,
`worktime` int DEFAULT NULL,
`stoptime` int DEFAULT NULL,
`uploadtime` int DEFAULT NULL,
`result` int DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb3;
-- ----------------------------
-- Table structure for para_limit
-- ----------------------------
DROP TABLE IF EXISTS `para_limit`;
CREATE TABLE `para_limit` (
`id` int NOT NULL,
`Para_Name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`Min` int DEFAULT NULL,
`Max` int DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for serial_number_table
-- ----------------------------
DROP TABLE IF EXISTS `serial_number_table`;
CREATE TABLE `serial_number_table` (
`id` int NOT NULL AUTO_INCREMENT,
`ability` varchar(50) DEFAULT NULL,
`serialnumber` smallint DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb3;
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int NOT NULL AUTO_INCREMENT,
`username` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`userpass` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`grade` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`data_type` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` int NOT NULL AUTO_INCREMENT,
`username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`password` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`token` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for wuxi_user
-- ----------------------------
DROP TABLE IF EXISTS `wuxi_user`;
CREATE TABLE `wuxi_user` (
`id` int NOT NULL AUTO_INCREMENT,
`username` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
`password` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
`role` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for ztms_observe_wangxiang_abnormaldata
-- ----------------------------
DROP TABLE IF EXISTS `ztms_observe_wangxiang_abnormaldata`;
CREATE TABLE `ztms_observe_wangxiang_abnormaldata` (
`id` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'id',
`project_id` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '所属站点id',
`node_id` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL 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 NOT NULL COMMENT '所属设备id',
`record_time` datetime DEFAULT NULL COMMENT '记录时间',
`device_name` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '设备名称',
`device_number` int 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_general_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,
`chroma` int DEFAULT NULL COMMENT '色度',
`contrast` int DEFAULT NULL COMMENT '对比度',
`luminance` int DEFAULT NULL COMMENT '亮度',
PRIMARY KEY (`id`,`project_id`,`node_id`,`device_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- 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 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_general_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=3906 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
Reference in New Issue Copy Permalink