개인프로젝트_증권
테이블 (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