/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50527
Source Host           : localhost:3306
Source Database       : onlinelearningrevisiting

Target Server Type    : MYSQL
Target Server Version : 50527
File Encoding         : 65001

Date: 2020-11-27 13:28:02
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `classinformation`
-- ----------------------------
DROP TABLE IF EXISTS `classinformation`;
CREATE TABLE `classinformation` (
  `ClassId` varchar(255) NOT NULL DEFAULT '',
  `AdminClass` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ClassId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of classinformation
-- ----------------------------

-- ----------------------------
-- Table structure for `classlearninginformation`
-- ----------------------------
DROP TABLE IF EXISTS `classlearninginformation`;
CREATE TABLE `classlearninginformation` (
  `ClassId` varchar(255) NOT NULL DEFAULT '',
  `AdminClass` varchar(255) DEFAULT NULL,
  `CourseId` varchar(255) DEFAULT NULL,
  `CourseName` varchar(255) DEFAULT NULL,
  `UsualScore` double DEFAULT NULL,
  `UsualScoreAvg` double DEFAULT NULL,
  `FinalScore` double DEFAULT NULL,
  `FinalScoreAvg` double DEFAULT NULL,
  `TotalScore` double DEFAULT NULL,
  `TotalScoreAvg` double DEFAULT NULL,
  PRIMARY KEY (`ClassId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of classlearninginformation
-- ----------------------------

-- ----------------------------
-- Table structure for `courseinformation`
-- ----------------------------
DROP TABLE IF EXISTS `courseinformation`;
CREATE TABLE `courseinformation` (
  `CourseId` varchar(255) NOT NULL DEFAULT '',
  `CourseName` varchar(255) DEFAULT NULL,
  `CouseHours` int(11) DEFAULT NULL,
  `CourseCredit` double DEFAULT NULL,
  PRIMARY KEY (`CourseId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of courseinformation
-- ----------------------------

-- ----------------------------
-- Table structure for `coursescore`
-- ----------------------------
DROP TABLE IF EXISTS `coursescore`;
CREATE TABLE `coursescore` (
  `StudentId` varchar(255) NOT NULL DEFAULT '',
  `StudentName` varchar(255) DEFAULT NULL,
  `CourseTitle` varchar(255) DEFAULT NULL,
  `UsualScore` double DEFAULT NULL,
  `FinalScore` double DEFAULT NULL,
  `TotalScore` double DEFAULT NULL,
  PRIMARY KEY (`StudentId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of coursescore
-- ----------------------------

-- ----------------------------
-- Table structure for `personlearinginformation`
-- ----------------------------
DROP TABLE IF EXISTS `personlearinginformation`;
CREATE TABLE `personlearinginformation` (
  `Id` varchar(255) NOT NULL DEFAULT '',
  `Name` varchar(255) DEFAULT NULL,
  `Sex` varchar(255) DEFAULT NULL,
  `AdminClass` varchar(255) DEFAULT NULL,
  `CourseName` varchar(255) DEFAULT NULL,
  `UsualScore` double DEFAULT NULL,
  `FinalScore` double DEFAULT NULL,
  `TotalScore` double DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of personlearinginformation
-- ----------------------------

-- ----------------------------
-- Table structure for `studentmanagement`
-- ----------------------------
DROP TABLE IF EXISTS `studentmanagement`;
CREATE TABLE `studentmanagement` (
  `StudentId` varchar(255) NOT NULL,
  `StudentName` varchar(255) DEFAULT NULL,
  `Sex` varchar(255) DEFAULT NULL,
  `Academy` varchar(255) DEFAULT NULL,
  `Classroom` varchar(255) DEFAULT NULL,
  `Telephone` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`StudentId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of studentmanagement
-- ----------------------------