(박서영)이메일발신인조회페이지 생성

1 files changed, 12 insertions, 0 deletions

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(),
+});
+
+