i-bax

테이블 (7)

기사 (article)

  • id — BIGINT
  • headline — VARCHAR(500) — NOT NULL
  • normalized_headline — VARCHAR(500) — NOT NULL
  • url — VARCHAR(1000) — NOT NULL
  • normalized_url — VARCHAR(1000) — NOT NULL
  • description — TEXT
  • published_at — DATETIME
  • publisher_id — BIGINT — 외래 키 → 언론사.id — NOT NULL
  • category — VARCHAR(30) — NOT NULL
  • rss_guid — VARCHAR(500)
  • dedupe_key — VARCHAR(255) — NOT NULL
  • fetched_at — DATETIME — NOT NULL

언론사 (publisher)

  • id — BIGINT
  • name — VARCHAR(255) — NOT NULL
  • country — VARCHAR(30) — NOT NULL
  • political_leaning — VARCHAR(30) — NOT NULL
  • rss_url — VARCHAR(500)
  • created_at — DATETIME — NOT NULL

언론사 RSS 피드 (publisher_feed)

  • id — BIGINT
  • publisher_id — BIGINT — 외래 키 → 언론사.id — NOT NULL
  • article_category — VARCHAR(30) — NOT NULL
  • rss_url — VARCHAR(500) — NOT NULL
  • active — BOOLEAN — NOT NULL

토픽 (topic)

  • id — BIGINT
  • title — VARCHAR(500) — NOT NULL
  • summary — TEXT
  • ai_summary — TEXT
  • summary_generated_at — DATETIME
  • ai_model — VARCHAR(100)
  • article_category — VARCHAR(30) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • start_date — DATE
  • created_at — DATETIME — NOT NULL

토픽 기사 연결 (topic_article)

  • id — BIGINT
  • topic_id — BIGINT — 외래 키 → 토픽.id — NOT NULL
  • article_id — BIGINT — 외래 키 → 기사.id — NOT NULL
  • linked_at — DATETIME — NOT NULL

파이프라인 실행 (pipeline_run)

  • id — BIGINT
  • status — VARCHAR(30) — NOT NULL
  • fetched_count — INT — NOT NULL
  • saved_count — INT — NOT NULL
  • clustered_count — INT — NOT NULL
  • summarized_count — INT — NOT NULL
  • message — VARCHAR(255)
  • error_message — VARCHAR(255)
  • started_at — DATETIME — NOT NULL
  • finished_at — DATETIME

파이프라인 실행 히스토리 (pipeline_step_history)

  • id — BIGINT
  • pipeline_run_id — BIGINT — 외래 키 → 파이프라인 실행.id — NOT NULL
  • step — VARCHAR(30) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • target_type — VARCHAR(100)
  • target_name — VARCHAR(255)
  • processed_count — INT — NOT NULL
  • success_count — INT — NOT NULL
  • failed_count — INT — NOT NULL
  • error_type — VARCHAR(100)
  • error_message — VARCHAR(255)
  • message — VARCHAR(255)
  • started_at — DATETIME — NOT NULL
  • finished_at — DATETIME