You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
244 lines
8.4 KiB
244 lines
8.4 KiB
-- MySQL dump 10.13 Distrib 8.0.12, for Win64 (x86_64)
|
|
--
|
|
-- Host: localhost Database: data
|
|
-- ------------------------------------------------------
|
|
-- Server version 8.0.12
|
|
|
|
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
|
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
|
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
|
SET NAMES utf8 ;
|
|
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
|
/*!40103 SET TIME_ZONE='+00:00' */;
|
|
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
|
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
|
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
|
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
|
|
|
--
|
|
-- Table structure for table `course_info`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `course_info`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
SET character_set_client = utf8mb4 ;
|
|
CREATE TABLE `course_info` (
|
|
`course_id` varchar(45) NOT NULL,
|
|
`course_name` varchar(45) NOT NULL,
|
|
`course_teacher` varchar(45) NOT NULL,
|
|
`course_credit` varchar(45) NOT NULL,
|
|
`course_time` varchar(45) NOT NULL,
|
|
`is_eva` varchar(45) NOT NULL,
|
|
PRIMARY KEY (`course_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `course_info`
|
|
--
|
|
|
|
LOCK TABLES `course_info` WRITE;
|
|
/*!40000 ALTER TABLE `course_info` DISABLE KEYS */;
|
|
INSERT INTO `course_info` VALUES ('c01','数据结构','liu','4','42','未评教'),('c02','python','李四','2','30','未评教');
|
|
/*!40000 ALTER TABLE `course_info` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `eva_info`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `eva_info`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
SET character_set_client = utf8mb4 ;
|
|
CREATE TABLE `eva_info` (
|
|
`eva_course` varchar(45) NOT NULL,
|
|
`eva_teacher` varchar(45) NOT NULL,
|
|
`eva_student` varchar(45) NOT NULL,
|
|
`index_one` int(11) NOT NULL,
|
|
`index_two` int(11) NOT NULL,
|
|
`index_three` int(11) NOT NULL,
|
|
`index_four` int(11) NOT NULL,
|
|
`opinion` varchar(45) DEFAULT NULL,
|
|
PRIMARY KEY (`eva_course`,`eva_student`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `eva_info`
|
|
--
|
|
|
|
LOCK TABLES `eva_info` WRITE;
|
|
/*!40000 ALTER TABLE `eva_info` DISABLE KEYS */;
|
|
INSERT INTO `eva_info` VALUES ('python','李四','小妹',15,25,25,20,'好'),('python','李四','林涛',25,20,25,25,'优秀的老师'),('数据结构','liu','林涛',20,20,25,25,'优秀');
|
|
/*!40000 ALTER TABLE `eva_info` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `registrations`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `registrations`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
SET character_set_client = utf8mb4 ;
|
|
CREATE TABLE `registrations` (
|
|
`id` int(11) NOT NULL,
|
|
`course_id` varchar(45) NOT NULL,
|
|
`stu_id` varchar(45) NOT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `course_id_idx` (`course_id`),
|
|
KEY `stu_id_idx` (`stu_id`),
|
|
CONSTRAINT `course_id` FOREIGN KEY (`course_id`) REFERENCES `course_info` (`course_id`),
|
|
CONSTRAINT `stu_id` FOREIGN KEY (`stu_id`) REFERENCES `stu_info` (`stu_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `registrations`
|
|
--
|
|
|
|
LOCK TABLES `registrations` WRITE;
|
|
/*!40000 ALTER TABLE `registrations` DISABLE KEYS */;
|
|
INSERT INTO `registrations` VALUES (1,'c01','s01'),(2,'c02','s01'),(3,'c01','s02'),(4,'c02','s02');
|
|
/*!40000 ALTER TABLE `registrations` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `stu_info`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `stu_info`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
SET character_set_client = utf8mb4 ;
|
|
CREATE TABLE `stu_info` (
|
|
`stu_id` varchar(45) NOT NULL,
|
|
`name` varchar(45) NOT NULL,
|
|
`grade` varchar(45) NOT NULL,
|
|
`department` varchar(45) DEFAULT NULL,
|
|
`gender` varchar(45) NOT NULL,
|
|
`en_year` varchar(45) NOT NULL,
|
|
`birthday` varchar(45) NOT NULL,
|
|
`email` varchar(45) NOT NULL,
|
|
`number` varchar(45) NOT NULL,
|
|
`pol_status` varchar(45) NOT NULL,
|
|
`edu_background` varchar(45) NOT NULL,
|
|
`address` varchar(45) NOT NULL,
|
|
PRIMARY KEY (`stu_id`),
|
|
CONSTRAINT `stu_info_ibfk_1` FOREIGN KEY (`stu_id`) REFERENCES `user` (`stu_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `stu_info`
|
|
--
|
|
|
|
LOCK TABLES `stu_info` WRITE;
|
|
/*!40000 ALTER TABLE `stu_info` DISABLE KEYS */;
|
|
INSERT INTO `stu_info` VALUES ('s01','林涛','研一','计算机学院','男','2018','1996-12-19','201814131052@cqu.edu.cn','18279184056','中共党员','硕士','江西省'),('s02','小妹','大四','通信学院','女','2015','1996-03-24','2315465305@qq.com','13546547898','中共党员','准硕士','江西省');
|
|
/*!40000 ALTER TABLE `stu_info` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `tea_course`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `tea_course`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
SET character_set_client = utf8mb4 ;
|
|
CREATE TABLE `tea_course` (
|
|
`id` int(11) NOT NULL,
|
|
`tea_id` varchar(45) NOT NULL,
|
|
`course_id` varchar(45) NOT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `courseid_idx` (`course_id`),
|
|
KEY `tea_id_idx` (`tea_id`),
|
|
CONSTRAINT `courseid` FOREIGN KEY (`course_id`) REFERENCES `course_info` (`course_id`),
|
|
CONSTRAINT `tea_id` FOREIGN KEY (`tea_id`) REFERENCES `tea_info` (`tea_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `tea_course`
|
|
--
|
|
|
|
LOCK TABLES `tea_course` WRITE;
|
|
/*!40000 ALTER TABLE `tea_course` DISABLE KEYS */;
|
|
INSERT INTO `tea_course` VALUES (1,'t01','c02');
|
|
/*!40000 ALTER TABLE `tea_course` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `tea_info`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `tea_info`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
SET character_set_client = utf8mb4 ;
|
|
CREATE TABLE `tea_info` (
|
|
`tea_id` varchar(45) NOT NULL,
|
|
`name` varchar(45) NOT NULL,
|
|
`tec_title` varchar(45) NOT NULL,
|
|
`department` varchar(45) DEFAULT NULL,
|
|
`gender` varchar(45) NOT NULL,
|
|
`en_year` varchar(45) NOT NULL,
|
|
`birthday` varchar(45) NOT NULL,
|
|
`email` varchar(45) NOT NULL,
|
|
`number` varchar(45) NOT NULL,
|
|
`pol_status` varchar(45) NOT NULL,
|
|
`edu_background` varchar(45) NOT NULL,
|
|
`address` varchar(45) NOT NULL,
|
|
PRIMARY KEY (`tea_id`),
|
|
CONSTRAINT `id` FOREIGN KEY (`tea_id`) REFERENCES `user` (`tea_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `tea_info`
|
|
--
|
|
|
|
LOCK TABLES `tea_info` WRITE;
|
|
/*!40000 ALTER TABLE `tea_info` DISABLE KEYS */;
|
|
INSERT INTO `tea_info` VALUES ('t01','李四','讲师','计算机学院','男','2018','1996-09-10','2315465305@qq.com','17679119796','中共党员','博士','江西省上饶市');
|
|
/*!40000 ALTER TABLE `tea_info` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `user`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `user`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
SET character_set_client = utf8mb4 ;
|
|
CREATE TABLE `user` (
|
|
`id` int(11) NOT NULL,
|
|
`username` varchar(45) NOT NULL,
|
|
`password` varchar(45) NOT NULL,
|
|
`status` varchar(4) NOT NULL,
|
|
`stu_id` varchar(45) DEFAULT NULL,
|
|
`tea_id` varchar(45) DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `stu_id_UNIQUE` (`stu_id`),
|
|
UNIQUE KEY `tea_id_UNIQUE` (`tea_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `user`
|
|
--
|
|
|
|
LOCK TABLES `user` WRITE;
|
|
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
|
|
INSERT INTO `user` VALUES (1,'林涛','123456','0','s01',NULL),(2,'李四','123456','1',NULL,'t01'),(3,'小妹','123456','0','s02',NULL);
|
|
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
|
|
|
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
|
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
|
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
|
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
|
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
|
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
|
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
|
|
|
-- Dump completed on 2019-04-22 17:38:23
|