(대표님) 변경사항 20250707 10시 43분 - unstaged 변경사항 추가

1 files changed, 2 insertions, 0 deletions

diff --git a/db/schema/vendors.ts b/db/schema/vendors.ts
index 0a694a40..78ecf83c 100644
--- a/db/schema/vendors.ts
+++ b/db/schema/vendors.ts
@@ -51,6 +51,7 @@ export const vendors = pgTable("vendors", {
   representativeBirth: varchar("representative_birth", { length: 20 }),
   representativeEmail: varchar("representative_email", { length: 255 }),
   representativePhone: varchar("representative_phone", { length: 50 }),
+  representativeWorkExpirence: boolean("representative_work_expirence").default(false),
   corporateRegistrationNumber: varchar("corporate_registration_number", {
     length: 100,
   }),
@@ -151,6 +152,7 @@ export const vendorMaterialsView = pgView("vendor_materials_view").as((qb) => {
 export const vendorAttachments = pgTable("vendor_attachments", {
   id: serial("id").primaryKey(),
   vendorId: integer("vendor_id").references(() => vendors.id),
+  fileType: varchar("file_type", { length: 255 }),
   fileName: varchar("file_name", { length: 255 }).notNull(),
   filePath: varchar("file_path", { length: 1024 }).notNull(),
   attachmentType: varchar("attachment_type", {