diff options
Diffstat (limited to 'db')
| -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, |