덕후감
테이블 (9)
books
- id — BIGINT — 기본 키 — NOT NULL
- title — VARCHAR(200) — NOT NULL
- author — VARCHAR(100) — NOT NULL
- description — TEXT
- publisher — VARCHAR(100)
- published_date — DATE
- isbn — VARCHAR(20)
- thumbnail_url — VARCHAR(255)
- review_count — INT
- rating — FLOAT
- is_deleted — BOOLEAN
comments
- id — BIGINT — 기본 키 — NOT NULL
- review_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- is_deleted — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
dashboard_books
- id — BIGINT — 기본 키 — NOT NULL
- book_id — BIGINT — NOT NULL
- score — FLOAT — NOT NULL
- rank — INT — NOT NULL
- period_type — ENUM('DAILY','WEEKLY','MONTHLY','ALL_TIME') — NOT NULL
- calculated_at — TIMESTAMP
dashboard_reviews
- id — BIGINT — 기본 키 — NOT NULL
- review_id — BIGINT — NOT NULL
- score — FLOAT — NOT NULL
- rank — INT — NOT NULL
- period_type — ENUM('DAILY','WEEKLY','MONTHLY','ALL_TIME') — NOT NULL
- calculated_at — TIMESTAMP
dashboard_users
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — NOT NULL
- score — FLOAT — NOT NULL
- rank — INT — NOT NULL
- period_type — ENUM('DAILY','WEEKLY','MONTHLY','ALL_TIME') — NOT NULL
- calculated_at — TIMESTAMP
notifications
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — NOT NULL
- review_id — BIGINT
- content — VARCHAR(255)
- is_read — BOOLEAN
- created_at — TIMESTAMP
- read_at — TIMESTAMP
- deleted_at — TIMESTAMP
review_likes
- id — BIGINT — 기본 키 — NOT NULL
- review_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- created_at — TIMESTAMP
reviews
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — NOT NULL
- book_id — BIGINT — NOT NULL
- rating — FLOAT — NOT NULL
- content — TEXT — NOT NULL
- like_count — INT
- comment_count — INT
- is_deleted — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
users
- id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(100) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- is_deleted — BOOLEAN
- deleted_at — TIMESTAMP
- created_at — TIMESTAMP
- updated_at — TIMESTAMP