From ed864fa46c7ce0aac2de4c5ba5d311ebfd7e6a88 Mon Sep 17 00:00:00 2001
From: dujinkim <dujin.kim@dtsolution.co.kr>
Date: Thu, 15 May 2025 01:34:49 +0000
Subject: (대표님) 벤더 문서 관련 개발사항
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 db/schema/vendorDocu.ts | 3 +++
 1 file changed, 3 insertions(+)

(limited to 'db/schema/vendorDocu.ts')

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,
   
-- 
cgit v1.2.3