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