토스10

테이블 (30)

alert_deliveries

  • id — UUID — 기본 키 — NOT NULL
  • alert_id — UUID — 외래 키 → alerts.id — NOT NULL
  • channel — TEXT — NOT NULL
  • status — TEXT — NOT NULL
  • response — TEXT
  • sent_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ

alerts

  • id — UUID — 기본 키 — NOT NULL
  • user_id — UUID — 외래 키 → users.id — NOT NULL
  • signal_id — UUID — 외래 키 → signals.id
  • stock_code — TEXT — 외래 키 → stocks.stock_code
  • title — TEXT — NOT NULL
  • message — TEXT
  • channel — TEXT
  • is_read — BOOLEAN
  • is_sent — BOOLEAN
  • payload — JSONB
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • created_by — UUID
  • updated_by — UUID

candles

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • candle_time — TIMESTAMPTZ — 기본 키 — NOT NULL
  • stock_code — TEXT — 외래 키 → stocks.stock_code — NOT NULL
  • timeframe — TEXT — NOT NULL
  • open — NUMERIC(18,2) — NOT NULL
  • high — NUMERIC(18,2) — NOT NULL
  • low — NUMERIC(18,2) — NOT NULL
  • close — NUMERIC(18,2) — NOT NULL
  • volume — BIGINT
  • trading_value — NUMERIC(18,2)
  • created_at — TIMESTAMPTZ
  • UNIQUE(stock_code, — timeframe,

candles_default

    daily_reports

    • id — UUID — 기본 키 — NOT NULL
    • report_date — DATE — NOT NULL
    • rank — INTEGER — NOT NULL
    • stock_code — TEXT — 외래 키 → stocks.stock_code — NOT NULL
    • stock_name — TEXT
    • score — NUMERIC(5,2)
    • reasons — JSONB
    • status — TEXT
    • result_summary — TEXT
    • created_at — TIMESTAMPTZ
    • updated_at — TIMESTAMPTZ
    • created_by — UUID
    • updated_by — UUID

    daily_top_10

    • id — UUID — 기본 키 — NOT NULL
    • screen_date — DATE — NOT NULL
    • user_id — UUID — 외래 키 → users.id — NOT NULL
    • rank — INTEGER — NOT NULL
    • stock_code — TEXT — 외래 키 → stocks.stock_code — NOT NULL
    • stock_name — TEXT
    • score — NUMERIC(5,2)
    • volume_ratio — NUMERIC(6,2)
    • change_rate — NUMERIC(6,2)
    • selected_by — UUID — 외래 키 → screening_criteria.id
    • reasons — JSONB
    • is_focus — BOOLEAN
    • focus_rank — INTEGER
    • status — TEXT
    • created_at — TIMESTAMPTZ
    • updated_at — TIMESTAMPTZ
    • UNIQUE(screen_date, — user_id,

    exchanges

    • exchange_code — TEXT — 기본 키 — NOT NULL
    • exchange_name — TEXT — NOT NULL
    • country — TEXT
    • created_at — TIMESTAMPTZ
    • updated_at — TIMESTAMPTZ
    • created_by — UUID
    • updated_by — UUID

    journals

    • id — UUID — 기본 키 — NOT NULL
    • user_id — UUID — 외래 키 → users.id — NOT NULL
    • trade_id — UUID — 외래 키 → trade_logs.id
    • emotion — TEXT
    • entry_reason — TEXT
    • exit_reason — TEXT
    • lesson — TEXT
    • score — INTEGER
    • ai_summary — TEXT
    • created_at — TIMESTAMPTZ
    • updated_at — TIMESTAMPTZ
    • created_by — UUID
    • updated_by — UUID

    live_focus_5

    • id — UUID — 기본 키 — NOT NULL
    • stock_code — TEXT — 외래 키 → stocks.stock_code — NOT NULL
    • user_id — UUID — 외래 키 → users.id — NOT NULL
    • focus_date — DATE — NOT NULL
    • focus_rank — INTEGER — NOT NULL
    • entered_at — TIMESTAMPTZ — NOT NULL
    • exited_at — TIMESTAMPTZ
    • entry_price — NUMERIC(18,2)
    • entry_reason — TEXT
    • exit_reason — TEXT
    • current_price — NUMERIC(18,2)
    • max_price — NUMERIC(18,2)
    • min_price — NUMERIC(18,2)
    • unrealized_pnl_rate — NUMERIC(6,2)
    • signal_count — INTEGER
    • is_active — BOOLEAN
    • created_at — TIMESTAMPTZ
    • updated_at — TIMESTAMPTZ
    • UNIQUE(focus_date, — user_id,

    news

    • id — UUID — 기본 키 — NOT NULL
    • stock_code — TEXT — 외래 키 → stocks.stock_code
    • title — TEXT — NOT NULL
    • source — TEXT
    • url — TEXT
    • content — TEXT
    • keywords — TEXT
    • published_at — TIMESTAMPTZ
    • created_at — TIMESTAMPTZ
    • updated_at — TIMESTAMPTZ
    • created_by — UUID
    • updated_by — UUID

    orderbook_levels

    • snapshot_id — BIGINT — 기본 키 — NOT NULL
    • level — INTEGER — 기본 키 — NOT NULL
    • id — BIGSERIAL
    • bid_price — NUMERIC(18,2)
    • bid_volume — NUMERIC(18,2)
    • ask_price — NUMERIC(18,2)
    • ask_volume — NUMERIC(18,2)
    • created_at — TIMESTAMPTZ

    orderbook_snapshots

    • id — BIGSERIAL — 기본 키 — NOT NULL
    • timestamp — TIMESTAMPTZ — 기본 키 — NOT NULL
    • stock_code — TEXT — 외래 키 → stocks.stock_code — NOT NULL
    • total_bid — NUMERIC(18,2)
    • total_ask — NUMERIC(18,2)
    • created_at — TIMESTAMPTZ

    orderbook_snapshots_default

      pool_transition_log

      • id — UUID — 기본 키 — NOT NULL
      • stock_code — TEXT — 외래 키 → stocks.stock_code — NOT NULL
      • from_pool — TEXT — NOT NULL
      • to_pool — TEXT — NOT NULL
      • transition_time — TIMESTAMPTZ — NOT NULL
      • reason — TEXT
      • score_at_transition — NUMERIC(5,2)
      • created_at — TIMESTAMPTZ

      positions

      • id — UUID — 기본 키 — NOT NULL
      • user_id — UUID — 외래 키 → users.id — NOT NULL
      • stock_code — TEXT — 외래 키 → stocks.stock_code — NOT NULL
      • quantity — INTEGER — NOT NULL
      • avg_price — NUMERIC(18,2) — NOT NULL
      • entry_time — TIMESTAMPTZ — NOT NULL
      • exit_time — TIMESTAMPTZ
      • exit_price — NUMERIC(18,2)
      • realized_pnl — NUMERIC(18,2)
      • is_open — BOOLEAN
      • created_at — TIMESTAMPTZ
      • updated_at — TIMESTAMPTZ
      • created_by — UUID
      • updated_by — UUID

      price_breakouts

      • id — UUID — 기본 키 — NOT NULL
      • stock_code — TEXT — 외래 키 → stocks.stock_code — NOT NULL
      • breakout_type — TEXT — NOT NULL
      • reference_price — NUMERIC(18,2) — NOT NULL
      • current_price — NUMERIC(18,2) — NOT NULL
      • detected_at — TIMESTAMPTZ — NOT NULL
      • created_at — TIMESTAMPTZ
      • updated_at — TIMESTAMPTZ
      • created_by — UUID
      • updated_by — UUID

      profiles

      • id — UUID — 외래 키 → users.id — NOT NULL
      • nickname — TEXT
      • avatar_url — TEXT
      • alert_channel — TEXT
      • created_at — TIMESTAMPTZ
      • updated_at — TIMESTAMPTZ
      • created_by — UUID
      • updated_by — UUID

      quotes

      • id — BIGSERIAL — 기본 키 — NOT NULL
      • timestamp — TIMESTAMPTZ — 기본 키 — NOT NULL
      • stock_code — TEXT — 외래 키 → stocks.stock_code — NOT NULL
      • price — NUMERIC(18,2) — NOT NULL
      • open_price — NUMERIC(18,2)
      • high_price — NUMERIC(18,2)
      • low_price — NUMERIC(18,2)
      • volume — BIGINT
      • trading_value — NUMERIC(18,2)
      • change_rate — NUMERIC(6,2)
      • bid_price — NUMERIC(18,2)
      • ask_price — NUMERIC(18,2)
      • created_at — TIMESTAMPTZ

      quotes_default

        risk_events

        • id — UUID — 기본 키 — NOT NULL
        • user_id — UUID — 외래 키 → users.id — NOT NULL
        • event_type — TEXT — NOT NULL
        • threshold_value — NUMERIC(18,2)
        • actual_value — NUMERIC(18,2)
        • message — TEXT
        • created_at — TIMESTAMPTZ

        screening_criteria

        • id — UUID — 기본 키 — NOT NULL
        • user_id — UUID — 외래 키 → users.id — NOT NULL
        • name — TEXT — NOT NULL
        • description — TEXT
        • conditions — JSONB — NOT NULL
        • priority — INTEGER
        • weight — NUMERIC(5,2)
        • is_active — BOOLEAN
        • created_at — TIMESTAMPTZ
        • updated_at — TIMESTAMPTZ
        • created_by — UUID
        • updated_by — UUID

        screening_execution_log

        • id — UUID — 기본 키 — NOT NULL
        • user_id — UUID — 외래 키 → users.id — NOT NULL
        • execution_date — DATE — NOT NULL
        • execution_time — TIMESTAMPTZ — NOT NULL
        • criteria_used — UUID — NOT NULL
        • total_scanned — INTEGER — NOT NULL
        • passed_count — INTEGER — NOT NULL
        • selected_count — INTEGER — NOT NULL
        • duration_ms — INTEGER
        • error_message — TEXT
        • created_at — TIMESTAMPTZ

        security_types

        • type_code — TEXT — 기본 키 — NOT NULL
        • type_name — TEXT — NOT NULL
        • created_at — TIMESTAMPTZ
        • updated_at — TIMESTAMPTZ
        • created_by — UUID
        • updated_by — UUID

        settings

        • id — UUID — 기본 키 — NOT NULL
        • user_id — UUID — 외래 키 → users.id — NOT NULL
        • max_daily_loss — NUMERIC(18,2)
        • risk_per_trade — NUMERIC(5,2)
        • profit_target — NUMERIC(5,2)
        • stop_loss — NUMERIC(5,2)
        • discord_webhook — TEXT
        • slack_webhook — TEXT
        • created_at — TIMESTAMPTZ
        • updated_at — TIMESTAMPTZ
        • created_by — UUID
        • updated_by — UUID

        signals

        • id — UUID — 기본 키 — NOT NULL
        • user_id — UUID — 외래 키 → users.id
        • stock_code — TEXT — 외래 키 → stocks.stock_code — NOT NULL
        • signal_type — TEXT — NOT NULL
        • signal_time — TIMESTAMPTZ — NOT NULL
        • price — NUMERIC(18,2)
        • reference_price — NUMERIC(18,2)
        • strength — NUMERIC(5,2)
        • reason — TEXT
        • is_triggered — BOOLEAN
        • triggered_at — TIMESTAMPTZ
        • created_at — TIMESTAMPTZ
        • updated_at — TIMESTAMPTZ
        • created_by — UUID
        • updated_by — UUID

        stocks

        • stock_code — TEXT — 기본 키 — NOT NULL
        • stock_name — TEXT — NOT NULL
        • exchange_code — TEXT — 외래 키 → exchanges.exchange_code — NOT NULL
        • security_type_code — TEXT — 외래 키 → security_types.type_code — NOT NULL
        • sector — TEXT
        • listed_shares — BIGINT
        • created_at — TIMESTAMPTZ
        • updated_at — TIMESTAMPTZ
        • created_by — UUID
        • updated_by — UUID

        trade_logs

        • id — UUID — 기본 키 — NOT NULL
        • user_id — UUID — 외래 키 → users.id — NOT NULL
        • stock_code — TEXT — 외래 키 → stocks.stock_code — NOT NULL
        • trade_type — TEXT — NOT NULL
        • order_type — TEXT
        • price — NUMERIC(18,2) — NOT NULL
        • quantity — INTEGER — NOT NULL
        • total_amount — NUMERIC(18,2)
        • fee — NUMERIC(18,2)
        • profit_rate — NUMERIC(6,2)
        • is_simulated — BOOLEAN
        • memo — TEXT
        • traded_at — TIMESTAMPTZ
        • created_at — TIMESTAMPTZ
        • updated_at — TIMESTAMPTZ
        • created_by — UUID
        • updated_by — UUID

        users

        • id — UUID — 외래 키 → users.id — NOT NULL
        • email — TEXT — NOT NULL
        • nickname — TEXT
        • created_at — TIMESTAMPTZ
        • updated_at — TIMESTAMPTZ
        • created_by — UUID
        • updated_by — UUID

        volume_spikes

        • id — UUID — 기본 키 — NOT NULL
        • stock_code — TEXT — 외래 키 → stocks.stock_code — NOT NULL
        • current_value — NUMERIC(18,2) — NOT NULL
        • avg_value_5d — NUMERIC(18,2) — NOT NULL
        • spike_ratio — NUMERIC(10,2) — NOT NULL
        • detected_at — TIMESTAMPTZ — NOT NULL
        • created_at — TIMESTAMPTZ
        • updated_at — TIMESTAMPTZ
        • created_by — UUID
        • updated_by — UUID

        watchlists

        • id — UUID — 기본 키 — NOT NULL
        • user_id — UUID — 외래 키 → users.id — NOT NULL
        • stock_code — TEXT — 외래 키 → stocks.stock_code — NOT NULL
        • is_active — BOOLEAN
        • alert_price_above — NUMERIC(18,2)
        • alert_price_below — NUMERIC(18,2)
        • alert_volume_ratio — NUMERIC(5,2)
        • alert_channels — TEXT
        • webhook_url — TEXT
        • memo — TEXT
        • created_at — TIMESTAMPTZ
        • updated_at — TIMESTAMPTZ
        • created_by — UUID
        • updated_by — UUID