diff options
Diffstat (limited to 'db/schema')
| -rw-r--r-- | db/schema/items.ts | 24 |
1 files changed, 11 insertions, 13 deletions
diff --git a/db/schema/items.ts b/db/schema/items.ts index a032de04..bf58915b 100644 --- a/db/schema/items.ts +++ b/db/schema/items.ts @@ -29,7 +29,7 @@ export const offshoreHullWorkTypeEnum = pgEnum('offshore_hull_work_type', ['HA', //아이템코드(:자재그룹코드), 아이템이름(:아이템리스트), 공종(:workType), 선종, createdAt(:생성일), updatedAt(:수정일) export const itemShipbuilding = pgTable("item_shipbuilding", { id: serial("id").primaryKey(), - itemId: integer("item_id").notNull().references(() => items.id, { onDelete: 'cascade' }), + itemCode: varchar("item_code", { length: 100 }).notNull().references(() => items.itemCode, { onDelete: 'cascade' }), workType: workTypeEnum("work_type").notNull(), itemList: text("item_list"), shipTypes: text("ship_types").notNull().default('OPTION'), @@ -37,24 +37,21 @@ export const itemShipbuilding = pgTable("item_shipbuilding", { updatedAt: timestamp("updated_at").defaultNow().notNull(), }); - //조선 아이템 관계 정의 export const itemShipbuildingRelations = relations(itemShipbuilding, ({ one }) => ({ item: one(items, { - fields: [itemShipbuilding.itemId], - references: [items.id], + fields: [itemShipbuilding.itemCode], + references: [items.itemCode], }), })); - - export type ItemShipbuilding = typeof itemShipbuilding.$inferSelect; export type ItemWithShipbuilding = Item & ItemShipbuilding; //해양 TOP 아이템 테이블 export const itemOffshoreTop = pgTable("item_offshore_top", { id: serial("id").primaryKey(), - itemId: integer("item_id").notNull().references(() => items.id, { onDelete: 'cascade' }), + itemCode: varchar("item_code", { length: 100 }).notNull().references(() => items.itemCode, { onDelete: 'cascade' }), workType: offshoreTopWorkTypeEnum("work_type").notNull(), itemList: text("item_list"), subItemList: text("sub_item_list"), @@ -65,7 +62,7 @@ export const itemOffshoreTop = pgTable("item_offshore_top", { //해양 HULL 아이템 테이블 export const itemOffshoreHull = pgTable("item_offshore_hull", { id: serial("id").primaryKey(), - itemId: integer("item_id").notNull().references(() => items.id, { onDelete: 'cascade' }), + itemCode: varchar("item_code", { length: 100 }).notNull().references(() => items.itemCode, { onDelete: 'cascade' }), workType: offshoreHullWorkTypeEnum("work_type").notNull(), itemList: text("item_list"), subItemList: text("sub_item_list"), @@ -76,20 +73,21 @@ export const itemOffshoreHull = pgTable("item_offshore_hull", { //해양 TOP 아이템 관계 정의 export const itemOffshoreTopRelations = relations(itemOffshoreTop, ({ one }) => ({ item: one(items, { - fields: [itemOffshoreTop.itemId], - references: [items.id], + fields: [itemOffshoreTop.itemCode], + references: [items.itemCode], }), })); //해양 HULL 아이템 관계 정의 export const itemOffshoreHullRelations = relations(itemOffshoreHull, ({ one }) => ({ item: one(items, { - fields: [itemOffshoreHull.itemId], - references: [items.id], + fields: [itemOffshoreHull.itemCode], + references: [items.itemCode], }), })); export type ItemOffshoreTop = typeof itemOffshoreTop.$inferSelect; export type ItemOffshoreHull = typeof itemOffshoreHull.$inferSelect; export type ItemWithOffshoreTop = Item & ItemOffshoreTop; -export type ItemWithOffshoreHull = Item & ItemOffshoreHull;
\ No newline at end of file +export type ItemWithOffshoreHull = Item & ItemOffshoreHull; +//각 테이블별 컬럼 변경(itemid -> itemCode)
\ No newline at end of file |