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