토스3

테이블 (16)

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

candles

  • id — BIGSERIAL — 기본 키 — 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)
  • candle_time — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ
  • UNIQUE(stock_code, — timeframe,

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
  • UNIQUE(report_date, — rank)

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

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

orderbooks

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • stock_code — TEXT — 외래 키 → stocks.stock_code — NOT NULL
  • ask_prices — NUMERIC
  • ask_volumes — NUMERIC
  • bid_prices — NUMERIC
  • bid_volumes — NUMERIC
  • total_ask — NUMERIC(18,2)
  • total_bid — NUMERIC(18,2)
  • timestamp — TIMESTAMPTZ — NOT NULL
  • created_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

profiles

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

quotes

  • id — BIGSERIAL — 기본 키 — 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)
  • timestamp — TIMESTAMPTZ — NOT NULL
  • created_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

signals

  • id — UUID — 기본 키 — NOT NULL
  • 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
  • created_at — TIMESTAMPTZ

stocks

  • stock_code — TEXT — 기본 키 — NOT NULL
  • stock_name — TEXT — NOT NULL
  • market — TEXT — NOT NULL
  • sector — TEXT
  • listed_shares — BIGINT
  • updated_at — TIMESTAMPTZ
  • created_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)
  • quantity — INTEGER
  • 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

users

  • id — UUID — 외래 키 → users.id — NOT NULL
  • email — TEXT — NOT NULL
  • nickname — TEXT
  • created_at — TIMESTAMPTZ
  • updated_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

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
  • UNIQUE(user_id, — stock_code)