/*
|
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:41:53
|
*/
|
|
SET FOREIGN_KEY_CHECKS=0;
|
|
-- ----------------------------
|
-- Table structure for abnormal_data
|
-- ----------------------------
|
DROP TABLE IF EXISTS `abnormal_data`;
|
CREATE TABLE `abnormal_data` (
|
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '序号',
|
`dev_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '设备编号',
|
`exception` varchar(20) NOT NULL,
|
`exception_type` varchar(20) NOT NULL COMMENT '异常类型',
|
`region` varchar(20) DEFAULT NULL COMMENT '地区',
|
`begin_time` datetime NOT NULL COMMENT '开始时间',
|
`end_time` datetime NOT NULL COMMENT '结束',
|
PRIMARY KEY (`id`)
|
) ENGINE=InnoDB AUTO_INCREMENT=625 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
