diff options
Diffstat (limited to 'db/schema/rfqLastTBE.ts')
| -rw-r--r-- | db/schema/rfqLastTBE.ts | 7 |
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"), |