diff options
| author | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-05-20 09:01:22 +0000 |
|---|---|---|
| committer | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-05-20 09:01:22 +0000 |
| commit | 45f4c426c98d86a251644a4858740bec989edf83 (patch) | |
| tree | b0a3f1ce6ac3e4493ee53c93ef33841c8eb34cfb /db/schema/items.ts | |
| parent | 11f13979825d28180956fc27600176bfc47457e1 (diff) | |
(최겸) 기술영업 아이템리스트 수정 및 개발 0520
Diffstat (limited to 'db/schema/items.ts')
| -rw-r--r-- | db/schema/items.ts | 15 |
1 files changed, 6 insertions, 9 deletions
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(), }); |