diff options
| author | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-08-11 09:00:38 +0000 |
|---|---|---|
| committer | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-08-11 09:00:38 +0000 |
| commit | eb654f88214095f71be142b989e620fd28db3f69 (patch) | |
| tree | aaad3074de4a6422a880b35f9e577d489b0a6c91 /db/schema | |
| parent | a383fd2a30f60360ebc0c1b897b3d43cbae178fa (diff) | |
(최겸) 기술영업 변경사항 반영, PQ/실사 변경사항 반영
Diffstat (limited to 'db/schema')
| -rw-r--r-- | db/schema/pq.ts | 12 |
1 files changed, 0 insertions, 12 deletions
diff --git a/db/schema/pq.ts b/db/schema/pq.ts index 580a45b3..7adcbf8b 100644 --- a/db/schema/pq.ts +++ b/db/schema/pq.ts @@ -262,17 +262,6 @@ export const vendorInvestigations = pgTable("vendor_investigations", { .notNull() .default("PLANNED"), - // 평가 유형 - evaluationType: varchar("evaluation_type", { - length: 50, - enum: [ - "PURCHASE_SELF_EVAL", // 구매자체평가 - 신규 평가 - "DOCUMENT_EVAL", // 서류평가 - 기존 QM 자체평가 - "PRODUCT_INSPECTION", // 제품검사평가 - 기존 실사의뢰평가 - "SITE_VISIT_EVAL" // 방문실사평가 - 기존 실사의뢰평가 - ], - }), - // 실사 주소 investigationAddress: text("investigation_address"), @@ -398,7 +387,6 @@ export const vendorInvestigationsView = pgView( requesterId: vendorInvestigations.requesterId, qmManagerId: vendorInvestigations.qmManagerId, investigationStatus: vendorInvestigations.investigationStatus, - evaluationType: vendorInvestigations.evaluationType, investigationAddress: vendorInvestigations.investigationAddress, investigationMethod: vendorInvestigations.investigationMethod, scheduledStartAt: vendorInvestigations.scheduledStartAt, |