삼정 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