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