1 files changed, 0 insertions, 12 deletions
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;