인사관리_rev2
테이블 (29)
가족사항 (employee_family)
- employee_family_id — BIGINT — 기본 키
- family_name — VARCHAR(100) — NOT NULL
- family_relation — VARCHAR(50) — NOT NULL
- birth_date — DATE
- job — VARCHAR(100)
- company_name — VARCHAR(100)
- living_together — BOOLEAN
- dependent — BOOLEAN
- disabled — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- created_by — VARCHAR(100)
- updated_by — VARCHAR(100)
- deleted — BOOLEAN
- active — BOOLEAN
- employee_id (employee_id2) — BIGINT — 외래 키 → 사원.employee_id
경력정보 (employee_career)
- employee_career_id — BIGINT — 기본 키
- company_name — VARCHAR(200) — NOT NULL
- hire_date — DATE
- resignation_date — DATE
- position_name — VARCHAR(100)
- department_name — VARCHAR(100)
- resignation_reason — VARCHAR(200)
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- created_by — VARCHAR(100)
- updated_by — VARCHAR(100)
- deleted — BOOLEAN
- active — BOOLEAN
- employee_id — BIGINT — 외래 키 → 사원.employee_id
경조사비 (employee_event_support)
- employee_event_support_id — BIGINT — 기본 키
- employee_id — BIGINT — 외래 키 → 사원.employee_id
- application_no — VARCHAR(30) — NOT NULL — 신청번호
- event_type — VARCHAR(100) — NOT NULL — 결혼, 부모상, 출산 등
- family_relation — VARCHAR(100) — 부, 모, 배우자 등
- target_name — VARCHAR(100) — NOT NULL — 대상자 성명
- application_date — DATE — NOT NULL — 신청일자
- event_date — DATE — NOT NULL — 경조일자
- requested_amount — INT — NOT NULL — 신청금액
- event_location — VARCHAR(255) — 경조장소
- bank_name — VARCHAR(100) — NOT NULL — 은행명
- account_number — VARCHAR(100) — NOT NULL — 계좌번호
- account_holder — VARCHAR(100) — NOT NULL — 예금주
- approval_status — VARCHAR(50) — NOT NULL — PENDING, APPROVED, REJECTED, PAID
- memo — VARCHAR(1000) — 비고
- deleted — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
근태 (attendance)
- attendance_id — BIGINT — 기본 키
- employee_id — BIGINT — 외래 키 → 사원.employee_id — NOT NULL
- work_date — DATE — NOT NULL
- check_in_time — DATETIME
- check_out_time — DATETIME
- work_minutes — INT
- overtime_minutes — INT
- night_work_minutes — INT
- late_minutes — INT
- early_leave_minutes — INT
- attendance_status_code — VARCHAR(30)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted — BOOLEAN — NOT NULL
- active — BOOLEAN — NOT NULL
급여 (payroll)
- payroll_id — BIGINT — 기본 키
- employee_id — BIGINT — 외래 키 → 사원.employee_id — NOT NULL
- payroll_year_month — VARCHAR(6) — NOT NULL
- payment_date — DATE
- total_pay_amount — DECIMAL(15,2) — NOT NULL
- total_deduction_amount — DECIMAL(15,2) — NOT NULL
- real_pay_amount — DECIMAL(15,2) — NOT NULL
- payroll_status_code — VARCHAR(30)
- employee_name_snapshot — VARCHAR(100)
- department_name_snapshot — VARCHAR(100)
- position_name_snapshot — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted — BOOLEAN — NOT NULL
- active — BOOLEAN — NOT NULL
급여마스터 (payroll_item_master)
- payroll_item_master_id — BIGINT — 기본 키
- item_name — VARCHAR(100) — NOT NULL
- item_type_code — VARCHAR(30) — NOT NULL
- taxable — BOOLEAN — NOT NULL
- fixed — BOOLEAN — NOT NULL
- active — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted — BOOLEAN — NOT NULL
급여상세 (payroll_detail)
- payroll_detail_id — BIGINT — 기본 키
- payroll_id — BIGINT — 외래 키 → 급여.payroll_id — NOT NULL
- payroll_item_master_id — BIGINT — 외래 키 → 급여마스터.payroll_item_master_id — NOT NULL
- item_name_snapshot — VARCHAR(100) — NOT NULL
- item_type_code — VARCHAR(30) — NOT NULL
- amount — DECIMAL(15,2) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted — BOOLEAN — NOT NULL
발령이력 (employee_appointment)
- employee_appointment_id — BIGINT — 기본 키
- employee_id — BIGINT — 외래 키 → 사원.employee_id
- appointment_type — VARCHAR(50) — NOT NULL — PROMOTION, TRANSFER, LEAVE ...
- appointment_date — DATE — NOT NULL
- effective_date — DATE
- from_department_id — BIGINT
- to_department_id — BIGINT
- from_position_name — VARCHAR(100)
- to_position_name — VARCHAR(100)
- from_job_title — VARCHAR(100)
- to_job_title — VARCHAR(100)
- reason — VARCHAR(500)
- memo — VARCHAR(1000)
- deleted — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
병역정보 (employee_military)
- employee_military_id — BIGINT — 기본 키
- discharge_type — VARCHAR(100)
- enlistment_date — DATE
- discharge_date — DATE
- military_type — VARCHAR(100)
- military_rank — VARCHAR(100)
- exemption_reason — VARCHAR(200)
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- created_by — VARCHAR(100)
- updated_by — VARCHAR(100)
- deleted — BOOLEAN
- active — BOOLEAN
- employee_id — BIGINT — 외래 키 → 사원.employee_id
부서 (department)
- department_id — BIGINT — 기본 키
- department_name — VARCHAR(100) — NOT NULL
- parent_department_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted — BOOLEAN — NOT NULL
- active — BOOLEAN — NOT NULL
사원 (employee)
- employee_id — BIGINT — 기본 키
- employee_no — VARCHAR(30) — NOT NULL
- department_id — BIGINT — 외래 키 → 부서.department_id
- position_id — BIGINT — 외래 키 → 직책.position_id
- employment_type_id — BIGINT — 외래 키 → 사원타입.employment_type_id
- name — VARCHAR(100) — NOT NULL
- birth_date — DATE
- phone — VARCHAR(30)
- email — VARCHAR(100)
- address — VARCHAR(255)
- hire_date — DATE
- resignation_date — DATE
- employee_status_code — VARCHAR(30)
- bank_name — VARCHAR(100)
- account_number — VARCHAR(100)
- account_holder — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted — BOOLEAN — NOT NULL
- active — BOOLEAN — NOT NULL
- employee_id (employee_id2) — BIGINT — 외래 키 → 사원.employee_id
- password — VARCHAR(100)
사원타입 (employment_type)
- employment_type_id — BIGINT — 기본 키
- employment_type_name — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted — BOOLEAN — NOT NULL
- active — BOOLEAN — NOT NULL
소셜회원정보 (employee_oauth)
- employee_oauth_id — BIGINT — 기본 키 — NOT NULL
- employee_id — BIGINT — 외래 키 → 사원.employee_id
- provider — VARCHAR(20) — NOT NULL — KAKAO, GOOGLE, NAVER
- provider_user_id — VARCHAR(100) — NOT NULL — 소셜 서비스의 고유 ID
- provider_email — VARCHAR(255) — 소셜 계정 이메일
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
수당 (employee_allowance)
- employee_allowance_id — BIGINT — 기본 키
- employee_id — BIGINT — 외래 키 → 사원.employee_id — NOT NULL
- allowance_id — BIGINT — 외래 키 → 수당마스터.allowance_id — NOT NULL
- amount — DECIMAL(15,2) — NOT NULL
- start_date — DATE
- end_date — DATE
- active — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted — BOOLEAN — NOT NULL
수당마스터 (allowance)
- allowance_id — BIGINT — 기본 키
- allowance_name — VARCHAR(100) — NOT NULL
- taxable — BOOLEAN — NOT NULL
- fixed — BOOLEAN — NOT NULL
- active — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted — BOOLEAN — NOT NULL
어학정보 (employee_language)
- employee_language_id — BIGINT — 기본 키
- language_name — VARCHAR(100) — NOT NULL
- reading_level — VARCHAR(50)
- writing_level — VARCHAR(50)
- speaking_level — VARCHAR(50)
- test_name — VARCHAR(100)
- test_score — VARCHAR(100)
- issued_date — DATE
- issuer — VARCHAR(100)
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- created_by — VARCHAR(100)
- updated_by — VARCHAR(100)
- deleted — BOOLEAN
- active — BOOLEAN
운송물품 (transport_cargo)
- transport_cargo_id — BIGINT — 기본 키 — NOT NULL — 운송 화물 ID
- transport_id (transport_id2) — BIGINT — 외래 키 → 운송테이블.transport_id — NOT NULL
- cargo_name — VARCHAR(100) — NOT NULL — 화물명
- cargo_type — VARCHAR(30) — 화물 유형
- quantity — INT — NOT NULL — 수량
- weight — DECIMAL(10, 2) — 화물 무게(kg)
- volume — DECIMAL(10, 2) — 화물 부피(m3)
- handling_note — VARCHAR(500) — 취급 주의사항
- created_at — DATETIME — NOT NULL — 생성일시
- updated_at — DATETIME — NOT NULL — 수정일시
운송테이블 (transport)
- transport_id — BIGINT — 기본 키 — NOT NULL
- driver_id (driver_id2) — BIGINT — 외래 키 → 지입기사.driver_id — NOT NULL
- vehicle_id (vehicle_id2) — BIGINT — 외래 키 → 차량.vehicle_id — NOT NULL
- transport_no — VARCHAR(30) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- departure_address — VARCHAR(255) — NOT NULL
- departure_latitude — DECIMAL(10,7) — NOT NULL
- departure_longitude — DECIMAL(10,7) — NOT NULL
- destination_address — VARCHAR(255) — NOT NULL
- destination_latitude — DECIMAL(10,7) — NOT NULL
- destination_longitude — DECIMAL(10,7) — NOT NULL
- current_latitude — DECIMAL(10,7)
- current_longitude — DECIMAL(10,7)
- scheduled_start_at — DATETIME
- started_at — DATETIME
- estimated_arrival_at — DATETIME
- completed_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
자격증정보 (employee_certificate)
- employee_certificate_id — BIGINT — 기본 키
- certificate_name — VARCHAR(200) — NOT NULL
- issuer — VARCHAR(100)
- acquired_date — DATE
- expiration_date — DATE
- certificate_number — VARCHAR(100)
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- created_by — VARCHAR(100)
- updated_by — VARCHAR(100)
- deleted — BOOLEAN
- active — BOOLEAN
- employee_id — BIGINT — 외래 키 → 사원.employee_id
잔여휴가 (employee_leave_balance)
- employee_leave_balance_id — BIGINT — 기본 키
- leave_type_id — BIGINT — 외래 키 → 휴가마스터.leave_type_id — NOT NULL
- employee_id — BIGINT — 외래 키 → 사원.employee_id
- total_days — DECIMAL(5,1) — NOT NULL
- used_days — DECIMAL(5,1) — NOT NULL
- remain_days — DECIMAL(5,1) — NOT NULL
- expire_date — DATE
- created_at — DATETIME
증명서발급 (employee_certificate_issue)
- employee_certificate_issue_id — BIGINT — 기본 키
- employee_id (employee_id2) — BIGINT — 외래 키 → 사원.employee_id
- application_no — VARCHAR(30) — NOT NULL — 신청번호
- certificate_type — VARCHAR(100) — NOT NULL — 증명서구분
- application_date — DATE — NOT NULL — 신청일자
- issue_status — VARCHAR(50) — NOT NULL — WAITING, ISSUED, REJECTED
- issued_at — DATETIME — 발행일자
- approval_status — VARCHAR(50) — NOT NULL — PENDING, APPROVED, REJECTED
- purpose — VARCHAR(500) — 용도
- memo — VARCHAR(1000) — 비고
- deleted — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
지입기사 (driver)
- driver_id — BIGINT — 기본 키 — NOT NULL
- driver_name — VARCHAR(50) — NOT NULL
- phone_number — VARCHAR(20)
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
직급별휴가정책 (leave_policy)
- leave_policy_id — BIGINT — 기본 키
- annual_leave_days — DECIMAL(4,1) — NOT NULL
- max_carry_over_days — DECIMAL(4,1)
- half_day_allowed — BOOLEAN
- note — VARCHAR(255)
- created_at — DATETIME
- position_id — BIGINT — 외래 키 → 직책.position_id
직책 (position)
- position_id — BIGINT — 기본 키
- position_name — VARCHAR(100) — NOT NULL
- level — INT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted — BOOLEAN — NOT NULL
- active — BOOLEAN — NOT NULL
차량 (vehicle)
- vehicle_id — BIGINT — 기본 키 — NOT NULL
- vehicle_number — VARCHAR(20) — NOT NULL
- vehicle_type — VARCHAR(30)
- capacity_ton — DECIMAL(5,1)
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
첨부파일 (file_attachment)
- file_id (pk) — BIGINT — 기본 키 — NOT NULL — 파일 PK
- ref_type — VARCHAR(50) — NOT NULL — 업무 유형 (CONDOLENCE, APPOINTMENT, BOARD 등)
- ref_id (등록폼PK) — BIGINT — NOT NULL — 업무 데이터 PK
- original_name — VARCHAR(255) — NOT NULL — 원본 파일명
- stored_name — VARCHAR(255) — NOT NULL — 저장 파일명(UUID 등)
- file_path — VARCHAR(500) — NOT NULL — 저장 경로
- extension — VARCHAR(20) — 확장자
- content_type — VARCHAR(100) — MIME 타입
- file_size — BIGINT — NOT NULL — 파일 크기(Byte)
- created_by — VARCHAR(50) — 등록자
- created_at — DATETIME — NOT NULL — 등록일시
학력정보 (employee_education)
- employee_education_id — BIGINT — 기본 키
- entrance_year_month — VARCHAR(6)
- graduate_year_month — VARCHAR(6)
- school_name — VARCHAR(200) — NOT NULL
- major_name — VARCHAR(200)
- degree — VARCHAR(100)
- graduate_status — VARCHAR(50)
- location — VARCHAR(100)
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- created_by — VARCHAR(100)
- updated_by — VARCHAR(100)
- deleted — BOOLEAN
- active — BOOLEAN
- employee_id — BIGINT — 외래 키 → 사원.employee_id
휴가마스터 (leave_type)
- leave_type_id — BIGINT — 기본 키
- leave_type_name — VARCHAR(100) — NOT NULL
- paid_yn — BOOLEAN — NOT NULL
- default_days — DECIMAL(4,1)
- note — VARCHAR(255)
- created_at — DATETIME
휴가신청내역 (leave_request)
- leave_request_id — BIGINT — 기본 키
- leave_type_id — BIGINT — 외래 키 → 휴가마스터.leave_type_id — NOT NULL
- employee_id — BIGINT — 외래 키 → 사원.employee_id
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- leave_days — DECIMAL(4,1) — NOT NULL
- reason — TEXT
- status — VARCHAR(30) — NOT NULL
- approver_id — BIGINT
- created_at — DATETIME