From 47fb72704161b4b58a27c7f5c679fc44618de9a1 Mon Sep 17 00:00:00 2001
From: dujinkim <dujin.kim@dtsolution.co.kr>
Date: Tue, 4 Nov 2025 10:03:32 +0000
Subject: (최겸) 구매 견적 내 RFQ Cancel/Delete, 연동제 적용, MRC Type 개발
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 db/schema/rfqLast.ts | 8 +++++++-
 1 file changed, 7 insertions(+), 1 deletion(-)

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

diff --git a/db/schema/rfqLast.ts b/db/schema/rfqLast.ts
index b4ec968b..19c213c0 100644
--- a/db/schema/rfqLast.ts
+++ b/db/schema/rfqLast.ts
@@ -14,7 +14,8 @@ export type RfqStatus =
     | "TBE 완료"
     | "RFQ 발송"
     | "견적접수"
-    | "최종업체선정";
+    | "최종업체선정"
+    | "RFQ 삭제";
 
 
 export const rfqsLast = pgTable(
@@ -96,6 +97,9 @@ export const rfqsLast = pgTable(
         // SS = 시리즈 통합, II = 품목 통합, 공란 = 통합 없음
         series: varchar("series", { length: 50 }),
 
+        // RFQ 삭제 사유
+        deleteReason: text("delete_reason"),
+
     },
 
 );
@@ -296,6 +300,7 @@ export const rfqsLastView = pgView("rfqs_last_view").as((qb) => {
             // Basic RFQ identification
             id: sql<number>`${rfqsLast.id}`.as("id"),
             rfqCode: sql<string>`${rfqsLast.rfqCode}`.as("rfq_code"),
+            ANFNR: sql<string | null>`${rfqsLast.ANFNR}`.as("ANFNR"),
             series: sql<string | null>`${rfqsLast.series}`.as("series"),
             rfqSealedYn: sql<boolean | null>`${rfqsLast.rfqSealedYn}`.as("rfq_sealed_yn"),
 
@@ -384,6 +389,7 @@ export const rfqsLastView = pgView("rfqs_last_view").as((qb) => {
             updatedAt: sql<Date>`${rfqsLast.updatedAt}`.as("updated_at"),
 
             remark: sql<string | null>`${rfqsLast.remark}`.as("remark"),
+            deleteReason: sql<string | null>`${rfqsLast.deleteReason}`.as("delete_reason"),
 
             // PR Items related information
             majorItemMaterialCode: sql<string | null>`(
-- 
cgit v1.2.3