(김준회) vendorWithTypesView 에 item 선택 롤백

1 files changed, 1 insertions, 0 deletions

diff --git a/db/schema/vendors.ts b/db/schema/vendors.ts
index e2b00632..f6f74373 100644
--- a/db/schema/vendors.ts
+++ b/db/schema/vendors.ts
@@ -462,6 +462,7 @@ export const vendorsWithTypesView = pgView("vendors_with_types").as((qb) => {
       representativeEmail: sql<string>`${vendors.representativeEmail}`.as("representative_email"),
       representativePhone: sql<string>`${vendors.representativePhone}`.as("representative_phone"),
       corporateRegistrationNumber: sql<string>`${vendors.corporateRegistrationNumber}`.as("corporate_registration_number"),
+      items: sql<string>`${vendors.items}`.as("items"),
       creditAgency: sql<string>`${vendors.creditAgency}`.as("credit_agency"),
       creditRating: sql<string>`${vendors.creditRating}`.as("credit_rating"),
       cashFlowRating: sql<string>`${vendors.cashFlowRating}`.as("cash_flow_rating"),