comicbook

Tables (8)

Author (Untitled4)

  • AuthorId (Key) — serial — Primary key — NOT NULL
  • Name (Field) — varchar(20)

AuthorComic (Untitled3)

  • AuthorId (Key) — serial — Foreign key → Author.AuthorId — NOT NULL
  • bookId (Key2) — serial — Foreign key → ComicBook.bookId — NOT NULL
  • Role (Field) — varchar(10)

CafeComic (Untitled7)

  • ComicCafeId (Key) — int — Foreign key → ComicCafe.ComicCafeId — NOT NULL
  • bookId (Key2) — int — Foreign key → ComicBook.bookId — NOT NULL

ComicBook (Untitled2)

  • bookId (Key) — serial — Primary key — NOT NULL
  • title (Field) — varchar(30)
  • pubId (Key2) — int — Foreign key → publisher.pubId — NOT NULL
  • status (Field2) — varchar(5)
  • volum (Field3) — int

ComicCafe (Untitled)

  • ComicCafeId (Key) — serial — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • address (Field2) — char(50)
  • callnumber (Field3) — varchar(35)
  • description (Field4) — varchar(400)

Genre (Untitled6)

  • GenreId (Key) — serial — Primary key — NOT NULL
  • GenreName (Field) — varchar(10)

bookgenre (Untitled8)

  • bookId (Key) — int — Foreign key → ComicBook.bookId — NOT NULL
  • GenreId (Key2) — int — Foreign key → Genre.GenreId — NOT NULL

publisher (Untitled5)

  • pubId (Key) — serial — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • callnumber (Field2) — varchar(30)
  • address (Field3) — varchar(50)