도서 추천

테이블 (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