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