diff options
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(), }); |