无标题1.sql

学生信息管理系统

create table exam
(
	course_id varchar(10)not null,
	student_id varchar(10)not null,
	teacher_id varchar(10)not null,
	term char(1) not null check (term in('1','2','3','4','5','6','7','8')),
	examtype char(6) check (examtype in('考试课','考察课')),
	examtime varchar(10) ,
	address varchar(20),
	primary key(student_id,course_id,term),
	foreign key (course_id,term)references course(course_id,term)
)