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