create table NEO2013_GRP5_CLASS_COURSE
(CLASS_COURSE_ID varchar(50) primary key,
START_TIME timestamp not null,
END_TIME timestamp not null,
TEACHER varchar(50) not null,
TEACHER_EMAIL varchar(50),
CLASS_ID varchar(50) not null,
COURSE_ID varchar(50) not null,
constraint class_course_class_fk foreign key(CLASS_ID) references NEO2013_GRP5_CLASS(CLASS_ID),
constraint class_course_course_fk foreign key(COURSE_ID) references NEO2013_GRP5_COURSE(COURSE_ID)
)