(대표님) 변경사항 20250707 10시 43분 - unstaged 변경사항 추가

1 files changed, 2 insertions, 0 deletions

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,