From 688d9884ca98b50d04ac78fc1f6e28e034a519c0 Mon Sep 17 00:00:00 2001 From: dujinkim Date: Wed, 3 Sep 2025 12:44:32 +0000 Subject: (대표님) rfq-last 작업, vendorDocu 스키마 변경, 벤더 문서 관련 변경 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- db/schema/vendorDocu.ts | 2 ++ 1 file changed, 2 insertions(+) (limited to 'db/schema/vendorDocu.ts') diff --git a/db/schema/vendorDocu.ts b/db/schema/vendorDocu.ts index b7136a5c..927c566d 100644 --- a/db/schema/vendorDocu.ts +++ b/db/schema/vendorDocu.ts @@ -84,6 +84,7 @@ export const documents = pgTable( uniqueExternalDoc: uniqueIndex("unique_external_doc").on( table.contractId, table.externalDocumentId, + table.discipline, table.externalSystemType ).where(sql`${table.externalDocumentId} IS NOT NULL`), @@ -102,6 +103,7 @@ export const documents = pgTable( uniqueExternalDocProject: uniqueIndex("unique_external_doc_project").on( table.projectId, table.externalDocumentId, + table.discipline, table.externalSystemType ).where(sql`${table.externalDocumentId} IS NOT NULL`), -- cgit v1.2.3