Hardy-Plants_DB
Tables (4)
Company (회사)
- name (Key2) — VARCHAR(30) — Primary key — NOT NULL
- Stock_code (Key) — int(6) — Primary key — NOT NULL
- Sectors_code (Key3) — int(6) — Foreign key → Sectors.Sectors_code — NOT NULL
News (뉴스)
- url (Key) — VARCHAR(100) — Primary key — NOT NULL
- ESG (Field) — VARCHAR(1)
- emotion (Field2) — bool
- date (Field3) — datetime
- title (Field4) — VARCHAR(30)
- article (Field5) — mediumtext
- name (Key2) — VARCHAR(30) — Foreign key → Company.name — NOT NULL
- Stock_code (Key3) — int(6) — Foreign key → Company.Stock_code — NOT NULL
Sectors (업종)
- Sectors_code (Key) — int(6) — Primary key — NOT NULL
- Sector_name (Field) — VARCHAR(30)
Stock (주가데이터)
- trading (Field) — int(11)
- closing (Field3) — int(11)
- Prior (Field4) — int(11)
- high (Field5) — int(11)
- low (Field6) — int(11)
- market (Field7) — int(11)
- date (Field2) — datetime
- Stock_code (Key) — int(6) — Foreign key → Company.Stock_code — NOT NULL