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 0e6c4d66..e5773fc1 100644 --- a/db/schema/vendors.ts +++ b/db/schema/vendors.ts @@ -95,6 +95,8 @@ export const vendorContacts = pgTable("vendor_contacts", { vendorId: integer("vendor_id").notNull().references(() => vendors.id), contactName: varchar("contact_name", { length: 255 }).notNull(), contactPosition: varchar("contact_position", { length: 100 }), + contactDepartment: varchar("contact_department", { length: 100 }), + contactTask: varchar("contact_task", { length: 100 }), contactEmail: varchar("contact_email", { length: 255 }).notNull(), contactPhone: varchar("contact_phone", { length: 50 }), isPrimary: boolean("is_primary").default(false).notNull(), |