book
Tables (8)
book
- book_isbn — BIGINT — Primary key — NOT NULL
- book_author — VARCHAR
- book_publisher — VARCHAR
- book_sales — INT
- book_price — INT
- book_tag — VARCHAR
- book_url — VARCHAR
- book_name — VARCHAR
- book_genre — VARCHAR
- book_grade — INT
book_genre
- book_genre_id — BIGINT — Primary key — NOT NULL
- genre_id (genre_id2) — BIGINT — Foreign key → genre.genre_id — NOT NULL
- book_isbn — BIGINT — Foreign key → book.book_isbn — NOT NULL
genre
- genre_id — BIGINT — Primary key — NOT NULL
- genre_name — VARCHAR
review
- review_id — BIGINT — Primary key — NOT NULL
- book_isbn — BIGINT — Foreign key → book.book_isbn — NOT NULL
- review_content — TEXT
- review_rating — INT
user
- user_id — BIGINT — Primary key
- user_email — VARCHAR — NOT NULL
- user_password — VARCHAR
- user_nickname — VARCHAR
- user_job — VARCHAR
- user_gender — VARCHAR
- user_birth — DATE
- user_role — VARCHAR
- user_profile_img — TEXT
user_book
- user_book_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.user_id
- book_isbn — BIGINT — Foreign key → book.book_isbn — NOT NULL
user_genre
- user_genre_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.user_id
- genre_id — BIGINT — Foreign key → genre.genre_id — NOT NULL
wishlist
- wishlist_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.user_id
- book_isbn — BIGINT — Foreign key → book.book_isbn — NOT NULL
- wishlist_date — DATETIME