/*
|
Navicat MySQL Data Transfer
|
|
Source Server : lcoal
|
Source Server Version : 80033
|
Source Host : localhost:3306
|
Source Database : qianduan_sql
|
|
Target Server Type : MYSQL
|
Target Server Version : 80033
|
File Encoding : 65001
|
|
Date: 2023-07-11 11:42:40
|
*/
|
|
SET FOREIGN_KEY_CHECKS=0;
|
|
-- ----------------------------
|
-- Table structure for exceeding_st_data
|
-- ----------------------------
|
DROP TABLE IF EXISTS `exceeding_st_data`;
|
CREATE TABLE `exceeding_st_data` (
|
`MV_ID` int NOT NULL AUTO_INCREMENT,
|
`MV_Stat_Code` varchar(50) DEFAULT NULL COMMENT '设备编号',
|
`MV_Create_Time` datetime DEFAULT NULL COMMENT '上报时间',
|
`MV_Data_Time` datetime DEFAULT NULL COMMENT '归属时间',
|
`MV_Power_On_Time` datetime DEFAULT NULL COMMENT '开机时间',
|
`MV_Recent_Down_Time` datetime DEFAULT NULL COMMENT '最近关机时间',
|
`MV_signal` double(6,0) DEFAULT NULL,
|
`MV_Fan_Status` bit(1) DEFAULT NULL COMMENT '风机开关状态',
|
`MV_Purifier_Status` bit(1) DEFAULT NULL COMMENT '净化器开关状态',
|
`MV_Fan_Electricity` double(8,2) DEFAULT NULL COMMENT '风机电流',
|
`MV_Purifier_Electricity` double(8,2) DEFAULT NULL COMMENT '净化器电流',
|
`MV_Fume_Concentration` double(8,2) DEFAULT NULL COMMENT '进油烟浓度值',
|
`MV_Fume_Concentration2` double(8,2) DEFAULT NULL COMMENT '排油烟浓度值（后）',
|
`MV_PM` double(8,2) DEFAULT NULL COMMENT '颗粒物（气溶胶）',
|
`MV_NMHC` double(8,2) DEFAULT NULL COMMENT '非甲烷总烃',
|
`MV_Upload` bit(1) DEFAULT NULL COMMENT '是否上传',
|
PRIMARY KEY (`MV_ID`),
|
KEY `MV_Stat_Code` (`MV_Stat_Code`)
|
) ENGINE=InnoDB AUTO_INCREMENT=1052 DEFAULT CHARSET=utf8mb3;
|
