Human Resources Database Tables

hr_employees (1) ──< (many) hr_employee_sites >── (1) pf_sites
hr_employees (1) ──< (many) hr_employee_teams
hr_employees (many) >── (1) pf_departments
hr_employees (many) >── (1) hr_positions

hr_job_postings → hr_applications → hr_candidates
                          ↓
                  hr_interviews → hr_interview_feedback
                          ↓
                     hr_offers → hr_offer_approvals
                          ↓
                  hr_hire_transitions → hr_employees

// Submit timesheet entry
const { data } = await supabase
  .from('hr_timesheet_entries')
  .insert({
    timesheet_id: timesheetId,
    work_date: '2026-01-10',
    hours_worked: 8.0,
    entry_type: 'regular',
    project_code: 'PROJ-001'
  });

// Get expiring credentials
const { data } = await supabase
  .from('hr_employee_credentials')
  .select(`
    *,
    employee:hr_employees(first_name, last_name),
    credential_type:hr_credential_types(name)
  `)
  .lte('expiration_date', addDays(new Date(), 30))
  .eq('status', 'active');

hr_incidents → hr_investigations → hr_disciplinary_actions
hr_grievances → hr_investigations

hr_references → hr_reference_emails (audit)
     ↓
Request → Sent → Viewed → Completed
     ↓
Ratings & Feedback stored in hr_references

Webhook fails → hr_background_check_webhook_dlq
     ↓
Retry (up to 3) → Success/Abandoned

const { data } = await supabase
  .from('hr_employees')
  .select(`
    *,
    department:pf_departments(name),
    position:hr_positions(title),
    manager:hr_employees!manager_id(first_name, last_name),
    credentials:hr_employee_credentials(
      *,
      credential_type:hr_credential_types(name)
    )
  `)
  .eq('id', employeeId)
  .single();

const { data } = await supabase
  .from('hr_team_members')
  .select(`
    employee:hr_employees(
      id, first_name, last_name, email,
      position:hr_positions(title)
    )
  `)
  .eq('team_id', teamId);

const { data } = await supabase
  .from('hr_employee_leave_balances')
  .select('*')
  .eq('employee_id', employeeId)
  .eq('leave_type', 'pto')
  .single();