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