summaryrefslogtreecommitdiff
path: root/db/schema/vendorDocu.ts
diff options
context:
space:
mode:
authordujinkim <dujin.kim@dtsolution.co.kr>2025-09-03 12:44:32 +0000
committerdujinkim <dujin.kim@dtsolution.co.kr>2025-09-03 12:44:32 +0000
commit688d9884ca98b50d04ac78fc1f6e28e034a519c0 (patch)
tree95cf4572882a4d771db9443140d8cf2735d840d7 /db/schema/vendorDocu.ts
parent522176a23ad9db47f85ceed13b2e54d369aa6e0a (diff)
(대표님) rfq-last 작업, vendorDocu 스키마 변경, 벤더 문서 관련 변경
Diffstat (limited to 'db/schema/vendorDocu.ts')
-rw-r--r--db/schema/vendorDocu.ts2
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`),