From 2c02afd48a4d9276a4f5c132e088540a578d0972 Mon Sep 17 00:00:00 2001 From: dujinkim Date: Tue, 30 Sep 2025 10:08:53 +0000 Subject: (대표님) 폼리스트, spreadjs 관련 변경사항, 벤더문서 뷰 쿼리 수정, 이메일 템플릿 추가 등 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- db/schema/rfqLastTBE.ts | 2 +- db/schema/vendorDocu.ts | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) (limited to 'db') diff --git a/db/schema/rfqLastTBE.ts b/db/schema/rfqLastTBE.ts index 8800cd3d..e690ce4b 100644 --- a/db/schema/rfqLastTBE.ts +++ b/db/schema/rfqLastTBE.ts @@ -34,7 +34,7 @@ export const rfqLastTbeSessions = pgTable( // 상태 관리 status: varchar("status", { length: 30 }) - .$type<"준비중" | "진행중" | "검토중" | "보류" | "완료" | "취소">() + .$type<"생성중"|"준비중" | "진행중" | "검토중" | "보류" | "완료" | "취소">() .notNull() .default("준비중"), diff --git a/db/schema/vendorDocu.ts b/db/schema/vendorDocu.ts index 3d9ad46c..1c634f64 100644 --- a/db/schema/vendorDocu.ts +++ b/db/schema/vendorDocu.ts @@ -1137,7 +1137,7 @@ export const simplifiedDocumentsView = pgView("simplified_documents_view", { -- projects, vendors 테이블 JOIN (projectId가 이제 documents에 직접 있음) LEFT JOIN projects p ON d.project_id = p.id AND p.type = 'ship' LEFT JOIN contracts c ON d.contract_id = c.id - LEFT JOIN vendors v ON c.vendor_id = v.id + LEFT JOIN vendors v ON d.vendor_id = v.id -- 스테이지 정보 JOIN LEFT JOIN first_stage_info fsi ON d.id = fsi.document_id -- cgit v1.2.3