summaryrefslogtreecommitdiff
path: root/db/schema/vendors.ts
diff options
context:
space:
mode:
authordujinkim <dujin.kim@dtsolution.co.kr>2025-07-10 09:55:45 +0000
committerdujinkim <dujin.kim@dtsolution.co.kr>2025-07-10 09:55:45 +0000
commitc657ef972feeafff16ab0e07cb4771f7dd141ba0 (patch)
treebefabd884b00d3cc632c628b3e3810f61cc9f38d /db/schema/vendors.ts
parentb8a03c9d130435a71c5d6217d06ccb0beb9697e5 (diff)
(대표님) 20250710 작업사항 - 평가 첨부, 로그인, SEDP 변경 요구사항 반영
Diffstat (limited to 'db/schema/vendors.ts')
-rw-r--r--db/schema/vendors.ts2
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(),