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