last

Tables (9)

books

  • id — UUID — Primary key — NOT NULL
  • title — VARCHAR(500) — NOT NULL
  • author — VARCHAR(255) — NOT NULL
  • description — TEXT — NOT NULL
  • publisher — VARCHAR(255) — NOT NULL
  • published_date — DATE — NOT NULL
  • isbn — VARCHAR(20)
  • thumbnail_url — VARCHAR(2048)
  • review_count — INT — NOT NULL
  • rating — DECIMAL(3, 2) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

comments

  • id — UUID — Primary key — NOT NULL
  • review_id — UUID — Foreign key → reviews.id — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

notifications

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • sender_id — UUID — Foreign key → users.id
  • review_id — UUID — Foreign key → reviews.id — NOT NULL
  • type — VARCHAR(10) — NOT NULL
  • confirmed — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

popular_books

  • id — UUID — Primary key — NOT NULL
  • book_id — UUID — Foreign key → books.id — NOT NULL
  • period — VARCHAR(10) — NOT NULL
  • ranking — BIGINT — NOT NULL
  • base_date — DATE — NOT NULL
  • score — DECIMAL(10, 4) — NOT NULL
  • review_count — BIGINT — NOT NULL
  • rating — DECIMAL(3, 2) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

popular_reviews

  • id — UUID — Primary key — NOT NULL
  • review_id — UUID — Foreign key → reviews.id — NOT NULL
  • period — VARCHAR(10) — NOT NULL
  • ranking — BIGINT — NOT NULL
  • base_date — DATE — NOT NULL
  • score — DECIMAL(10, 4) — NOT NULL
  • like_count — BIGINT — NOT NULL
  • comment_count — BIGINT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

power_users

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • period — VARCHAR(10) — NOT NULL
  • ranking — BIGINT — NOT NULL
  • base_date — DATE — NOT NULL
  • score — DECIMAL(10, 4) — NOT NULL
  • review_score_sum — DECIMAL(10, 4) — NOT NULL
  • like_count — BIGINT — NOT NULL
  • comment_count — BIGINT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

review_likes

  • id — UUID — Primary key — NOT NULL
  • review_id — UUID — Foreign key → reviews.id — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

reviews

  • id — UUID — Primary key — NOT NULL
  • book_id — UUID — Foreign key → books.id — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • content — TEXT — NOT NULL
  • rating — INT — NOT NULL
  • like_count — INT — NOT NULL
  • comment_count — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

users

  • id — UUID — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(20) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP