From 1a034c7f6f50e443bc9f97c3d84bfb0a819af6ce Mon Sep 17 00:00:00 2001
From: joonhoekim <26rote@gmail.com>
Date: Tue, 4 Nov 2025 18:15:39 +0900
Subject: (김준회) MDG 자재마스터 테이블 인덱스 추가, MANTR로 MRC Type 반환하는
 서버액션 구현
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 db/schema/MDG/mdg.ts | 6 +++++-
 1 file changed, 5 insertions(+), 1 deletion(-)

(limited to 'db/schema')

diff --git a/db/schema/MDG/mdg.ts b/db/schema/MDG/mdg.ts
index f4f68a20..bf55a1a0 100644
--- a/db/schema/MDG/mdg.ts
+++ b/db/schema/MDG/mdg.ts
@@ -1,4 +1,4 @@
-import { pgSchema, integer, varchar, timestamp, text } from 'drizzle-orm/pg-core';
+import { pgSchema, integer, varchar, timestamp, text, index } from 'drizzle-orm/pg-core';
 
 // 테이블이 너무 많아서 별도 스키마로 분리함
 export const mdgSchema = pgSchema("mdg");
@@ -948,6 +948,10 @@ export const MATERIAL_MASTER_PART_MATL = mdgSchema.table('MATERIAL_MASTER_PART_M
   
   createdAt: timestamp('created_at').defaultNow().notNull(),
   updatedAt: timestamp('updated_at').defaultNow().notNull(),
+}, (table) => {
+  return {
+    matnrIdx: index('material_master_part_matl_matnr_idx').on(table.MATNR),
+  };
 });
 
 export const MATERIAL_MASTER_PART_MATL_CHARASGN = mdgSchema.table('MATERIAL_MASTER_PART_MATL_CHARASGN', {
-- 
cgit v1.2.3