test2_oracle.sql

来自「hibernate的经典练习」· SQL 代码 · 共 17 行

drop table  COURSES cascade constraints;
drop table  STUDENTS;
create table COURSES (
   ID varchar(15) not null,
   NAME varchar(15),
   primary key (ID)
);
create table STUDENTS (
   ID varchar(15) not null,
   STUDENT_NUMBER varchar(15),
   COURSE_ID varchar(15),
   primary key (ID)
);
alter table STUDENTS add constraint FK8B7256E516B4893C foreign key (COURSE_ID) references COURSES (ID);

create index FK8B7256E516B4893C on STUDENTS(COURSE_ID);