From 45f4c426c98d86a251644a4858740bec989edf83 Mon Sep 17 00:00:00 2001 From: dujinkim Date: Tue, 20 May 2025 09:01:22 +0000 Subject: (최겸) 기술영업 아이템리스트 수정 및 개발 0520 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- db/schema/items.ts | 15 ++++++--------- 1 file changed, 6 insertions(+), 9 deletions(-) (limited to 'db/schema/items.ts') diff --git a/db/schema/items.ts b/db/schema/items.ts index 4218f0f4..a032de04 100644 --- a/db/schema/items.ts +++ b/db/schema/items.ts @@ -31,7 +31,8 @@ export const itemShipbuilding = pgTable("item_shipbuilding", { id: serial("id").primaryKey(), itemId: integer("item_id").notNull().references(() => items.id, { onDelete: 'cascade' }), workType: workTypeEnum("work_type").notNull(), - shipTypes: text("ship_types").notNull().default('A-MAX'), + itemList: text("item_list"), + shipTypes: text("ship_types").notNull().default('OPTION'), createdAt: timestamp("created_at").defaultNow().notNull(), updatedAt: timestamp("updated_at").defaultNow().notNull(), }); @@ -55,10 +56,8 @@ export const itemOffshoreTop = pgTable("item_offshore_top", { id: serial("id").primaryKey(), itemId: integer("item_id").notNull().references(() => items.id, { onDelete: 'cascade' }), workType: offshoreTopWorkTypeEnum("work_type").notNull(), - itemList1: text("item_list1"), - itemList2: text("item_list2"), - itemList3: text("item_list3"), - itemList4: text("item_list4"), + itemList: text("item_list"), + subItemList: text("sub_item_list"), createdAt: timestamp("created_at").defaultNow().notNull(), updatedAt: timestamp("updated_at").defaultNow().notNull(), }); @@ -68,10 +67,8 @@ export const itemOffshoreHull = pgTable("item_offshore_hull", { id: serial("id").primaryKey(), itemId: integer("item_id").notNull().references(() => items.id, { onDelete: 'cascade' }), workType: offshoreHullWorkTypeEnum("work_type").notNull(), - itemList1: text("item_list1"), - itemList2: text("item_list2"), - itemList3: text("item_list3"), - itemList4: text("item_list4"), + itemList: text("item_list"), + subItemList: text("sub_item_list"), createdAt: timestamp("created_at").defaultNow().notNull(), updatedAt: timestamp("updated_at").defaultNow().notNull(), }); -- cgit v1.2.3