summaryrefslogtreecommitdiff
path: root/db/schema/pq.ts
diff options
context:
space:
mode:
authordujinkim <dujin.kim@dtsolution.co.kr>2025-12-09 05:31:04 +0000
committerdujinkim <dujin.kim@dtsolution.co.kr>2025-12-09 05:31:04 +0000
commit3462d754574e2558c791c7958d3e5da013a7a573 (patch)
tree6eb26fddda5e4081fdead977c0ec6b152286d164 /db/schema/pq.ts
parent3f11179b2c50d7ee56b0cea38778191e3259b941 (diff)
(최겸) 구매 pq 내 안전 담당자 평가 기능 추가, vendor 안전적격성 평가 컬럼 추가
Diffstat (limited to 'db/schema/pq.ts')
-rw-r--r--db/schema/pq.ts10
1 files changed, 6 insertions, 4 deletions
diff --git a/db/schema/pq.ts b/db/schema/pq.ts
index e273f656..33f095c4 100644
--- a/db/schema/pq.ts
+++ b/db/schema/pq.ts
@@ -149,10 +149,12 @@ export const vendorPQSubmissions = pgTable("vendor_pq_submissions", {
status: varchar("status", {
length: 20,
enum: [
- "REQUESTED", // PQ 요청됨
- "SUBMITTED", // PQ 제출됨
- "APPROVED", // PQ 승인됨
- "REJECTED", // PQ 거절됨
+ "REQUESTED", // PQ 요청됨
+ "SUBMITTED", // PQ 제출됨
+ "SAFETY_APPROVED", // 안전 승인됨
+ "SAFETY_REJECTED", // 안전 거절됨
+ "APPROVED", // PQ 승인됨
+ "REJECTED", // PQ 거절됨
"QM_REVIEWING", // QM 검토중
"QM_APPROVED", // QM 승인됨
"QM_REJECTED" // QM 거절됨