안전보건관리 시스템 사업장관리 db 테이블 설계

테이블 (59)

KPI목표

  • kpi_target_id — BIGINT — 기본 키 — NOT NULL
  • business_object_id — BIGINT — 외래 키 → 업무객체.business_object_id — NOT NULL
  • kpi_definition_id — BIGINT — 외래 키 → KPI정의.kpi_definition_id — NOT NULL
  • workplace_id — BIGINT — 외래 키 → 사업장.workplace_id — NOT NULL
  • period_start — DATE — NOT NULL
  • period_end — DATE — NOT NULL
  • target_value — DECIMAL(18,4) — NOT NULL
  • weight_percent — DECIMAL(7,4) — NOT NULL
  • warning_threshold — DECIMAL(18,4)
  • failure_threshold — DECIMAL(18,4)
  • aggregation_cycle — VARCHAR(20) — NOT NULL
  • target_status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT — 외래 키 → 사용자_공통.user_id

KPI실적

  • kpi_result_id — BIGINT — 기본 키 — NOT NULL
  • kpi_target_id — BIGINT — 외래 키 → KPI목표.kpi_target_id — NOT NULL
  • result_period_start — DATE — NOT NULL
  • result_period_end — DATE — NOT NULL
  • actual_value — DECIMAL(18,4) — NOT NULL
  • achievement_rate — DECIMAL(18,4)
  • result_status — VARCHAR(20) — NOT NULL
  • source_snapshot — JSON — NOT NULL
  • calculated_at — DATETIME — NOT NULL
  • calculated_by — BIGINT — 외래 키 → 사용자_공통.user_id

KPI정의

  • kpi_definition_id — BIGINT — 기본 키 — NOT NULL
  • kpi_code — VARCHAR(50) — NOT NULL
  • kpi_name — VARCHAR(300) — NOT NULL
  • kpi_domain — VARCHAR(30) — NOT NULL
  • unit_code — VARCHAR(20) — NOT NULL
  • calculation_method — VARCHAR(30) — NOT NULL
  • source_metric_code — VARCHAR(100) — NOT NULL
  • calculation_description — VARCHAR(2000) — NOT NULL
  • default_cycle — VARCHAR(20) — NOT NULL
  • is_active — TINYINT(1) — NOT NULL

개선조치

  • improvement_action_id — BIGINT — 기본 키 — NOT NULL
  • business_object_id — BIGINT — 외래 키 → 업무객체.business_object_id — NOT NULL
  • kpi_result_id — BIGINT — 외래 키 → KPI실적.kpi_result_id
  • workplace_id — BIGINT — 외래 키 → 사업장.workplace_id — NOT NULL
  • action_title — VARCHAR(500) — NOT NULL
  • action_description — TEXT
  • owner_user_id — BIGINT — 외래 키 → 사용자_공통.user_id
  • due_date — DATE
  • action_status — VARCHAR(20) — NOT NULL
  • completed_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT — 외래 키 → 사용자_공통.user_id

결재단계

  • approval_step_id — BIGINT — 기본 키 — NOT NULL
  • approval_request_id — BIGINT — 외래 키 → 결재요청.approval_request_id — NOT NULL
  • step_order — INTEGER — NOT NULL
  • step_type — VARCHAR(20) — NOT NULL
  • approver_user_id — BIGINT — 외래 키 → 사용자_공통.user_id — NOT NULL
  • step_status — VARCHAR(20) — NOT NULL
  • delegated_from_user_id — BIGINT — 외래 키 → 사용자_공통.user_id
  • acted_at — DATETIME
  • opinion — VARCHAR(2000)
  • signature_hash — CHAR(64)

결재선템플릿

  • approval_template_id — BIGINT — 기본 키 — NOT NULL
  • template_code — VARCHAR(50) — NOT NULL
  • template_name — VARCHAR(200) — NOT NULL
  • business_type — VARCHAR(40) — NOT NULL
  • min_amount — DECIMAL(18,2)
  • max_amount — DECIMAL(18,2)
  • workplace_id — BIGINT — 외래 키 → 사업장.workplace_id
  • version_no — INTEGER — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT — 외래 키 → 사용자_공통.user_id

결재선템플릿단계

  • approval_template_step_id — BIGINT — 기본 키 — NOT NULL
  • approval_template_id — BIGINT — 외래 키 → 결재선템플릿.approval_template_id — NOT NULL
  • step_order — INTEGER — NOT NULL
  • step_type — VARCHAR(20) — NOT NULL
  • approver_role_type_id — BIGINT — 외래 키 → 안전보건역할유형.role_type_id
  • fixed_approver_user_id — BIGINT — 외래 키 → 사용자_공통.user_id
  • is_required — TINYINT(1) — NOT NULL

결재요청

  • approval_request_id — BIGINT — 기본 키 — NOT NULL
  • request_no — VARCHAR(40) — NOT NULL
  • business_object_id — BIGINT — 외래 키 → 업무객체.business_object_id — NOT NULL
  • subject_version_no — INTEGER
  • approval_template_id — BIGINT — 외래 키 → 결재선템플릿.approval_template_id
  • requester_user_id — BIGINT — 외래 키 → 사용자_공통.user_id — NOT NULL
  • request_title — VARCHAR(500) — NOT NULL
  • request_summary — TEXT
  • amount — DECIMAL(18,2)
  • approval_status — VARCHAR(20) — NOT NULL
  • current_step_order — INTEGER
  • requested_at — DATETIME
  • completed_at — DATETIME
  • evidence_locked_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT — 외래 키 → 사용자_공통.user_id

결재처리이력

  • approval_action_id — BIGINT — 기본 키 — NOT NULL
  • approval_request_id — BIGINT — 외래 키 → 결재요청.approval_request_id — NOT NULL
  • approval_step_id — BIGINT — 외래 키 → 결재단계.approval_step_id
  • action_type — VARCHAR(20) — NOT NULL
  • actor_user_id — BIGINT — 외래 키 → 사용자_공통.user_id
  • action_at — DATETIME — NOT NULL
  • opinion — VARCHAR(2000)
  • action_payload — JSON — NOT NULL

공간

  • space_id — BIGINT — 기본 키 — NOT NULL
  • business_object_id — BIGINT — 외래 키 → 업무객체.business_object_id — NOT NULL
  • workplace_id — BIGINT — 외래 키 → 사업장.workplace_id — NOT NULL
  • space_code — VARCHAR(40) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT — 외래 키 → 사용자_공통.user_id

공간유해위험요인

  • identified_date — DATE — 기본 키 — NOT NULL
  • space_id — BIGINT — 외래 키 → 공간.space_id — NOT NULL
  • hazard_factor_id — BIGINT — 외래 키 → 유해위험요인.hazard_factor_id — NOT NULL
  • risk_level — VARCHAR(20) — NOT NULL
  • resolved_date — DATE

공간이력

  • space_version_id — BIGINT — 기본 키 — NOT NULL
  • space_id — BIGINT — 외래 키 → 공간.space_id — NOT NULL
  • version_no — INTEGER — NOT NULL
  • parent_space_id — BIGINT — 외래 키 → 공간.space_id
  • space_name — VARCHAR(200) — NOT NULL
  • space_type — VARCHAR(30) — NOT NULL
  • purpose — VARCHAR(500)
  • responsible_department_id — BIGINT — 외래 키 → 부서.department_id
  • area_sqm — DECIMAL(15,2)
  • is_confined_space — TINYINT(1) — NOT NULL
  • access_control — VARCHAR(20) — NOT NULL
  • risk_grade — VARCHAR(20) — NOT NULL
  • operation_status — VARCHAR(20) — NOT NULL
  • valid_from — DATE — NOT NULL
  • valid_to — DATE
  • is_current — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT — 외래 키 → 사용자_공통.user_id

공정

  • process_id — BIGINT — 기본 키 — NOT NULL
  • business_object_id — BIGINT — 외래 키 → 업무객체.business_object_id — NOT NULL
  • workplace_id — BIGINT — 외래 키 → 사업장.workplace_id — NOT NULL
  • process_code — VARCHAR(40) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT — 외래 키 → 사용자_공통.user_id

공정공간

  • valid_from — DATE — 기본 키 — NOT NULL
  • process_id — BIGINT — 외래 키 → 공정.process_id — NOT NULL
  • space_id — BIGINT — 외래 키 → 공간.space_id — NOT NULL
  • is_primary — TINYINT(1) — NOT NULL
  • valid_to — DATE
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT — 외래 키 → 사용자_공통.user_id

공정물질

  • valid_from — DATE — 기본 키 — NOT NULL
  • process_id — BIGINT — 외래 키 → 공정.process_id — NOT NULL
  • material_id — BIGINT — 외래 키 → 물질.material_id — NOT NULL
  • usage_quantity — DECIMAL(18,4)
  • usage_unit — VARCHAR(20)
  • valid_to — DATE
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT — 외래 키 → 사용자_공통.user_id

공정설비

  • valid_from — DATE — 기본 키 — NOT NULL
  • process_id — BIGINT — 외래 키 → 공정.process_id — NOT NULL
  • equipment_id — BIGINT — 외래 키 → 설비.equipment_id — NOT NULL
  • valid_to — DATE
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT — 외래 키 → 사용자_공통.user_id

공정유해위험요인

  • identified_date — DATE — 기본 키 — NOT NULL
  • process_id — BIGINT — 외래 키 → 공정.process_id — NOT NULL
  • hazard_factor_id — BIGINT — 외래 키 → 유해위험요인.hazard_factor_id — NOT NULL
  • risk_level — VARCHAR(20) — NOT NULL
  • resolved_date — DATE

공정이력

  • process_version_id — BIGINT — 기본 키 — NOT NULL
  • process_id — BIGINT — 외래 키 → 공정.process_id — NOT NULL
  • version_no — INTEGER — NOT NULL
  • process_name — VARCHAR(200) — NOT NULL
  • work_description — TEXT
  • standard_worker_count — INTEGER
  • work_schedule — VARCHAR(200)
  • responsible_user_id — BIGINT — 외래 키 → 사용자_공통.user_id
  • risk_grade — VARCHAR(20) — NOT NULL
  • operation_status — VARCHAR(20) — NOT NULL
  • valid_from — DATE — NOT NULL
  • valid_to — DATE
  • is_current — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT — 외래 키 → 사용자_공통.user_id

관할기관

  • authority_id — BIGINT — 기본 키 — NOT NULL
  • authority_type — VARCHAR(30) — NOT NULL
  • authority_code — VARCHAR(30)
  • authority_name — VARCHAR(200) — NOT NULL
  • jurisdiction_area — VARCHAR(300)
  • phone_enc — BLOB
  • email_enc — BLOB
  • is_active — TINYINT(1) — NOT NULL

근로자초대

  • invitation_id — BIGINT — 기본 키 — NOT NULL
  • invitation_no — VARCHAR(30) — NOT NULL
  • workplace_id — BIGINT — 외래 키 → 부서.workplace_id — NOT NULL
  • department_id — BIGINT — 외래 키 → 부서.department_id — NOT NULL
  • invitee_name_enc — BLOB — NOT NULL
  • contact_enc — BLOB — NOT NULL
  • contact_hash — CHAR(64) — NOT NULL
  • member_type — VARCHAR(20) — NOT NULL
  • invite_channel — VARCHAR(20) — NOT NULL
  • invitation_status — VARCHAR(20) — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • sent_at — DATETIME
  • accepted_at — DATETIME
  • accepted_user_id — BIGINT — 외래 키 → 사용자_공통.user_id
  • failure_reason — VARCHAR(1000)
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT — 외래 키 → 사용자_공통.user_id

물질

  • material_id — BIGINT — 기본 키 — NOT NULL
  • business_object_id — BIGINT — 외래 키 → 업무객체.business_object_id — NOT NULL
  • workplace_id — BIGINT — 외래 키 → 사업장.workplace_id — NOT NULL
  • material_code — VARCHAR(40) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT — 외래 키 → 사용자_공통.user_id

물질유해위험요인

  • identified_date — DATE — 기본 키 — NOT NULL
  • material_id — BIGINT — 외래 키 → 물질.material_id — NOT NULL
  • hazard_factor_id — BIGINT — 외래 키 → 유해위험요인.hazard_factor_id — NOT NULL
  • risk_level — VARCHAR(20) — NOT NULL
  • resolved_date — DATE

물질이력

  • material_version_id — BIGINT — 기본 키 — NOT NULL
  • material_id — BIGINT — 외래 키 → 물질.material_id — NOT NULL
  • version_no — INTEGER — NOT NULL
  • material_name — VARCHAR(200) — NOT NULL
  • cas_no — VARCHAR(50)
  • manufacturer — VARCHAR(200)
  • msds_revision_date — DATE
  • storage_quantity — DECIMAL(18,4)
  • storage_unit — VARCHAR(20)
  • hazard_grade — VARCHAR(20) — NOT NULL
  • material_status — VARCHAR(20) — NOT NULL
  • responsible_user_id — BIGINT — 외래 키 → 사용자_공통.user_id
  • valid_from — DATE — NOT NULL
  • valid_to — DATE
  • is_current — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT — 외래 키 → 사용자_공통.user_id

변경이벤트

  • change_event_id — BIGINT — 기본 키 — NOT NULL
  • business_object_id — BIGINT — 외래 키 → 업무객체.business_object_id — NOT NULL
  • event_type — VARCHAR(30) — NOT NULL
  • entity_version_no — INTEGER
  • before_data — JSON
  • after_data — JSON
  • changed_fields — JSON — NOT NULL
  • actor_user_id — BIGINT — 외래 키 → 사용자_공통.user_id
  • actor_name_snapshot — VARCHAR(200)
  • occurred_at — DATETIME — NOT NULL
  • previous_event_hash — CHAR(64)
  • event_hash — CHAR(64) — NOT NULL
  • source_ip_hash — CHAR(64)

보고서템플릿_공통

  • template_id — BIGINT — 기본 키 — NOT NULL

부서

  • department_id — BIGINT — 기본 키 — NOT NULL
  • business_object_id — BIGINT — 외래 키 → 업무객체.business_object_id — NOT NULL
  • workplace_id — BIGINT — 외래 키 → 사업장.workplace_id — NOT NULL
  • org_id — BIGINT — 외래 키 → 조직_공통.org_id — NOT NULL
  • department_code — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT — 외래 키 → 사용자_공통.user_id

부서이력

  • department_version_id — BIGINT — 기본 키 — NOT NULL
  • department_id — BIGINT — 외래 키 → 부서.department_id — NOT NULL
  • version_no — INTEGER — NOT NULL
  • parent_department_id — BIGINT — 외래 키 → 부서.department_id
  • department_name — VARCHAR(200) — NOT NULL
  • major_duties — VARCHAR(1000)
  • sort_order — INTEGER — NOT NULL
  • department_status — VARCHAR(20) — NOT NULL
  • valid_from — DATE — NOT NULL
  • valid_to — DATE
  • is_current — TINYINT(1) — NOT NULL
  • change_reason — VARCHAR(1000)
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT — 외래 키 → 사용자_공통.user_id

사업장

  • workplace_id — BIGINT — 기본 키 — NOT NULL
  • business_object_id — BIGINT — 외래 키 → 업무객체.business_object_id — NOT NULL
  • workplace_code — VARCHAR(30) — NOT NULL
  • root_org_id — BIGINT — 외래 키 → 조직_공통.org_id — NOT NULL
  • legal_entity_org_id — BIGINT — 외래 키 → 조직_공통.org_id
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT — 외래 키 → 사용자_공통.user_id
  • updated_at — DATETIME — NOT NULL
  • updated_by — BIGINT — 외래 키 → 사용자_공통.user_id
  • row_version — BIGINT — NOT NULL

사업장관할기관

  • workplace_authority_id — BIGINT — 기본 키 — NOT NULL
  • workplace_id — BIGINT — 외래 키 → 사업장.workplace_id — NOT NULL
  • authority_id — BIGINT — 외래 키 → 관할기관.authority_id — NOT NULL
  • is_primary — TINYINT(1) — NOT NULL
  • valid_from — DATE — NOT NULL
  • valid_to — DATE
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT — 외래 키 → 사용자_공통.user_id

사업장이력

  • workplace_version_id — BIGINT — 기본 키 — NOT NULL
  • workplace_id — BIGINT — 외래 키 → 사업장.workplace_id — NOT NULL
  • version_no — INTEGER — NOT NULL
  • workplace_name — VARCHAR(200) — NOT NULL
  • business_registration_no_enc — BLOB
  • business_registration_no_hash — CHAR(64)
  • representative_name_enc — BLOB
  • industry_code — VARCHAR(20)
  • industry_name — VARCHAR(200)
  • operating_status — VARCHAR(20) — NOT NULL
  • risk_grade — VARCHAR(20) — NOT NULL
  • opening_date — DATE
  • shift_type — VARCHAR(30)
  • postal_code — VARCHAR(10)
  • address_line1_enc — BLOB
  • address_line2_enc — BLOB
  • primary_work_description — TEXT
  • official_email_enc — BLOB
  • official_phone_enc — BLOB
  • valid_from — DATE — NOT NULL
  • valid_to — DATE
  • is_current — TINYINT(1) — NOT NULL
  • change_reason — VARCHAR(1000)
  • approved_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT — 외래 키 → 사용자_공통.user_id

사업장인원현황

  • workplace_headcount_id — BIGINT — 기본 키 — NOT NULL
  • workplace_id — BIGINT — 외래 키 → 사업장.workplace_id — NOT NULL
  • snapshot_date — DATE — NOT NULL
  • total_workers — INTEGER — NOT NULL
  • office_workers — INTEGER — NOT NULL
  • production_workers — INTEGER — NOT NULL
  • contractor_workers — INTEGER — NOT NULL
  • source_type — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT — 외래 키 → 사용자_공통.user_id

사업장테마

  • workplace_id — BIGINT — 외래 키 → 사업장.workplace_id — NOT NULL
  • display_name — VARCHAR(200)
  • slogan — VARCHAR(300)
  • sub_text — VARCHAR(500)
  • logo_attachment_id — BIGINT — 외래 키 → 첨부파일_공통.attachment_id
  • banner_attachment_id — BIGINT — 외래 키 → 첨부파일_공통.attachment_id
  • primary_color — VARCHAR(7)
  • updated_at — DATETIME — NOT NULL
  • updated_by — BIGINT — 외래 키 → 사용자_공통.user_id
  • row_version — BIGINT — NOT NULL

사용자_공통

  • user_id — BIGINT — 기본 키 — NOT NULL

사용자교육

  • user_training_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → 사용자_공통.user_id — NOT NULL
  • training_code — VARCHAR(50)
  • training_name — VARCHAR(300) — NOT NULL
  • provider_name — VARCHAR(200)
  • completed_date — DATE
  • valid_to — DATE
  • training_hours — DECIMAL(8,2)
  • certificate_no_enc — BLOB
  • training_status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT — 외래 키 → 사용자_공통.user_id

사용자소속이력

  • user_assignment_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → 사용자_공통.user_id — NOT NULL
  • workplace_id — BIGINT — 외래 키 → 부서.workplace_id — NOT NULL
  • department_id — BIGINT — 외래 키 → 부서.department_id — NOT NULL
  • position_id — BIGINT — 외래 키 → 직위_공통.position_id
  • employee_no_enc — BLOB
  • employee_no_hash — CHAR(64)
  • employment_type — VARCHAR(20) — NOT NULL
  • employment_status — VARCHAR(20) — NOT NULL
  • is_primary — TINYINT(1) — NOT NULL
  • valid_from — DATE — NOT NULL
  • valid_to — DATE
  • is_current — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT — 외래 키 → 사용자_공통.user_id

사용자자격

  • user_qualification_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → 사용자_공통.user_id — NOT NULL
  • qualification_type_id — BIGINT — 외래 키 → 자격유형.qualification_type_id — NOT NULL
  • certificate_no_enc — BLOB
  • certificate_no_hash — CHAR(64)
  • issuer_name — VARCHAR(200)
  • acquired_date — DATE
  • valid_from — DATE
  • valid_to — DATE
  • qualification_status — VARCHAR(20) — NOT NULL
  • renewal_notice_days — INTEGER
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT — 외래 키 → 사용자_공통.user_id
  • updated_at — DATETIME — NOT NULL
  • updated_by — BIGINT — 외래 키 → 사용자_공통.user_id

설비

  • equipment_id — BIGINT — 기본 키 — NOT NULL
  • business_object_id — BIGINT — 외래 키 → 업무객체.business_object_id — NOT NULL
  • workplace_id — BIGINT — 외래 키 → 사업장.workplace_id — NOT NULL
  • asset_no — VARCHAR(50) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT — 외래 키 → 사용자_공통.user_id

설비검사

  • equipment_inspection_id — BIGINT — 기본 키 — NOT NULL
  • equipment_id — BIGINT — 외래 키 → 설비.equipment_id — NOT NULL
  • inspection_type — VARCHAR(30) — NOT NULL
  • inspection_date — DATE
  • next_due_date — DATE
  • inspection_result — VARCHAR(20) — NOT NULL
  • inspector_name_enc — BLOB
  • inspector_org — VARCHAR(200)
  • certificate_no — VARCHAR(100)
  • finding_summary — VARCHAR(2000)
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT — 외래 키 → 사용자_공통.user_id

설비유해위험요인

  • identified_date — DATE — 기본 키 — NOT NULL
  • equipment_id — BIGINT — 외래 키 → 설비.equipment_id — NOT NULL
  • hazard_factor_id — BIGINT — 외래 키 → 유해위험요인.hazard_factor_id — NOT NULL
  • risk_level — VARCHAR(20) — NOT NULL
  • resolved_date — DATE

설비이력

  • equipment_version_id — BIGINT — 기본 키 — NOT NULL
  • equipment_id — BIGINT — 외래 키 → 설비.equipment_id — NOT NULL
  • version_no — INTEGER — NOT NULL
  • equipment_name — VARCHAR(200) — NOT NULL
  • manufacturer — VARCHAR(200)
  • model_name — VARCHAR(200)
  • serial_no — VARCHAR(200)
  • installation_space_id — BIGINT — 외래 키 → 공간.space_id
  • responsible_user_id — BIGINT — 외래 키 → 사용자_공통.user_id
  • statutory_inspection_required — TINYINT(1) — NOT NULL
  • guarding_description — VARCHAR(1000)
  • risk_grade — VARCHAR(20) — NOT NULL
  • operation_status — VARCHAR(20) — NOT NULL
  • valid_from — DATE — NOT NULL
  • valid_to — DATE
  • is_current — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT — 외래 키 → 사용자_공통.user_id

안전보건역할유형

  • role_type_id — BIGINT — 기본 키 — NOT NULL
  • role_code — VARCHAR(50) — NOT NULL
  • role_name — VARCHAR(200) — NOT NULL
  • role_category — VARCHAR(30) — NOT NULL
  • is_legal_role — TINYINT(1) — NOT NULL
  • qualification_required — TINYINT(1) — NOT NULL
  • description — VARCHAR(2000)
  • is_active — TINYINT(1) — NOT NULL

업무객체

  • business_object_id — BIGINT — 기본 키 — NOT NULL
  • object_type — VARCHAR(40) — NOT NULL
  • object_key — VARCHAR(100) — NOT NULL
  • lifecycle_status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT — 외래 키 → 사용자_공통.user_id

업무문서연결

  • document_link_id — BIGINT — 기본 키 — NOT NULL
  • business_object_id — BIGINT — 외래 키 → 업무객체.business_object_id — NOT NULL
  • attachment_id — BIGINT — 외래 키 → 첨부파일_공통.attachment_id — NOT NULL
  • document_type — VARCHAR(40) — NOT NULL
  • document_version — INTEGER — NOT NULL
  • content_hash — CHAR(64) — NOT NULL
  • malware_scan_status — VARCHAR(20) — NOT NULL
  • source_trust_level — VARCHAR(20) — NOT NULL
  • is_locked — TINYINT(1) — NOT NULL
  • locked_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT — 외래 키 → 사용자_공통.user_id

역할선임

  • role_assignment_id — BIGINT — 기본 키 — NOT NULL
  • business_object_id — BIGINT — 외래 키 → 업무객체.business_object_id — NOT NULL
  • role_type_id — BIGINT — 외래 키 → 안전보건역할유형.role_type_id — NOT NULL
  • workplace_id — BIGINT — 외래 키 → 사업장.workplace_id — NOT NULL
  • department_id — BIGINT — 외래 키 → 부서.department_id
  • assignee_user_id — BIGINT — 외래 키 → 사용자_공통.user_id — NOT NULL
  • appointment_date — DATE — NOT NULL
  • planned_release_date — DATE
  • release_date — DATE
  • assignment_mode — VARCHAR(20) — NOT NULL
  • assignment_status — VARCHAR(20) — NOT NULL
  • appointment_document_no — VARCHAR(100)
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT — 외래 키 → 사용자_공통.user_id
  • updated_at — DATETIME — NOT NULL
  • updated_by — BIGINT — 외래 키 → 사용자_공통.user_id
  • row_version — BIGINT — NOT NULL

역할선임기준

  • role_requirement_rule_id — BIGINT — 기본 키 — NOT NULL
  • role_type_id — BIGINT — 외래 키 → 안전보건역할유형.role_type_id — NOT NULL
  • industry_code — VARCHAR(20)
  • min_worker_count — INTEGER
  • max_worker_count — INTEGER
  • hazard_condition — JSON — NOT NULL
  • required_count — INTEGER — NOT NULL
  • legal_basis — VARCHAR(2000)
  • review_status — VARCHAR(20) — NOT NULL
  • effective_from — DATE — NOT NULL
  • effective_to — DATE
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT — 외래 키 → 사용자_공통.user_id

역할자격요건

  • effective_from — DATE — 기본 키 — NOT NULL
  • role_type_id — BIGINT — 외래 키 → 안전보건역할유형.role_type_id — NOT NULL
  • qualification_type_id — BIGINT — 외래 키 → 자격유형.qualification_type_id — NOT NULL
  • requirement_level — VARCHAR(20) — NOT NULL
  • effective_to — DATE

예산산출내역

  • budget_item_id — BIGINT — 기본 키 — NOT NULL
  • budget_plan_id — BIGINT — 외래 키 → 예산편성.budget_plan_id — NOT NULL
  • line_no — INTEGER — NOT NULL
  • item_name — VARCHAR(300) — NOT NULL
  • quantity — DECIMAL(18,4) — NOT NULL
  • unit_price — DECIMAL(18,2) — NOT NULL
  • amount — DECIMAL(18,2)
  • description — VARCHAR(1000)

예산월별계획

  • budget_monthly_plan_id — BIGINT — 기본 키 — NOT NULL
  • budget_plan_id — BIGINT — 외래 키 → 예산편성.budget_plan_id — NOT NULL
  • plan_month — DATE — NOT NULL
  • planned_amount — DECIMAL(18,2) — NOT NULL
  • description — VARCHAR(1000)

예산집행

  • budget_execution_id — BIGINT — 기본 키 — NOT NULL
  • budget_plan_id — BIGINT — 외래 키 → 예산편성.budget_plan_id — NOT NULL
  • execution_date — DATE — NOT NULL
  • vendor_name — VARCHAR(300)
  • amount — DECIMAL(18,2) — NOT NULL
  • description — VARCHAR(1000)
  • executed_by — BIGINT — 외래 키 → 사용자_공통.user_id
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT — 외래 키 → 사용자_공통.user_id

예산편성

  • budget_plan_id — BIGINT — 기본 키 — NOT NULL
  • business_object_id — BIGINT — 외래 키 → 업무객체.business_object_id — NOT NULL
  • budget_plan_no — VARCHAR(40) — NOT NULL
  • fiscal_year — INTEGER — NOT NULL
  • workplace_id — BIGINT — 외래 키 → 사업장.workplace_id
  • budget_category — VARCHAR(30) — NOT NULL
  • budget_name — VARCHAR(300) — NOT NULL
  • owner_user_id — BIGINT — 외래 키 → 사용자_공통.user_id
  • purpose — TEXT
  • expected_effect — TEXT
  • budget_status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT — 외래 키 → 사용자_공통.user_id
  • updated_at — DATETIME — NOT NULL
  • updated_by — BIGINT — 외래 키 → 사용자_공통.user_id
  • row_version — BIGINT — NOT NULL

유해위험요인

  • hazard_factor_id — BIGINT — 기본 키 — NOT NULL
  • hazard_code — VARCHAR(50) — NOT NULL
  • hazard_name — VARCHAR(200) — NOT NULL
  • hazard_category — VARCHAR(30) — NOT NULL
  • legal_basis — VARCHAR(2000)
  • is_active — TINYINT(1) — NOT NULL

일괄처리오류

  • bulk_job_error_id — BIGINT — 기본 키 — NOT NULL
  • bulk_job_id — BIGINT — 외래 키 → 일괄처리작업.bulk_job_id — NOT NULL
  • row_no — INTEGER — NOT NULL
  • column_name — VARCHAR(100)
  • error_code — VARCHAR(50) — NOT NULL
  • error_message — VARCHAR(1000) — NOT NULL
  • raw_value_masked — VARCHAR(1000)

일괄처리작업

  • bulk_job_id — BIGINT — 기본 키 — NOT NULL
  • job_type — VARCHAR(30) — NOT NULL
  • source_attachment_id — BIGINT — 외래 키 → 첨부파일_공통.attachment_id
  • requested_by — BIGINT — 외래 키 → 사용자_공통.user_id
  • requested_at — DATETIME — NOT NULL
  • job_status — VARCHAR(20) — NOT NULL
  • total_count — INTEGER — NOT NULL
  • valid_count — INTEGER — NOT NULL
  • error_count — INTEGER — NOT NULL
  • completed_at — DATETIME

자격유형

  • qualification_type_id — BIGINT — 기본 키 — NOT NULL
  • qualification_code — VARCHAR(50) — NOT NULL
  • qualification_name — VARCHAR(200) — NOT NULL
  • qualification_group — VARCHAR(30) — NOT NULL
  • issuer_default — VARCHAR(200)
  • validity_managed — TINYINT(1) — NOT NULL
  • renewal_notice_days — INTEGER — NOT NULL
  • is_active — TINYINT(1) — NOT NULL

조직_공통

  • org_id — BIGINT — 기본 키 — NOT NULL

증빙패키지

  • evidence_package_id — BIGINT — 기본 키 — NOT NULL
  • workplace_id — BIGINT — 외래 키 → 사업장.workplace_id — NOT NULL
  • business_object_id — BIGINT — 외래 키 → 업무객체.business_object_id
  • report_template_id — BIGINT — 외래 키 → 보고서템플릿_공통.template_id
  • approval_request_id — BIGINT — 외래 키 → 결재요청.approval_request_id
  • package_type — VARCHAR(40) — NOT NULL
  • as_of_date — DATE — NOT NULL
  • package_version — INTEGER — NOT NULL
  • package_status — VARCHAR(20) — NOT NULL
  • package_hash — CHAR(64)
  • generated_at — DATETIME
  • generated_by — BIGINT — 외래 키 → 사용자_공통.user_id
  • locked_at — DATETIME
  • locked_by — BIGINT — 외래 키 → 사용자_공통.user_id

증빙패키지항목

  • evidence_package_id — BIGINT — 외래 키 → 증빙패키지.evidence_package_id — NOT NULL
  • document_link_id — BIGINT — 외래 키 → 업무문서연결.document_link_id — NOT NULL
  • item_order — INTEGER — NOT NULL

직위_공통

  • position_id — BIGINT — 기본 키 — NOT NULL

첨부파일_공통

  • attachment_id — BIGINT — 기본 키 — NOT NULL