diff options
Diffstat (limited to 'db/schema/pq.ts')
| -rw-r--r-- | db/schema/pq.ts | 11 |
1 files changed, 9 insertions, 2 deletions
diff --git a/db/schema/pq.ts b/db/schema/pq.ts index 7adcbf8b..0bc720f6 100644 --- a/db/schema/pq.ts +++ b/db/schema/pq.ts @@ -133,8 +133,8 @@ export const vendorPQSubmissions = pgTable("vendor_pq_submissions", { dueDate: timestamp("due_date"), agreements: jsonb("agreements").notNull().default({}), // ✅ 체크 항목들을 JSON으로 저장 - // PQ 대상품목 - pqItems: varchar("pq_items", { length: 1000 }), + // PQ 대상품목 - [{ itemCode: string, itemName: string }, ...] + pqItems: jsonb("pq_items"), submittedAt: timestamp("submitted_at"), approvedAt: timestamp("approved_at"), @@ -405,6 +405,9 @@ export const vendorInvestigationsView = pgView( vendorName: vendors.vendorName, vendorCode: vendors.vendorCode, + // PQ 정보 + pqItems: vendorPQSubmissions.pqItems, + // User names and emails instead of just IDs requesterName: sql<string>`requester.name`.as("requesterName"), requesterEmail: sql<string>`requester.email`.as("requesterEmail"), @@ -436,6 +439,10 @@ export const vendorInvestigationsView = pgView( sql`users AS qm_manager`, eq(vendorInvestigations.qmManagerId, sql`qm_manager.id`) ) + .leftJoin( + vendorPQSubmissions, + eq(vendorInvestigations.pqSubmissionId, vendorPQSubmissions.id) + ) }) // 방문실사 요청 테이블 |