안전보건관리 시스템 사업장관리 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