도서 추천
테이블 (13)
book_genres
- book_id — BIGINT — 외래 키 → books.id — NOT NULL
- genre_id — BIGINT — 외래 키 → genres.id — NOT NULL
book_view_logs
- id — BIGSERIAL
- user_id — BIGINT — 외래 키 → users.id
- book_id — BIGINT — 외래 키 → books.id — NOT NULL
- viewed_at — TIMESTAMP
books
- id — BIGSERIAL
- title — VARCHAR(255) — NOT NULL
- author — VARCHAR(255) — NOT NULL
- description — TEXT
- isbn — VARCHAR(20)
- published_date — DATE
- cover_image_url — TEXT
- average_rating — DECIMAL(2,1)
- created_at — TIMESTAMP
content_book_map
- id — BIGSERIAL
- content_id — BIGINT — 외래 키 → contents.id — NOT NULL
- book_id — BIGINT — 외래 키 → books.id — NOT NULL
- similarity_score — DECIMAL(5,4)
- mapping_reason — VARCHAR(255)
contents
- id — BIGSERIAL
- title — VARCHAR(255) — NOT NULL
- type — VARCHAR(20)
- description — TEXT
- poster_url — TEXT
- release_year — INT
genres
- id — BIGSERIAL
- name — VARCHAR(100) — NOT NULL
preference_tags
- id — BIGSERIAL
- name — VARCHAR(100)
reviews
- id — BIGSERIAL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- book_id — BIGINT — 외래 키 → books.id — NOT NULL
- rating — INT
- content — TEXT
- created_at — TIMESTAMP
user_books
- id — BIGSERIAL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- book_id — BIGINT — 외래 키 → books.id — NOT NULL
- status — VARCHAR(20)
- completed_at — TIMESTAMP
- created_at — TIMESTAMP
user_content_inputs
- id — BIGSERIAL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- content_id — BIGINT — 외래 키 → contents.id — NOT NULL
- created_at — TIMESTAMP
user_genre_scores
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- genre_id — BIGINT — 외래 키 → genres.id — NOT NULL
- score — DECIMAL(5,2)
user_preferences
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- preference_tag_id — BIGINT — 외래 키 → preference_tags.id — NOT NULL
users
- id — BIGSERIAL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(100) — NOT NULL
- profile_image_url — TEXT
- level — INT
- created_at — TIMESTAMP