diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/schema/avl/vendor-pool.ts | 11 |
1 files changed, 9 insertions, 2 deletions
diff --git a/db/schema/avl/vendor-pool.ts b/db/schema/avl/vendor-pool.ts index 62f9dace..a1b7fa3a 100644 --- a/db/schema/avl/vendor-pool.ts +++ b/db/schema/avl/vendor-pool.ts @@ -1,4 +1,5 @@ -import { pgTable, text, boolean, integer, timestamp, varchar } from "drizzle-orm/pg-core"; +import { pgTable, text, boolean, integer, timestamp, varchar, uniqueIndex } from "drizzle-orm/pg-core"; +import { sql } from 'drizzle-orm'; import { createInsertSchema, createSelectSchema } from "drizzle-zod"; // Vendor Pool 테이블 @@ -95,7 +96,13 @@ export const vendorPool = pgTable("vendor_pool", { registrant: varchar("registrant", { length: 50 }), // 등재자 lastModifiedDate: timestamp("last_modified_date").defaultNow(), // 최종변경일 lastModifier: varchar("last_modifier", { length: 50 }), // 최종변경자 -}); +}, (table) => ({ + + // 새로운 unique 제약조건: 공사부문 + H/T + 자재그룹코드 + 협력업체명 + uniqueVendorPoolCombination: uniqueIndex("unique_vendor_pool_combination") + .on(table.constructionSector, table.htDivision, table.materialGroupCode, table.vendorName) + .where(sql`${table.materialGroupCode} IS NOT NULL AND ${table.vendorName} IS NOT NULL`) +})); // 복합키 인덱스 (자재그룹코드 + 벤더코드) // 구매 의도상은 복합키가 맞는 것 같은데, 요구사항 불명확하므로 별도 제약조건 없이 개발 후 요구 나오면 수정 |