토스9

테이블 (20)

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
  • deleted_at — TIMESTAMPTZ

candles

  • id — BIGSERIAL
  • 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)
  • candle_time — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ
  • created_by — UUID
  • updated_by — UUID
  • deleted_at — TIMESTAMPTZ

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
  • deleted_at — TIMESTAMPTZ

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
  • deleted_at — TIMESTAMPTZ

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
  • deleted_at — TIMESTAMPTZ

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
  • deleted_at — TIMESTAMPTZ

orderbook_levels

  • id — BIGSERIAL
  • snapshot_id — BIGINT — 외래 키 → orderbook_snapshots.id — NOT NULL
  • level — INTEGER — NOT NULL
  • 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
  • stock_code — TEXT — 외래 키 → stocks.stock_code — NOT NULL
  • total_bid — NUMERIC(18,2)
  • total_ask — NUMERIC(18,2)
  • timestamp — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ
  • created_by — UUID
  • updated_by — UUID
  • deleted_at — TIMESTAMPTZ

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
  • deleted_at — TIMESTAMPTZ

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
  • deleted_at — TIMESTAMPTZ

quotes

  • id — BIGSERIAL
  • 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)
  • timestamp — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ
  • created_by — UUID
  • updated_by — UUID
  • deleted_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
  • deleted_at — TIMESTAMPTZ

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
  • deleted_at — TIMESTAMPTZ

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
  • deleted_at — TIMESTAMPTZ

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
  • deleted_at — TIMESTAMPTZ

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
  • deleted_at — TIMESTAMPTZ

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
  • deleted_at — TIMESTAMPTZ

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
  • deleted_at — TIMESTAMPTZ

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
  • deleted_at — TIMESTAMPTZ