summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
Diffstat (limited to 'db')
-rw-r--r--db/schema/emailLogs.ts12
-rw-r--r--db/schema/index.ts4
2 files changed, 15 insertions, 1 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(),
+});
+
+
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