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