mytables.ddl

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

drop table t_student;
drop table t_family;
drop table t_lession;
drop table t_teacher;
drop table t_StudentTeacherJoin;

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

create table t_family(
  number integer primary key
);

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

create table t_teacher(
  ssn integer primary key,
  name varchar(255)
);

create table t_StudentTeacherJoin(
  teacher_ssn integer,
  student_ssn integer
);