1 files changed, 3 insertions, 0 deletions
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(