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