From 0e68be98b4ad4691af77232cb0b02b17af825ba3 Mon Sep 17 00:00:00 2001
From: joonhoekim <26rote@gmail.com>
Date: Wed, 6 Aug 2025 04:25:00 +0000
Subject: (김준회) 문서/도서 리스트 및 제출(조선) 메뉴 디버깅(dolce) -
 attachment revisionId 누락건 해결 - crypto 모듈에서 deprecated des-ecb
 알고리즘 사용을 위한 추가 처리 - enhancedDocumentsView에 projectId 추가 -
 route에서 contractId -> projectId 사용하도록 변경
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 642657e2..d451c408 100644
--- a/db/schema/vendorDocu.ts
+++ b/db/schema/vendorDocu.ts
@@ -246,6 +246,7 @@ export const enhancedDocumentsView = pgView("enhanced_documents_view", {
   contractId: integer("contract_id").notNull(),
 
   // ✅ 프로젝트 및 벤더 정보 추가
+  projectId: integer("project_id"),
   projectCode: varchar("project_code", { length: 50 }),
   vendorName: varchar("vendor_name", { length: 255 }),
   vendorCode: varchar("vendor_code", { length: 50 }),
@@ -503,6 +504,7 @@ export const enhancedDocumentsView = pgView("enhanced_documents_view", {
 
     
     -- ✅ 프로젝트 및 벤더 정보 추가
+    c.project_id as project_id,
     p.code as project_code,
     v.vendor_name as vendor_name,
     v.vendor_code as vendor_code,
-- 
cgit v1.2.3