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