diff options
Diffstat (limited to 'db')
| -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', { |