From b67e36df49f067cbd5ba899f9fbcc755f38d4b4f Mon Sep 17 00:00:00 2001
From: dujinkim <dujin.kim@dtsolution.co.kr>
Date: Thu, 4 Sep 2025 08:31:31 +0000
Subject: (대표님, 최겸, 임수민) 작업사항 커밋
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

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

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

diff --git a/db/schema/rfqLast.ts b/db/schema/rfqLast.ts
index 34c61cd0..a9f91308 100644
--- a/db/schema/rfqLast.ts
+++ b/db/schema/rfqLast.ts
@@ -315,6 +315,23 @@ export const rfqsLastView = pgView("rfqs_last_view").as((qb) => {
                 LIMIT 1
             )`.as("major_item_material_code"),
 
+            majorItemMaterialDescription: sql<string | null>`(
+                SELECT material_description 
+                FROM rfq_pr_items 
+                WHERE rfqs_last_id = ${rfqsLast.id}
+                AND major_yn = true
+                LIMIT 1
+            )`.as("major_item_materialD_description"),
+
+            
+            majorItemMaterialCategory: sql<string | null>`(
+                SELECT material_category 
+                FROM rfq_pr_items 
+                WHERE rfqs_last_id = ${rfqsLast.id}
+                AND major_yn = true
+                LIMIT 1
+            )`.as("major_item_material_category"),
+
             majorItemPrNo: sql<string | null>`(
                 SELECT pr_no 
                 FROM rfq_pr_items 
-- 
cgit v1.2.3