From 8238c0c0ed6fd182d33f3437a22da1d80cfa928f Mon Sep 17 00:00:00 2001
From: dujinkim <dujin.kim@dtsolution.co.kr>
Date: Mon, 24 Nov 2025 10:47:34 +0000
Subject: (임수민) 법무검토 요청 데이터 조회 수정
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 db/schema/basicContractDocumnet.ts | 8 ++++++--
 1 file changed, 6 insertions(+), 2 deletions(-)

(limited to 'db/schema/basicContractDocumnet.ts')

diff --git a/db/schema/basicContractDocumnet.ts b/db/schema/basicContractDocumnet.ts
index 8cfd3baa..ba1f7856 100644
--- a/db/schema/basicContractDocumnet.ts
+++ b/db/schema/basicContractDocumnet.ts
@@ -64,6 +64,8 @@ export const basicContract = pgTable('basic_contract', {
   negotiationCompletedAt: timestamp('negotiation_completed_at'), // GTC 협의 완료일
   legalReviewRequestedAt: timestamp('legal_review_requested_at'), // 법무검토 요청일
   legalReviewCompletedAt: timestamp('legal_review_completed_at'), // 법무검토 완료일
+  legalReviewRegNo: varchar('legal_review_reg_no', { length: 100 }), // 법무 시스템 REG_NO
+  legalReviewProgressStatus: varchar('legal_review_progress_status', { length: 255 }), // PRGS_STAT_DSC 값
   
   createdAt: timestamp('created_at').defaultNow(),
   updatedAt: timestamp('updated_at').defaultNow(),
@@ -94,6 +96,8 @@ export const basicContractView = pgView('basic_contract_view').as((qb) => {
       negotiationCompletedAt: sql<Date | null>`${basicContract.negotiationCompletedAt}`.as('negotiation_completed_at'),
       legalReviewRequestedAt: sql<Date | null>`${basicContract.legalReviewRequestedAt}`.as('legal_review_requested_at'),
       legalReviewCompletedAt: sql<Date | null>`${basicContract.legalReviewCompletedAt}`.as('legal_review_completed_at'),
+      legalReviewRegNo: sql<string | null>`${basicContract.legalReviewRegNo}`.as('legal_review_reg_no'),
+      legalReviewProgressStatus: sql<string | null>`${basicContract.legalReviewProgressStatus}`.as('legal_review_progress_status'),
       
       createdAt: sql<Date>`${basicContract.createdAt}`.as('created_at'),
       updatedAt: sql<Date>`${basicContract.updatedAt}`.as('updated_at'),
@@ -114,8 +118,8 @@ export const basicContractView = pgView('basic_contract_view').as((qb) => {
       validityPeriod: sql<number | null>`${basicContractTemplates.validityPeriod}`.as('validity_period'),
       legalReviewRequired: sql<boolean | null>`${basicContractTemplates.legalReviewRequired}`.as('legal_review_required'),
 
-      // 법무검토 상태 (legalWorks에서 가져옴)
-      legalReviewStatus: sql<string | null>`${legalWorks.status}`.as('legal_review_status'),
+      // 법무검토 상태 (PRGS_STAT_DSC 동기화 값)
+      legalReviewStatus: sql<string | null>`${basicContract.legalReviewProgressStatus}`.as('legal_review_status'),
 
       // 템플릿 파일 정보
       templateFilePath: sql<string | null>`${basicContractTemplates.filePath}`.as('template_file_path'),
-- 
cgit v1.2.3