bestseller

Tables (4)

books (Untitled)

  • ISBN (isbn) — VARCHAR(20) — Primary key — NOT NULL
  • ID (id) — INTEGER — Foreign key → month_book.ID — NOT NULL
  • title — VARCHAR(256)
  • genre_id (genre) — INTEGER
  • author — VARCHAR(256)
  • publisher — VARCHAR(128)
  • publication_year (publication year) — DATE
  • price — INTEGER

genre (Untitled4)

  • ID (id) — INTEGER — Primary key — NOT NULL
  • ISBN (isbn) — VARCHAR(20) — Foreign key → books.ISBN — NOT NULL
  • ID (id2) — INTEGER — Foreign key → books.ID — NOT NULL
  • name (genre name) — VARCHAR(128)

month_book (Untitled3)

  • ID (id) — INTEGER — Primary key — NOT NULL
  • isbn — VARCHAR(20)
  • month_info (month info) — INTEGER
  • ranking (Field) — INTEGER
  • site_name (Field2) — VARCHAR(128)

reviews (Untitled2)

  • ID (id) — INTEGER — Primary key — NOT NULL
  • ISBN (isbn2) — VARCHAR(20) — Foreign key → books.ISBN — NOT NULL
  • ID (id2) — INTEGER — Foreign key → books.ID — NOT NULL
  • isbn — VARCHAR(20)
  • rating — FLOAT
  • review_count (review count) — INTEGER
  • site_name (site name) — VARCHAR(128)