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)