/* 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:29 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for ed_data -- ---------------------------- DROP TABLE IF EXISTS `ed_data`; CREATE TABLE `ed_data` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '序号', `provider` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '供应商', `shop_name` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '餐饮店', `equipment_number` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '设备编号', `equipment_name` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '设备名称', `smoke_push_density` double(8,0) DEFAULT NULL COMMENT '禁烟浓度,单位mg/m^3', `smoke_pop_density` double(8,2) DEFAULT NULL COMMENT '排烟浓度,单位mg/m^3', `wind_turbine` double(8,2) DEFAULT NULL COMMENT '风机电,单位A', `purifier` double(8,2) DEFAULT NULL COMMENT '净化器,单位A', `level` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '级别', `alarm_required` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '需报警', `alarm_triggered` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '已报警', `attribution_time` datetime DEFAULT NULL COMMENT '归属时间,每10分钟一段', `reporting_time` datetime DEFAULT NULL COMMENT '上报时间', `data_time` datetime DEFAULT NULL COMMENT '数据时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=36751 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;