CREATE TABLE Student (

id INT PRIMARY KEY AUTO_INCREMENT,

name VARCHAR(50) NOT NULL,

major VARCHAR(50),

grade INT

);

CREATE TABLE Honor (

id INT PRIMARY KEY AUTO_INCREMENT,

honor_name VARCHAR(100) NOT NULL,

description TEXT,

level ENUM('National', 'University', 'Department') NOT NULL

);

CREATE TABLE Student_Honor (

student_id INT,

honor_id INT,

obtained_date DATE,

PRIMARY KEY (student_id, honor_id),

FOREIGN KEY (student_id) REFERENCES Student(id),

FOREIGN KEY (honor_id) REFERENCES Honor(id)

);

]]>

实训实习管理系统

CREATE INDEX idx_student_major ON Student(major);

CREATE INDEX idx_honor_level ON Honor(level);

]]>