From b67e36df49f067cbd5ba899f9fbcc755f38d4b4f Mon Sep 17 00:00:00 2001 From: dujinkim Date: Thu, 4 Sep 2025 08:31:31 +0000 Subject: (대표님, 최겸, 임수민) 작업사항 커밋 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- db/schema/vendorDocu.ts | 3 +++ 1 file changed, 3 insertions(+) (limited to 'db/schema/vendorDocu.ts') diff --git a/db/schema/vendorDocu.ts b/db/schema/vendorDocu.ts index 927c566d..c37bc2ec 100644 --- a/db/schema/vendorDocu.ts +++ b/db/schema/vendorDocu.ts @@ -73,10 +73,12 @@ export const documents = pgTable( uniqueContractDocStatus: uniqueIndex("unique_contract_doc_status").on( table.contractId, table.docNumber, + table.discipline, table.status ), uniqueContractVendorDoc: uniqueIndex("unique_contract_vendor_doc").on( table.contractId, + table.discipline, table.vendorDocNumber ).where(sql`${table.vendorDocNumber} IS NOT NULL`), @@ -92,6 +94,7 @@ export const documents = pgTable( uniqueProjectDocStatus: uniqueIndex("unique_project_doc_status").on( table.projectId, table.docNumber, + table.discipline, table.status ), // uniqueProjectVendorDoc: uniqueIndex("unique_project_vendor_doc").on( -- cgit v1.2.3