finsight

Tables (17)

ai_feedback_items

  • id — UUID — Primary key — NOT NULL
  • ai_feedback_id — UUID — Foreign key → ai_feedbacks.id — NOT NULL
  • session_target_id — UUID — Foreign key → session_targets.id
  • content — TEXT — NOT NULL
  • variables_to_check — JSONB
  • sort_order — INTEGER — NOT NULL

ai_feedback_references

  • ai_feedback_id — UUID — Foreign key → ai_feedbacks.id — NOT NULL
  • source_document_id — UUID — Foreign key → source_documents.id — NOT NULL
  • citation_label — VARCHAR — NOT NULL
  • sort_order — INTEGER — NOT NULL

ai_feedbacks

  • id — UUID — Primary key — NOT NULL
  • learning_session_id — UUID — Foreign key → learning_sessions.id — NOT NULL
  • feedback_stage — feedback_stage — NOT NULL
  • status — feedback_status — NOT NULL
  • version — INTEGER — NOT NULL
  • flow_summary — TEXT
  • prompt_version — VARCHAR — NOT NULL
  • generated_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

learning_sessions

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • news_id — UUID — Foreign key → news.id — NOT NULL
  • session_type — session_type — NOT NULL
  • status — learning_status — NOT NULL
  • results_revealed_at — TIMESTAMPTZ — Replay 결과를 사용자가 명시적으로 공개한 시각
  • saved_at — TIMESTAMPTZ — 마지막 수동 임시 저장 시각
  • submitted_at — TIMESTAMPTZ — 최종 예측 제출 시각
  • completed_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

market_targets

  • id — UUID — Primary key — NOT NULL
  • code — VARCHAR — NOT NULL
  • display_name — VARCHAR — NOT NULL
  • market_category — market_category — NOT NULL
  • target_type — target_type — NOT NULL
  • direction_labels — JSONB — NOT NULL
  • unit — VARCHAR — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

news

  • id — UUID — Primary key — NOT NULL
  • content_type — news_content_type — NOT NULL
  • replay_status — replay_status — NOT NULL
  • title — VARCHAR — NOT NULL
  • category — VARCHAR — NOT NULL
  • briefing — TEXT — NOT NULL — 사실 요약, 배경, 핵심 변수로 구성된 서비스용 브리핑
  • published_at — TIMESTAMPTZ — NOT NULL
  • reference_at — TIMESTAMPTZ — NOT NULL — 시장 결과 산정 기준 시점
  • curated_at — TIMESTAMPTZ
  • status — news_status — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

news_facts

  • id — UUID — Primary key — NOT NULL
  • news_id — UUID — Foreign key → news.id — NOT NULL
  • source_document_id — UUID — Foreign key → source_documents.id
  • label — VARCHAR — NOT NULL
  • value_text — VARCHAR — NOT NULL
  • unit — VARCHAR
  • as_of_at — TIMESTAMPTZ
  • sort_order — INTEGER — NOT NULL

news_market_outcomes

  • id — UUID — Primary key — NOT NULL
  • news_id — UUID — Foreign key → news.id — NOT NULL
  • market_target_id — UUID — Foreign key → market_targets.id — NOT NULL
  • horizon — SMALLINT — NOT NULL
  • status — outcome_status — NOT NULL
  • reference_at — TIMESTAMPTZ — NOT NULL
  • baseline_at — TIMESTAMPTZ
  • baseline_value — NUMERIC
  • observed_at — TIMESTAMPTZ
  • observed_value — NUMERIC
  • change_value — NUMERIC
  • change_percent — NUMERIC — 금리 대상은 NULL 가능. bp 변화는 change_value에 저장
  • unit — VARCHAR — NOT NULL
  • data_source_name — VARCHAR
  • data_source_url — VARCHAR
  • updated_at — TIMESTAMPTZ — NOT NULL

news_target_candidates

  • news_id — UUID — Foreign key → news.id — NOT NULL
  • market_target_id — UUID — Foreign key → market_targets.id — NOT NULL
  • rationale — TEXT
  • sort_order — INTEGER — NOT NULL

outcome_series_points

  • id — UUID — Primary key — NOT NULL
  • news_id — UUID — Foreign key → news.id — NOT NULL
  • market_target_id — UUID — Foreign key → market_targets.id — NOT NULL
  • trading_date — DATE — NOT NULL
  • close_value — NUMERIC — NOT NULL
  • unit — VARCHAR — NOT NULL
  • data_source_name — VARCHAR — NOT NULL

predictions

  • id — UUID — Primary key — NOT NULL
  • session_target_id — UUID — Foreign key → session_targets.id — NOT NULL
  • horizon — SMALLINT — NOT NULL
  • direction — prediction_direction — NOT NULL
  • confidence — confidence_level
  • reason — TEXT
  • submitted_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

reflection_notes

  • id — UUID — Primary key — NOT NULL
  • learning_session_id — UUID — Foreign key → learning_sessions.id — NOT NULL
  • session_target_id — UUID — Foreign key → session_targets.id
  • reflection_type — reflection_type — NOT NULL
  • prompt_key — reflection_prompt_key — NOT NULL
  • body — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

session_targets

  • id — UUID — Primary key — NOT NULL
  • learning_session_id — UUID — Foreign key → learning_sessions.id — NOT NULL
  • market_target_id — UUID — Foreign key → market_targets.id — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

source_documents

  • id — UUID — Primary key — NOT NULL
  • news_id — UUID — Foreign key → news.id — NOT NULL
  • source_type — source_type — NOT NULL
  • publisher — VARCHAR — NOT NULL
  • title — VARCHAR — NOT NULL
  • url — VARCHAR — NOT NULL
  • published_at — TIMESTAMPTZ
  • is_primary — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

user_consents

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • policy_type — policy_type — NOT NULL
  • policy_version — VARCHAR — NOT NULL
  • consented_at — TIMESTAMPTZ — NOT NULL

user_interests

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • interest_type — interest_type — NOT NULL
  • interest_key — VARCHAR — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

users

  • id — UUID — Primary key — NOT NULL
  • auth_provider — auth_provider — NOT NULL
  • provider_user_id — VARCHAR — NOT NULL
  • display_name — VARCHAR
  • onboarding_completed_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL