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