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.
172 lines
9.4 KiB
172 lines
9.4 KiB
/*
|
|
Navicat Premium Data Transfer
|
|
|
|
Source Server : localhost_connect
|
|
Source Server Type : MySQL
|
|
Source Server Version : 80017
|
|
Source Host : localhost:3306
|
|
Source Schema : css
|
|
|
|
Target Server Type : MySQL
|
|
Target Server Version : 80017
|
|
File Encoding : 65001
|
|
|
|
Date: 20/05/2024 21:57:22
|
|
*/
|
|
|
|
SET NAMES utf8mb4;
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for tb_course
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `tb_course`;
|
|
CREATE TABLE `tb_course` (
|
|
`courseID` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '课程号',
|
|
`courseName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '匿名' COMMENT '课程名',
|
|
`courseNum` tinyint(4) NOT NULL COMMENT '课序号',
|
|
`courseCredit` float NOT NULL DEFAULT 0 COMMENT '学分',
|
|
`courseDesc` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '课程介绍',
|
|
PRIMARY KEY (`courseID`, `courseNum`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of tb_course
|
|
-- ----------------------------
|
|
INSERT INTO `tb_course` VALUES ('A1-101', '程序开发基础', 1, 4, 'A1-101, Program development foundation.');
|
|
INSERT INTO `tb_course` VALUES ('A1-101', '程序开发基础', 2, 4, 'A1-101, Program development foundation.');
|
|
INSERT INTO `tb_course` VALUES ('A2-201', '数据结构与算法', 1, 4, 'A2-201, Data structure and algorithm.');
|
|
INSERT INTO `tb_course` VALUES ('A2-201', '数据结构与算法', 2, 4, 'A2-201, Data structure and algorithm.');
|
|
INSERT INTO `tb_course` VALUES ('A2-202', '操作系统', 1, 4, 'A2-202, Operating system.');
|
|
INSERT INTO `tb_course` VALUES ('A2-202', '操作系统', 2, 4, 'A2-202, Operating system.');
|
|
INSERT INTO `tb_course` VALUES ('A2-203', '计算机组成', 1, 3, 'A2-203, Computer composition.');
|
|
INSERT INTO `tb_course` VALUES ('A2-203', '计算机组成', 2, 3, 'A2-203, Computer composition.');
|
|
INSERT INTO `tb_course` VALUES ('S1-103', '面向对象程序设计', 1, 4, 'S1-103, Object-oriented programming.');
|
|
INSERT INTO `tb_course` VALUES ('S1-103', '面向对象程序设计', 2, 4, 'S1-103, Object-oriented programming.');
|
|
INSERT INTO `tb_course` VALUES ('S2-301', '数据库', 1, 4, 'S2-301, database.');
|
|
INSERT INTO `tb_course` VALUES ('S2-301', '数据库', 2, 4, 'S2-301, database.');
|
|
INSERT INTO `tb_course` VALUES ('S2-302', '计算机网络', 1, 4, 'S2-302, computer network.');
|
|
INSERT INTO `tb_course` VALUES ('S2-302', '计算机网络', 2, 4, 'S2-302, computer network.');
|
|
INSERT INTO `tb_course` VALUES ('S2-303', '软件工程导论', 1, 3, 'S2-303, ntroduction to Software Engineering.');
|
|
INSERT INTO `tb_course` VALUES ('S2-303', '软件工程导论', 2, 3, 'S2-303, ntroduction to Software Engineering.');
|
|
|
|
-- ----------------------------
|
|
-- Table structure for tb_manager
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `tb_manager`;
|
|
CREATE TABLE `tb_manager` (
|
|
`managerID` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '工号',
|
|
`managerName` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '匿名' COMMENT '姓名',
|
|
`managerPswd` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '123456' COMMENT '密码',
|
|
PRIMARY KEY (`managerID`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of tb_manager
|
|
-- ----------------------------
|
|
INSERT INTO `tb_manager` VALUES ('admin', 'admin', '123456');
|
|
|
|
-- ----------------------------
|
|
-- Table structure for tb_student
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `tb_student`;
|
|
CREATE TABLE `tb_student` (
|
|
`studentID` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '学号',
|
|
`studentName` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '匿名' COMMENT '姓名',
|
|
`studentSex` char(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '男' COMMENT '性别',
|
|
`studentAge` tinyint(4) NOT NULL DEFAULT 18 COMMENT '年龄',
|
|
`studentPswd` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '123456' COMMENT '密码',
|
|
PRIMARY KEY (`studentID`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of tb_student
|
|
-- ----------------------------
|
|
INSERT INTO `tb_student` VALUES ('202101', '王铭', '男', 20, '123456');
|
|
INSERT INTO `tb_student` VALUES ('202201', '李明', '男', 20, '123456');
|
|
INSERT INTO `tb_student` VALUES ('202202', '刘成刚', '男', 19, '123456');
|
|
INSERT INTO `tb_student` VALUES ('202301', '李铭', '男', 18, '123456');
|
|
INSERT INTO `tb_student` VALUES ('202302', '刘晓鸣', '男', 19, '123456');
|
|
INSERT INTO `tb_student` VALUES ('202303', '张鹰', '女', 19, '123456');
|
|
INSERT INTO `tb_student` VALUES ('202304', '刘竟静', '女', 18, '123456');
|
|
INSERT INTO `tb_student` VALUES ('202305', '宣明尼', '女', 18, '123456');
|
|
INSERT INTO `tb_student` VALUES ('202306', '柳红利', '女', 19, '123456');
|
|
INSERT INTO `tb_student` VALUES ('202307', '匿名', '男', 18, '123456');
|
|
|
|
-- ----------------------------
|
|
-- Table structure for tb_student_course
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `tb_student_course`;
|
|
CREATE TABLE `tb_student_course` (
|
|
`studentID` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '学号',
|
|
`courseID` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '课程号',
|
|
`courseNum` tinyint(4) NOT NULL COMMENT '课序号',
|
|
`grade` smallint(6) NULL DEFAULT -1 COMMENT '成绩',
|
|
PRIMARY KEY (`studentID`, `courseID`, `courseNum`) USING BTREE,
|
|
INDEX `courseID`(`courseID`, `courseNum`) USING BTREE,
|
|
CONSTRAINT `tb_student_course_ibfk_1` FOREIGN KEY (`studentID`) REFERENCES `tb_student` (`studentID`) ON DELETE RESTRICT ON UPDATE RESTRICT,
|
|
CONSTRAINT `tb_student_course_ibfk_2` FOREIGN KEY (`courseID`, `courseNum`) REFERENCES `tb_course` (`courseID`, `courseNum`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of tb_student_course
|
|
-- ----------------------------
|
|
INSERT INTO `tb_student_course` VALUES ('202201', 'S2-301', 1, 92);
|
|
INSERT INTO `tb_student_course` VALUES ('202201', 'S2-302', 1, -1);
|
|
INSERT INTO `tb_student_course` VALUES ('202201', 'S2-303', 1, 90);
|
|
INSERT INTO `tb_student_course` VALUES ('202202', 'S2-301', 2, -1);
|
|
INSERT INTO `tb_student_course` VALUES ('202202', 'S2-302', 1, -1);
|
|
INSERT INTO `tb_student_course` VALUES ('202202', 'S2-303', 2, 85);
|
|
INSERT INTO `tb_student_course` VALUES ('202301', 'S1-103', 1, -1);
|
|
|
|
-- ----------------------------
|
|
-- Table structure for tb_teacher
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `tb_teacher`;
|
|
CREATE TABLE `tb_teacher` (
|
|
`teacherID` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '工号',
|
|
`teacherName` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '匿名' COMMENT '姓名',
|
|
`teacherSex` char(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '男' COMMENT '性别',
|
|
`teacherPswd` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '123456' COMMENT '密码',
|
|
PRIMARY KEY (`teacherID`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of tb_teacher
|
|
-- ----------------------------
|
|
INSERT INTO `tb_teacher` VALUES ('200008', '黄武', '男', '123456');
|
|
INSERT INTO `tb_teacher` VALUES ('200015', '陈蓉', '女', '200015');
|
|
INSERT INTO `tb_teacher` VALUES ('200305', '熊运余', '男', '200305');
|
|
INSERT INTO `tb_teacher` VALUES ('200407', '何军', '男', '200407');
|
|
INSERT INTO `tb_teacher` VALUES ('200710', '李晓华', '女', '200710');
|
|
INSERT INTO `tb_teacher` VALUES ('200901', '林兰', '女', '200901');
|
|
|
|
-- ----------------------------
|
|
-- Table structure for tb_teacher_course
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `tb_teacher_course`;
|
|
CREATE TABLE `tb_teacher_course` (
|
|
`teacherID` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '工号',
|
|
`courseID` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '课程号',
|
|
`courseNum` tinyint(4) NOT NULL COMMENT '课序号',
|
|
PRIMARY KEY (`courseID`, `courseNum`) USING BTREE,
|
|
INDEX `teacherID`(`teacherID`) USING BTREE,
|
|
CONSTRAINT `tb_teacher_course_ibfk_1` FOREIGN KEY (`teacherID`) REFERENCES `tb_teacher` (`teacherID`) ON DELETE RESTRICT ON UPDATE RESTRICT,
|
|
CONSTRAINT `tb_teacher_course_ibfk_2` FOREIGN KEY (`courseID`, `courseNum`) REFERENCES `tb_course` (`courseID`, `courseNum`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of tb_teacher_course
|
|
-- ----------------------------
|
|
INSERT INTO `tb_teacher_course` VALUES ('200015', 'S2-301', 1);
|
|
INSERT INTO `tb_teacher_course` VALUES ('200015', 'S2-303', 2);
|
|
INSERT INTO `tb_teacher_course` VALUES ('200305', 'S2-302', 2);
|
|
INSERT INTO `tb_teacher_course` VALUES ('200407', 'S1-103', 1);
|
|
INSERT INTO `tb_teacher_course` VALUES ('200407', 'S2-301', 2);
|
|
INSERT INTO `tb_teacher_course` VALUES ('200710', 'S1-103', 2);
|
|
INSERT INTO `tb_teacher_course` VALUES ('200710', 'S2-303', 1);
|
|
INSERT INTO `tb_teacher_course` VALUES ('200901', 'S2-302', 1);
|
|
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|