diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/schema/techSales.ts | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/db/schema/techSales.ts b/db/schema/techSales.ts index 590ddc76..082ab592 100644 --- a/db/schema/techSales.ts +++ b/db/schema/techSales.ts @@ -39,7 +39,7 @@ import { import { relations } from "drizzle-orm"; import { biddingProjects } from "./projects"; import { users } from "./users"; -import { items } from "./items"; +import { itemShipbuilding } from "./items"; import { vendors } from "./vendors"; // ===== 기술영업 상태 관리 상수 및 타입 ===== @@ -108,9 +108,9 @@ export const techSalesRfqs = pgTable("tech_sales_rfqs", { rfqCode: varchar("rfq_code", { length: 50 }).unique(), // ex) "RFQ-2025-001" // item에서 기술영업에서 사용하는 추가 정보는 itemShipbuilding 테이블에 저장되어 있다. - itemId: integer("item_id") + itemShipbuildingId: integer("item_shipbuilding_id") .notNull() - .references(() => items.id, { onDelete: "cascade" }), + .references(() => itemShipbuilding.id, { onDelete: "cascade" }), // 프로젝트 참조 ID biddingProjectId: integer("bidding_project_id").references(() => biddingProjects.id, { onDelete: "set null" }), @@ -324,10 +324,10 @@ export type TechSalesVendorQuotations = // Relations 정의 export const techSalesRfqsRelations = relations(techSalesRfqs, ({ one, many }) => ({ - // 아이템 관계 - item: one(items, { - fields: [techSalesRfqs.itemId], - references: [items.id], + // 조선 아이템 관계 + itemShipbuilding: one(itemShipbuilding, { + fields: [techSalesRfqs.itemShipbuildingId], + references: [itemShipbuilding.id], }), // 프로젝트 관계 |