khuthon2024

Tables (3)

Article (기사)

  • article_id (Key) — BIGINT — Primary key — NOT NULL
  • result_id (Key2) — BIGINT — Foreign key → Result.result_id — NOT NULL
  • url — TEXT

ESG (esg)

  • esg_id (Key) — BIGINT — Primary key — NOT NULL
  • result_id (Key2) — BIGINT — Foreign key → Result.result_id — NOT NULL
  • keyword (Field) — VARCHAR(45)
  • context (내용) — TEXT

Result (result)

  • result_id (Key) — BIGINT — Primary key — NOT NULL
  • companName (회사이름) — VARCHAR(100)
  • productName (제품명) — VARCHAR(100)
  • Mark (Field) — BOOLEAN
  • Grade (ESG등급) — VARCHAR(10)
  • Environment (환경) — VARCHAR(10)
  • Social (사회) — VARCHAR(10)
  • Governance (지배구조) — VARCHAR(10)
  • Result (결과) — VARCHAR(10)