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