토스6

테이블 (16)

alerts

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

candles

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • stock_code — VARCHAR(20) — 외래 키 → stocks.stock_code — NOT NULL
  • timeframe — VARCHAR(10) — NOT NULL
  • open — NUMERIC — NOT NULL
  • high — NUMERIC — NOT NULL
  • low — NUMERIC — NOT NULL
  • close — NUMERIC — NOT NULL
  • volume — BIGINT
  • trading_value — NUMERIC
  • 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 — VARCHAR(20) — 외래 키 → stocks.stock_code — NOT NULL
  • stock_name — VARCHAR(100)
  • score — NUMERIC
  • reasons — JSONB
  • status — VARCHAR(20)
  • 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 — VARCHAR(20)
  • 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 — VARCHAR(20) — 외래 키 → stocks.stock_code
  • title — TEXT — NOT NULL
  • source — VARCHAR(50)
  • url — TEXT
  • content — TEXT
  • keywords — TEXT
  • published_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ

orderbooks

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • stock_code — VARCHAR(20) — 외래 키 → stocks.stock_code — NOT NULL
  • ask_prices — NUMERIC
  • ask_volumes — NUMERIC
  • bid_prices — NUMERIC
  • bid_volumes — NUMERIC
  • total_ask — NUMERIC
  • total_bid — NUMERIC
  • timestamp — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ

price_breakouts

  • id — UUID — 기본 키 — NOT NULL
  • stock_code — VARCHAR(20) — 외래 키 → stocks.stock_code — NOT NULL
  • breakout_type — VARCHAR(20) — NOT NULL
  • reference_price — NUMERIC — NOT NULL
  • current_price — NUMERIC — 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 — VARCHAR(20) — 외래 키 → stocks.stock_code — NOT NULL
  • price — NUMERIC — NOT NULL
  • open_price — NUMERIC
  • high_price — NUMERIC
  • low_price — NUMERIC
  • volume — BIGINT
  • trading_value — NUMERIC
  • change_rate — NUMERIC
  • bid_price — NUMERIC
  • ask_price — NUMERIC
  • timestamp — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ

settings

  • id — UUID — 기본 키 — NOT NULL
  • user_id — UUID — 외래 키 → users.id — NOT NULL
  • max_daily_loss — NUMERIC
  • risk_per_trade — NUMERIC
  • profit_target — NUMERIC
  • stop_loss — NUMERIC
  • discord_webhook — TEXT
  • slack_webhook — TEXT
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

signals

  • id — UUID — 기본 키 — NOT NULL
  • stock_code — VARCHAR(20) — 외래 키 → stocks.stock_code — NOT NULL
  • signal_type — VARCHAR(30) — NOT NULL
  • signal_time — TIMESTAMPTZ — NOT NULL
  • price — NUMERIC
  • reference_price — NUMERIC
  • strength — NUMERIC
  • reason — TEXT
  • is_triggered — BOOLEAN
  • created_at — TIMESTAMPTZ

stocks

  • stock_code — VARCHAR(20) — 기본 키 — NOT NULL
  • stock_name — VARCHAR(100) — NOT NULL
  • market — VARCHAR(20) — NOT NULL
  • sector — VARCHAR(50)
  • listed_shares — BIGINT
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

trade_logs

  • id — UUID — 기본 키 — NOT NULL
  • user_id — UUID — 외래 키 → users.id — NOT NULL
  • stock_code — VARCHAR(20) — 외래 키 → stocks.stock_code — NOT NULL
  • trade_type — VARCHAR(10) — NOT NULL
  • order_type — VARCHAR(10)
  • price — NUMERIC
  • quantity — INTEGER
  • total_amount — NUMERIC
  • fee — NUMERIC
  • profit_rate — NUMERIC
  • 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 — VARCHAR(20) — 외래 키 → stocks.stock_code — NOT NULL
  • current_value — NUMERIC — NOT NULL
  • avg_value_5d — NUMERIC — NOT NULL
  • spike_ratio — NUMERIC — NOT NULL
  • detected_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ

watchlists

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