ERD 수정 임시_민식
테이블 (16)
book_content_features
- feature_version — VARCHAR(50) — 기본 키 — NOT NULL
- book_id — UUID — 외래 키 → books.id — NOT NULL
- feature_scores — TEXT — NOT NULL
- extracted_at — DATETIME — NOT NULL
book_demand_features
- as_of_month — DATE — 기본 키 — NOT NULL
- feature_version — VARCHAR(50) — 기본 키 — NOT NULL
- book_id — UUID — 외래 키 → books.id — NOT NULL
- cumulative_loan_count — BIGINT — NOT NULL
- loan_24m_count — BIGINT — NOT NULL
- loan_3m_count — BIGINT — NOT NULL
- observed_months — SMALLINT — NOT NULL
- trending_score — DECIMAL(6, 3) — NOT NULL
- steady_score — DECIMAL(6, 3) — NOT NULL
- rank_score — DECIMAL(20, 4) — NOT NULL
- candidate_type — VARCHAR(30) — NOT NULL
book_loaned_top20
- id — BIGINT — 기본 키 — NOT NULL
- book_id — BIGINT — 외래 키 — NOT NULL
- gender — VARCHAR(1) — NOT NULL
- age_group — VARCHAR(2) — NOT NULL
- ranking — SMALLINT — NOT NULL
- loan_count — INT
- period — VARCHAR(6) — NOT NULL
book_ratings
- id — UUID — 기본 키 — NOT NULL
- user_id — UUID — 외래 키 → users.id — NOT NULL
- book_id — UUID — 외래 키 → books.id — NOT NULL
- rating — SMALLINT — NOT NULL
- review_text — VARCHAR(300)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
book_tags
- feature_version — VARCHAR(50) — 기본 키 — NOT NULL
- book_id — UUID — 외래 키 → books.id — NOT NULL
- tag_code — VARCHAR(50) — 외래 키 → tags.code — NOT NULL
- score — DECIMAL(5, 2)
- confidence — DECIMAL(4, 3) — NOT NULL
- source — VARCHAR(50) — NOT NULL
books
- id — UUID — 기본 키 — NOT NULL
- isbn13 — CHAR(13) — NOT NULL
- isbn10 — CHAR(10)
- title — VARCHAR(500) — NOT NULL
- subtitle — VARCHAR(500)
- authors — TEXT — NOT NULL
- publisher — VARCHAR(255)
- published_date — DATE
- description — TEXT
- categories — TEXT — NOT NULL
- cover_image_url — TEXT
- page_count — INTEGER
- publication_form — VARCHAR(50)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
library_items
- id — UUID — 기본 키 — NOT NULL
- user_id — UUID — 외래 키 → users.id — NOT NULL
- book_id — UUID — 외래 키 → books.id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- finished_at — DATE
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
recommendation_items
- recommendation_id — UUID — 외래 키 → recommendations.id — NOT NULL
- book_id — UUID — 외래 키 → books.id — NOT NULL
- rank — INTEGER — NOT NULL
- score — DECIMAL(20, 6) — NOT NULL
- feature_scores — TEXT — NOT NULL
- tags — TEXT — NOT NULL
- reason_type — VARCHAR(50) — NOT NULL
- reason_text — VARCHAR(500) — NOT NULL
recommendations
- id — UUID — 기본 키 — NOT NULL
- user_id — UUID — 외래 키 → users.id — NOT NULL
- mode — VARCHAR(30) — NOT NULL
- model_version — VARCHAR(100) — NOT NULL
- weights — TEXT — NOT NULL
- applied_tags — TEXT — NOT NULL
- fallback — BOOLEAN — NOT NULL
- based_on_count — INTEGER — NOT NULL
- generated_at — DATETIME — NOT NULL
tags
- code — VARCHAR(50) — 기본 키 — NOT NULL
- label — VARCHAR(100) — NOT NULL
- tag_type — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
user_actions
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 — NOT NULL
- book_id — BIGINT — 외래 키 — NOT NULL
- event_type — VARCHAR(15) — NOT NULL
- context — VARCHAR(20)
- created_at — TIMESTAMPTZ — NOT NULL
user_events
- id — UUID — 기본 키 — NOT NULL
- user_id — UUID — 외래 키 → users.id — NOT NULL
- recommendation_id — UUID — 외래 키 → recommendations.id
- book_id — UUID — 외래 키 → books.id
- event_type — VARCHAR(30) — NOT NULL
- rank — INTEGER
- client_event_id — VARCHAR(255)
- occurred_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
user_interests
- user_id — UUID — 외래 키 → users.id — NOT NULL
- tag_code — VARCHAR(50) — 외래 키 → tags.code — NOT NULL
- created_at — DATETIME — NOT NULL
user_library
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 — NOT NULL
- book_id — BIGINT — 외래 키 — NOT NULL
- status — VARCHAR(15) — NOT NULL
- rating — SMALLINT
- review_text — VARCHAR(300)
- finished_at — DATE
- source — VARCHAR(15) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
user_seed_books
- user_id — UUID — 외래 키 → users.id — NOT NULL
- book_id — UUID — 외래 키 → books.id — NOT NULL
- rating — SMALLINT — NOT NULL
- created_at — DATETIME — NOT NULL
users
- id — UUID — 기본 키 — NOT NULL
- oauth_provider — VARCHAR(20) — NOT NULL
- oauth_subject — VARCHAR(255) — NOT NULL
- email — VARCHAR(320)
- nickname — VARCHAR(100)
- birth_year — SMALLINT
- gender — VARCHAR(20)
- onboarding_status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL