summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--db/schema/basicContractDocumnet.ts1
1 files changed, 1 insertions, 0 deletions
diff --git a/db/schema/basicContractDocumnet.ts b/db/schema/basicContractDocumnet.ts
index 6a73b82d..944c4b2c 100644
--- a/db/schema/basicContractDocumnet.ts
+++ b/db/schema/basicContractDocumnet.ts
@@ -107,6 +107,7 @@ export const basicContractView = pgView('basic_contract_view').as((qb) => {
vendorCode: sql<string | null>`${vendors.vendorCode}`.as('vendor_code'),
vendorEmail: sql<string | null>`${vendors.email}`.as('vendor_email'),
vendorName: sql<string | null>`${vendors.vendorName}`.as('vendor_name'),
+ vendorCountry: sql<string | null>`${vendors.country}`.as('vendor_country'),
// 요청자 정보
requestedByName: sql<string | null>`${users.name}`.as('requested_by_name'),