From 087fc383a662d45a69b5971a6ad821209bcbaf5b Mon Sep 17 00:00:00 2001
From: joonhoekim <26rote@gmail.com>
Date: Mon, 22 Sep 2025 12:04:24 +0900
Subject: (김준회) 수신부 UPSERT 제거 및 ANFNR 유니크 처리
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 db/schema/bidding.ts | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

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

diff --git a/db/schema/bidding.ts b/db/schema/bidding.ts
index fbc620c8..a4d64e86 100644
--- a/db/schema/bidding.ts
+++ b/db/schema/bidding.ts
@@ -180,7 +180,7 @@ export const biddings = pgTable('biddings', {
   createdAt: timestamp('created_at').defaultNow().notNull(),
   updatedAt: timestamp('updated_at').defaultNow().notNull(), // 최종수정일
   updatedBy: varchar('updated_by', { length: 100 }), // 최종수정자
-  ANFNR: varchar({length: 50}), // 원본 ANFNR 추적을 위한 Bidding/RFQ Number (ECC)
+  ANFNR: varchar({length: 50}).unique(), // 원본 ANFNR 추적을 위한 Bidding/RFQ Number (ECC), onConflict target이므로 unique 처리
 })
 
 // 9. 사양설명회 정보 테이블
-- 
cgit v1.2.3