表结构:
CREATE TABLE `students` (
`sid` bigint(20) NOT NULL,
`sname` char(10) CHARACTER SET utf8mb4 DEFAULT NULL,
`email` char(20) CHARACTER SET utf8mb4 DEFAULT NULL,
`grade` char(10) CHARACTER SET utf8mb4 DEFAULT NULL,
PRIMARY KEY (`sid`)
);
CREATE TABLE `teachers` (
`tid` bigint(20) NOT NULL,
`tname` char(10) CHARACTER SET utf8mb4 DEFAULT NULL,
`email` char(20) CHARACTER SET utf8mb4 DEFAULT NULL,
`salary` smallint(6) DEFAULT NULL,
PRIMARY KEY (`tid`)
);
CREATE TABLE `courses` (
`cid` bigint(20) NOT NULL,
`cname` char(10) CHARACTER SET utf8mb4 DEFAULT NULL,
`hour` char(10) CHARACTER SET utf8mb4 DEFAULT NULL,
PRIMARY KEY (`cid`)
);
CREATE TABLE `choices` (