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