(대표님, 최겸, 임수민) 작업사항 커밋

2 files changed, 20 insertions, 0 deletions

diff --git a/db/schema/rfqLast.ts b/db/schema/rfqLast.ts
index 34c61cd0..a9f91308 100644
--- a/db/schema/rfqLast.ts
+++ b/db/schema/rfqLast.ts
@@ -315,6 +315,23 @@ export const rfqsLastView = pgView("rfqs_last_view").as((qb) => {
                 LIMIT 1
             )`.as("major_item_material_code"),
 
+            majorItemMaterialDescription: sql<string | null>`(
+                SELECT material_description 
+                FROM rfq_pr_items 
+                WHERE rfqs_last_id = ${rfqsLast.id}
+                AND major_yn = true
+                LIMIT 1
+            )`.as("major_item_materialD_description"),
+
+            
+            majorItemMaterialCategory: sql<string | null>`(
+                SELECT material_category 
+                FROM rfq_pr_items 
+                WHERE rfqs_last_id = ${rfqsLast.id}
+                AND major_yn = true
+                LIMIT 1
+            )`.as("major_item_material_category"),
+
             majorItemPrNo: sql<string | null>`(
                 SELECT pr_no 
                 FROM rfq_pr_items 
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(