Stock

Tables (5)

largeTheme (Untitled)

  • theme_name — varchar(100) — Primary key — NOT NULL
  • id — int — Primary key — NOT NULL — auto_increment

smallTheme (Untitled3)

  • small_theme — varchar(100) — Primary key — NOT NULL
  • theme_name — varchar(100) — Foreign key → largeTheme.theme_name — NOT NULL
  • Key — Foreign key → largeTheme.id — NOT NULL

stockInfo

  • stock_name — varchar(30) — Primary key — NOT NULL — 종목 이름
  • cir_num — int — NOT NULL — 상장 시장 구분
  • cir_num_per — double — NOT NULL — 종목코드(stockcode)
  • face_value — int — NOT NULL
  • market — varchar(10) — NOT NULL
  • num_stock — int — NOT NULL
  • stock_code — varchar(10) — NOT NULL

stockList

  • stock_name — varchar(30) — Primary key — NOT NULL — 종목 이름
  • market — varchar(10) — NOT NULL — 상장 시장 구분
  • ticker — varchar(15) — NOT NULL — 종목코드(stockcode)

themeList

  • stock_name — varchar(30) — Foreign key → stockList.stock_name — NOT NULL — 종목 이름
  • theme_name — varchar(100) — Foreign key → largeTheme.theme_name — NOT NULL
  • Key — Foreign key → largeTheme.id — NOT NULL