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