(대표님, 최겸) 계약, 업로드 관련, 메뉴처리, 입찰, 프리쿼트, rfqLast관련, tbeLast관련

1 files changed, 0 insertions, 7 deletions

diff --git a/db/schema/rfqLastTBE.ts b/db/schema/rfqLastTBE.ts
index 1efb43bb..8800cd3d 100644
--- a/db/schema/rfqLastTBE.ts
+++ b/db/schema/rfqLastTBE.ts
@@ -412,13 +412,6 @@ export const tbeSessionSummaryView = pgView("tbe_session_summary_view").as((qb)
                 WHERE dr.tbe_session_id = ${tbeSession.id}
             )`.as("total_comments"),
 
-            unresolvedComments: sql<number>`(
-                SELECT COUNT(*)
-                FROM rfq_last_tbe_pdftron_comments pc
-                JOIN rfq_last_tbe_document_reviews dr ON pc.document_review_id = dr.id
-                WHERE dr.tbe_session_id = ${tbeSession.id}
-                AND pc.status = 'open'
-            )`.as("unresolved_comments"),
 
             // 일정
             actualStartDate: sql<Date | null>`${tbeSession.actualStartDate}`.as("actual_start_date"),