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)