Public deokhugam-team2

테이블 (9)

댓글 관리 (comments)

  • id — UUID — 기본 키 — NOT NULL
  • id (user_id) — UUID, ON DELETE CASCADE — 외래 키 → 사용자.id — NOT NULL
  • id (review_id) — UUID, ON DELETE CASCADE — 외래 키 → 리뷰관리.id — NOT NULL
  • content — VARCAHR(200) — NOT NULL
  • created_at — TIMESTAMPZ — NOT NULL
  • updated_at — TIMESTAMPZ
  • is_deleted — BOOLEAN — NOT NULL

도서관리 (books)

  • id — UUID — 기본 키 — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • author — VARCHAR(50) — NOT NULL
  • description — TEXT — NOT NULL
  • publisher — VARCHAR(50) — NOT NULL
  • publishedDate (published_date) — DATE — NOT NULL
  • isbn — VARCHAR(13),UNIQUE
  • thumbnailUrl (thumbnail_url) — VARCHAR(255)
  • reviewCount (review_count) — INTEGER — NOT NULL
  • rating — REAL — NOT NULL
  • createdAt (created_at) — TIMESTAMPTZ — NOT NULL
  • updatedAt (updated_at) — TIMESTAMPTZ
  • isDeleted (is_deleted) — BOOLEAN — NOT NULL

리뷰 좋아요 (review_like)

  • id (review_id) — UUID, ON DELETE CASCADE — 외래 키 → 리뷰관리.id — NOT NULL
  • id (user_id) — UUID, ON DELETE CASCADE — 외래 키 → 사용자.id — NOT NULL
  • liked — BOOLEAN — NOT NULL

리뷰관리 (reviews)

  • id — UUID — 기본 키 — NOT NULL
  • 책 아이디 (book_id) — UUID — 외래 키 → 도서관리.id — NOT NULL
  • user_id — UUID, ON DELETE CASCADE — 외래 키 → 사용자.id — NOT NULL
  • book_title — VARCHAR(100) — NOT NULL
  • book_thumbnail_url — VARCHAR(255)
  • user_nickname — VARCHAR(50) — NOT NULL
  • content — TEXT — NOT NULL
  • rating — REAL — NOT NULL
  • like_count — BIGINT
  • comment_count — BIGINT
  • liked_by_me — BOOLEAN — NOT NULL
  • create_at — TIMESTAMPTZ — NOT NULL
  • update_at — TIMESTAMPTZ
  • is_delete — BOOLEAN — NOT NULL

사용자 (users)

  • id — UUID — 기본 키 — NOT NULL
  • email — VARCHAR(255), UNIQUE — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • password — VARCHAR(50) — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL

알림 관리 (notifications)

  • id — UUID — 기본 키 — NOT NULL
  • content — VARCHAR(255) — NOT NULL
  • confirmed — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPZ — NOT NULL
  • updated_at — TIMESTAMPZ — NOT NULL
  • review_id — UUID, ON DELETE CASCADE — 외래 키 → 사용자.id — NOT NULL
  • user_id — UUID, ON DELETE CASCADE — 외래 키 → 리뷰관리.id — NOT NULL

인기 도서 랭킹 (popular_book_ranking)

  • id — UUID — 기본 키 — NOT NULL
  • book_id — UUID, ON DELETE SET NULL — 외래 키 → 도서관리.id — NOT NULL
  • period — VARCHAR(20) — NOT NULL
  • rank — INTEGER — NOT NULL
  • score — DOUBLE — NOT NULL
  • review_count — BIGINT — NOT NULL
  • rating — REAL — NOT NULL
  • created_at — TIMESTAMPZ — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • author — VARCHAR(50) — NOT NULL
  • thumbnailUrl — VARCHAR(255)

인기 리뷰 랭킹 (popular_review_ranking)

  • id — UUID — 기본 키 — NOT NULL
  • review_id — UUID, ON DELETE SET NULL — 외래 키 → 리뷰관리.id
  • period — VARCHAR(20) — NOT NULL
  • rank — INTEGER — NOT NULL
  • score — DOUBLE — NOT NULL
  • like_count — BIGINT — NOT NULL
  • comment_count — BIGINT — NOT NULL
  • created_at — TIMESTAMPZ — NOT NULL
  • bookId — UUID — NOT NULL
  • bookTitle (book_title) — VARCHAR(100) — NOT NULL
  • bookThumnailUrl (book_thumbnail_url) — VARCHAR(255)
  • userId (user_id) — UUID — NOT NULL
  • userNickname (user_nickname) — VARCHAR(50) — NOT NULL
  • reviewContent (review_content) — TEXT — NOT NULL
  • reviewRating (review_rating) — REAL — NOT NULL

파워 유저 랭킹 (power_user_ranking)

  • id — UUID — 기본 키 — NOT NULL
  • user_id — UUID, ON DELETE SET NULL — 외래 키 → 사용자.id — NOT NULL
  • period — VARCHAR(20) — NOT NULL
  • rank — INTEGER — NOT NULL
  • score — DOUBLE — NOT NULL
  • review_score_sum — DOUBLE — NOT NULL
  • like_count — BIGINT — NOT NULL
  • comment_count — BIGINT — NOT NULL
  • created_at — TIMESTAMPZ — NOT NULL
  • ncikname (nickname) — VARCHAR(50) — NOT NULL