From cd0ce0cbe8af8719a6f542098ec78f2a5c1222ce Mon Sep 17 00:00:00 2001
From: dujinkim <dujin.kim@dtsolution.co.kr>
Date: Mon, 1 Dec 2025 10:28:05 +0000
Subject: (최겸) 구매 입찰 사전견적 개발(rfq-last)
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 db/schema/bidding.ts |  1 +
 db/schema/rfqLast.ts | 20 ++++++++++++++++++++
 2 files changed, 21 insertions(+)

(limited to 'db')

diff --git a/db/schema/bidding.ts b/db/schema/bidding.ts
index cc79f482..c08ea921 100644
--- a/db/schema/bidding.ts
+++ b/db/schema/bidding.ts
@@ -156,6 +156,7 @@ export const biddings = pgTable('biddings', {
   biddingSourceType: varchar('bidding_source_type', { length: 20 }).notNull().default('manual'),
   // 기본 정보
   projectName: varchar('project_name', { length: 300 }), // 프로젝트명
+  projectCode: varchar('project_code', { length: 100 }), // 프로젝트 코드 (새로 추가)
   itemName: varchar('item_name', { length: 300 }), // 품목명
   title: varchar('title', { length: 300 }).notNull(), // 입찰명
   description: text('description'),
diff --git a/db/schema/rfqLast.ts b/db/schema/rfqLast.ts
index 2f2a6710..325942f4 100644
--- a/db/schema/rfqLast.ts
+++ b/db/schema/rfqLast.ts
@@ -83,6 +83,13 @@ export const rfqsLast = pgTable(
         rfqType: varchar("rfq_type", { length: 255 }),
         rfqTitle: varchar("rfq_title", { length: 255 }),
 
+        // 입찰 사전견적 추가 필드
+        biddingNumber: varchar("bidding_number", { length: 50 }),
+        contractStartDate: date("contract_start_date", { mode: "date" })
+            .$type<Date | null>(),
+        contractEndDate: date("contract_end_date", { mode: "date" })
+            .$type<Date | null>(),
+
         //ITB 추가 필드
         projectCompany: varchar("project_company", { length: 255 }),
         projectFlag: varchar("project_flag", { length: 255 }),
@@ -309,6 +316,11 @@ export const rfqsLastView = pgView("rfqs_last_view").as((qb) => {
             rfqType: sql<string | null>`${rfqsLast.rfqType}`.as("rfq_type"),
             rfqTitle: sql<string | null>`${rfqsLast.rfqTitle}`.as("rfq_title"),
 
+            // 입찰 사전견적 추가 필드
+            biddingNumber: sql<string | null>`${rfqsLast.biddingNumber}`.as("bidding_number"),
+            contractStartDate: sql<Date | null>`${rfqsLast.contractStartDate}`.as("contract_start_date"),
+            contractEndDate: sql<Date | null>`${rfqsLast.contractEndDate}`.as("contract_end_date"),
+
             // ITB 관련 필드
             projectCompany: sql<string | null>`${rfqsLast.projectCompany}`.as("project_company"),
             projectFlag: sql<string | null>`${rfqsLast.projectFlag}`.as("project_flag"),
@@ -480,6 +492,11 @@ export const rfqLastDetailsView = pgView("rfq_last_details_view").as((qb) => {
             rfqType: sql<string | null>`${rfqsTable.rfqType}`.as("rfq_type"),
             rfqTitle: sql<string | null>`${rfqsTable.rfqTitle}`.as("rfq_title"),
 
+            // 입찰 사전견적 추가 필드
+            biddingNumber: sql<string | null>`${rfqsTable.biddingNumber}`.as("bidding_number"),
+            contractStartDate: sql<Date | null>`${rfqsTable.contractStartDate}`.as("contract_start_date"),
+            contractEndDate: sql<Date | null>`${rfqsTable.contractEndDate}`.as("contract_end_date"),
+
             // ITB 관련 정보
             projectCompany: sql<string | null>`${rfqsTable.projectCompany}`.as("project_company"),
             projectFlag: sql<string | null>`${rfqsTable.projectFlag}`.as("project_flag"),
@@ -677,6 +694,9 @@ export const prItemsLastView = pgView("pr_items_last_view").as((qb) => {
             rfqCode: rfqsLast.rfqCode,
             rfqType: rfqsLast.rfqType,
             rfqTitle: rfqsLast.rfqTitle,
+            biddingNumber: rfqsLast.biddingNumber,
+            contractStartDate: rfqsLast.contractStartDate,
+            contractEndDate: rfqsLast.contractEndDate,
             itemCode: rfqsLast.itemCode,
             itemName: rfqsLast.itemName,
             prNumber: rfqsLast.prNumber,
-- 
cgit v1.2.3