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