From ef4c533ebacc2cdc97e518f30e9a9350004fcdfb Mon Sep 17 00:00:00 2001
From: dujinkim <dujin.kim@dtsolution.co.kr>
Date: Mon, 28 Apr 2025 02:13:30 +0000
Subject: ~20250428 작업사항
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 db/schema/contract.ts | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

(limited to 'db/schema/contract.ts')

diff --git a/db/schema/contract.ts b/db/schema/contract.ts
index 1d628442..226fecfa 100644
--- a/db/schema/contract.ts
+++ b/db/schema/contract.ts
@@ -14,13 +14,14 @@ import {
 import { projects } from "./projects"
 import { vendorContacts, vendors } from "./vendors"
 import { eq, sql } from "drizzle-orm";
+import { items } from "./items";
 
 // ============ contracts (계약/PO 정보) ============
 export const contracts = pgTable("contracts", {
     // 주 키
     id: integer("id").primaryKey().generatedAlwaysAsIdentity(),
 
-    // 프로젝트와 벤더 참조
+    // 프로젝트와 협력업체 참조
     projectId: integer("project_id")
         .notNull()
         .references(() => projects.id, { onDelete: "cascade" }),
@@ -81,7 +82,7 @@ export const contractItems = pgTable("contract_items", {
 
     itemId: integer("item_id")
         .notNull()
-    // .references(() => items.id, { onDelete: "cascade" })
+    .references(() => items.id, { onDelete: "cascade" })
     ,
 
     // --- 품목(아이템) 단위 정보 ---
-- 
cgit v1.2.3