diff options
Diffstat (limited to 'db/schema/vendorDocu.ts')
| -rw-r--r-- | db/schema/vendorDocu.ts | 2 |
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, |