diff options
Diffstat (limited to 'db/schema/vendors.ts')
| -rw-r--r-- | db/schema/vendors.ts | 2 |
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", { |