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