diff options
Diffstat (limited to 'db/schema/vendors.ts')
| -rw-r--r-- | db/schema/vendors.ts | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/db/schema/vendors.ts b/db/schema/vendors.ts index e5773fc1..d53fb674 100644 --- a/db/schema/vendors.ts +++ b/db/schema/vendors.ts @@ -24,6 +24,8 @@ export const vendors = pgTable("vendors", { //사업자번호이고, 법인등록번호는 corporateRegistrationNumber taxId: varchar("tax_id", { length: 100 }).notNull(), address: text("address"), + addressDetail: text("address_detail"), + postalCode: varchar("postal_code", { length: 20 }), country: varchar("country", { length: 100 }), phone: varchar("phone", { length: 50 }), email: varchar("email", { length: 255 }), @@ -242,6 +244,8 @@ export const vendorDetailView = pgView("vendor_detail_view").as((qb) => { vendorCode: vendors.vendorCode, taxId: vendors.taxId, address: vendors.address, + addressDetail: vendors.addressDetail, + postalCode: vendors.postalCode, businessSize:vendors.businessSize, country: vendors.country, phone: vendors.phone, @@ -421,6 +425,8 @@ export const vendorsWithTypesView = pgView("vendors_with_types").as((qb) => { vendorCode: sql<string>`${vendors.vendorCode}`.as("vendor_code"), taxId: sql<string>`${vendors.taxId}`.as("tax_id"), address: sql<string>`${vendors.address}`.as("address"), + addressDetail: sql<string>`${vendors.addressDetail}`.as("address_detail"), + postalCode: sql<string>`${vendors.postalCode}`.as("postal_code"), country: sql<string>`${vendors.country}`.as("country"), phone: sql<string>`${vendors.phone}`.as("phone"), email: sql<string>`${vendors.email}`.as("email"), |