331_imcs/图南新增SQL/device_collection_detail.sql

/*
 Navicat Premium Dump SQL

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50728 (5.7.28-log)
 Source Host           : localhost:3306
 Source Schema         : zuihou_base_yj_0000

 Target Server Type    : MySQL
 Target Server Version : 50728 (5.7.28-log)
 File Encoding         : 65001

 Date: 09/11/2024 13:54:00
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for device_collection_detail
-- ----------------------------
DROP TABLE IF EXISTS `device_collection_detail`;
CREATE TABLE `device_collection_detail`  (
  `id` bigint(24) NOT NULL,
  `device_rate` double NULL DEFAULT NULL COMMENT '设备稼动率',
  `detail_info` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '设备采集明细(只包含前五条)',
  `create_date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '创建日期',
  `device_ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '设备IP',
  `today_earliest_power_on_time` datetime NULL DEFAULT NULL COMMENT '当天最早开机时间',
  `today_power_on_time` int(11) NULL DEFAULT NULL COMMENT '当天开机时间(秒)',
  `today_work_time` int(11) NULL DEFAULT NULL COMMENT '当日工作时长(秒)',
  `device_id` bigint(20) NULL DEFAULT NULL COMMENT '设备ID',
  `device_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '设备名称',
  `today_alarm_time` int(11) NULL DEFAULT NULL COMMENT '当日报警时长(秒)',
  `create_time` datetime NULL DEFAULT NULL,
  `create_user` bigint(20) NULL DEFAULT NULL,
  `update_time` datetime NULL DEFAULT NULL,
  `update_user` bigint(20) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;