Company_DB

Tables (6)

Company (회사)

  • Stock_code (Key) — VARCHAR(6) — Primary key — NOT NULL
  • name (Field2) — VARCHAR(30) — NOT NULL
  • report_link (Field) — VARCHAR(255)
  • E_score (Field3) — Float(4)
  • S_score (Field4) — Float(4)
  • G_score (Field5) — Float(4)
  • sector_code (Field7) — int(3) — Foreign key → Sectors.sector_code

News (뉴스)

  • id (Key2) — int — Primary key — NOT NULL
  • press (Field) — VARCHAR(10)
  • Writer (Field11) — VARCHAR(30)
  • createdAt (Field3) — datetime
  • quarter (Field2) — VARCHAR(10)
  • title (Field4) — VARCHAR(30)
  • contents (Field5) — mediumtext
  • url (Field6) — VARCHAR(255)
  • E (Field7) — VARCHAR(2)
  • S (Field8) — VARCHAR(2)
  • G (Field9) — VARCHAR(2)
  • Tag (Field10) — VARCHAR(255)
  • Stock_code (Key) — VARCHAR(6) — Foreign key → Company.Stock_code — NOT NULL

Sectors (업종)

  • sector_code (Field) — int(3) — Primary key
  • E_score (Field2) — Float(4)
  • S_score (Field3) — Float(4)
  • G_score (Field4) — Float(4)
  • Sector_name (key) — VARCHAR(40)

report (Untitled2)

  • year (Field2) — int(4)
  • KCGS_sum (Field3) — VARCHAR(2)
  • 한국ESG연구소 (Field4) — VARCHAR(2)
  • 서스틴베스트 (Field5) — VARCHAR(2)
  • moodys (Field6) — int(3)
  • S&P (Field7) — int(3)
  • 공시여부 (Field8) — bool
  • MSCI (Field9) — VARCHAR(2)
  • KCGS_E (Field10) — VARCHAR(2)
  • KCGS_S (Field11) — VARCHAR(2)
  • KCGS_G (Field12) — VARCHAR(2)
  • Stock_code (Key) — VARCHAR(6) — Foreign key → Company.Stock_code — NOT NULL

stock (태블로용)

  • createdAt (Field3) — datetime
  • alpha (Field4) — Float(4)
  • beta (Field5) — Float(4)
  • x_return (Field6) — Float(4)
  • m_return (Field7) — Float(4)
  • SP500 (Field8) — Float(4)
  • CAR0 (Field9) — Float(4)
  • CAR (Field10) — Float(4)
  • Stock_code (Key) — VARCHAR(6) — Foreign key → Company.Stock_code — NOT NULL

word_count (Untitled)

  • quarter (Field2) — VARCHAR(7)
  • token (Field3) — VARCHAR(20)
  • Count (Field4) — int(3)
  • sector_code (Field5) — int(3) — Foreign key → Sectors.sector_code