diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/schema/pq.ts | 19 | ||||
| -rw-r--r-- | db/schema/vendorRegistrations.ts | 2 |
2 files changed, 14 insertions, 7 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, diff --git a/db/schema/vendorRegistrations.ts b/db/schema/vendorRegistrations.ts index d6030a75..b5f13ca3 100644 --- a/db/schema/vendorRegistrations.ts +++ b/db/schema/vendorRegistrations.ts @@ -16,7 +16,7 @@ import { vendors } from "./vendors"; export const vendorRegularRegistrations = pgTable("vendor_regular_registrations", {
id: serial("id").primaryKey(),
vendorId: integer("vendor_id").notNull().references(() => vendors.id),
- status: varchar("status", { length: 50 }).notNull().default("audit_pass"), // audit_pass, cp_submitted, cp_review, cp_finished, approval_ready, in_review, pending_approval
+ status: varchar("status", { length: 50 }).notNull().default("audit_pass"), // audit_pass, approval_ready, pending_approval, registration_completed, registration_failed
potentialCode: varchar("potential_code", { length: 20 }), // 잠재코드
majorItems: text("major_items"), // 주요품목 (JSON 형태로 저장)
registrationRequestDate: date("registration_request_date"), // 등록요청일
|