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`