삼정 KPMG 최종 프로젝트 초안

테이블 (7)

chunk

  • id (Key) — INT, AI — 기본 키 — NOT NULL
  • page_no (Field) — INT
  • text (Field2) — LONGTEXT
  • created_at (Field3) — DATETIME, now
  • report_id (Key2) — INT, AI — 외래 키 → report.id — NOT NULL

company

  • id (Key) — INT, AI, Not Null — 기본 키 — NOT NULL
  • name (Field) — VARCHAR(255)
  • sector (Field2) — VARCHAR(255)
  • created_at (Field3) — DATETIME, default now
  • updated_at (Field4) — DATETIME, nullable

evidence

  • id (Key) — INT, AI — 기본 키 — NOT NULL
  • page_no (Field) — INT, nullable
  • quote (Field2) — TEXT
  • created_at (Field3) — DATETIME, now
  • mapping_id (Key2) — INT, AI — 외래 키 → mapping.id — NOT NULL
  • chunk_id (Key3) — INT, AI — 외래 키 → chunk.id — NOT NULL

indicator

  • id (Key) — INT, AI — 기본 키 — NOT NULL
  • framework (Field) — ENUM: 'META', 'CORE', 'GRI', 'ISSB', 'KSSB', 'ESRS', 'TCFD', 'SASB', 'SEC'
  • code (Field2) — VARCHAR(255)
  • name (Field3) — VARCHAR(255)
  • description (Field4) — TEXT, nullable
  • category (Field5) — ENUM: 'E', 'S', 'G'

mapping

  • id (Key) — INT, AI — 기본 키 — NOT NULL
  • status (Field) — ENUM: 'MEETS', 'PARTIAL', 'MISSSING'
  • score (Field2) — DECIMAL(5, 2), nullable
  • source (Field3) — ENUM: 'summary', 'CHUNK'
  • source_ref_id (Field4) — INT, nullable
  • created_at (Field5) — DATETIME, now
  • report_id (Key2) — INT, AI — 외래 키 → report.id — NOT NULL
  • indicator_id (Key3) — INT, AI — 외래 키 → indicator.id — NOT NULL
  • note (Field6) — TEXT // 지표 부족 사유

report

  • id (Key) — INT, AI — 기본 키 — NOT NULL
  • title (Field) — VARCHAR(255)
  • report_year (Field2) — INT
  • file_path (Field3) — VARCHAR(255)
  • status (Field4) — (ENUM: uploaded, parsed, summarized, mapped, exported)
  • created_at (Field5) — DATETIME, now
  • updated_at (Field6) — DATETIME, nullable
  • company_id (Key2) — INT(20), AI — 외래 키 → company.id — NOT NULL

summary

  • id (Key) — INT, AI — 기본 키 — NOT NULL
  • category (Field) — ENUM: 'E', 'S', 'G'
  • text (Field2) — TEXT
  • confidence (Field3) — DECIMAL(4, 3), nullable
  • created_at (Field4) — DATETIME, now
  • report_id (Key2) — INT, AI — 외래 키 → report.id — NOT NULL