summaryrefslogtreecommitdiff
path: root/db/schema
diff options
context:
space:
mode:
authorjoonhoekim <26rote@gmail.com>2025-09-22 12:04:24 +0900
committerjoonhoekim <26rote@gmail.com>2025-09-22 12:04:24 +0900
commit087fc383a662d45a69b5971a6ad821209bcbaf5b (patch)
tree219a1a7a551875722c780c587b20feab6cd53e24 /db/schema
parent614ca42937a39a16ce35e99d93085a56705c7a19 (diff)
(김준회) 수신부 UPSERT 제거 및 ANFNR 유니크 처리
Diffstat (limited to 'db/schema')
-rw-r--r--db/schema/bidding.ts2
1 files changed, 1 insertions, 1 deletions
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. 사양설명회 정보 테이블