请帮我生成一个学生、课程、教师和学生课程的三个数据库表的sql语句

学生表：

CREATE TABLE student ( id INT PRIMARY KEY, name VARCHAR(50), age INT, gender VARCHAR(10), address VARCHAR(100), phone VARCHAR(20) );

课程表：

CREATE TABLE course ( id INT PRIMARY KEY, name VARCHAR(50), teacher_id INT, credit INT, time VARCHAR(50), location VARCHAR(100) );

教师表：

CREATE TABLE teacher ( id INT PRIMARY KEY, name VARCHAR(50), age INT, gender VARCHAR(10), address VARCHAR(100), phone VARCHAR(20) );

学生课程表：

CREATE TABLE student_course ( student_id INT, course_id INT, score INT, PRIMARY KEY (student_id, course_id), FOREIGN KEY (student_id) REFERENCES student(id), FOREIGN KEY (course_id) REFERENCES course(id) )