사업장관리 db 테이블 추적성 반영

테이블 (35)

감사이벤트

  • audit_event_id — BIGINT — 기본 키 — NOT NULL
  • event_uuid — VARCHAR(36) — NOT NULL
  • business_object_id — BIGINT
  • object_version_id — BIGINT — 외래 키 → 업무객체버전.object_version_id
  • event_type — VARCHAR(40) — NOT NULL
  • actor_type — VARCHAR(20) — NOT NULL
  • actor_user_id — BIGINT
  • source_module_code — VARCHAR(30) — NOT NULL
  • request_id — VARCHAR(100)
  • session_id_hash — CHAR(64)
  • source_ip_hash — CHAR(64)
  • event_summary — VARCHAR(2000)
  • payload_hash — CHAR(64)
  • previous_event_hash — CHAR(64)
  • event_hash — CHAR(64) — NOT NULL
  • occurred_at — TIMESTAMPTZ — NOT NULL

감사필드변경

  • audit_field_change_id — BIGINT — 기본 키 — NOT NULL
  • audit_event_id — BIGINT — 외래 키 → 감사이벤트.audit_event_id — NOT NULL
  • field_code — VARCHAR(100) — NOT NULL
  • field_name — VARCHAR(200)
  • data_classification — VARCHAR(20) — NOT NULL
  • before_value_masked — VARCHAR(2000)
  • after_value_masked — VARCHAR(2000)
  • before_value_hash — CHAR(64)
  • after_value_hash — CHAR(64)

객체연계유형

  • mapping_type_id — BIGINT — 기본 키 — NOT NULL
  • mapping_type_code — VARCHAR(60) — NOT NULL
  • mapping_type_name — VARCHAR(300) — NOT NULL
  • source_object_type — VARCHAR(40) — NOT NULL
  • target_object_type — VARCHAR(40) — NOT NULL
  • cardinality_type — VARCHAR(10) — NOT NULL
  • mapping_owner_module — VARCHAR(30) — NOT NULL
  • business_rule — VARCHAR(2000)
  • is_active — BOOLEAN — NOT NULL

데이터접근감사

  • data_access_audit_id — BIGINT — 기본 키 — NOT NULL
  • actor_user_id — BIGINT
  • business_object_id — BIGINT
  • document_version_id — BIGINT — 외래 키 → 문서버전.document_version_id
  • access_type — VARCHAR(30) — NOT NULL
  • purpose_code — VARCHAR(50)
  • purpose_detail — VARCHAR(1000)
  • access_result — VARCHAR(20) — NOT NULL
  • source_ip_hash — CHAR(64)
  • request_id — VARCHAR(100)
  • occurred_at — TIMESTAMPTZ — NOT NULL

문서

  • document_id — BIGINT — 기본 키 — NOT NULL
  • document_no — VARCHAR(60) — NOT NULL
  • document_type_id — BIGINT — 외래 키 → 문서유형.document_type_id — NOT NULL
  • document_title — VARCHAR(500) — NOT NULL
  • owner_user_id — BIGINT
  • document_status — VARCHAR(20) — NOT NULL
  • current_version_no — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — BIGINT
  • row_version — BIGINT — NOT NULL

문서버전

  • document_version_id — BIGINT — 기본 키 — NOT NULL
  • document_id — BIGINT — 외래 키 → 문서.document_id — NOT NULL
  • version_no — INTEGER — NOT NULL
  • attachment_id — BIGINT — NOT NULL
  • supersedes_version_id — BIGINT — 외래 키 → 문서버전.document_version_id
  • content_hash — CHAR(64) — NOT NULL
  • file_name_snapshot — VARCHAR(500) — NOT NULL
  • mime_type — VARCHAR(200)
  • file_size_bytes — BIGINT
  • version_status — VARCHAR(20) — NOT NULL
  • effective_from — TIMESTAMPTZ — NOT NULL
  • effective_to — TIMESTAMPTZ
  • approved_at — TIMESTAMPTZ
  • locked_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT

문서서명

  • document_signature_id — BIGINT — 기본 키 — NOT NULL
  • document_version_id — BIGINT — 외래 키 → 문서버전.document_version_id — NOT NULL
  • signer_user_id — BIGINT
  • signer_name_snapshot — VARCHAR(200) — NOT NULL
  • signature_type — VARCHAR(20) — NOT NULL
  • signature_hash — CHAR(64) — NOT NULL
  • certificate_serial_no — VARCHAR(200)
  • signed_at — TIMESTAMPTZ — NOT NULL
  • signature_status — VARCHAR(20) — NOT NULL
  • verification_result — VARCHAR(1000)

문서업무객체연결

  • document_object_link_id — BIGINT — 기본 키 — NOT NULL
  • document_id — BIGINT — 외래 키 → 문서.document_id — NOT NULL
  • business_object_id — BIGINT — NOT NULL
  • relation_type — VARCHAR(30) — NOT NULL
  • is_primary — BOOLEAN — NOT NULL
  • valid_from — TIMESTAMPTZ — NOT NULL
  • valid_to — TIMESTAMPTZ
  • created_by — BIGINT

문서유형

  • document_type_id — BIGINT — 기본 키 — NOT NULL
  • document_type_code — VARCHAR(50) — NOT NULL
  • document_type_name — VARCHAR(200) — NOT NULL
  • document_category — VARCHAR(30) — NOT NULL
  • sensitive_level — VARCHAR(20) — NOT NULL
  • signature_required — BOOLEAN — NOT NULL
  • retention_policy_id — BIGINT — 외래 키 → 보존정책.retention_policy_id
  • allowed_mime_types — VARCHAR(1000)
  • max_file_size_bytes — BIGINT
  • is_active — BOOLEAN — NOT NULL

법정요건

  • legal_requirement_id — BIGINT — 기본 키 — NOT NULL
  • requirement_code — VARCHAR(60) — NOT NULL
  • requirement_name — VARCHAR(500) — NOT NULL
  • requirement_category — VARCHAR(30) — NOT NULL
  • jurisdiction_code — VARCHAR(30) — NOT NULL
  • owner_module_code — VARCHAR(30) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT

법정요건버전

  • requirement_version_id — BIGINT — 기본 키 — NOT NULL
  • legal_requirement_id — BIGINT — 외래 키 → 법정요건.legal_requirement_id — NOT NULL
  • version_no — INTEGER — NOT NULL
  • law_name — VARCHAR(500)
  • article_reference — VARCHAR(500)
  • source_document_version_id — BIGINT — 외래 키 → 문서버전.document_version_id
  • requirement_text — TEXT — NOT NULL
  • applicability_scope — TEXT
  • evidence_description — TEXT
  • effective_from — DATE — NOT NULL
  • effective_to — DATE
  • version_status — VARCHAR(20) — NOT NULL
  • reviewed_by_hse — BOOLEAN — NOT NULL
  • reviewed_by_legal — BOOLEAN — NOT NULL
  • approved_at — TIMESTAMPTZ
  • created_by — BIGINT

변경세트

  • change_set_id — BIGINT — 기본 키 — NOT NULL
  • change_set_no — VARCHAR(60) — NOT NULL
  • business_object_id — BIGINT — NOT NULL
  • from_object_version_id — BIGINT — 외래 키 → 업무객체버전.object_version_id
  • to_object_version_id — BIGINT — 외래 키 → 업무객체버전.object_version_id
  • change_type — VARCHAR(30) — NOT NULL
  • change_reason — VARCHAR(2000) — NOT NULL
  • requested_at — TIMESTAMPTZ — NOT NULL
  • requested_by — BIGINT
  • approval_request_id — BIGINT
  • completed_at — TIMESTAMPTZ
  • change_status — VARCHAR(20) — NOT NULL

변경영향규칙

  • impact_rule_id — BIGINT — 기본 키 — NOT NULL
  • source_object_type — VARCHAR(40) — NOT NULL
  • changed_field_code — VARCHAR(100)
  • source_event_type — VARCHAR(40) — NOT NULL
  • target_module_code — VARCHAR(30) — NOT NULL
  • target_event_code — VARCHAR(80) — NOT NULL
  • redecision_required — BOOLEAN — NOT NULL
  • evidence_refresh_required — BOOLEAN — NOT NULL
  • followup_action_code — VARCHAR(80)
  • priority_no — INTEGER — NOT NULL
  • is_active — BOOLEAN — NOT NULL

변경항목

  • change_item_id — BIGINT — 기본 키 — NOT NULL
  • change_set_id — BIGINT — 외래 키 → 변경세트.change_set_id — NOT NULL
  • field_code — VARCHAR(100) — NOT NULL
  • field_name — VARCHAR(200)
  • data_classification — VARCHAR(20) — NOT NULL
  • before_value_masked — VARCHAR(2000)
  • after_value_masked — VARCHAR(2000)
  • before_value_hash — CHAR(64)
  • after_value_hash — CHAR(64)
  • change_reason_detail — VARCHAR(1000)

보존정책

  • retention_policy_id — BIGINT — 기본 키 — NOT NULL
  • policy_code — VARCHAR(50) — NOT NULL
  • policy_name — VARCHAR(200) — NOT NULL
  • retention_years — INTEGER
  • retention_months — INTEGER
  • retention_start_event — VARCHAR(30) — NOT NULL
  • disposition_method — VARCHAR(20) — NOT NULL
  • legal_basis — VARCHAR(2000)
  • legal_hold_supported — BOOLEAN — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT

보존처리이력

  • retention_action_id — BIGINT — 기본 키 — NOT NULL
  • document_version_id — BIGINT — 외래 키 → 문서버전.document_version_id — NOT NULL
  • retention_policy_id — BIGINT — 외래 키 → 보존정책.retention_policy_id — NOT NULL
  • action_type — VARCHAR(30) — NOT NULL
  • scheduled_at — TIMESTAMPTZ
  • executed_at — TIMESTAMPTZ
  • legal_hold_reason — VARCHAR(2000)
  • action_reason — VARCHAR(2000)
  • action_status — VARCHAR(20) — NOT NULL
  • acted_by — BIGINT

상태이력

  • status_history_id — BIGINT — 기본 키 — NOT NULL
  • business_object_id — BIGINT — NOT NULL
  • object_version_id — BIGINT — 외래 키 → 업무객체버전.object_version_id
  • from_status — VARCHAR(30)
  • to_status — VARCHAR(30) — NOT NULL
  • reason_code — VARCHAR(50)
  • reason_detail — VARCHAR(2000)
  • effective_at — TIMESTAMPTZ — NOT NULL
  • changed_at — TIMESTAMPTZ — NOT NULL
  • changed_by — BIGINT
  • approval_request_id — BIGINT

업무객체매핑

  • object_mapping_id — BIGINT — 기본 키 — NOT NULL
  • mapping_type_id — BIGINT — 외래 키 → 객체연계유형.mapping_type_id — NOT NULL
  • source_business_object_id — BIGINT — NOT NULL
  • target_business_object_id — BIGINT — NOT NULL
  • valid_from — TIMESTAMPTZ — NOT NULL
  • valid_to — TIMESTAMPTZ
  • mapping_status — VARCHAR(20) — NOT NULL
  • mapping_reason — VARCHAR(2000)
  • created_by — BIGINT

업무객체버전

  • object_version_id — BIGINT — 기본 키 — NOT NULL
  • business_object_id — BIGINT — NOT NULL
  • version_no — INTEGER — NOT NULL
  • version_status — VARCHAR(20) — NOT NULL
  • valid_from — TIMESTAMPTZ — NOT NULL
  • valid_to — TIMESTAMPTZ
  • is_current — BOOLEAN — NOT NULL
  • snapshot_payload_enc — BYTEA — NOT NULL
  • snapshot_summary — JSONB — NOT NULL
  • snapshot_hash — CHAR(64) — NOT NULL
  • approval_request_id — BIGINT
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT

연계이벤트

  • integration_event_id — BIGINT — 기본 키 — NOT NULL
  • event_uuid — VARCHAR(36) — NOT NULL
  • event_code — VARCHAR(80) — NOT NULL
  • source_module_code — VARCHAR(30) — NOT NULL
  • source_business_object_id — BIGINT — NOT NULL
  • source_object_version_id — BIGINT — 외래 키 → 업무객체버전.object_version_id
  • event_payload — JSONB — NOT NULL
  • payload_hash — CHAR(64) — NOT NULL
  • publish_status — VARCHAR(20) — NOT NULL
  • occurred_at — TIMESTAMPTZ — NOT NULL
  • published_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

연계전송이력

  • integration_delivery_id — BIGINT — 기본 키 — NOT NULL
  • integration_event_id — BIGINT — 외래 키 → 연계이벤트.integration_event_id — NOT NULL
  • target_module_code — VARCHAR(30) — NOT NULL
  • attempt_no — INTEGER — NOT NULL
  • delivery_status — VARCHAR(20) — NOT NULL
  • requested_at — TIMESTAMPTZ — NOT NULL
  • completed_at — TIMESTAMPTZ
  • response_code — VARCHAR(100)
  • error_message — VARCHAR(2000)
  • response_hash — CHAR(64)

외부식별자매핑

  • external_id_mapping_id — BIGINT — 기본 키 — NOT NULL
  • business_object_id — BIGINT — NOT NULL
  • external_system_code — VARCHAR(50) — NOT NULL
  • external_object_type — VARCHAR(50) — NOT NULL
  • external_object_id — VARCHAR(200) — NOT NULL
  • external_version — VARCHAR(100)
  • sync_status — VARCHAR(20) — NOT NULL
  • last_synced_at — TIMESTAMPTZ
  • created_by — BIGINT

증빙검증이력

  • evidence_verification_id — BIGINT — 기본 키 — NOT NULL
  • evidence_item_id — BIGINT — 외래 키 → 증빙항목.evidence_item_id — NOT NULL
  • verification_type — VARCHAR(30) — NOT NULL
  • verification_result — VARCHAR(20) — NOT NULL
  • issue_code — VARCHAR(50)
  • verification_comment — VARCHAR(2000)
  • verified_at — TIMESTAMPTZ — NOT NULL
  • verified_by — BIGINT
  • verification_hash — CHAR(64)

증빙수집

  • evidence_collection_id — BIGINT — 기본 키 — NOT NULL
  • evidence_collection_no — VARCHAR(60) — NOT NULL
  • business_object_id — BIGINT — NOT NULL
  • evidence_requirement_id — BIGINT — 외래 키 → 증빙요건.evidence_requirement_id — NOT NULL
  • period_start — DATE
  • period_end — DATE
  • due_date — DATE
  • collection_status — VARCHAR(20) — NOT NULL
  • responsible_user_id — BIGINT
  • completed_at — TIMESTAMPTZ
  • completed_by — BIGINT
  • created_at — TIMESTAMPTZ — NOT NULL

증빙요건

  • evidence_requirement_id — BIGINT — 기본 키 — NOT NULL
  • evidence_requirement_code — VARCHAR(60) — NOT NULL
  • requirement_version_id — BIGINT — 외래 키 → 법정요건버전.requirement_version_id — NOT NULL
  • document_type_id — BIGINT — 외래 키 → 문서유형.document_type_id
  • retention_policy_id — BIGINT — 외래 키 → 보존정책.retention_policy_id
  • evidence_name — VARCHAR(500) — NOT NULL
  • evidence_description — TEXT
  • collection_frequency — VARCHAR(20) — NOT NULL
  • required_count — INTEGER — NOT NULL
  • due_offset_days — INTEGER
  • is_mandatory — BOOLEAN — NOT NULL
  • is_active — BOOLEAN — NOT NULL

증빙잠금이력

  • evidence_lock_history_id — BIGINT — 기본 키 — NOT NULL
  • evidence_package_id — BIGINT — 외래 키 → 증빙패키지.evidence_package_id — NOT NULL
  • action_type — VARCHAR(30) — NOT NULL
  • action_reason — VARCHAR(2000) — NOT NULL
  • approval_request_id — BIGINT
  • before_package_hash — CHAR(64)
  • after_package_hash — CHAR(64)
  • occurred_at — TIMESTAMPTZ — NOT NULL
  • acted_by — BIGINT

증빙패키지

  • evidence_package_id — BIGINT — 기본 키 — NOT NULL
  • package_no — VARCHAR(60) — NOT NULL
  • business_object_id — BIGINT — NOT NULL
  • package_type — VARCHAR(30) — NOT NULL
  • as_of_date — DATE — NOT NULL
  • package_version_no — INTEGER — NOT NULL
  • package_status — VARCHAR(20) — NOT NULL
  • package_hash — CHAR(64)
  • approval_request_id — BIGINT
  • generated_at — TIMESTAMPTZ
  • generated_by — BIGINT
  • locked_at — TIMESTAMPTZ
  • locked_by — BIGINT

증빙패키지항목

  • evidence_package_item_id — BIGINT — 기본 키 — NOT NULL
  • evidence_package_id — BIGINT — 외래 키 → 증빙패키지.evidence_package_id — NOT NULL
  • item_order — INTEGER — NOT NULL
  • evidence_item_id — BIGINT — 외래 키 → 증빙항목.evidence_item_id
  • document_version_id — BIGINT — 외래 키 → 문서버전.document_version_id
  • object_version_id — BIGINT — 외래 키 → 업무객체버전.object_version_id
  • decision_run_id — BIGINT — 외래 키 → 판정실행.decision_run_id
  • approval_request_id — BIGINT
  • package_item_hash — CHAR(64) — NOT NULL

증빙항목

  • evidence_item_id — BIGINT — 기본 키 — NOT NULL
  • evidence_collection_id — BIGINT — 외래 키 → 증빙수집.evidence_collection_id — NOT NULL
  • item_type — VARCHAR(30) — NOT NULL
  • document_version_id — BIGINT — 외래 키 → 문서버전.document_version_id
  • object_version_id — BIGINT — 외래 키 → 업무객체버전.object_version_id
  • decision_run_id — BIGINT — 외래 키 → 판정실행.decision_run_id
  • approval_request_id — BIGINT
  • evidence_hash — CHAR(64) — NOT NULL
  • item_status — VARCHAR(20) — NOT NULL
  • submitted_at — TIMESTAMPTZ — NOT NULL
  • submitted_by — BIGINT

판정규칙

  • decision_rule_id — BIGINT — 기본 키 — NOT NULL
  • requirement_version_id — BIGINT — 외래 키 → 법정요건버전.requirement_version_id — NOT NULL
  • rule_code — VARCHAR(80) — NOT NULL
  • rule_name — VARCHAR(300) — NOT NULL
  • priority_no — INTEGER — NOT NULL
  • result_code — VARCHAR(50) — NOT NULL
  • result_name — VARCHAR(200) — NOT NULL
  • expression_summary — VARCHAR(2000)
  • effective_from — DATE — NOT NULL
  • effective_to — DATE
  • rule_status — VARCHAR(20) — NOT NULL
  • engine_version — VARCHAR(50)
  • created_by — BIGINT

판정규칙조건

  • rule_condition_id — BIGINT — 기본 키 — NOT NULL
  • decision_rule_id — BIGINT — 외래 키 → 판정규칙.decision_rule_id — NOT NULL
  • condition_group_no — INTEGER — NOT NULL
  • sequence_no — INTEGER — NOT NULL
  • fact_definition_id — BIGINT — 외래 키 → 판정사실정의.fact_definition_id — NOT NULL
  • comparison_operator — VARCHAR(20) — NOT NULL
  • compare_value — VARCHAR(1000)
  • compare_value_to — VARCHAR(1000)
  • logical_connector — VARCHAR(10) — NOT NULL

판정근거연결

  • decision_basis_id — BIGINT — 기본 키 — NOT NULL
  • decision_run_id — BIGINT — 외래 키 → 판정실행.decision_run_id — NOT NULL
  • basis_type — VARCHAR(30) — NOT NULL
  • decision_rule_id — BIGINT — 외래 키 → 판정규칙.decision_rule_id
  • document_version_id — BIGINT — 외래 키 → 문서버전.document_version_id
  • object_version_id — BIGINT — 외래 키 → 업무객체버전.object_version_id
  • approval_request_id — BIGINT
  • basis_description — VARCHAR(2000)

판정사실정의

  • fact_definition_id — BIGINT — 기본 키 — NOT NULL
  • fact_code — VARCHAR(80) — NOT NULL
  • fact_name — VARCHAR(300) — NOT NULL
  • data_type — VARCHAR(20) — NOT NULL
  • source_module_code — VARCHAR(30) — NOT NULL
  • source_object_type — VARCHAR(40)
  • source_field_code — VARCHAR(100)
  • value_unit — VARCHAR(30)
  • sensitive_level — VARCHAR(20) — NOT NULL
  • is_active — BOOLEAN — NOT NULL

판정실행

  • decision_run_id — BIGINT — 기본 키 — NOT NULL
  • decision_run_no — VARCHAR(60) — NOT NULL
  • business_object_id — BIGINT — NOT NULL
  • requirement_version_id — BIGINT — 외래 키 → 법정요건버전.requirement_version_id — NOT NULL
  • trigger_type — VARCHAR(30) — NOT NULL
  • trigger_source_object_id — BIGINT
  • run_sequence_no — INTEGER — NOT NULL
  • decision_result_code — VARCHAR(50) — NOT NULL
  • decision_result_name — VARCHAR(300) — NOT NULL
  • decision_reason_summary — VARCHAR(2000)
  • engine_version — VARCHAR(50)
  • executed_at — TIMESTAMPTZ — NOT NULL
  • executed_by — BIGINT
  • is_final — BOOLEAN — NOT NULL
  • finalized_at — TIMESTAMPTZ
  • finalized_by — BIGINT

판정입력값

  • decision_input_id — BIGINT — 기본 키 — NOT NULL
  • decision_run_id — BIGINT — 외래 키 → 판정실행.decision_run_id — NOT NULL
  • fact_definition_id — BIGINT — 외래 키 → 판정사실정의.fact_definition_id — NOT NULL
  • source_business_object_id — BIGINT
  • source_object_version_id — BIGINT — 외래 키 → 업무객체버전.object_version_id
  • raw_value_enc — BYTEA
  • display_value_masked — VARCHAR(1000)
  • value_hash — CHAR(64) — NOT NULL
  • observed_at — TIMESTAMPTZ — NOT NULL
  • collected_at — TIMESTAMPTZ — NOT NULL