/*
Navicat Premium Data Transfer
Source Server : localhost_3306
Source Server Type : MySQL
Source Server Version : 80015
Source Host : localhost:3306
Source Schema : niceschool_easy
Target Server Type : MySQL
Target Server Version : 80015
File Encoding : 65001
Date: 18/04/2022 23:39:36
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for classinfo
-- ----------------------------
DROP TABLE IF EXISTS `classinfo`;
CREATE TABLE `classinfo` (
`classid` int(11) NOT NULL AUTO_INCREMENT,
`classname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`begintime` date NULL DEFAULT NULL,
`endtime` date NULL DEFAULT NULL,
`ccount` int(11) NOT NULL DEFAULT 0,
`gid` int(11) NOT NULL,
`is_del` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`classid`) USING BTREE,
INDEX `gid`(`gid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 122 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of classinfo
-- ----------------------------
INSERT INTO `classinfo` VALUES (116, '2022-01班', NULL, NULL, 2, 36, 0);
INSERT INTO `classinfo` VALUES (117, '2022-02班', NULL, NULL, 0, 36, 0);
INSERT INTO `classinfo` VALUES (118, '2022-03班', NULL, NULL, 0, 39, 0);
INSERT INTO `classinfo` VALUES (119, '2022-04班', NULL, NULL, 0, 36, 0);
INSERT INTO `classinfo` VALUES (120, '2022-05班', NULL, NULL, 0, 41, 0);
INSERT INTO `classinfo` VALUES (121, '2022-06班', NULL, NULL, 0, 41, 0);
-- ----------------------------
-- Table structure for course
-- ----------------------------
DROP TABLE IF EXISTS `course`;
CREATE TABLE `course` (
`cid` int(11) NOT NULL AUTO_INCREMENT,
`cname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`ccredit` decimal(9, 2) NOT NULL,
`cperiod` decimal(9, 2) NOT NULL,
`cstate` int(11) NOT NULL DEFAULT 0,
`cselcount` int(11) NOT NULL DEFAULT 0,
`cmaxcount` int(11) NOT NULL DEFAULT 0,
`studytype` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`ctid` int(11) NOT NULL,
`mid` int(11) NOT NULL,
`is_del` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`cid`) USING BTREE,
INDEX `ctid`(`ctid`) USING BTREE,
INDEX `mid`(`mid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of course
-- ----------------------------
INSERT INTO `course` VALUES (3, '计算机网络', 2.00, 16.00, 0, 0, 30, '必修', 1, 17, 0);
INSERT INTO `course` VALUES (4, '操作系统', 2.00, 18.00, 0, 0, 30, '选修', 1, 16, 0);
INSERT INTO `course` VALUES (5, '大数据', 2.00, 16.00, 0, 0, 30, '选修', 1, 18, 0);
-- ----------------------------
-- Table structure for course_type
-- ----------------------------
DROP TABLE IF EXISTS `course_type`;
CREATE TABLE `course_type` (
`ctid` int(11) NOT NULL AUTO_INCREMENT,
`ctname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
PRIMARY KEY (`ctid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of course_type
-- ----------------------------
INSERT INTO `course_type` VALUES (1, '专业基础课');
INSERT INTO `course_type` VALUES (2, '公共课');
INSERT INTO `course_type` VALUES (3, '任选课');
-- ----------------------------
-- Table structure for department
-- ----------------------------
DROP TABLE IF EXISTS `department`;
CREATE TABLE `department` (
`did` int(11) NOT NULL AUTO_INCREMENT,
`dname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`dcount` int(11) NOT NULL DEFAULT 0,
`is_del` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`did`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of department
-- ----------------------------
INSERT INTO `department` VALUES (10, '计算机系', 2, 0);
-- ----------------------------
-- Table structure for dropout
-- ----------------------------
DROP TABLE IF EXISTS `dropout`;
CREATE TABLE `dropout` (
`drid` int(11) NOT NULL AUTO_INCREMENT,
`drreason` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`sid` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`drid`) USING BTREE,
INDEX `sid`(`sid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of dropout
-- ----------------------------
INSERT INTO `dropout` VALUES (13, '生病回家，第二年再高考去读大学', 20220003);
INSERT INTO `dropout` VALUES (14, '生病回家，第二年高考再入学', 20220004);
-- ----------------------------
-- Table structure for evaluate_list
-- ----------------------------
DROP TABLE IF EXISTS `evaluate_list`;
CREATE TABLE `evaluate_list` (
`elid` int(11) NOT NULL AUTO_INCREMENT,
`elcontent` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
PRIMARY KEY (`elid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of evaluate_list
-- ----------------------------
INSERT INTO `evaluate_list` VALUES (1, '讲师是否能坚持进行随堂测试，及时激励和督促学生的学习');
INSERT INTO `evaluate_list` VALUES (2, '讲师是否能提前五分钟入班并准时上课？');
INSERT INTO `evaluate_list` VALUES (3, '讲师的授课内容是否条理清晰、表达准确、操作熟练、逻辑性强？');
INSERT INTO `evaluate_list` VALUES (4, '课堂气氛是否活跃，你对所学知识是否感兴趣并能积极参与？');
INSERT INTO `evaluate_list` VALUES (5, '在做练习或项目时讲师是否保持在班内巡视，随时监督学生进度并及时发现和解决问题？');
INSERT INTO `evaluate_list` VALUES (6, '讲师是否能在课程结束时及时总结，便于我对知识点的理解和掌握？');
INSERT INTO `evaluate_list` VALUES (7, '讲师是否能对作业或练习中的问题进行集中讲解或单个点评？');
INSERT INTO `evaluate_list` VALUES (8, '讲师是否能够严格要求学生并积极耐心的解答学生疑问？');
INSERT INTO `evaluate_list` VALUES (9, '讲师是否能够诚实讲授知识，从不诱导我为其授课结果虚高打分？');
INSERT INTO `evaluate_list` VALUES (10, '讲师是否能对学生认真负责，责任心强？');
INSERT INTO `evaluate_list` VALUES (11, '最代码网站域名是多少？');
-- ----------------------------
-- Table structure for evaluate_record
-- ----------------------------
DROP TABLE IF EXISTS `evaluate_record`;
CREATE TABLE `evaluate_record` (
`erid` int(11) NOT NULL AUTO_INCREMENT,
`stuid` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`tchid` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`erexam` int(11) NOT NULL,
`is_del` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`erid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of evaluate_record
-- ----------------------------
INSERT INTO `evaluate_record` VALUES (1, '20220001', '2022001', 45, 0);
-- ----------------------------
-- Table structure for grade
-- ----------------------------
DROP TABLE IF EXISTS `grade`;
CREATE TABLE `grade` (
`gid` int(11) NOT NULL AUTO_INCREMENT,
`gname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`gcount` int(5) UNSIGNED ZEROFILL NOT NULL DEFAULT 00000,
`mid` int(11) NOT NULL,
`is_del` int(11) NOT NULL D
- 1
- 2
- 3
前往页