HomeHR & RecruitingEmployee Management System (HRIS)

Employee Management System (HRIS)

Core HRIS with departments, positions, leave management, performance reviews, goals, training, and certifications

SchemaVerse
HR & RecruitingPostgreSQLAudit LogHRNormalized
1
0
0
employee-management.dbml
14 tables|22 relations

About this Schema

Overview

Human Resources Information System for employee lifecycle management. Covers organizational structure, leave tracking, performance reviews, goal setting, training programs, and certification management.

Key Design Decisions

  • Org Structure: Departments and positions with reporting hierarchy
  • Leave Management: PTO accrual, requests, and approval workflow
  • Performance Reviews: Scheduled reviews with rating scales
  • Training Tracking: Required and completed training courses

Tables

14 tables covering employees, departments, positions, leave, performance reviews, goals, training, and certifications. Complete HRIS foundation.

Comments

Sign in to comment on this schema

Loading comments...