개인프로젝트_증권

테이블 (16)

comment_likes

  • id — BIGSERIAL
  • comment_id — BIGINT — 외래 키 → comments.id — NOT NULL
  • user_id — UUID — 외래 키 → users.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

comments

  • id — BIGSERIAL
  • post_id — BIGINT — 외래 키 → posts.id — NOT NULL
  • user_id — UUID — 외래 키 → users.id — NOT NULL
  • parent_id — BIGINT — 외래 키 → comments.id
  • content — VARCHAR(2000) — NOT NULL
  • like_count — INTEGER — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

kafka_dead_letters

  • id — BIGSERIAL
  • topic — VARCHAR(100) — NOT NULL
  • partition_no — INTEGER — NOT NULL
  • offset_no — BIGINT — NOT NULL
  • payload — JSONB — NOT NULL
  • error_message — TEXT
  • retry_count — SMALLINT — NOT NULL
  • is_resolved — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • resolved_at — TIMESTAMPTZ

portfolio_holdings

  • id — BIGSERIAL
  • portfolio_id — BIGINT — 외래 키 → portfolios.id — NOT NULL
  • stock_code — VARCHAR(20) — 외래 키 → stocks.code — NOT NULL
  • quantity — INTEGER — NOT NULL
  • average_buy_price — NUMERIC(15, 2) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

portfolios

  • id — BIGSERIAL
  • user_id — UUID — 외래 키 → users.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(500)
  • is_public — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

post_likes

  • id — BIGSERIAL
  • post_id — BIGINT — 외래 키 → posts.id — NOT NULL
  • user_id — UUID — 외래 키 → users.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

posts

  • id — BIGSERIAL
  • user_id — UUID — 외래 키 → users.id — NOT NULL
  • stock_code — VARCHAR(20) — 외래 키 → stocks.code
  • title — VARCHAR(300) — NOT NULL
  • content — TEXT — NOT NULL
  • view_count — INTEGER — NOT NULL
  • like_count — INTEGER — NOT NULL
  • comment_count — INTEGER — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

price_alerts

  • id — BIGSERIAL
  • user_id — UUID — 외래 키 → users.id — NOT NULL
  • stock_code — VARCHAR(20) — 외래 키 → stocks.code — NOT NULL
  • alert_type — VARCHAR(20) — NOT NULL
  • target_price — NUMERIC(15, 2) — NOT NULL
  • is_triggered — BOOLEAN — NOT NULL — TRUE:
  • is_active — BOOLEAN — NOT NULL
  • triggered_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

stock_prices

  • recorded_at — TIMESTAMPTZ — 기본 키 — NOT NULL — 파티션
  • id — BIGSERIAL
  • stock_code — VARCHAR(20) — 외래 키 → stocks.code — NOT NULL
  • price — NUMERIC(15, 2) — NOT NULL
  • volume — BIGINT — NOT NULL
  • change_rate — NUMERIC(6, 2)
  • source — VARCHAR(20) — NOT NULL

stock_prices_2026_03

  • 2026-03-01) — TO

stock_prices_2026_04

  • 2026-04-01) — TO

stock_view_stats

  • id — BIGSERIAL
  • stock_code — VARCHAR(20) — 외래 키 → stocks.code — NOT NULL
  • view_count — BIGINT — NOT NULL
  • search_count — BIGINT — NOT NULL
  • stat_date — DATE — NOT NULL

stocks

  • code — VARCHAR(20)
  • name — VARCHAR(100) — NOT NULL
  • market — VARCHAR(10) — NOT NULL — KOSPI
  • sector — VARCHAR(50)
  • industry — VARCHAR(100)
  • listing_date — DATE
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

trade_events

  • id — BIGSERIAL
  • stock_code — VARCHAR(20) — 외래 키 → stocks.code — NOT NULL
  • trade_type — VARCHAR(10) — NOT NULL
  • price — NUMERIC(15, 2) — NOT NULL
  • quantity — INTEGER — NOT NULL
  • traded_at — TIMESTAMPTZ — NOT NULL
  • kafka_offset — BIGINT

users

  • id — UUID
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • profile_image — VARCHAR(500)
  • role — VARCHAR(20) — NOT NULL
  • is_active — BOOLEAN — NOT NULL — FALSE:
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • last_login_at — TIMESTAMPTZ

watchlists

  • id — BIGSERIAL
  • user_id — UUID — 외래 키 → users.id — NOT NULL
  • stock_code — VARCHAR(20) — 외래 키 → stocks.code — NOT NULL
  • display_order — SMALLINT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL