mytables.ddl

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

delete from t_student;
delete from t_teacher;
delete from t_book;
delete from t_studentteacherjoin;
delete from t_family;

drop table t_student;
drop table t_family;
drop table t_book;
drop table t_teacher;
drop table t_StudentTeacherJoin;

create table t_student(
  sID integer primary key,
  name varchar(255),
  grade integer,
  familyNO integer
);

create table t_family(
  fID integer primary key,
  address varchar(255)
);

create table t_book(
  publisher varchar(255),//isbn
  bookCode integer, //copyNumber
  title varchar(255),
  author varchar(255),
  studentNo integer,
  primary key (publisher, bookCode)
);

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

create table t_StudentTeacherJoin(
  teacher_ID integer,
  student_ID integer
);