diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/schema/MDG/mdg.ts | 5 | ||||
| -rw-r--r-- | db/schema/items.ts | 12 |
2 files changed, 3 insertions, 14 deletions
diff --git a/db/schema/MDG/mdg.ts b/db/schema/MDG/mdg.ts index 7dd2db88..f4f68a20 100644 --- a/db/schema/MDG/mdg.ts +++ b/db/schema/MDG/mdg.ts @@ -1039,8 +1039,9 @@ export const MATERIAL_MASTER_PART_MATL_UNIT = mdgSchema.table('MATERIAL_MASTER_P // [별도 테이블] 자재그룹코드 마스터 - MATKL, MAKTX 중복 최소화 export const MATERIAL_GROUP_MASTER = mdgSchema.table('MATERIAL_GROUP_MASTER', { - MATKL: varchar('MATKL', { length: 1000 }).primaryKey(), // Material Group Code (자재그룹코드) - 기본 키 - MAKTX: varchar('MAKTX', { length: 1000 }), // Material Group Description (자재그룹명) - 영어(SPRAS='E') 기준 + materialGroupCode: varchar('material_group_code', { length: 1000 }).primaryKey(), // Material Group Code (자재그룹코드) - 기본 키 + materialGroupDescription: varchar('material_group_description', { length: 1000 }), // Material Group Description (자재그룹명) - 영어 + materialGroupUom: varchar('material_group_uom', { length: 1000 }), // Material Group UOM (UOM = Unit of Measure) createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), 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; |