살라말래 주식 위원회

테이블 (41)

ai_daily_performance

  • id — BIGSERIAL
  • portfolio_id — BIGINT — 외래 키 → ai_portfolio.id — NOT NULL
  • model_version — VARCHAR(20) — NOT NULL
  • record_date — DATE — NOT NULL
  • daily_return — REAL
  • cumulative_return — REAL
  • mdd — REAL
  • cash_balance — BIGINT — NOT NULL
  • invested_amount — BIGINT — NOT NULL
  • market_value — BIGINT — NOT NULL
  • realized_profit — BIGINT — NOT NULL
  • unrealized_profit — BIGINT — NOT NULL
  • total_asset_value — BIGINT — NOT NULL
  • holding_count — INTEGER — NOT NULL

ai_debate_reports

  • id — BIGSERIAL
  • stock_id — BIGINT — 외래 키 → stocks.id — NOT NULL
  • report_date — DATE — NOT NULL
  • debate_version — VARCHAR(20)
  • chairman_signal — VARCHAR(4)
  • debate_confidence — REAL
  • debate_summary — JSONB
  • final_stances — JSONB
  • debate_full_log — JSONB
  • chairman_report — TEXT
  • created_at — TIMESTAMPTZ

ai_ml_reports

  • id — BIGSERIAL
  • stock_id — BIGINT — 외래 키 → stocks.id — NOT NULL
  • report_date — DATE — NOT NULL
  • model_version — VARCHAR(20) — NOT NULL
  • ml_signal — VARCHAR(4)
  • ml_confidence — REAL
  • signal_agreement — BOOLEAN
  • confidence_gap — REAL
  • scenario_type — VARCHAR(30)
  • risk_flag — BOOLEAN
  • report_data — JSONB
  • created_at — TIMESTAMPTZ
  • UNIQUE(stock_id, — report_date,

ai_portfolio

  • id — BIGSERIAL
  • name — VARCHAR(50) — NOT NULL
  • model_version — VARCHAR(20) — NOT NULL
  • debate_version — VARCHAR(20)
  • cumulative_return — REAL
  • total_trades — INT
  • winning_trades — INT
  • initial_capital — BIGINT — NOT NULL
  • cash_balance — BIGINT — NOT NULL
  • realized_profit — BIGINT — NOT NULL
  • unrealized_profit — BIGINT — NOT NULL
  • total_asset_value — BIGINT — NOT NULL
  • latest_record_date — DATE
  • updated_at — TIMESTAMPTZ

ai_portfolio_holdings

  • id — BIGSERIAL
  • portfolio_id — BIGINT — 외래 키 → ai_portfolio.id — NOT NULL
  • stock_id — BIGINT — 외래 키 → stocks.id — NOT NULL
  • model_version — VARCHAR(20) — NOT NULL
  • portfolio_weight — REAL
  • return_rate — REAL
  • buy_date — TIMESTAMPTZ
  • avg_buy_price — INTEGER
  • current_price — INTEGER
  • holding_quantity — BIGINT
  • investment_amount — BIGINT
  • market_value — BIGINT
  • evaluation_profit — BIGINT
  • updated_at — TIMESTAMPTZ

ai_trading_history

  • id — BIGSERIAL
  • portfolio_id — BIGINT — 외래 키 → ai_portfolio.id — NOT NULL
  • stock_id — BIGINT — 외래 키 → stocks.id — NOT NULL
  • ml_report_id — BIGINT — 외래 키 → ai_ml_reports.id
  • debate_report_id — BIGINT — 외래 키 → ai_debate_reports.id
  • model_version — VARCHAR(20)
  • trade_type — VARCHAR(4) — NOT NULL
  • trade_weight — REAL
  • trade_price_rate — REAL
  • trade_price — INTEGER
  • trade_quantity — BIGINT
  • trade_amount — BIGINT
  • return_rate — REAL
  • realized_profit — BIGINT — NOT NULL
  • holding_quantity_after — BIGINT
  • cash_balance_after — BIGINT
  • avg_buy_price_after — INTEGER
  • trade_time — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ

device_sessions

  • id — BIGSERIAL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • device_id — VARCHAR(255) — NOT NULL
  • device_name — VARCHAR(255) — NOT NULL
  • device_info — VARCHAR(512)
  • ip_address — VARCHAR(45)
  • trust_level — VARCHAR(20) — NOT NULL
  • login_count — INT — NOT NULL
  • last_login_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

ensemble_portfolio

  • id — BIGSERIAL
  • strategy_name — VARCHAR(50) — NOT NULL
  • model_version — VARCHAR(20) — NOT NULL
  • initial_capital — BIGINT — NOT NULL
  • params — JSONB
  • created_at — TIMESTAMPTZ

ensemble_portfolio_holdings

  • id — BIGSERIAL
  • portfolio_id — BIGINT — 외래 키 → ensemble_portfolio.id — NOT NULL
  • snapshot_date — DATE — NOT NULL
  • stock_id — BIGINT — 외래 키 → stocks.id — NOT NULL
  • buy_date — DATE — NOT NULL
  • buy_price — INT — NOT NULL
  • current_price — INT
  • shares — INT — NOT NULL
  • invested — BIGINT — NOT NULL
  • unrealized_pnl — BIGINT
  • hold_days — INT — NOT NULL
  • is_extended — BOOLEAN
  • ensemble_prob — REAL
  • created_at — TIMESTAMPTZ

ensemble_portfolio_snapshots

  • id — BIGSERIAL
  • portfolio_id — BIGINT — 외래 키 → ensemble_portfolio.id — NOT NULL
  • snapshot_date — DATE — NOT NULL
  • portfolio_value — BIGINT — NOT NULL
  • cash — BIGINT — NOT NULL
  • n_positions — INT — NOT NULL
  • daily_return — REAL
  • cumulative_return — REAL
  • mdd — REAL
  • sharpe_30d — REAL
  • created_at — TIMESTAMPTZ
  • UNIQUE(portfolio_id, — snapshot_date)

ensemble_portfolio_trades

  • id — BIGSERIAL
  • portfolio_id — BIGINT — 외래 키 → ensemble_portfolio.id — NOT NULL
  • trade_date — DATE — NOT NULL
  • stock_id — BIGINT — 외래 키 → stocks.id — NOT NULL
  • trade_type — VARCHAR(4) — NOT NULL
  • price — INT — NOT NULL
  • shares — INT — NOT NULL
  • amount — BIGINT — NOT NULL
  • commission — BIGINT
  • pnl — BIGINT
  • return_rate — REAL
  • hold_days — INT
  • trade_reason — VARCHAR(30)
  • is_extended — BOOLEAN
  • ensemble_prob — REAL
  • created_at — TIMESTAMPTZ

keyword_clusters

  • id — BIGSERIAL
  • name — VARCHAR(15) — NOT NULL
  • created_at — TIMESTAMPTZ

keyword_embeddings

  • keyword_id — BIGINT — 외래 키 → keywords.id
  • embedding — vector(384) — NOT NULL

keywords

  • id — BIGSERIAL
  • name — VARCHAR(20) — NOT NULL
  • cluster_id — BIGINT — 외래 키 → keyword_clusters.id
  • created_at — TIMESTAMPTZ

login_history

  • id — BIGSERIAL
  • user_id — BIGINT — 외래 키 → users.id
  • attempt_email — VARCHAR(255)
  • ip_address — VARCHAR(45)
  • device_info — VARCHAR(512)
  • is_success — BOOLEAN — NOT NULL
  • event_type — VARCHAR(30)
  • created_at — TIMESTAMPTZ

ml_ensemble_predictions

  • id — BIGSERIAL
  • stock_id — BIGINT — 외래 키 → stocks.id — NOT NULL
  • report_date — DATE — NOT NULL
  • model_version — VARCHAR(20) — NOT NULL
  • ensemble_result — INT — NOT NULL
  • ensemble_confidence — REAL — NOT NULL
  • signal_agreement — BOOLEAN
  • confidence_gap — REAL
  • risk_flag — BOOLEAN
  • scenario_type — VARCHAR(30)
  • scenario_label — VARCHAR(20)
  • created_at — TIMESTAMPTZ
  • UNIQUE(stock_id, — report_date,

ml_garch_predictions

  • id — BIGSERIAL
  • stock_id — BIGINT — 외래 키 → stocks.id — NOT NULL
  • report_date — DATE — NOT NULL
  • model_version — VARCHAR(20) — NOT NULL
  • vol_1d — REAL
  • vol_3d — REAL
  • vol_5d — REAL
  • volatility_level — VARCHAR(10)
  • risk_flag — BOOLEAN
  • percentile_vs_1y — REAL
  • created_at — TIMESTAMPTZ
  • UNIQUE(stock_id, — report_date,

ml_lgbm_predictions

  • id — BIGSERIAL
  • stock_id — BIGINT — 외래 키 → stocks.id — NOT NULL
  • report_date — DATE — NOT NULL
  • model_version — VARCHAR(20) — NOT NULL
  • predicted_class — INT — NOT NULL
  • confidence — REAL — NOT NULL
  • prob_down — REAL — NOT NULL
  • prob_sideways — REAL — NOT NULL
  • prob_up — REAL — NOT NULL
  • created_at — TIMESTAMPTZ
  • UNIQUE(stock_id, — report_date,

ml_tft_predictions

  • id — BIGSERIAL
  • stock_id — BIGINT — 외래 키 → stocks.id — NOT NULL
  • report_date — DATE — NOT NULL
  • model_version — VARCHAR(20) — NOT NULL
  • group_id — VARCHAR(50)
  • prob — REAL — NOT NULL
  • pred — INT — NOT NULL
  • created_at — TIMESTAMPTZ
  • UNIQUE(stock_id, — report_date,

news_agent_stock_data

  • id — BIGSERIAL
  • stock_id — BIGINT — 외래 키 → stocks.id — NOT NULL
  • report_date — DATE — NOT NULL
  • top_keywords — JSONB — NOT NULL
  • sentiment — JSONB — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

news_keyword_map

  • news_id — BIGINT — 외래 키 → stock_news.id — NOT NULL
  • keyword_id — BIGINT — 외래 키 → keywords.id — NOT NULL

password_history

  • id — BIGSERIAL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • password_hash — VARCHAR(60) — NOT NULL
  • changed_at — TIMESTAMPTZ
  • changed_by — VARCHAR(10) — NOT NULL
  • ip_address — VARCHAR(45)

pipeline_signals

  • id — BIGSERIAL
  • signal_type — VARCHAR(50) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • retry_count — BIGINT — NOT NULL
  • created_at — TIMESTAMPTZ
  • processed_at — TIMESTAMPTZ

social_accounts

  • id — BIGSERIAL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • provider — VARCHAR(10) — NOT NULL
  • provider_account_id — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMPTZ
  • UNIQUE(provider, — provider_account_id)

stock_announcements

  • id — BIGSERIAL
  • stock_id — BIGINT — 외래 키 → stocks.id — NOT NULL
  • announced_at — DATE — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • url — VARCHAR(512)
  • content — TEXT
  • target_year — INT
  • has_financial_analysis — BOOLEAN
  • has_operating_profit — BOOLEAN
  • created_at — TIMESTAMPTZ

stock_dividend_yield_snapshots

  • id — BIGSERIAL
  • stock_id — BIGINT — 외래 키 → stocks.id — NOT NULL
  • as_of_date — DATE — NOT NULL
  • record_date — DATE
  • cash_dividend_yield — NUMERIC(10,4)
  • stock_dividend_yield — NUMERIC(10,4)
  • dividend_kind — VARCHAR(30)
  • source — VARCHAR(40) — NOT NULL
  • source_window_from — DATE — NOT NULL
  • source_window_to — DATE — NOT NULL
  • fetched_at — TIMESTAMPTZ — NOT NULL
  • is_latest — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

stock_financials

  • id — BIGSERIAL
  • stock_id — BIGINT — 외래 키 → stocks.id — NOT NULL
  • report_year — INT — NOT NULL
  • report_quarter — VARCHAR(10) — NOT NULL
  • total_assets — BIGINT
  • total_liabilities — BIGINT
  • total_equity — BIGINT
  • revenue — BIGINT
  • operating_profit — BIGINT
  • net_income — BIGINT
  • operating_cash_flow — BIGINT
  • per — REAL
  • pbr — REAL
  • roe — REAL
  • created_at — TIMESTAMPTZ

stock_news

  • id — BIGSERIAL
  • title — VARCHAR(255) — NOT NULL
  • snippet — TEXT
  • url — VARCHAR(512)
  • publisher — VARCHAR(20)
  • drive_file_id — VARCHAR(100)
  • published_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ

stock_news_map

  • stock_id — BIGINT — 외래 키 → stocks.id — NOT NULL
  • news_id — BIGINT — 외래 키 → stock_news.id — NOT NULL
  • sentiment_score — REAL
  • sentiment_label — VARCHAR(20)

stock_notifications

  • id — BIGSERIAL
  • stock_id — BIGINT — 외래 키 → stocks.id — NOT NULL
  • noti_type — VARCHAR(30) — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • message — VARCHAR(512)
  • related_link — VARCHAR(255)
  • created_at — TIMESTAMPTZ

stock_prices_daily

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • trade_date — DATE — 기본 키 — NOT NULL
  • stock_id — BIGINT — 외래 키 → stocks.id — NOT NULL
  • open_price — INT
  • high_price — INT
  • low_price — INT
  • close_price — INT — NOT NULL
  • volume — BIGINT
  • fluctuation_rate — REAL
  • created_at — TIMESTAMPTZ
  • UNIQUE(stock_id, — trade_date)

stock_prices_minute

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • trade_timestamp — TIMESTAMPTZ — 기본 키 — NOT NULL
  • stock_id — BIGINT — 외래 키 → stocks.id — NOT NULL
  • open_price — INT
  • high_price — INT
  • low_price — INT
  • close_price — INT — NOT NULL
  • volume — BIGINT
  • fluctuation_rate — REAL
  • created_at — TIMESTAMPTZ
  • UNIQUE(stock_id, — trade_timestamp)

stock_prices_monthly

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • trade_month — DATE — 기본 키 — NOT NULL
  • stock_id — BIGINT — 외래 키 → stocks.id — NOT NULL
  • open_price — INT
  • high_price — INT
  • low_price — INT
  • close_price — INT — NOT NULL
  • volume — BIGINT
  • fluctuation_rate — REAL
  • created_at — TIMESTAMPTZ
  • UNIQUE(stock_id, — trade_month)

stock_prices_weekly

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • trade_week — DATE — 기본 키 — NOT NULL
  • stock_id — BIGINT — 외래 키 → stocks.id — NOT NULL
  • open_price — INT
  • high_price — INT
  • low_price — INT
  • close_price — INT — NOT NULL
  • volume — BIGINT
  • fluctuation_rate — REAL
  • created_at — TIMESTAMPTZ
  • UNIQUE(stock_id, — trade_week)

stock_prices_yearly

  • id — BIGSERIAL
  • stock_id — BIGINT — 외래 키 → stocks.id — NOT NULL
  • trade_year — INT — NOT NULL
  • open_price — INT
  • high_price — INT
  • low_price — INT
  • close_price — INT — NOT NULL
  • volume — BIGINT
  • fluctuation_rate — REAL
  • created_at — TIMESTAMPTZ
  • UNIQUE(stock_id, — trade_year)

stocks

  • id — BIGSERIAL
  • ticker — VARCHAR(6) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • gics_sector — VARCHAR(50)
  • category — VARCHAR(50)
  • outstanding_shares — BIGINT
  • market_type — VARCHAR(20)
  • icon_url — VARCHAR(500) — 종목
  • is_active — BOOLEAN
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

terms

  • id — BIGSERIAL
  • term_type — VARCHAR(30) — NOT NULL
  • version — VARCHAR(20) — NOT NULL
  • title — VARCHAR(50) — NOT NULL
  • content — TEXT — NOT NULL
  • is_required — BOOLEAN
  • is_active — BOOLEAN
  • enforced_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ

user_agreements

  • id — BIGSERIAL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • terms_id — BIGINT — 외래 키 → terms.id — NOT NULL
  • is_agreed — BOOLEAN — NOT NULL
  • agreed_at — TIMESTAMPTZ

user_notifications

  • id — BIGSERIAL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • notification_id — BIGINT — 외래 키 → stock_notifications.id — NOT NULL
  • is_read — BOOLEAN
  • created_at — TIMESTAMPTZ

user_watchlist

  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • stock_id — BIGINT — 외래 키 → stocks.id — NOT NULL
  • is_noti_enabled — BOOLEAN
  • created_at — TIMESTAMPTZ

users

  • id — BIGSERIAL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(60)
  • nickname — VARCHAR(20) — NOT NULL
  • profile_image_url — VARCHAR(512)
  • is_email_opt_in — BOOLEAN
  • is_noti_enabled — BOOLEAN — NOT NULL
  • status — VARCHAR(20)
  • admin — BOOLEAN
  • token_version — INT
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • withdrawn_at — TIMESTAMPTZ
  • deleted_at — TIMESTAMPTZ