/*
|
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:45:21
|
*/
|
|
SET FOREIGN_KEY_CHECKS=0;
|
|
-- ----------------------------
|
-- Table structure for analysis_data
|
-- ----------------------------
|
DROP TABLE IF EXISTS `analysis_data`;
|
CREATE TABLE `analysis_data` (
|
`fume_dev_id` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '设备编号',
|
`fume_date` date DEFAULT NULL,
|
`fume_day_min` double(8,2) DEFAULT NULL COMMENT '排烟浓度，单位mg/m^3',
|
`fume_day_max` double(8,2) DEFAULT NULL COMMENT '排烟浓度，单位mg/m^3',
|
`fume_day_average` double(23,2) DEFAULT NULL,
|
`purifier_open_rate` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
|
`fume_minute_exceeding_num` decimal(23,0) DEFAULT NULL,
|
`fume_over_standard_rate` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
|
`fume_data_efficiency` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
|
`daily_online_rate` varchar(29) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
|
`noon_online_rate` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
|
`night_online_rate` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
|
`key_online_rate` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
|
`noon__valid_rate` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
|
`night__valid_rate` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
|
`key_valid_rate` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
|
`noon_opening_count` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
|
`night_opening_count` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
|
`key_opening_rate` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
|
`noon_exceeding_num` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
|
`night_exceeding_num` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
|
`key_exceeding_rate` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
