summaryrefslogtreecommitdiff
path: root/db/schema
diff options
context:
space:
mode:
authordujinkim <dujin.kim@dtsolution.co.kr>2025-12-01 11:18:09 +0000
committerdujinkim <dujin.kim@dtsolution.co.kr>2025-12-01 11:18:09 +0000
commitc3a1e8480ab016d2bf0b1fc2470943a0d64749d5 (patch)
tree4ddb4af7f4a833c69d9a0d596acc0e599d0add32 /db/schema
parentcd0ce0cbe8af8719a6f542098ec78f2a5c1222ce (diff)
(임수민) 기본계약 스키마 수정
Diffstat (limited to 'db/schema')
-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'),