Dashboard Overview

Core Database Schema

-- Core Entities
users (id, email, password_hash, role_id, status, created_at)
roles (id, name, permissions_json, hierarchy_level)
employees (id, user_id, employee_code, department_id, manager_id, join_date, salary_band)
departments (id, name, cost_center, parent_id)
 
-- HR Modules
attendance_records (id, employee_id, date, check_in, check_out, status, gps_location)
leave_requests (id, employee_id, type, start_date, end_date, status, approver_id)
payroll_runs (id, month, year, status, total_amount, processed_by)
payroll_items (id, payroll_run_id, employee_id, base_salary, deductions, bonuses, net_pay)
recruitment_jobs (id, title, department_id, status, posted_date, closing_date)
candidates (id, job_id, name, email, stage, rating, resume_url)
performance_reviews (id, employee_id, reviewer_id, period, goals_json, rating, feedback)
training_courses (id, title, provider, duration, certification_available)
enrollments (id, employee_id, course_id, status, completion_date, score)