pp

Tables (9)

calendar_event

  • calendar_id — BIGINT — Primary key — NOT NULL
  • stock_id — INT — Foreign key → stock.stock_id — 종목 관련 일정만 값 존재, 나머지는 NULL
  • event_name — VARCHAR(200) — NOT NULL
  • event_type — enum — NOT NULL — 경제지표/실적발표/배당락/휴장일 등
  • event_datetime — DATETIME — NOT NULL
  • country — VARCHAR(20)
  • importance (중요도(별점?)) — int — 경제지표 전용, 상/중/하
  • previous_value — VARCHAR(50) — 경제지표 전용

industry

  • industry_id — INT — Primary key — NOT NULL
  • industry_name (sector_name) — VARCHAR(100) — NOT NULL

market

  • market_id — INT — Primary key — NOT NULL
  • market_code — VARCHAR(20) — NOT NULL — 예: KOSPI, KOSDAQ, NASDAQ
  • market_name — VARCHAR(50) — NOT NULL
  • status (앱장, 본장등) — enum

market_metric

  • id — BIGINT — Primary key — NOT NULL
  • market_id — INT — Foreign key → market.market_id — 지수(INDEX)만 market 연결, 환율/유가는 NULL
  • metric_type (지수, 환율, 유가) — enum — NOT NULL — INDEX/EXCHANGE_RATE/OIL
  • metric_name — VARCHAR(30) — NOT NULL — 예: KOSPI, USD/KRW, WTI
  • price_datetime — DATETIME — NOT NULL
  • value — DECIMAL(18, 4) — NOT NULL
  • change_rate (변화율) — DECIMAL(6, 2)

news

  • news_id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(300) — NOT NULL
  • source — VARCHAR(100)
  • published_at — DATETIME — NOT NULL
  • url — VARCHAR(500)
  • content — VARCHAR(1000) — 시황요약처럼 자체 본문이 필요한 경우

news_stock

  • news_id — BIGINT — Foreign key → news.news_id — NOT NULL
  • stock_id — INT — Foreign key → stock.stock_id — NOT NULL

stock

  • stock_id — INT — Primary key — NOT NULL
  • market_id — INT — Foreign key → market.market_id — NOT NULL — 상장 시장
  • symbol (티커 이름) — VARCHAR(20) — NOT NULL
  • name_kr — VARCHAR(100) — NOT NULL
  • name_en — VARCHAR(100)
  • listed_date — DATE
  • delisted_date — DATE
  • is_active — BOOLEAN — NOT NULL

stock_industry (Untitled)

  • stock_industry_id (Key) — INT — Primary key — NOT NULL
  • industry_id — INT — Foreign key → industry.industry_id — NOT NULL
  • stock_id — INT — Foreign key → stock.stock_id — NOT NULL

stock_price

  • id — BIGINT — Primary key — NOT NULL
  • stock_id — INT — Foreign key → stock.stock_id — NOT NULL
  • price_date — DATE — NOT NULL — 시세 기준일 (매매기록 아님)
  • open_price — DECIMAL(18, 2)
  • high_price — DECIMAL(18, 2)
  • low_price — DECIMAL(18, 2)
  • close_price — DECIMAL(18, 2)
  • volume (거래량) — BIGINT
  • change_rate — DECIMAL(6, 2)