score1.txt

来自「oracle操作基础基础基础基础基础基础基础基础基础基础基础基础」· 文本 代码 · 共 8 行

create table score1(
  sno varchar2(5),
  cno varchar2(4),
  score number(5,2),
  constraint score_fk_sno foreign key(sno) references student(sno) on delete cascade,
  constraint score_fk_cno foreign key(cno) references course(con) on delete cascade,
  constraint score_pk_sno_cno primary key(sno,cno)
)