diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/schema/emailLogs.ts | 12 | ||||
| -rw-r--r-- | db/schema/index.ts | 4 |
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 |
