chek

Tables (6)

book (Untitled)

  • 책 ID (book_id) — bigInt — Primary key — NOT NULL — auto increment
  • 저자 (author) — varchar(40)
  • 조회수 (view_count) — bigint
  • 요약 정보 (summary) — varchar(255)
  • 추천수 (like) — int
  • 책 이름 (title) — varchar
  • ISBN (isbn) — varchar
  • 카테고리 ID (category_id) — bigint — Foreign key → category.카테고리 ID — NOT NULL

category (Untitled5)

  • 카테고리 ID (category_id) — bigint — Primary key — NOT NULL
  • 카테고리 명 (category_name) — varchar
  • Field

comment (Untitled4)

  • 댓글 ID (reply_id) — bigint — Primary key — NOT NULL
  • 익명 이름 (annonymous_name) — varchar(10)
  • 댓글 내용 (reply_contents) — varchar(500)
  • delete (soft_delete) — boolean(false)
  • 부모 댓글 ID (parent_comment_id) — bigint
  • 자식 댓글 ID (child_reply_id) — bigint — Foreign key → comment.댓글 ID
  • 작성자 ID (member_id) — varchar(100) — Foreign key → member.회원 ID — NOT NULL
  • 리뷰 ID (review_id) — bigint — Foreign key → review.리뷰 ID — NOT NULL
  • 리뷰 높이 (review_level) — int
  • Field

member (Untitled2)

  • 회원 ID (member_id) — varchar(100) — Primary key — NOT NULL
  • 비밀번호 (member_pw) — varchar(100)
  • Field (age) — int

memberReviewLiked (Untitled6)

  • 매핑 ID (mappedId) — bigint — Primary key — NOT NULL
  • 추천 (like) — boolean(true)
  • 회원 ID (member_id) — varchar(100) — Foreign key → member.회원 ID — NOT NULL
  • 리뷰 ID (review_id) — bigint — Foreign key → review.리뷰 ID — NOT NULL

review (Untitled3)

  • 리뷰 ID (review_id) — bigint — Primary key — NOT NULL
  • 제목 (title) — varchar(100)
  • 내용 (Field)
  • 등록일자 (created_at) — date
  • 추천수 (likeCount) — int
  • soft delete (soft_delete) — boolean(false)
  • 수정일자 (updated_at) — date
  • 회원 ID (member_id) — varchar(100) — Foreign key → member.회원 ID — NOT NULL
  • 책 ID (book_id) — bigInt — Foreign key → book.책 ID — NOT NULL — auto increment