From 9da494b0e3bbe7b513521d0915510fe9ee376b8b Mon Sep 17 00:00:00 2001 From: dujinkim Date: Mon, 21 Jul 2025 07:19:52 +0000 Subject: (대표님, 최겸) 작업사항 - 이메일 템플릿, 메일링, 기술영업 요구사항 반영 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- db/schema/techVendors.ts | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'db/schema/techVendors.ts') diff --git a/db/schema/techVendors.ts b/db/schema/techVendors.ts index b5624b85..e34d3e60 100644 --- a/db/schema/techVendors.ts +++ b/db/schema/techVendors.ts @@ -55,7 +55,7 @@ export const techVendorContacts = pgTable("tech_vendor_contacts", { contactPosition: varchar("contact_position", { length: 100 }), contactEmail: varchar("contact_email", { length: 255 }).notNull(), contactPhone: varchar("contact_phone", { length: 50 }), - country: varchar("country", { length: 100 }), + contactCountry: varchar("contact_country", { length: 100 }), isPrimary: boolean("is_primary").default(false).notNull(), createdAt: timestamp("created_at").defaultNow().notNull(), updatedAt: timestamp("updated_at").defaultNow().notNull(), @@ -68,7 +68,7 @@ export const techVendorPossibleItems = pgTable("tech_vendor_possible_items", { vendorCode: varchar("vendor_code", { length: 100 }), // 검색/필터용 중복 저장 vendorEmail: varchar("vendor_email", { length: 255 }), // 검색/필터용 중복 저장 - // 아이템 정보 (필수: itemCode, 나머지는 nullable) + // 아이템 정보 (itemCode도 nullable로 변경 - 해양 HULL 등에서 없을 수 있음) itemCode: varchar("item_code", { length: 100 }).notNull(), workType: varchar("work_type", { length: 100 }), // 공종 (nullable) shipTypes: varchar("ship_types", { length: 255 }), // 선종 (nullable) -- cgit v1.2.3