summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authordujinkim <dujin.kim@dtsolution.co.kr>2025-07-15 10:07:09 +0000
committerdujinkim <dujin.kim@dtsolution.co.kr>2025-07-15 10:07:09 +0000
commit4eb7532f822c821fb6b69bf103bd075fefba769b (patch)
treeb4bcf6c0bf791d71569f3f35498ed256bf7cfaf3 /db
parent660c7888d885badab7af3e96f9c16bd0172ad0f1 (diff)
(대표님) 20250715 협력사 정기평가, spreadJS, roles 서비스에 함수 추가
Diffstat (limited to 'db')
-rw-r--r--db/schema/evaluationTarget.ts8
1 files changed, 4 insertions, 4 deletions
diff --git a/db/schema/evaluationTarget.ts b/db/schema/evaluationTarget.ts
index 466143be..1bb9ae02 100644
--- a/db/schema/evaluationTarget.ts
+++ b/db/schema/evaluationTarget.ts
@@ -406,22 +406,22 @@ export const periodicEvaluations = pgTable("periodic_evaluations", {
finalScore: decimal("final_score", { precision: 5, scale: 2 }),
finalGrade: varchar("final_grade", {
length: 5,
- enum: ["S", "A", "B", "C", "D"]
+ enum: ["A", "B", "C", "D"]
}),
// 평가 점수 (평가자 평균)
evaluationScore: decimal("evaluation_score", { precision: 5, scale: 2 }),
evaluationGrade: varchar("evaluation_grade", {
length: 5,
- enum: ["S", "A", "B", "C", "D"]
+ enum: ["A", "B", "C", "D"]
}),
// 평가 상태
status: varchar("status", {
length: 30,
- enum: ["PENDING_SUBMISSION", "SUBMITTED", "IN_REVIEW", "REVIEW_COMPLETED", "FINALIZED"]
- }).notNull().default("PENDING_SUBMISSION"),
+ enum: ["PENDING","PENDING_SUBMISSION", "SUBMITTED", "IN_REVIEW", "REVIEW_COMPLETED", "FINALIZED"]
+ }).notNull().default("PENDING"),
// 평가 완료 정보
reviewCompletedAt: timestamp("review_completed_at"),