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)