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