ESG_skm
Tables (50)
ALARM
- id — BIGINT — Primary key — NOT NULL — 고유ID
- company_id — BIGINT — Foreign key → COMPANY.id — NOT NULL — 회사ID
- user_id — BIGINT — NOT NULL — 사용자ID
- type — VARCHAR(30) — NOT NULL — 알림 유형' COLLATE 'utf8mb4_unicode_ci
- title — VARCHAR(100) — NOT NULL — 일림 제목' COLLATE 'utf8mb4_unicode_ci
- content — VARCHAR(255) — NOT NULL — 알림 내용' COLLATE 'utf8mb4_unicode_ci
- is_read — TINYINT(1) — 읽음여부
- path — VARCHAR(255) — NOT NULL — 클릭시 이동 경로' COLLATE 'utf8mb4_unicode_ci
- meta_json — LONGTEXT — 추가 메타데이터' COLLATE 'utf8mb4_unicode_ci
- created_at — DATETIME — 등록일자
- updated_at — DATETIME — 수정일자
- delete_yn — TINYINT(1) — 삭제여부
- INDEX — `FK_ALARM_COMPANY`
CODE_MAP
- id — BIGINT — Primary key — NOT NULL — 중분류' COLLATE 'utf8mb4_unicode_ci
- code_use — BIGINT — NOT NULL — 소분류 코드' COLLATE 'utf8mb4_unicode_ci
- code_nm — VARCHAR(20) — NOT NULL — 소분류' COLLATE 'utf8mb4_unicode_ci
- created_at — DATETIME — 세분류 코드' COLLATE 'utf8mb4_unicode_ci
- updated_at — DATETIME — 세분류' COLLATE 'utf8mb4_unicode_ci
- delete_yn — TINYINT(1) — 세세분류' COLLATE 'utf8mb4_unicode_ci
COMPANY
- id — BIGINT — Primary key — NOT NULL — 사업자등록증ID
- license_file_id — BIGINT — Foreign key → LICENSE_FILE.id — NOT NULL — 사용자ID
- user_id — BIGINT — NOT NULL — 사업자등록번호' COLLATE 'utf8mb4_unicode_ci
- business_number — VARCHAR(255) — NOT NULL — 사업장명' COLLATE 'utf8mb4_unicode_ci
- company_name — VARCHAR(255) — NOT NULL — 대표자명' COLLATE 'utf8mb4_unicode_ci
- ceo_name — VARCHAR(255) — NOT NULL — 기업설립일' COLLATE 'utf8mb4_unicode_ci
- company_establishment — VARCHAR(255) — NOT NULL — 법인등록번호' COLLATE 'utf8mb4_unicode_ci
- corporate_number — VARCHAR(255) — 소재지' COLLATE 'utf8mb4_unicode_ci
- company_address — VARCHAR(255) — NOT NULL — 발행처' COLLATE 'utf8mb4_unicode_ci
- tax_name — VARCHAR(255) — NOT NULL — 발행일' COLLATE 'utf8mb4_unicode_ci
- issue_date — VARCHAR(255) — NOT NULL — 기업 규모' COLLATE 'utf8mb4_unicode_ci
- company_size — VARCHAR(255) — NOT NULL — 등록일자
- created_at — DATETIME — 수정일자
- updated_at — DATETIME — 탈퇴 및 해지 여부
- delete_yn — TINYINT(1) — 고유ID
- INDEX — `FK_COMPANY_LICENSE_FILE`
ESG_APPROVAL_LOG
- id — BIGINT — Primary key — NOT NULL — 변경 전 JSON
- esg_approval_task_id — BIGINT — Foreign key → ESG_APPROVAL_TASK.id — NOT NULL — 변경 후 JSON
- action — VARCHAR(30) — NOT NULL — 보고서 문단/문장 단위 히든 감사 라벨 JSON
- actor_user_id — BIGINT — Foreign key → USER.id — NOT NULL — 요청 ID
- comment_text — TEXT — 등록일자
- created_at — DATETIME — 고유ID
ESG_APPROVAL_TASK
- id — BIGINT — Primary key — NOT NULL — 등록일자
- company_id — BIGINT — Foreign key → COMPANY.id — NOT NULL — 고유ID
- reporting_year — INT — NOT NULL — COMPANY.id logical FK
- metric_id — VARCHAR(50) — Foreign key → ESG_METRIC_MASTER.metric_id — NOT NULL — USER.id logical FK. 시스템 이벤트는 NULL 가능
- esg_onboarding_submission_id — BIGINT — Foreign key → ESG_ONBOARDING_SUBMISSION.id — 이벤트 유형: input_update/calculation_run/rollup_run/report_generate/reference_link 등
- approver_user_id — BIGINT — Foreign key → USER.id — 대상 테이블
- task_status — VARCHAR(30) — NOT NULL — 대상 id
- comment_text — TEXT — 보고서 문단 draft_id. 문장/문단 감사추적 라벨용
- created_at — DATETIME — 관련 atomic_metric_id
- updated_at — DATETIME — kpi_fact/rollup_result/evidence_chunk/source_document 등
- delete_yn — TINYINT(1) — 참조 ID
ESG_ATOMIC_METRIC_MASTER
- id — BIGINT — Primary key — NOT NULL — QL token 여부
- topic_code — VARCHAR(50) — EV token 여부
- materiality_topic — VARCHAR(200) — event token 여부
- sub_issue_code — VARCHAR(120) — Foreign key → ESG_SUB_ISSUE_MASTER.sub_issue_code — ALL_COMPANIES/A_GROUP_ONLY 등
- owner_metric_id — VARCHAR(50) — ENTITY_SOURCE/GROUP_POLICY/GROUP_CONSOLIDATED/ENTITY_ONLY
- metric_id — VARCHAR(50) — Foreign key → ESG_METRIC_MASTER.metric_id — NOT NULL — 롤업 필요 여부
- metric_name_kr — VARCHAR(300) — source/result/reference
- atomic_metric_id — VARCHAR(80) — NOT NULL — 롤업 설명식
- atomic_name_kr — VARCHAR(300) — NOT NULL — source atomic list ; separated
- atomic_name_en — VARCHAR(300) — 사람용 계산식
- description — TEXT — ESG_CALCULATION_RULE.calculation_rule_code logical FK
- data_value_type — VARCHAR(20) — NOT NULL — 참조 source atomic
- atomic_data_role — VARCHAR(30) — NOT NULL — 단위
- token_role — VARCHAR(20) — 증빙 필요 여부
- onboarding_input_yn — TINYINT(1) — 논리 적재 대상
- q_token_yn — TINYINT(1) — template owner 여부
- ql_token_yn — TINYINT(1) — QA 규칙
- ev_token_yn — TINYINT(1) — 등록일자
- event_token_yn — TINYINT(1) — 수정일자
- applicable_company_scope — VARCHAR(50) — 삭제여부
- group_link_type_code — VARCHAR(50) — 고유ID
- rollup_required_yn — TINYINT(1) — sub_issue 코드
- rollup_role — VARCHAR(50) — metric_id
- rollup_formula — TEXT — MVP/FULL
- source_atomic_metric_ids — TEXT — 온보딩 필수 여부
- calculation_formula — TEXT — 정렬순서
- calculation_rule_code — VARCHAR(100) — Foreign key → ESG_CALCULATION_RULE.calculation_rule_code — 등록일자
- reference_source_atomic_metric_id — VARCHAR(80) — Foreign key → ESG_ATOMIC_METRIC_MASTER.atomic_metric_id — 수정일자
- unit — VARCHAR(50) — 삭제여부
- evidence_required_yn — TINYINT(1) — 고유ID
- target_db_table — VARCHAR(100) — sub_issue 코드
- narrative_template_owner_yn — TINYINT(1) — metric_id
- qa_rule — TEXT — atomic_metric_id
- created_at — DATETIME — MVP/FULL
- updated_at — DATETIME — 온보딩 필수 여부
- delete_yn — TINYINT(1) — 정렬순서
ESG_AUDIT_LOG
- id — BIGINT — Primary key — NOT NULL — ESG_ONBOARDING_INPUT_VALUE.id
- company_id — BIGINT — Foreign key → COMPANY.id — COMPANY.id logical FK
- actor_user_id — BIGINT — Foreign key → USER.id — 보고연도
- event_type — VARCHAR(100) — NOT NULL — ENTITY
- target_table — VARCHAR(100) — NOT NULL — metric_id
- target_id — BIGINT — atomic_metric_id
- draft_id — VARCHAR(120) — 정량값
- atomic_metric_id — VARCHAR(80) — Foreign key → ESG_ATOMIC_METRIC_MASTER.atomic_metric_id — 정성값
- reference_type — VARCHAR(50) — 단위
- reference_id — VARCHAR(120) — manual_input/calculated/reference_copy
- old_value_json — LONGTEXT — submitted/approved/rejected
- new_value_json — LONGTEXT — USER.id logical FK
- trace_label_json — LONGTEXT — USER.id logical FK
- request_id — VARCHAR(100) — 승인일시
- created_at — DATETIME — 등록일자
ESG_CALCULATION_RULE
- id — BIGINT — Primary key — NOT NULL — 출력 단위
- calculation_rule_code — VARCHAR(100) — NOT NULL — 실행 순서
- target_atomic_metric_id — VARCHAR(80) — Foreign key → ESG_ATOMIC_METRIC_MASTER.atomic_metric_id — NOT NULL — 등록일자
- target_atomic_name_kr — VARCHAR(300) — 수정일자
- metric_id — VARCHAR(50) — Foreign key → ESG_METRIC_MASTER.metric_id — 삭제여부
- formula_type — VARCHAR(50) — NOT NULL — 고유ID
- execution_scope — VARCHAR(30) — NOT NULL — ESG_CALCULATION_RULE.calculation_rule_code logical FK
- applicable_company_scope — VARCHAR(200) — target atomic_metric_id
- source_atomic_metric_ids — TEXT — source atomic_metric_id
- numerator_atomic_metric_ids — TEXT — numerator/denominator/addend/source/reference
- denominator_atomic_metric_ids — TEXT — ENTITY/CONSOLIDATED
- calculation_formula_label — TEXT — source metric_id
- sql_template — LONGTEXT — NOT NULL — 등록일자
- zero_division_policy — VARCHAR(50) — 수정일자
- rounding_policy — VARCHAR(50) — 삭제여부
- result_table — VARCHAR(100) — 고유ID
- output_unit — VARCHAR(50) — 롤업 배치 코드
- execution_order — INT — 그룹사 COMPANY.id logical FK
- created_at — DATETIME — 보고연도
- updated_at — DATETIME — pending/processing/completed/failed/approved
- delete_yn — TINYINT(1) — USER.id logical FK
ESG_CALCULATION_RULE_SOURCE
- id — BIGINT — Primary key — NOT NULL — 완료일시
- calculation_rule_code — VARCHAR(100) — Foreign key → ESG_CALCULATION_RULE.calculation_rule_code — NOT NULL — 등록일자
- target_atomic_metric_id — VARCHAR(80) — Foreign key → ESG_ATOMIC_METRIC_MASTER.atomic_metric_id — NOT NULL — 수정일자
- source_atomic_metric_id — VARCHAR(80) — Foreign key → ESG_ATOMIC_METRIC_MASTER.atomic_metric_id — NOT NULL — 삭제여부
- source_role — VARCHAR(30) — 고유ID
- source_scope — VARCHAR(30) — ESG_ROLLUP_BATCH.id
- source_metric_id — VARCHAR(50) — Foreign key → ESG_METRIC_MASTER.metric_id — 롤업 결과 코드
- created_at — DATETIME — 보고연도
- updated_at — DATETIME — 그룹사 COMPANY.id logical FK
- delete_yn — TINYINT(1) — CONSOLIDATED
ESG_COMPANY_PROFILE
- id — BIGINT — Primary key — NOT NULL — 등록일자
- company_id — BIGINT — Foreign key → COMPANY.id — NOT NULL — 수정일자
- company_code — VARCHAR(50) — NOT NULL — 삭제여부
- company_scope_type — VARCHAR(30) — NOT NULL — 고유ID
- active_yn — TINYINT(1) — 상위 issue group 코드
- created_at — DATETIME — 상위 issue group 한글명
- updated_at — DATETIME — sub_issue 코드
- delete_yn — TINYINT(1) — sub_issue 한글명
ESG_COMPANY_ROLLUP_SCOPE
- id — BIGINT — Primary key — NOT NULL — sub_issue 영문명
- parent_company_id — BIGINT — Foreign key → COMPANY.id — NOT NULL — 이중중대성평가 pool 포함 여부
- source_company_id — BIGINT — Foreign key → COMPANY.id — NOT NULL — 정렬순서
- source_company_code — VARCHAR(50) — 사용여부
- rollup_include_yn — TINYINT(1) — 등록일자
- effective_from_year — INT — 수정일자
- effective_to_year — INT — 삭제여부
- note — TEXT — 고유ID
- created_at — DATETIME — G0/E/S/G 또는 MVP topic 코드
- updated_at — DATETIME — 현대모비스 선정 이슈 또는 경영일반
- delete_yn — TINYINT(1) — ESG_SUB_ISSUE_MASTER.sub_issue_code logical FK
ESG_EVIDENCE_CHUNK
- id — BIGINT — Primary key — NOT NULL — 관련 metric_id 목록
- evidence_chunk_id — VARCHAR(100) — NOT NULL — atomic token 기반 템플릿
- source_document_id — VARCHAR(100) — Foreign key → ESG_SOURCE_DOCUMENT.source_document_id — NOT NULL — 출력 구조
- section_title — VARCHAR(300) — 보고서 섹션 힌트
- page_no — INT — active/inactive
- quote_summary — TEXT — 등록일자
- evidence_role — VARCHAR(80) — 수정일자
- created_at — DATETIME — 삭제여부
- updated_at — DATETIME — 고유ID
- delete_yn — TINYINT(1) — ESG_NARRATIVE_TEMPLATE.narrative_template_id logical FK
ESG_FACT_CANDIDATE
- id — BIGINT — Primary key — NOT NULL — 수정일자
- esg_onboarding_input_value_id — BIGINT — Foreign key → ESG_ONBOARDING_INPUT_VALUE.id — 삭제여부
- company_id — BIGINT — Foreign key → COMPANY.id — NOT NULL — 고유ID
- reporting_year — INT — NOT NULL — ESG_FACT_CANDIDATE.id
- company_scope_type — VARCHAR(30) — NOT NULL — COMPANY.id logical FK
- metric_id — VARCHAR(50) — Foreign key → ESG_METRIC_MASTER.metric_id — NOT NULL — 보고연도
- atomic_metric_id — VARCHAR(80) — Foreign key → ESG_ATOMIC_METRIC_MASTER.atomic_metric_id — NOT NULL — ENTITY
- value_numeric — DECIMAL(24, 6) — metric_id
- value_text — LONGTEXT — atomic_metric_id
- unit — VARCHAR(50) — 정량값
- value_source_type — VARCHAR(30) — 정성값
- candidate_status — VARCHAR(30) — NOT NULL — 단위
- created_by_user_id — BIGINT — Foreign key → USER.id — manual_input/calculated/reference_copy
- approved_by_user_id — BIGINT — Foreign key → USER.id — pending/approved/rejected
- approved_at — DATETIME — USER.id logical FK
- created_at — DATETIME — 승인일시
- updated_at — DATETIME — 등록일자
- delete_yn — TINYINT(1) — 수정일자
ESG_GROUP_ROLLUP_RESULT
- id — BIGINT — Primary key — NOT NULL — pending/approved/rejected
- esg_rollup_batch_id — BIGINT — Foreign key → ESG_ROLLUP_BATCH.id — NOT NULL — USER.id logical FK
- rollup_result_code — VARCHAR(120) — 승인일시
- reporting_year — INT — NOT NULL — 등록일자
- parent_company_id — BIGINT — Foreign key → COMPANY.id — NOT NULL — 수정일자
- parent_company_scope_type — VARCHAR(30) — NOT NULL — 삭제여부
- included_company_ids — TEXT — 고유ID
- group_metric_id — VARCHAR(50) — Foreign key → ESG_METRIC_MASTER.metric_id — NOT NULL — 문서 ID. 예: DOC-E1-001
- group_atomic_metric_id — VARCHAR(80) — Foreign key → ESG_ATOMIC_METRIC_MASTER.atomic_metric_id — NOT NULL — COMPANY.id logical FK
- group_atomic_name — VARCHAR(300) — SUPPORTING_FILE.id logical FK
- value_numeric — DECIMAL(24, 6) — 문서명
- value_text — LONGTEXT — policy/procedure/evidence/report
- unit — VARCHAR(50) — 관련 owner_metric_id
- source_company_values_json — LONGTEXT — 등록일자
- rollup_method — VARCHAR(50) — 수정일자
- calculation_trace — TEXT — 삭제여부
- rollup_status — VARCHAR(30) — NOT NULL — 고유ID
- approved_by_user_id — BIGINT — Foreign key → USER.id — chunk ID
- approved_at — DATETIME — ESG_SOURCE_DOCUMENT.source_document_id logical FK
- created_at — DATETIME — 섹션명
- updated_at — DATETIME — 페이지
- delete_yn — TINYINT(1) — 근거 요약
ESG_KPI_FACT
- id — BIGINT — Primary key — NOT NULL — 삭제여부
- esg_fact_candidate_id — BIGINT — Foreign key → ESG_FACT_CANDIDATE.id — 고유ID
- company_id — BIGINT — Foreign key → COMPANY.id — NOT NULL — 계산 규칙 코드
- reporting_year — INT — NOT NULL — 결과 atomic_metric_id
- company_scope_type — VARCHAR(30) — NOT NULL — 결과 atomic 명
- metric_id — VARCHAR(50) — Foreign key → ESG_METRIC_MASTER.metric_id — NOT NULL — metric_id
- atomic_metric_id — VARCHAR(80) — Foreign key → ESG_ATOMIC_METRIC_MASTER.atomic_metric_id — NOT NULL — REFERENCE_COPY/ENTITY_SUM/ENTITY_RATIO/ENTITY_DIVIDE/ROLLUP_SUM/ROLLUP_RATIO_RECALC/ROLLUP_YOY_DIFF/ROLLUP_YOY_RATE
- value_numeric — DECIMAL(24, 6) — ENTITY/CONSOLIDATED
- value_text — LONGTEXT — 적용 회사 범위 설명
- unit — VARCHAR(50) — source atomic list
- value_source_type — VARCHAR(30) — numerator atomic list
- approval_status — VARCHAR(30) — NOT NULL — denominator atomic list
- approved_by_user_id — BIGINT — Foreign key → USER.id — 사람용 계산식
- approved_at — DATETIME — MariaDB 실행 SQL 템플릿. ? positional parameter 사용
- created_at — DATETIME — 분모 0 처리
- updated_at — DATETIME — 반올림 정책
- delete_yn — TINYINT(1) — 결과 적재 테이블
ESG_MATERIALITY_RUN
- id — BIGINT — Primary key — NOT NULL — benchmark 점수
- company_id — BIGINT — Foreign key → COMPANY.id — NOT NULL — media 점수
- reporting_year — INT — NOT NULL — 최종 점수
- run_name — VARCHAR(200) — NOT NULL — 순위
- run_status — VARCHAR(30) — NOT NULL — 등록일자
- selected_result_fixed_yn — TINYINT(1) — 수정일자
- requested_by_user_id — BIGINT — Foreign key → USER.id — 삭제여부
- created_at — DATETIME — 고유ID
- updated_at — DATETIME — ESG_MATERIALITY_RUN.id
- delete_yn — TINYINT(1) — 선정 sub_issue 코드
ESG_MATERIALITY_SELECTED_SUB_ISSUE
- id — BIGINT — Primary key — NOT NULL — 필수 입력 여부
- esg_materiality_run_id — BIGINT — Foreign key → ESG_MATERIALITY_RUN.id — NOT NULL — 등록일자
- sub_issue_code — VARCHAR(120) — Foreign key → ESG_SUB_ISSUE_MASTER.sub_issue_code — NOT NULL — 수정일자
- selection_type — VARCHAR(30) — NOT NULL — 삭제여부
- selected_rank_no — INT — 고유ID
- selected_reason — TEXT — COMPANY.id logical FK
- created_at — DATETIME — 보고연도
- updated_at — DATETIME — 사이클명
- delete_yn — TINYINT(1) — open/collecting/review/closed
ESG_MATERIALITY_SUB_ISSUE_SCORE
- id — BIGINT — Primary key — NOT NULL — mvp_fixed/score_based/manual
- esg_materiality_run_id — BIGINT — Foreign key → ESG_MATERIALITY_RUN.id — NOT NULL — 선정 순위
- sub_issue_code — VARCHAR(120) — Foreign key → ESG_SUB_ISSUE_MASTER.sub_issue_code — NOT NULL — 선정 사유
- impact_score — DECIMAL(10, 4) — 등록일자
- financial_score — DECIMAL(10, 4) — 수정일자
- stakeholder_score — DECIMAL(10, 4) — 삭제여부
- benchmark_score — DECIMAL(10, 4) — 고유ID
- media_score — DECIMAL(10, 4) — ESG_MATERIALITY_SELECTED_SUB_ISSUE.id
- final_score — DECIMAL(10, 4) — sub_issue 코드
- rank_no — INT — metric/atomic/mandatory_context
- created_at — DATETIME — metric_id
- updated_at — DATETIME — atomic_metric_id
- delete_yn — TINYINT(1) — 중복 방지용 key
ESG_METRIC_ASSIGNMENT
- id — BIGINT — Primary key — NOT NULL — COMPANY.id logical FK
- esg_onboarding_cycle_id — BIGINT — Foreign key → ESG_ONBOARDING_CYCLE.id — NOT NULL — 보고연도
- company_id — BIGINT — Foreign key → COMPANY.id — NOT NULL — ENTITY. CONSOLIDATED는 롤업결과 테이블에서 관리
- metric_id — VARCHAR(50) — Foreign key → ESG_METRIC_MASTER.metric_id — NOT NULL — metric_id
- invite_id — BIGINT — Foreign key → INVITE.id — atomic_metric_id
- assignee_user_id — BIGINT — Foreign key → USER.id — 정량값
- assignee_email — VARCHAR(100) — 정성값
- assignment_status — VARCHAR(30) — NOT NULL — 단위
- due_date — DATE — manual_input/calculated/reference_copy/imported
- created_by_user_id — BIGINT — Foreign key → USER.id — draft/submitted/approved/rejected
- created_at — DATETIME — 입력자 USER.id logical FK
- updated_at — DATETIME — 승인자 USER.id logical FK
- delete_yn — TINYINT(1) — 승인일시
ESG_METRIC_MASTER
- id — BIGINT — Primary key — NOT NULL — sub_issue 코드
- topic_code — VARCHAR(50) — 대표 metric_id
- materiality_topic — VARCHAR(200) — metric_id
- sub_issue_code — VARCHAR(120) — Foreign key → ESG_SUB_ISSUE_MASTER.sub_issue_code — metric 명
- owner_metric_id — VARCHAR(50) — atomic_metric_id. 예: E1-06__Q0001
- metric_id — VARCHAR(50) — NOT NULL — atomic 한글명
- metric_name_kr — VARCHAR(300) — NOT NULL — atomic 영문명/짧은 설명
- metric_description — TEXT — 설명
- mandatory_context_yn — TINYINT(1) — 정성/정량
- active_yn — TINYINT(1) — INPUT/DERIVED/REFERENCE
- created_at — DATETIME — Q/QL/EV/EVENT/ROLLUP
- updated_at — DATETIME — 온보딩 직접입력 여부
- delete_yn — TINYINT(1) — Q token 여부
ESG_NARRATIVE_REFERENCE
- id — BIGINT — Primary key — NOT NULL — 등록일자
- draft_id — VARCHAR(120) — Foreign key → ESG_REPORT_SECTION_DRAFT.draft_id — NOT NULL — 고유ID
- reference_type — VARCHAR(50) — NOT NULL — DMA scoring rule version
- reference_id — VARCHAR(120) — NOT NULL — 버전명
- atomic_metric_id — VARCHAR(80) — Foreign key → ESG_ATOMIC_METRIC_MASTER.atomic_metric_id — 산업 프로필
- source_document_id — VARCHAR(100) — Foreign key → ESG_SOURCE_DOCUMENT.source_document_id — 단계/내부 가중치 JSON
- evidence_chunk_id — VARCHAR(100) — Foreign key → ESG_EVIDENCE_CHUNK.evidence_chunk_id — threshold/top_k/alpha 설정 JSON
- quote_summary — TEXT — 사용여부
- created_at — DATETIME — 등록일자
- updated_at — DATETIME — 수정일자
- delete_yn — TINYINT(1) — 삭제여부
ESG_NARRATIVE_TEMPLATE
- id — BIGINT — Primary key — NOT NULL — 토큰 atomic_metric_id
- narrative_template_id — VARCHAR(100) — NOT NULL — Q/QL/EV/ROLLUP
- owner_metric_id — VARCHAR(50) — Foreign key → ESG_METRIC_MASTER.metric_id — NOT NULL — 필수 여부
- owner_metric_name — VARCHAR(300) — 정렬순서
- materiality_topic — VARCHAR(200) — 등록일자
- sub_issue_code — VARCHAR(120) — Foreign key → ESG_SUB_ISSUE_MASTER.sub_issue_code — 수정일자
- related_metric_ids — TEXT — 삭제여부
- template_text_with_atomic_tokens — LONGTEXT — NOT NULL — 고유ID
- expected_output_structure — TEXT — context snapshot ID
- report_section_hint — VARCHAR(200) — 보고연도
- template_status — VARCHAR(30) — COMPANY.id logical FK
- created_at — DATETIME — ENTITY/CONSOLIDATED
- updated_at — DATETIME — template ID
- delete_yn — TINYINT(1) — Q context JSON
ESG_NARRATIVE_TEMPLATE_TOKEN
- id — BIGINT — Primary key — NOT NULL — QL context JSON
- narrative_template_id — VARCHAR(100) — Foreign key → ESG_NARRATIVE_TEMPLATE.narrative_template_id — NOT NULL — EV context JSON
- atomic_metric_id — VARCHAR(80) — Foreign key → ESG_ATOMIC_METRIC_MASTER.atomic_metric_id — NOT NULL — rollup context JSON
- token_role — VARCHAR(20) — context hash
- required_yn — TINYINT(1) — 등록일자
- sort_order — INT — 수정일자
- created_at — DATETIME — 삭제여부
- updated_at — DATETIME — 고유ID
- delete_yn — TINYINT(1) — draft ID
ESG_ONBOARDING_CYCLE
- id — BIGINT — Primary key — NOT NULL — 초대 이메일. 초대 수락 전 담당자 식별
- company_id — BIGINT — Foreign key → COMPANY.id — NOT NULL — pending/accepted/in_progress/submitted/completed/canceled
- reporting_year — INT — NOT NULL — 제출기한
- cycle_name — VARCHAR(200) — NOT NULL — 배정자 USER.id logical FK
- cycle_status — VARCHAR(30) — NOT NULL — 등록일자
- esg_materiality_run_id — BIGINT — Foreign key → ESG_MATERIALITY_RUN.id — 수정일자
- created_by_user_id — BIGINT — Foreign key → USER.id — 삭제여부
- created_at — DATETIME — 고유ID
- updated_at — DATETIME — ESG_METRIC_ASSIGNMENT.id
- delete_yn — TINYINT(1) — ESG_ONBOARDING_CYCLE.id
ESG_ONBOARDING_INPUT_VALUE
- id — BIGINT — Primary key — NOT NULL — SUPPORTING_FILE.id logical FK
- esg_metric_assignment_id — BIGINT — Foreign key → ESG_METRIC_ASSIGNMENT.id — 등록일자
- esg_onboarding_cycle_id — BIGINT — Foreign key → ESG_ONBOARDING_CYCLE.id — 수정일자
- company_id — BIGINT — Foreign key → COMPANY.id — NOT NULL — 삭제여부
- reporting_year — INT — NOT NULL — 고유ID
- company_scope_type — VARCHAR(30) — NOT NULL — ESG_ONBOARDING_CYCLE.id
- metric_id — VARCHAR(50) — Foreign key → ESG_METRIC_MASTER.metric_id — NOT NULL — COMPANY.id logical FK
- atomic_metric_id — VARCHAR(80) — Foreign key → ESG_ATOMIC_METRIC_MASTER.atomic_metric_id — NOT NULL — metric_id
- value_numeric — DECIMAL(24, 6) — ESG_METRIC_ASSIGNMENT.id
- value_text — LONGTEXT — USER.id logical FK
- unit — VARCHAR(50) — submitted/under_review/approved/rejected/revision_requested/resubmitted
- value_source_type — VARCHAR(30) — 제출일시
- input_status — VARCHAR(30) — NOT NULL — 등록일자
- input_user_id — BIGINT — Foreign key → USER.id — 수정일자
- approved_by_user_id — BIGINT — Foreign key → USER.id — 삭제여부
- approved_at — DATETIME — 고유ID
- source_file_id — BIGINT — Foreign key → SUPPORTING_FILE.id — COMPANY.id logical FK
- created_at — DATETIME — 보고연도
- updated_at — DATETIME — metric_id
- delete_yn — TINYINT(1) — ESG_ONBOARDING_SUBMISSION.id
ESG_ONBOARDING_SUBMISSION
- id — BIGINT — Primary key — NOT NULL — 승인자 USER.id logical FK
- esg_onboarding_cycle_id — BIGINT — Foreign key → ESG_ONBOARDING_CYCLE.id — NOT NULL — pending/approved/rejected/revision_requested/canceled
- company_id — BIGINT — Foreign key → COMPANY.id — NOT NULL — 승인자 코멘트
- metric_id — VARCHAR(50) — Foreign key → ESG_METRIC_MASTER.metric_id — NOT NULL — 등록일자
- esg_metric_assignment_id — BIGINT — Foreign key → ESG_METRIC_ASSIGNMENT.id — 수정일자
- submitter_user_id — BIGINT — Foreign key → USER.id — NOT NULL — 삭제여부
- submission_status — VARCHAR(30) — NOT NULL — 고유ID
- submitted_at — DATETIME — ESG_APPROVAL_TASK.id
- created_at — DATETIME — submitted/approved/rejected/revision_requested/resubmitted
- updated_at — DATETIME — USER.id logical FK
- delete_yn — TINYINT(1) — 코멘트
ESG_REPORT_CONTEXT_SNAPSHOT
- id — BIGINT — Primary key — NOT NULL — 보고연도
- context_snapshot_id — VARCHAR(120) — NOT NULL — COMPANY.id logical FK
- reporting_year — INT — NOT NULL — ENTITY/CONSOLIDATED
- company_id — BIGINT — Foreign key → COMPANY.id — NOT NULL — 주제명
- company_scope_type — VARCHAR(30) — NOT NULL — sub_issue 코드
- narrative_template_id — VARCHAR(100) — Foreign key → ESG_NARRATIVE_TEMPLATE.narrative_template_id — NOT NULL — owner metric_id
- q_context_json — LONGTEXT — template ID
- ql_context_json — LONGTEXT — 내부 관리용 설명
- ev_context_json — LONGTEXT — 보고서 문단 초안
- rollup_context_json — LONGTEXT — 사용 Q atomic 목록
- source_context_hash — VARCHAR(128) — 사용 QL atomic 목록
- created_at — DATETIME — 사용 EV atomic 목록
- updated_at — DATETIME — 사용 rollup atomic 목록
- delete_yn — TINYINT(1) — QA 점수
ESG_REPORT_SECTION_DRAFT
- id — BIGINT — Primary key — NOT NULL — PASS/REVIEW/FAIL
- draft_id — VARCHAR(120) — NOT NULL — 등록일자
- reporting_year — INT — NOT NULL — 수정일자
- company_id — BIGINT — Foreign key → COMPANY.id — NOT NULL — 삭제여부
- company_scope_type — VARCHAR(30) — NOT NULL — 고유ID
- materiality_topic — VARCHAR(200) — ESG_REPORT_SECTION_DRAFT.draft_id logical FK
- sub_issue_code — VARCHAR(120) — Foreign key → ESG_SUB_ISSUE_MASTER.sub_issue_code — kpi_fact/rollup_result/evidence_chunk/source_document
- owner_metric_id — VARCHAR(50) — Foreign key → ESG_METRIC_MASTER.metric_id — 참조 ID
- narrative_template_id — VARCHAR(100) — Foreign key → ESG_NARRATIVE_TEMPLATE.narrative_template_id — 관련 atomic_metric_id
- internal_management_summary — LONGTEXT — source document ID
- report_narrative_draft — LONGTEXT — NOT NULL — evidence chunk ID
- used_q_atomic_ids — TEXT — 인용/근거 요약
- used_ql_atomic_ids — TEXT — 등록일자
- used_ev_atomic_ids — TEXT — 수정일자
- used_rollup_atomic_ids — TEXT — 삭제여부
- qa_score — DECIMAL(5, 2) — 고유ID
- qa_status — VARCHAR(30) — seed version
- created_at — DATETIME — QA 항목
- updated_at — DATETIME — PASS/FAIL/REVIEW
- delete_yn — TINYINT(1) — 상세
ESG_ROLLUP_BATCH
- id — BIGINT — Primary key — NOT NULL — 포함 COMPANY.id 목록. ESG_COMPANY_ROLLUP_SCOPE 조회 후 동적 생성. 세미콜론 구분
- rollup_batch_code — VARCHAR(100) — NOT NULL — metric_id
- parent_company_id — BIGINT — Foreign key → COMPANY.id — NOT NULL — 그룹 결과 atomic_metric_id
- reporting_year — INT — NOT NULL — 그룹 결과 atomic 명
- batch_status — VARCHAR(30) — NOT NULL — 롤업 결과 정량값
- requested_by_user_id — BIGINT — Foreign key → USER.id — 롤업 결과 정성값
- completed_at — DATETIME — 단위
- created_at — DATETIME — 회사별 원본값 JSON
- updated_at — DATETIME — SUM/REFERENCE/RECALCULATE/YOY_DIFF/YOY_RATE
- delete_yn — TINYINT(1) — 계산 추적 설명
ESG_SELECTED_ONBOARDING_SCOPE
- id — BIGINT — Primary key — NOT NULL — ESG_MATERIALITY_RUN.id
- esg_materiality_selected_sub_issue_id — BIGINT — Foreign key → ESG_MATERIALITY_SELECTED_SUB_ISSUE.id — NOT NULL — USER.id logical FK
- sub_issue_code — VARCHAR(120) — Foreign key → ESG_SUB_ISSUE_MASTER.sub_issue_code — NOT NULL — 등록일자
- scope_row_type — VARCHAR(30) — NOT NULL — 수정일자
- metric_id — VARCHAR(50) — Foreign key → ESG_METRIC_MASTER.metric_id — NOT NULL — 삭제여부
- atomic_metric_id — VARCHAR(80) — Foreign key → ESG_ATOMIC_METRIC_MASTER.atomic_metric_id — 고유ID
- scope_key — VARCHAR(255) — NOT NULL — ESG_ONBOARDING_CYCLE.id
- required_yn — TINYINT(1) — COMPANY.id logical FK
- created_at — DATETIME — metric_id
- updated_at — DATETIME — INVITE.id logical FK. 초대 전/중 연결
- delete_yn — TINYINT(1) — USER.id logical FK. 초대 수락 후
ESG_SOURCE_DOCUMENT
- id — BIGINT — Primary key — NOT NULL — policy_evidence/evidence_summary/cap_evidence 등
- source_document_id — VARCHAR(100) — NOT NULL — 등록일자
- company_id — BIGINT — Foreign key → COMPANY.id — 수정일자
- supporting_file_id — BIGINT — Foreign key → SUPPORTING_FILE.id — 삭제여부
- source_document_title — VARCHAR(300) — NOT NULL — 고유ID
- document_type — VARCHAR(50) — template ID
- owner_metric_id — VARCHAR(50) — Foreign key → ESG_METRIC_MASTER.metric_id — 대표 metric_id
- created_at — DATETIME — 대표 metric 명
- updated_at — DATETIME — 주제명
- delete_yn — TINYINT(1) — sub_issue 코드
ESG_SUB_ISSUE_ATOMIC_MAP
- id — BIGINT — Primary key — NOT NULL — USER.id logical FK
- sub_issue_code — VARCHAR(120) — Foreign key → ESG_SUB_ISSUE_MASTER.sub_issue_code — NOT NULL — 등록일자
- metric_id — VARCHAR(50) — Foreign key → ESG_METRIC_MASTER.metric_id — NOT NULL — 수정일자
- atomic_metric_id — VARCHAR(80) — Foreign key → ESG_ATOMIC_METRIC_MASTER.atomic_metric_id — NOT NULL — 삭제여부
- map_scope — VARCHAR(30) — NOT NULL — 고유ID
- required_yn — TINYINT(1) — ESG_MATERIALITY_RUN.id
- sort_order — INT — sub_issue 코드
- created_at — DATETIME — impact 점수
- updated_at — DATETIME — financial 점수
- delete_yn — TINYINT(1) — stakeholder 점수
ESG_SUB_ISSUE_MASTER
- id — BIGINT — Primary key — NOT NULL — 대표 metric_id
- issue_group_code — VARCHAR(80) — NOT NULL — metric_id
- issue_group_name_kr — VARCHAR(200) — 지표명
- sub_issue_code — VARCHAR(120) — NOT NULL — 지표 설명
- sub_issue_name_kr — VARCHAR(300) — NOT NULL — G0 등 항상 포함 context 여부
- sub_issue_name_en — VARCHAR(300) — 사용여부
- materiality_issue_pool_yn — TINYINT(1) — 등록일자
- sort_order — INT — 수정일자
- active_yn — TINYINT(1) — 삭제여부
- created_at — DATETIME — 고유ID
- updated_at — DATETIME — topic 코드
- delete_yn — TINYINT(1) — 주제명
ESG_SUB_ISSUE_METRIC_MAP
- id — BIGINT — Primary key — NOT NULL — 등록일자
- sub_issue_code — VARCHAR(120) — Foreign key → ESG_SUB_ISSUE_MASTER.sub_issue_code — NOT NULL — 수정일자
- metric_id — VARCHAR(50) — Foreign key → ESG_METRIC_MASTER.metric_id — NOT NULL — 삭제여부
- map_scope — VARCHAR(30) — NOT NULL — 고유ID
- required_yn — TINYINT(1) — COMPANY.id logical FK
- sort_order — INT — 보고연도
- created_at — DATETIME — 이중중대성평가 실행명
- updated_at — DATETIME — draft/running/scored/selected/closed
- delete_yn — TINYINT(1) — MVP 고정 선정결과 여부
INDUSTRY_CODE
- id — VARCHAR(50) — Primary key — NOT NULL — 수정일자
- large_code — VARCHAR(20) — NOT NULL — 삭제여부
- large_category — VARCHAR(100) — NOT NULL — 고유ID
- middle_code — VARCHAR(20) — NOT NULL — 권한(영문)' COLLATE 'utf8mb4_unicode_ci
- middle_category — VARCHAR(100) — NOT NULL — 권한(한글)' COLLATE 'utf8mb4_unicode_ci
- small_code — VARCHAR(20) — NOT NULL — 등록일자
- small_category — VARCHAR(100) — NOT NULL — 수정일자
- sub_code — VARCHAR(20) — NOT NULL — 삭제여부
- sub_category — VARCHAR(100) — NOT NULL — 고유ID
- sub_detail_category — VARCHAR(100) — NOT NULL — 사용자ID
- created_at — DATETIME — 리프레쉬 토큰' COLLATE 'utf8mb4_unicode_ci
- updated_at — DATETIME — 식별 아이디' COLLATE 'utf8mb4_unicode_ci
- delete_yn — TINYINT(1) — 등록일자
INDUSTRY_DETAIL
- id — BIGINT — Primary key — NOT NULL — 업종분류코드ID' COLLATE 'utf8mb4_unicode_ci
- company_id — BIGINT — Foreign key → COMPANY.id — NOT NULL — 등록일자
- industry_id — VARCHAR(50) — NOT NULL — 수정일자
- created_at — DATETIME — 삭제여부
- updated_at — DATETIME — 고유ID
- delete_yn — TINYINT(1) — 보낸 회사정보ID
- INDEX — `FK_INDUSTRY_DETAIL_COMPANY`
INVITE
- id — BIGINT — Primary key — NOT NULL — 권한 코드ID
- company_id — BIGINT — Foreign key → COMPANY.id — NOT NULL — 받는사람 이메일' COLLATE 'utf8mb4_unicode_ci
- user_id — BIGINT — NOT NULL — 상태/\r\n- 승인대기\r\n- 승인완료\r\n- 승인취소\r\n- 토큰만료' COLLATE 'utf8mb4_unicode_ci
- role_id — BIGINT — NOT NULL — 등록일자
- email — VARCHAR(100) — NOT NULL — 수정일자
- state — VARCHAR(20) — NOT NULL — 삭제여부
- created_at — DATETIME — NOT NULL — 고유ID
- updated_at — DATETIME — NOT NULL — 부서명' COLLATE 'utf8mb4_unicode_ci
- delete_yn — TINYINT(1) — NOT NULL — 부서정보' COLLATE 'utf8mb4_unicode_ci
- INDEX — `FK_INVITE_COMPANY`
ISSUE
- id — BIGINT — Primary key — NOT NULL — 수정일자
- department — VARCHAR(20) — NOT NULL — 삭제여부
- department_detail — VARCHAR(20) — NOT NULL — 고유ID
- created_at — DATETIME — 이슈ID
- updated_at — DATETIME — 초대 정보ID
- delete_yn — TINYINT(1) — 사용자ID
ISSUE_DETAIL
- id — BIGINT — Primary key — NOT NULL — 수정일자
- invite_id — BIGINT — Foreign key → INVITE.id — NOT NULL — 삭제여부
- issue_id — BIGINT — Foreign key → ISSUE.id — NOT NULL — 고유ID
- user_id — BIGINT — NOT NULL — 파일명' COLLATE 'utf8mb4_unicode_ci
- created_at — DATETIME — 암호화된 파일명' COLLATE 'utf8mb4_unicode_ci
- updated_at — DATETIME — 파일 타입' COLLATE 'utf8mb4_unicode_ci
- delete_yn — TINYINT(1) — 등록일자
- INDEX — `FK_ISSUE_DETAIL_INVITE`
- INDEX — `FK_ISSUE_DETAIL_ISSUE`
LICENSE_FILE
- id — BIGINT — Primary key — NOT NULL — 삭제여부
- origin — VARCHAR(255) — NOT NULL — 고유ID
- filename — VARCHAR(255) — NOT NULL — 파일명' COLLATE 'utf8mb4_unicode_ci
- ext — VARCHAR(50) — NOT NULL — 암호화된 파일명' COLLATE 'utf8mb4_unicode_ci
- created_at — DATETIME — 파일 타입' COLLATE 'utf8mb4_unicode_ci
- updated_at — DATETIME — 등록일자
- delete_yn — TINYINT(1) — 수정일자
ROLE
- id — BIGINT — Primary key — NOT NULL — 삭제여부
- role — VARCHAR(100) — NOT NULL — 고유ID
- name — VARCHAR(100) — 이메일' COLLATE 'utf8mb4_unicode_ci
- created_at — DATETIME — 비밀번호' COLLATE 'utf8mb4_unicode_ci
- updated_at — DATETIME — 이름' COLLATE 'utf8mb4_unicode_ci
- delete_yn — TINYINT(1) — 이용약관 동의여부
SUPPORTING_FILE
- id — BIGINT — Primary key — NOT NULL — 고유ID
- origin — VARCHAR(255) — NOT NULL — 파일명
- filename — VARCHAR(255) — NOT NULL — 도메인명' COLLATE 'utf8mb4_unicode_ci
- ext — VARCHAR(50) — NOT NULL — 선정된 이슈명' COLLATE 'utf8mb4_unicode_ci
- created_at — DATETIME — 선정된 서브 이슈명' COLLATE 'utf8mb4_unicode_ci
- updated_at — DATETIME — 등록일자
- delete_yn — TINYINT(1) — 수정일자
TE_BENCHMK
- id — BIGINT — Primary key — NOT NULL — 고유ID
- sr_id — BIGINT — Foreign key → TE_SR_FILE.id — NOT NULL — 파일명' COLLATE 'utf8mb4_unicode_ci
- domain — VARCHAR(255) — NOT NULL — 암호파일명' COLLATE 'utf8mb4_unicode_ci
- selected_issue — VARCHAR(255) — NOT NULL — 파일 타입(리더, 피어, 오너) ' COLLATE 'utf8mb4_unicode_ci
- selected_sub_issue — TEXT — NOT NULL — SR 보고서 회사명' COLLATE 'utf8mb4_unicode_ci
- created_at — DATETIME — 생성 유저 id
- updated_at — DATETIME — 등록일자
- delete_yn — TINYINT(1) — 수정일자
- INDEX — `fk_sr_id`
TE_CRAWLING
- id — INT — Primary key — NOT NULL
- source — VARCHAR(255) — NOT NULL
- date — DATETIME
- title — VARCHAR(255) — NOT NULL
- link — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
TE_MEDIA
- type — VARCHAR(255) — NOT NULL
- source — VARCHAR(255) — NOT NULL
- issue — VARCHAR(255) — NOT NULL
- sub_issue — VARCHAR(255) — NOT NULL
- impact — INT — NOT NULL
- financial — INT — NOT NULL
TE_SR_FILE
- id — BIGINT — Primary key — NOT NULL — Actual DB type: VECTOR(384)
- origin — VARCHAR(255) — NOT NULL — 고유ID
- file_name — VARCHAR(255) — NOT NULL — 사용 대상\r\n- 초대정보=> 1\r\n- 협력사관계 => 1,2
- type — VARCHAR(255) — NOT NULL — 코드명' COLLATE 'utf8mb4_unicode_ci
- company_name — VARCHAR(255) — NOT NULL — 등록일자
- create_user_id — BIGINT — Foreign key → USER.id — NOT NULL — 수정일자
- created_at — DATETIME — 삭제여부
- updated_at — DATETIME — 고유ID, 표준산업\n분류' COLLATE 'utf8mb4_unicode_ci
- delete_yn — TINYINT(1) — 대분류 코드' COLLATE 'utf8mb4_unicode_ci
- INDEX — `fk_create_user_id`
TE_vectorData
- id — INT — Primary key — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME
- embedding — LONGTEXT — NOT NULL — 중분류 코드' COLLATE 'utf8mb4_unicode_ci
TOKEN
- id — BIGINT — Primary key — NOT NULL — 수정일자
- user_id — BIGINT — Foreign key → USER.id — NOT NULL — 탈퇴여부
- refresh_token — TEXT — NOT NULL — 무결성' `uuid` VARCHAR(100) NOT NULL COMMENT '고유ID
- created_at — DATETIME — 회사정보ID
- updated_at — DATETIME — 권한 코드ID
- delete_yn — TINYINT(1) — 사용자ID
- INDEX — `FK_TOKEN_USER`
USER
- id — BIGINT — Primary key — NOT NULL — 수정일자
- email — VARCHAR(100) — NOT NULL — 삭제여부
- password — VARCHAR(255) — NOT NULL — 고유ID
- name — VARCHAR(50) — NOT NULL — COMPANY.id logical FK
- agreed — TINYINT(1) — 시연/ESG 회사코드: A_GROUP/B_SUB_KR/C_SUB_EU/D_SUB_US
- created_at — DATETIME — ENTITY/CONSOLIDATED
- updated_at — DATETIME — 사용여부
- delete_yn — TINYINT(1) — 등록일자
USER_ROLE
- id — BIGINT — Primary key — NOT NULL — 고유ID
- user_id — BIGINT — Foreign key → USER.id — NOT NULL — 롤업 요청 주체 COMPANY.id logical FK
- role_id — BIGINT — Foreign key → ROLE.id — NOT NULL — 롤업 포함 원천 회사 COMPANY.id logical FK
- company_id — BIGINT — Foreign key → COMPANY.id — NOT NULL — A_GROUP/B_SUB_KR/C_SUB_EU/D_SUB_US 등
- created_at — DATETIME — 롤업 포함 여부
- updated_at — DATETIME — 적용 시작 보고연도
- delete_yn — TINYINT(1) — 적용 종료 보고연도. NULL이면 현재 유효
- INDEX — `FK_UR_USER`
- INDEX — `FK_UR_ROLE`