hk-hrms

Tables (8)

department(tree, closure-table) (department)

  • departmentId — uuid — Primary key — NOT NULL
  • departmentName (Field) — text
  • parentDepartmentId — uuid — Foreign key → department(tree, closure-table).departmentId — NOT NULL
  • userId (leaderId) — uuid — Foreign key → user.userId — NOT NULL

goal

  • goalId — uuid — Primary key — NOT NULL
  • description — text
  • created — Date
  • updated — Date
  • userAppraisalId — uuid — Foreign key → user_appraisal.userAppraisalId — NOT NULL

goal_assessment_by

  • goalAssessId — uuid — Primary key — NOT NULL
  • grade — A|B|C or O|E|M|P|N
  • created — date
  • updated — date
  • goalId — uuid — Foreign key → goal.goalId — NOT NULL
  • userId — uuid — Foreign key → user.userId — NOT NULL

performance_appraisal (CopyOfperformance_appraisal)

  • appraisalId — uuid — Primary key — NOT NULL
  • title — title
  • description — string
  • endDate — Date
  • appraisalType — "2025-q1" | "2025-q2" | "2025-q3" | "2025-q4" or "2025-mid" | "2025-final" or "yearly ex) 2025"
  • status — ongoing | draft | finished

performance_appraisal_by

  • appraisalById — uuid — Primary key — NOT NULL
  • assessType — performance | competency
  • assessTerm — mid|final
  • grade — A|B|C or O|E|M|P|N
  • comment — text
  • created — date
  • updated — date
  • userId — uuid — Foreign key → user.userId — NOT NULL

user

  • userId — uuid — Primary key — NOT NULL
  • kroeanName (koreanName) — text
  • email — text
  • pw — text
  • lv — reviewer | both | reviewee
  • created — date
  • updated — date

user-department

  • Key — Primary key — NOT NULL
  • userId — uuid — Foreign key → user.userId — NOT NULL
  • departmentId — uuid — Foreign key → department(tree, closure-table).departmentId — NOT NULL

user_appraisal

  • userAppraisalId — uuid — Primary key — NOT NULL
  • appraisalId (appraisalId2) — uuid — Foreign key → performance_appraisal.appraisalId — NOT NULL
  • appraisalById — uuid — Foreign key → performance_appraisal_by.appraisalById — NOT NULL
  • userId (targetUser) — uuid — Foreign key → user.userId — NOT NULL
  • status — text