diff options
| author | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-10-30 10:44:47 +0000 |
|---|---|---|
| committer | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-10-30 10:44:47 +0000 |
| commit | 871a6d46a769cbe9e87146434f4bcb2d6792ab81 (patch) | |
| tree | acc25b3645e2253625e68f3721a203131ff4f3c4 /db/schema/pq.ts | |
| parent | 17b9d2016be7c0ab6571de6aba36b3f4ea37bdb1 (diff) | |
(최겸) 구매 PQ/실사 재개발(테스트 필요), 정규업체등록 결재 개발, 실사 의뢰 결재 후처리 등
Diffstat (limited to 'db/schema/pq.ts')
| -rw-r--r-- | db/schema/pq.ts | 19 |
1 files changed, 13 insertions, 6 deletions
diff --git a/db/schema/pq.ts b/db/schema/pq.ts index b233119f..11d55473 100644 --- a/db/schema/pq.ts +++ b/db/schema/pq.ts @@ -132,13 +132,13 @@ export const vendorPQSubmissions = pgTable("vendor_pq_submissions", { status: varchar("status", { length: 20, enum: [ - "REQUESTED", - "SUBMITTED", - "APPROVED", - "REJECTED", + "REQUESTED", // PQ 요청됨 + "SUBMITTED", // PQ 제출됨 + "APPROVED", // PQ 승인됨 + "REJECTED", // PQ 거절됨 "QM_REVIEWING", // QM 검토중 - "QM_APPROVED", // QM 승인 - "QM_REJECTED" // QM 거절 + "QM_APPROVED", // QM 승인됨 + "QM_REJECTED" // QM 거절됨 ] }).notNull().default("REQUESTED"), dueDate: timestamp("due_date"), @@ -255,6 +255,7 @@ export const vendorInvestigations = pgTable("vendor_investigations", { length: 50, enum: [ "PLANNED", // 계획됨 + "QM_REVIEW_CONFIRMED", // QM 검토 확정 "IN_PROGRESS", // 진행 중 "COMPLETED", // 완료됨 "CANCELED", // 취소됨 @@ -265,6 +266,11 @@ export const vendorInvestigations = pgTable("vendor_investigations", { .notNull() .default("PLANNED"), + // 보완요청 여부 (최초 보완 요청이 있었는지 기록) + hasSupplementRequested: boolean("has_supplement_requested") + .notNull() + .default(false), + // 실사 주소 investigationAddress: text("investigation_address"), @@ -403,6 +409,7 @@ export const vendorInvestigationsView = pgView( evaluationScore: vendorInvestigations.evaluationScore, evaluationResult: vendorInvestigations.evaluationResult, investigationNotes: vendorInvestigations.investigationNotes, + hasSupplementRequested: vendorInvestigations.hasSupplementRequested, createdAt: vendorInvestigations.createdAt, updatedAt: vendorInvestigations.updatedAt, |