From 90f79a7a691943a496f67f01c1e493256070e4de Mon Sep 17 00:00:00 2001 From: dujinkim Date: Mon, 7 Jul 2025 01:44:45 +0000 Subject: (대표님) 변경사항 20250707 10시 43분 - unstaged 변경사항 추가 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- db/schema/vendorDocu.ts | 2 ++ 1 file changed, 2 insertions(+) (limited to 'db/schema/vendorDocu.ts') diff --git a/db/schema/vendorDocu.ts b/db/schema/vendorDocu.ts index 1953d5ac..80eb5c5d 100644 --- a/db/schema/vendorDocu.ts +++ b/db/schema/vendorDocu.ts @@ -226,6 +226,7 @@ export const enhancedDocumentsView = pgView("enhanced_documents_view", { projectCode: varchar("project_code", { length: 50 }), vendorName: varchar("vendor_name", { length: 255 }), vendorCode: varchar("vendor_code", { length: 50 }), + vendorId: varchar("vendor_id", { length: 50 }), // ✅ B4 전용 필드들 (drawingKind가 B4일 때만 사용) cGbn: varchar("c_gbn", { length: 50 }), // CGbn @@ -482,6 +483,7 @@ export const enhancedDocumentsView = pgView("enhanced_documents_view", { p.code as project_code, v.vendor_name as vendor_name, v.vendor_code as vendor_code, + c.vendor_id as vendor_id, -- 현재 스테이지 정보 csi.current_stage_id, -- cgit v1.2.3