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