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