tables.ddl

来自「java的一系列产品中包括jsme,jmse,j2ee,本文件提供j2ee实现的」· DDL 代码 · 共 43 行

drop table studentcmptable;
drop table lockercmptable;
drop table bookcmptable;
drop table teachercmptable;
drop table StudentTeacherJoin;

create table studentcmptable (

  ssn integer primary key,
  name varchar(255),
  grade integer,
  lockerkey integer
);

create table lockercmptable (

  number integer primary key
);

create table bookcmptable (

  isbn varchar(255),
  copyNumber integer,
  title varchar(255),
  author varchar(255),
  studentkey integer,
  primary key (isbn, copyNumber)
);

create table teachercmptable (

  ssn integer primary key,
  name varchar(255)
);

create table StudentTeacherJoin (

  teacher_ssn integer,
  student_ssn integer
);