diff options
Diffstat (limited to 'db/schema/vendorDocu.ts')
| -rw-r--r-- | db/schema/vendorDocu.ts | 2 |
1 files changed, 2 insertions, 0 deletions
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`), |