(대표님) 벤더 문서 관련 개발사항

1 files changed, 3 insertions, 0 deletions

diff --git a/db/schema/vendorDocu.ts b/db/schema/vendorDocu.ts
index 1e166e6b..8eb9cbc6 100644
--- a/db/schema/vendorDocu.ts
+++ b/db/schema/vendorDocu.ts
@@ -13,6 +13,7 @@ export const documents = pgTable(
 
     // documentType: varchar("document_type", { length: 50 }).notNull(),
 
+    pic: varchar("pic", { length: 50 }),
 
     // 어느 계약(Contract) 소속인지
     contractId: integer("contract_id")
@@ -128,6 +129,7 @@ export const vendorDocumentsView = pgView("vendor_documents_view", {
   id: integer("id").notNull(),
   docNumber: varchar("doc_number", { length: 100 }).notNull(),
   title: varchar("title", { length: 255 }).notNull(),
+  pic: varchar("pic", { length: 255 }).notNull(),
   status: varchar("status", { length: 50 }).notNull(),
   issuedDate: date("issued_date"),
 
@@ -152,6 +154,7 @@ export const vendorDocumentsView = pgView("vendor_documents_view", {
       d.id, 
       d.doc_number,
       d.title,
+      d.pic,
       d.status,
       d.issued_date,