인용

테이블 (8)

book

  • id — BIGINT
  • title — VARCHAR(255) — NOT NULL
  • author — VARCHAR(255)
  • comment — VARCHAR(255) — ARCHAR(255

celebrity

  • id — BIGINT
  • name — VARCHAR(255) — NOT NULL
  • comment — VARCHAR(255) — ARCHAR(255

quote_content

  • id — BIGINT
  • content_text — TEXT — NOT NULL
  • hash_value — VARCHAR(64)
  • language — ENUM('ko', 'en') — NOT NULL

quote_context

  • id — BIGINT
  • quote_id — BIGINT — 외래 키 → 인용.id — NOT NULL
  • how — VARCHAR(255)
  • when_read — VARCHAR(255)
  • why — VARCHAR(255)
  • help — VARCHAR(255)

quote_source

  • id — BIGINT
  • quote_id — BIGINT — 외래 키 → 인용.id — NOT NULL
  • source_url — VARCHAR(255)
  • source_type — ENUM('sns', 'interview', 'video', 'article')
  • timestamp — VARCHAR(50)

topic

  • id — BIGINT
  • name — VARCHAR(100) — NOT NULL

topic_quote_content

  • id — BIGINT
  • topic_id — BIGINT — 외래 키 → topic.id — NOT NULL
  • content_id — BIGINT — 외래 키 → quote_content.id — NOT NULL

인용 (quote)

  • id — BIGINT
  • 인용문 (content_id) — BIGINT — 외래 키 → quote_content.id — NOT NULL
  • 유명인id (celebrity_id) — BIGINT — 외래 키 → celebrity.id — NOT NULL
  • 책id (book_id) — BIGINT — 외래 키 → book.id — NOT NULL
  • confidence_score — INT
  • context_score — INT
  • is_direct_quote — BOOLEAN