사업장관리 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