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