토스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