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