From 7433eea5b4bbc0899e255b88e1a7e91f26e9d95b Mon Sep 17 00:00:00 2001
From: joonhoekim <26rote@gmail.com>
Date: Wed, 17 Sep 2025 18:04:10 +0900
Subject: (김준회) 자재그룹 선택기 오류수정, 공용사용을 위한 다이얼로그
 컴포넌트 구현, data-table 오류 수정
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 db/schema/items.ts | 12 ------------
 1 file changed, 12 deletions(-)

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

diff --git a/db/schema/items.ts b/db/schema/items.ts
index e87f256e..e50ff491 100644
--- a/db/schema/items.ts
+++ b/db/schema/items.ts
@@ -88,16 +88,4 @@ export type ItemOffshoreHull = typeof itemOffshoreHull.$inferSelect;
 //각 테이블별 컬럼 변경(itemid -> itemCode)
 
 
-// 자재그룹 검색용 뷰 - 새로운 MATERIAL_GROUP_MASTER 테이블 기반
-export const materialSearchView = pgView("material_search_view").as((qb) => {
-  return qb
-    .select({
-      materialGroupCode: MATERIAL_GROUP_MASTER.MATKL,
-      materialGroupDesc: MATERIAL_GROUP_MASTER.MAKTX
-    })
-    .from(MATERIAL_GROUP_MASTER)
-    .orderBy(MATERIAL_GROUP_MASTER.MATKL);
-});
-
-export type MaterialSearchView = typeof materialSearchView.$inferSelect;
 
-- 
cgit v1.2.3