인사관리_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