From b5c174429548a53e5c86a13bdbfc61516e5ee345 Mon Sep 17 00:00:00 2001
From: dujinkim <dujin.kim@dtsolution.co.kr>
Date: Tue, 9 Dec 2025 03:04:05 +0000
Subject: (최겸) 구매 구매자서명 내 삼성중공업 정보 입력 추가
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 db/schema/basicContractDocumnet.ts | 2 ++
 db/schema/pq.ts                    | 1 +
 2 files changed, 3 insertions(+)

(limited to 'db')

diff --git a/db/schema/basicContractDocumnet.ts b/db/schema/basicContractDocumnet.ts
index 5edc9836..7c8d4bc5 100644
--- a/db/schema/basicContractDocumnet.ts
+++ b/db/schema/basicContractDocumnet.ts
@@ -284,6 +284,8 @@ export type BasicContractTemplateStatsView = typeof basicContractTemplateStatsVi
 export const buyerSignatures = pgTable('buyer_signatures', {
   id: integer("id").primaryKey().generatedAlwaysAsIdentity(),
   name: varchar('name', { length: 255 }).notNull().default('삼성중공업'),
+  shiAddress: text('shi_address'),
+  shiCeoName: varchar('shi_ceo_name', { length: 255 }),
   imageUrl: text('image_url').notNull(),
   dataUrl: text('data_url'), // Base64 데이터
   mimeType: varchar('mime_type', { length: 100 }),
diff --git a/db/schema/pq.ts b/db/schema/pq.ts
index 68c58613..e273f656 100644
--- a/db/schema/pq.ts
+++ b/db/schema/pq.ts
@@ -433,6 +433,7 @@ export const vendorInvestigationsView = pgView(
       // Essential vendor fields
       vendorName: vendors.vendorName,
       vendorCode: vendors.vendorCode,
+      vendorCountry: vendors.country,
       
       // PQ 정보
       pqItems: vendorPQSubmissions.pqItems,
-- 
cgit v1.2.3