diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/schema/vendorDocu.ts | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/db/schema/vendorDocu.ts b/db/schema/vendorDocu.ts index b7cef5e5..624ce11d 100644 --- a/db/schema/vendorDocu.ts +++ b/db/schema/vendorDocu.ts @@ -38,6 +38,7 @@ export const documents = pgTable( drawingKind: varchar("drawing_kind", { length: 10 }), // B3, B4, B5 drawingMoveGbn: varchar("drawing_move_gbn", { length: 50 }), // 도면입수, 도면제출, GTT Deliverable, SHI Input Information discipline: varchar("discipline", { length: 10 }), // DE, ME, etc. + docClass: varchar("doc_class", { length: 20 }), // 문서 분류 (B3, B4, B5, etc.) // ✅ 외부 시스템 연동 정보 externalDocumentId: varchar("external_document_id", { length: 100 }), // DOLCE 시스템의 문서 ID @@ -817,6 +818,7 @@ export const simplifiedDocumentsView = pgView("simplified_documents_view", { drawingKind: varchar("drawing_kind", { length: 10 }), drawingMoveGbn: varchar("drawing_move_gbn", { length: 50 }), discipline: varchar("discipline", { length: 10 }), + docClass: varchar("doc_class", { length: 20 }), // 문서 분류 vendorDocNumber: varchar("vendor_doc_number", { length: 100 }), title: varchar("title", { length: 255 }).notNull(), pic: varchar("pic", { length: 50 }), @@ -1077,6 +1079,7 @@ export const simplifiedDocumentsView = pgView("simplified_documents_view", { d.drawing_kind, d.drawing_move_gbn, d.discipline, + d.doc_class, d.vendor_doc_number, d.title, d.pic, @@ -1357,6 +1360,7 @@ export const stageDocuments = pgTable( // 선택적 문서 정보 vendorDocNumber: varchar("vendor_doc_number", { length: 100 }), issuedDate: date("issued_date"), + docClass: varchar("doc_class", { length: 20 }), // 문서 분류 (B3, B4, B5, etc.) // 직접 참조로 JOIN 최소화 projectId: integer("project_id") @@ -1417,6 +1421,7 @@ export const stageDocumentsView = pgView("stage_documents_view", { title: varchar("title", { length: 255 }).notNull(), status: varchar("status", { length: 50 }).notNull(), issuedDate: date("issued_date"), + docClass: varchar("doc_class", { length: 20 }), // 문서 분류 // 프로젝트 및 벤더 정보 projectId: integer("project_id").notNull(), @@ -1542,13 +1547,14 @@ export const stageDocumentsView = pgView("stage_documents_view", { GROUP BY ist.document_id ) - SELECT + SELECT sd.id as document_id, sd.doc_number, sd.vendor_doc_number, sd.title, sd.status, sd.issued_date, + sd.doc_class, -- 프로젝트 및 벤더 정보 sd.project_id, |