살라말래 주식 위원회
테이블 (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