/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 80031
Source Host           : 127.0.0.1:3306
Source Database       : zhihuihangbiao

Target Server Type    : MYSQL
Target Server Version : 80031
File Encoding         : 65001

Date: 2022-12-16 09:38:22
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for ztms_observe_zhihuihangbiao_data
-- ----------------------------
DROP TABLE IF EXISTS `ztms_observe_zhihuihangbiao_data`;
CREATE TABLE `ztms_observe_zhihuihangbiao_data` (
  `id` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL 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 '水温/温度',
  `ctemperature` float(8,2) DEFAULT NULL,
  `conductivity` float(8,2) DEFAULT NULL COMMENT '电导率',
  `cconductivity` float(8,2) DEFAULT NULL,
  `ph` float(8,2) DEFAULT NULL COMMENT '酸碱度',
  `cph` float(8,2) DEFAULT NULL,
  `oxygen` float(8,2) DEFAULT NULL COMMENT '溶解氧',
  `coxygen` float(8,0) DEFAULT NULL,
  `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 '亮度',
  `rechargeablebattery` float(8,2) DEFAULT NULL COMMENT '可充电电池容量',
  `drybattery` float(8,2) DEFAULT NULL COMMENT '干电池容量',
  `latitude` int DEFAULT NULL COMMENT '纬度',
  `longitude` int DEFAULT NULL COMMENT '经度',
  `Ax` float(8,2) DEFAULT NULL COMMENT 'X轴加速度',
  `Ay` float(8,2) DEFAULT NULL COMMENT 'Y轴加速度',
  `Az` float(8,2) DEFAULT NULL COMMENT 'Z轴加速度',
  `Wx` float(8,2) DEFAULT NULL COMMENT 'X轴角速度',
  `Wy` float(8,2) DEFAULT NULL COMMENT 'Y轴角速度',
  `Wz` float(8,2) DEFAULT NULL COMMENT 'Z轴角速度',
  `roll` float(8,2) DEFAULT NULL COMMENT '横滚角，绕Z',
  `pitch` float(8,2) DEFAULT NULL COMMENT '俯仰角，绕X',
  `yaw` float(8,2) DEFAULT NULL COMMENT '偏航角,绕Y',
  `pressure` float(8,2) DEFAULT NULL COMMENT '压力',
  `totalcapacity` int DEFAULT NULL COMMENT 'TF总容量',
  `remainingcapacity` int DEFAULT NULL COMMENT 'TF卡剩余容量',
  `chargingcurrent` float(8,2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;