-- 创建教师表
CREATE TABLE teacher_table (
teacher_id INT PRIMARY KEY,
student_id INT,
FOREIGN KEY (student_id) REFERENCES student_table(student_id)
);
-- 创建学生表
CREATE TABLE student_table (
student_id INT PRIMARY KEY,
student_name VARCHAR(50),
course_score INT
);