erd3

Tables (10)

books

  • id — UUID — Primary key — NOT NULL
  • title — varchar
  • author — varchar
  • description — TEXT
  • publisher — varchar
  • published_date — date
  • isbn — varchar
  • thumbnail_url — varchar
  • review_count — INT
  • rating — DECIMAL
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

comments

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

notifications

  • id — UUID — Primary key — NOT NULL
  • sender_id — UUID — Primary key — NOT NULL
  • user_id — UUID — Foreign key → user.id — NOT NULL
  • review_id — UUID — Foreign key → reviews.id — NOT NULL
  • type — varchar
  • confirm_status — boolean
  • created_at — timestamp
  • updated_at — timestamp

popular_books

  • id — UUID — Primary key — NOT NULL
  • book_id — UUID — Foreign key → books.id — NOT NULL
  • period — varchar
  • rank — BIGINT
  • score — DECIMAL
  • review_count — BIGINT
  • rating — DECIMAL
  • created_at — timestamp

popular_reviews

  • id — UUID — Primary key — NOT NULL
  • review_id — UUID — Foreign key → reviews.id — NOT NULL
  • period — varchar
  • rank — BIGINT
  • score — DECIMAL
  • like_count — BIGINT
  • comment_count — BIGINT
  • created_at — timestamp

power_users

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — Foreign key → user.id — NOT NULL
  • period — varchar
  • rank — BIGINT
  • score — DECIMAL
  • review_score_sum — DECIMAL
  • like_count — BIGINT
  • comment_count — BIGINT
  • created_at — timestamp

review_likes

  • id — UUID — Primary key — NOT NULL
  • review_id — UUID — Foreign key → reviews.id — NOT NULL
  • user_id — UUID — Foreign key → user.id — NOT NULL
  • created_at — timestamp

reviews

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

user

  • id — UUID — Primary key — NOT NULL
  • email — varchar(255)
  • nickname — varchar(20)
  • password — varchar
  • created_at — timestamp
  • updated_at — timestamp
  • 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