readwe

Tables (14)

book

  • book_id — bigint(20) — Primary key — NOT NULL
  • author — varchar(255) — NOT NULL
  • category_id — bigint(20) — Foreign key → book_category.category_id — NOT NULL
  • published_date — datetime(6)
  • publisher — varchar(255) — NOT NULL
  • title — varchar(255) — NOT NULL

book_category

  • category_id — bigint(20) — Primary key — NOT NULL
  • category — enum('CHILDREN','FANTASY','FICTION','HISTORY','HORROR','MYSTERY','NONFICTION','NOVEL','PICTURE_BOOK','ROMANCE','SCIENCEFICTION','SF','YA') — NOT NULL

book_report

  • id — bigint(20) — Primary key — NOT NULL
  • book_id — bigint(20) — Foreign key → book.book_id
  • created_at — datetime(6)
  • description — varchar(255)
  • title — varchar(255)
  • updated_at — datetime(6)
  • user_id — bigint(20) — Foreign key → user.id
  • total_like — int(11)

book_report_comment

  • report_comment_id — bigint(20) — Primary key — NOT NULL
  • content — varchar(255)
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • user_id — bigint(20) — Foreign key → user.id
  • book_report_id — bigint(20) — Foreign key → book_report.id
  • parent_id — bigint(20) — Foreign key → book_report_comment.report_comment_id

book_report_like

  • b_report_like_id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL
  • book_report_id — bigint(20) — Foreign key → book_report.id

booklike

  • booklike_id — bigint(20) — Primary key — NOT NULL
  • book_id — bigint(20) — Foreign key → book.book_id — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL

reading_club

  • club_id — bigint(20) — Primary key — NOT NULL
  • category — bigint(20) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • current_member — int(11)
  • club_description — varchar(255)
  • max_member — int(11)
  • club_name — varchar(255) — NOT NULL
  • club_status — enum('CLOSED','FINISHED','OPEN') — NOT NULL
  • host_user_id — bigint(20) — Foreign key → user.id — NOT NULL

reading_club_join_request

  • id — bigint(20) — Primary key — NOT NULL
  • club_id — bigint(20) — Foreign key → reading_club.club_id — NOT NULL
  • created_at — datetime(6)
  • request_message — enum('APPROVED','PENDING','REJECTED') — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL
  • message — varchar(255)
  • status — enum('APPROVED','PENDING','REJECTED') — NOT NULL

reading_club_member

  • id — bigint(20) — Primary key — NOT NULL
  • club_id — bigint(20) — Foreign key → reading_club.club_id — NOT NULL
  • joined_at — datetime(6)
  • role — enum('HOST','MEMBER') — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL

reading_club_review

  • club_review_id — bigint(20) — Primary key — NOT NULL
  • club_id — bigint(20) — Foreign key → reading_club.club_id — NOT NULL
  • created_at — datetime(6)
  • like_total — bigint(20)
  • review_content — varchar(255) — NOT NULL
  • review_title — varchar(255) — NOT NULL
  • writer_id — bigint(20) — Foreign key → user.id — NOT NULL

reading_club_review_comment

  • review_comment_id — bigint(20) — Primary key — NOT NULL
  • club_review_id — bigint(20) — Foreign key → reading_club_review.club_review_id — NOT NULL
  • comment_detail — varchar(255) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • delete_comment — bit(1) — NOT NULL
  • parent_comment_id — bigint(20) — Foreign key → reading_club_review_comment.review_comment_id
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL

reading_club_review_like

  • review_like_id — bigint(20) — Primary key — NOT NULL
  • club_review_id — bigint(20) — Foreign key → reading_club_review.club_review_id — NOT NULL
  • like_datetime — datetime(6) — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL

user

  • id — bigint(20) — Primary key — NOT NULL
  • nickname — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • role — enum('ADMIN','USER') — NOT NULL
  • username — varchar(255) — NOT NULL
  • profile_image_url — varchar(255)

user_like

  • user_like_id — bigint(20) — Primary key — NOT NULL
  • category_id — bigint(20) — Foreign key → book_category.category_id
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL