mine
Tables (10)
calendar_event
- calendar_id — BIGINT — Primary key — NOT NULL
- stock_id — INT — Foreign key → stock.stock_id
- event_name — VARCHAR(200) — NOT NULL
- event_datetime — DATETIME — NOT NULL
- actual_value — VARCHAR(50)
industry (산업)
- industry_id — INT — Primary key — NOT NULL
- industry_name (name) — varchar(50)
market
- market_id — INT — Primary key — NOT NULL
- market_name — enum — NOT NULL
- market_code — enum
market_index
- id — BIGINT — Primary key — NOT NULL
- market_id — INT — Foreign key → market.market_id — NOT NULL
- price_datetime — DATETIME — NOT NULL
- value — DECIMAL(18, 4) — NOT NULL
- change_rate — DECIMAL(6, 2)
market_indicator
- market_indicator_id — INT — Primary key — NOT NULL
- indicator_type — enum
- price_datetime — DATETIME
- value — DECIMAL(18, 4)
- change_rate — DECIMAL(18, 4)
news
- news_id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(300) — NOT NULL
- source — VARCHAR(100)
- published_at — DATETIME — NOT NULL
- url — VARCHAR(500)
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
- ticker (티커) — 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_daily_price
- stock_daily_price_id — INT — 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)
stock_industry
- Key — Primary key — NOT NULL
- industry_id — INT — Foreign key → industry.industry_id — NOT NULL
- stock_id — INT — Foreign key → stock.stock_id — NOT NULL