diff options
| author | joonhoekim <26rote@gmail.com> | 2025-11-04 18:15:39 +0900 |
|---|---|---|
| committer | joonhoekim <26rote@gmail.com> | 2025-11-04 18:15:39 +0900 |
| commit | 1a034c7f6f50e443bc9f97c3d84bfb0a819af6ce (patch) | |
| tree | c6546872915ea10c5b94d7c452cba33f89fdf74e /db/schema/MDG | |
| parent | a1710296dbc1881a7ed86093872904a529901430 (diff) | |
(김준회) MDG 자재마스터 테이블 인덱스 추가, MANTR로 MRC Type 반환하는 서버액션 구현
Diffstat (limited to 'db/schema/MDG')
| -rw-r--r-- | db/schema/MDG/mdg.ts | 6 |
1 files changed, 5 insertions, 1 deletions
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', { |