CREATE TABLE course (
cno CHAR (4) NOT NULL PRIMARY KEY COMMENT '课程ID',
cname CHAR (40) NOT NULL COMMENT '课程名',
cpno CHAR (4) COMMENT '先行课(参照自身,Cno)',
ccredit SMALLINT COMMENT '学分'
);
CREATE TABLE course (
cno CHAR (4) NOT NULL PRIMARY KEY COMMENT '课程ID',
cname CHAR (40) NOT NULL COMMENT '课程名',
cpno CHAR (4) COMMENT '先行课(参照自身,Cno)',
ccredit SMALLINT COMMENT '学分'
);