From e9f707b10b81d9759243473dd03fa463573d0772 Mon Sep 17 00:00:00 2001 From: 0-Zz-ang Date: Fri, 26 Sep 2025 16:45:59 +0900 Subject: (박서영)이메일발신인조회페이지 생성 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- db/schema/emailLogs.ts | 12 ++++++++++++ db/schema/index.ts | 4 +++- 2 files changed, 15 insertions(+), 1 deletion(-) create mode 100644 db/schema/emailLogs.ts (limited to 'db/schema') diff --git a/db/schema/emailLogs.ts b/db/schema/emailLogs.ts new file mode 100644 index 00000000..3a6f83dc --- /dev/null +++ b/db/schema/emailLogs.ts @@ -0,0 +1,12 @@ +import { pgTable, serial, text, timestamp } from "drizzle-orm/pg-core"; + +export const emailLogs = pgTable("email_logs", { + id: serial("id").primaryKey(), + from: text("from").notNull(), + to: text("to").notNull(), + cc: text("cc"), + subject: text("subject").notNull(), + createdAt: timestamp("created_at").defaultNow().notNull(), +}); + + diff --git a/db/schema/index.ts b/db/schema/index.ts index a223f0de..efd38e71 100644 --- a/db/schema/index.ts +++ b/db/schema/index.ts @@ -76,4 +76,6 @@ export * from './S_ERP/s_erp'; // AVL 스키마 export * from './avl/avl'; -export * from './avl/vendor-pool'; \ No newline at end of file +export * from './avl/vendor-pool'; +// === Email Logs 스키마 === +export * from './emailLogs'; \ No newline at end of file -- cgit v1.2.3