schoolDB代码

/*
Navicat Premium Data Transfer

Source Server : mySQL
Source Server Type : MySQL
Source Server Version : 50731
Source Host : localhost:3306
Source Schema : schooldb

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

Date: 11/03/2026 12:13:20
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

— —————————-
— Table structure for class1
— —————————-
DROP TABLE IF EXISTS `class1`;
CREATE TABLE `class1` (
`class` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`student` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`course` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`score` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
PRIMARY KEY (`class`) USING BTREE,
INDEX `class`(`class`, `student`, `course`, `score`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

— —————————-
— Records of class1
— —————————-

— —————————-
— Table structure for course
— —————————-
DROP TABLE IF EXISTS `course`;
CREATE TABLE `course` (
`courseNo` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`courseName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`point` int(11) NOT NULL,
`hour` int(11) NOT NULL,
`term` char(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`lead` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`courseNo`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

— —————————-
— Records of course
— —————————-

— —————————-
— Table structure for score
— —————————-
DROP TABLE IF EXISTS `score`;
CREATE TABLE `score` (
`scoreID` int(11) NOT NULL,
`studentNo` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`courseNo` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`result` float NULL DEFAULT NULL,
`class` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`scoreID`) USING BTREE,
INDEX `studentNo`(`studentNo`) USING BTREE,
INDEX `courseNo`(`courseNo`) USING BTREE,
INDEX `class`(`class`) USING BTREE,
CONSTRAINT `score_ibfk_1` FOREIGN KEY (`studentNo`) REFERENCES `student` (`student`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `score_ibfk_2` FOREIGN KEY (`courseNo`) REFERENCES `course` (`courseNo`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `score_ibfk_3` FOREIGN KEY (`class`) REFERENCES `class1` (`class`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

— —————————-
— Records of score
— —————————-

— —————————-
— Table structure for student
— —————————-
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
`student` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
INDEX `student`(`student`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

— —————————-
— Records of student
— —————————-

SET FOREIGN_KEY_CHECKS = 1;