MIVA/source/db/miva_db.sql

/*
 Navicat MySQL Data Transfer

 Source Server         : tx2
 Source Server Type    : MySQL
 Source Server Version : 80026
 Source Host           : 192.168.31.225:3306
 Source Schema         : MIVA_DB

 Target Server Type    : MySQL
 Target Server Version : 80026
 File Encoding         : 65001

 Date: 10/11/2022 14:12:44
*/


# Create Database

CREATE DATABASE IF NOT EXISTS MIVA_DB DEFAULT CHARACTER SET = utf8mb4;
Use MIVA_DB;


SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for CarData
-- ----------------------------
DROP TABLE IF EXISTS `CarData`;
CREATE TABLE `CarData`  (
  `Id` int(0) NOT NULL AUTO_INCREMENT,
  `NoLoad` int(0) NOT NULL COMMENT '空载载荷',
  `DynamicLoad` int(0) NOT NULL COMMENT '动态载荷',
  `Grade` int(0) NOT NULL COMMENT '拥挤等级 1-4',
  `Num` int(0) NOT NULL COMMENT '识别数量',
  `dataTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'label',
  `PId` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '列车编号',
  `CarId` int(0) NOT NULL COMMENT '唯一Id',
  `enableFlag` int(0) NOT NULL COMMENT '是否启用',
  `addTime` datetime(0) NULL DEFAULT NULL,
  `updateTime` datetime(0) NULL DEFAULT NULL,
  `carriageCode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '车厢编号',
  PRIMARY KEY (`Id`) USING BTREE,
  UNIQUE INDEX `CarId`(`CarId`) USING BTREE COMMENT '唯一Id'
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for DataSources
-- ----------------------------
DROP TABLE IF EXISTS `DataSources`;
CREATE TABLE `DataSources`  (
  `Id` int(0) NOT NULL AUTO_INCREMENT,
  `CarId` int(0) NOT NULL,
  `Uri` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `RecognitionRange` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `Play` int(0) NOT NULL,
  `Del` int(0) NOT NULL,
  `DataTime` datetime(0) NULL DEFAULT NULL,
  `Num` int(0) NOT NULL,
  `PId` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `dv_Id` int(0) NOT NULL,
  `addTime` datetime(0) NULL DEFAULT NULL,
  `updateTime` datetime(0) NULL DEFAULT NULL,
  `IP` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '摄像头IP',
  `finish` int(0) NULL DEFAULT NULL,
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for DeviceState
-- ----------------------------
DROP TABLE IF EXISTS `DeviceState`;
CREATE TABLE `DeviceState`  (
  `Id` int(0) NOT NULL AUTO_INCREMENT,
  `CpuUsage` int(0) NOT NULL,
  `GpuUsage` int(0) NOT NULL,
  `MemoryUsage` int(0) NOT NULL,
  `CpuTemp` int(0) NOT NULL,
  `GpuTemp` int(0) NOT NULL,
  `FdUsage` int(0) NOT NULL,
  `AUXTemp` int(0) NOT NULL,
  `A0Temp` int(0) NOT NULL,
  `ThermalTemp` int(0) NOT NULL,
  `updateTime` datetime(0) NOT NULL,
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for InferRecord
-- ----------------------------
DROP TABLE IF EXISTS `InferRecord`;
CREATE TABLE `InferRecord`  (
  `Id` int(0) NOT NULL AUTO_INCREMENT,
  `time` datetime(0) NOT NULL,
  `InferTime` int(0) NOT NULL,
  `OutPath` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `batch_size` int(0) NOT NULL,
  `out_size` int(0) NOT NULL,
  `Finish` int(0) NOT NULL,
  `Del` int(0) NOT NULL,
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for MivaConfig
-- ----------------------------
DROP TABLE IF EXISTS `MivaConfig`;
CREATE TABLE `MivaConfig`  (
  `Id` int(0) NOT NULL AUTO_INCREMENT,
  `account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户',
  `pwd` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '密码',
  `privateKey` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '密钥',
  `outType` int(0) NULL DEFAULT NULL COMMENT '输入类型',
  `outPath` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '输出路径',
  `outEnable` int(0) NULL DEFAULT NULL COMMENT '输出使能',
  `ClearType` int(0) NULL DEFAULT NULL COMMENT '清除机制 ',
  `recordMax` int(0) NULL DEFAULT NULL COMMENT '记录的最大阈值',
  `validTime` int(0) NULL DEFAULT NULL COMMENT '保持时间',
  `MemoryThreshold` int(0) NULL DEFAULT NULL,
  `TempThreshold` int(0) NULL DEFAULT NULL,
  `FdThreshold` int(0) NULL DEFAULT NULL,
  `ResetThreshold` int(0) NULL DEFAULT NULL,
  `ResetSwitch` int(0) NULL DEFAULT NULL,
  `TimeoutThreshold` int(0) NULL DEFAULT NULL,
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for PeakValleyConfig
-- ----------------------------
DROP TABLE IF EXISTS `PeakValleyConfig`;
CREATE TABLE `PeakValleyConfig`  (
  `Id` int(0) NOT NULL AUTO_INCREMENT,
  `addTime` datetime(0) NULL DEFAULT NULL,
  `updateTime` datetime(0) NULL DEFAULT NULL,
  `createBy` int(0) NULL DEFAULT NULL,
  `updateBy` int(0) NULL DEFAULT NULL,
  `attr1` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `attr2` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `attr3` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `appId` int(0) NULL DEFAULT NULL,
  `pvcId` int(0) NULL DEFAULT NULL,
  `startTime` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `endTime` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `timeType` int(0) NULL DEFAULT NULL,
  `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for SystemConfig
-- ----------------------------
DROP TABLE IF EXISTS `SystemConfig`;
CREATE TABLE `SystemConfig`  (
  `Id` int(0) NOT NULL AUTO_INCREMENT,
  `addTime` datetime(0) NULL DEFAULT NULL,
  `updateTime` datetime(0) NULL DEFAULT NULL,
  `createBy` int(0) NULL DEFAULT NULL,
  `updateBy` int(0) NULL DEFAULT NULL,
  `attr1` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `attr2` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `attr3` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `appId` int(0) NULL DEFAULT NULL,
  `configId` int(0) NULL DEFAULT NULL,
  `conKey` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `conValue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `active` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for TrainInfo
-- ----------------------------
DROP TABLE IF EXISTS `TrainInfo`;
CREATE TABLE `TrainInfo`  (
  `Id` int(0) NOT NULL AUTO_INCREMENT,
  `carId` int(0) NOT NULL,
  `carCode` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `carName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `enableFlag` int(0) NOT NULL,
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;