# HR Database Design

## Setup Tables
- hr_departments
- hr_designations
- hr_grades
- hr_contract_types
- hr_leave_types
- hr_permission_types
- hr_loan_types
- hr_bonus_types
- hr_penalty_types
- hr_earning_types
- hr_deduction_types

## Recruitment Tables
- hr_job_requests
- hr_candidates
- hr_candidate_documents
- hr_interviews
- hr_interview_evaluations
- hr_job_offers

## Employee Tables
- hr_employees
- hr_employee_contracts
- hr_employee_documents
- hr_employee_salary_profiles
- hr_employee_allowances
- hr_employee_deductions
- hr_employee_transfers
- hr_employee_secondments
- hr_employee_status_histories
- hr_employee_bank_accounts

## Requests Tables
- hr_leave_requests
- hr_permission_requests
- hr_loan_requests
- hr_data_change_requests
- hr_bonus_requests
- hr_complaint_requests
- hr_resignation_requests

## Attendance Tables
- hr_attendance_records
- hr_overtime_records
- hr_absence_records

## Payroll Tables
- hr_payroll_periods
- hr_payroll_runs
- hr_payroll_lines
- hr_payroll_line_items
- hr_salary_payments
- hr_payroll_postings
- hr_end_of_service_settlements

## Tasks Tables
- hr_tasks
- hr_task_comments
- hr_task_attachments