ERD2

Tables (12)

backtest_results

  • backtest_id — BIGINT — Primary key — NOT NULL
  • ticker — VARCHAR(10) — Foreign key → tickers.ticker — NOT NULL
  • window_days — INT — NOT NULL
  • violation_rate — DECIMAL(6,4)
  • hit_count — INT
  • miss_count — INT
  • hit_rate — DECIMAL(6,4)
  • avg_violation_depth — DECIMAL(6,4)
  • kupiec_statistic — DECIMAL(10,6)
  • kupiec_p_value — DECIMAL(10,6)
  • is_valid — BOOLEAN
  • run_at — TIMESTAMP — NOT NULL

decisions

  • decision_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • ticker — VARCHAR(10) — Foreign key → tickers.ticker — NOT NULL
  • prediction_id — BIGINT — Foreign key → predictions.prediction_id — NOT NULL
  • grade — VARCHAR(20) — NOT NULL
  • worst_case_pct — DECIMAL(6, 4)
  • price_at_decision — DECIMAL(12, 4) — NOT NULL
  • decided_at — TIMESTAMP — NOT NULL
  • outcome — VARCHAR(30)
  • 4) — undefined

macro_indicators

  • indicator_code — VARCHAR(20) — Primary key — NOT NULL — Q0.05 30일 경로
  • trade_date — DATE — Primary key — NOT NULL
  • value — DECIMAL(15, 6) — NOT NULL

predictions

  • prediction_id — BIGINT — Primary key — NOT NULL
  • ticker — VARCHAR(10) — Foreign key → tickers.ticker — NOT NULL
  • base_date — DATE — NOT NULL — Q0.5 (내부용)
  • horizon_days — INT — NOT NULL
  • q05_path — JSON — NOT NULL — UI 노출용 (예: -0.2200)
  • q15_path — JSON — NOT NULL — WARNING/CAUTION/OK/STABLE
  • q50_path — JSON — RECONSIDER_BUY 등
  • worst_case_pct — DECIMAL(6, 4) — 빨간불 요인 개수
  • model_name — VARCHAR(50) — NOT NULL
  • model_version — VARCHAR(30) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

prices

  • trade_date — DATE — Primary key — NOT NULL
  • ticker — VARCHAR(10) — Foreign key → tickers.ticker — NOT NULL
  • open_price — DECIMAL(12,4) — NOT NULL
  • high_price — DECIMAL(12,4) — NOT NULL
  • low_price — DECIMAL(12,4) — NOT NULL
  • close_price — DECIMAL(12,4) — NOT NULL
  • volume — BIGINT — NOT NULL

purchases

  • purchase_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • ticker — VARCHAR(10) — Foreign key → tickers.ticker — NOT NULL
  • purchase_date — DATE — NOT NULL
  • purchase_price — DECIMAL(12,4) — NOT NULL
  • quantity — DECIMAL(15,6)
  • memo — VARCHAR(200)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

risk_grades

  • ticker — VARCHAR(10) — Foreign key → tickers.ticker — NOT NULL
  • prediction_id — BIGINT — Foreign key → predictions.prediction_id — NOT NULL
  • grade — VARCHAR(20) — NOT NULL — avoided_loss/missed_gain/pending
  • message_code — VARCHAR(50) — NOT NULL — 30일 후 max drawdown %
  • worst_case_pct — DECIMAL(6, 4) — NOT NULL
  • current_price — DECIMAL(12, 4)
  • as_of — DATE — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

search_history

  • search_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • ticker — VARCHAR(10) — Foreign key → tickers.ticker — NOT NULL
  • searched_at — TIMESTAMP — NOT NULL

tickers

  • ticker — VARCHAR(10) — Primary key — NOT NULL — 회사명
  • company_name — VARCHAR(200) — NOT NULL — 섹터
  • sector — VARCHAR(50) — 시가총액
  • market_cap — BIGINT — 활성 여부
  • is_active — BOOLEAN — NOT NULL — VIX/FED_RATE/USD_KRW/NASDAQ
  • created_at — TIMESTAMP — NOT NULL

users

  • user_id — BIGINT — Primary key — NOT NULL — 사용자 PK
  • email — VARCHAR(255) — NOT NULL — 로그인 ID
  • name — VARCHAR(50) — NOT NULL — 표시 이름
  • password_hash — VARCHAR(255) — 비밀번호 해시 (OAuth만 쓰면 NULL)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

watchlist

  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • ticker — VARCHAR(10) — Foreign key → tickers.ticker — NOT NULL
  • added_at — TIMESTAMP — NOT NULL

xai_explanations

  • xai_id — BIGINT — Primary key — NOT NULL
  • prediction_id — BIGINT — Foreign key → predictions.prediction_id — NOT NULL
  • ticker — VARCHAR(10) — Foreign key → tickers.ticker — NOT NULL
  • base_date — DATE — NOT NULL
  • red_flag_count — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL