diff options
| author | joonhoekim <26rote@gmail.com> | 2025-08-06 04:25:00 +0000 |
|---|---|---|
| committer | joonhoekim <26rote@gmail.com> | 2025-08-06 04:25:00 +0000 |
| commit | 0e68be98b4ad4691af77232cb0b02b17af825ba3 (patch) | |
| tree | 09dd9152c87a9c21343e6a1562c959a828e2b462 /db/schema/vendorDocu.ts | |
| parent | de2ac5a2860bc25180971e7a11f852d9d44675b7 (diff) | |
(김준회) 문서/도서 리스트 및 제출(조선) 메뉴 디버깅(dolce)
- attachment revisionId 누락건 해결
- crypto 모듈에서 deprecated des-ecb 알고리즘 사용을 위한 추가 처리
- enhancedDocumentsView에 projectId 추가
- route에서 contractId -> projectId 사용하도록 변경
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 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, |