--
-- This SQL script generated on Sat Apr 02 2005 at 12:30:05.182
--

----------------------------------------------------------------------
-- Entity: Book
-- A book - It is always related to one author and one publisher.
----------------------------------------------------------------------

drop table book;

create table book (
    book_id integer not null,
    title varchar(80),
    isbn varchar(80),
    author_id integer not null,
    publisher_id integer not null,
    constraint pk_book primary key (book_id)
);

grant all on book to public;

alter table book
  add constraint book_author_id
  foreign key (author_id)
  references author (author_id);

alter table book
  add constraint book_publisher_id
  foreign key (publisher_id)
  references publisher (publisher_id);