Skip to content
File

Blob: src/worker/db/relations.ts

typescript22 lines
1import { relations } from "drizzle-orm";
2import { attachments, emails, inboxes } from "@/worker/db/schema";
3 
4export const inboxesRelations = relations(inboxes, ({ many }) => ({
5 emails: many(emails),
6}));
7 
8export const emailsRelations = relations(emails, ({ many, one }) => ({
9 inbox: one(inboxes, {
10 fields: [emails.inboxId],
11 references: [inboxes.id],
12 }),
13 attachments: many(attachments),
14}));
15 
16export const attachmentsRelations = relations(attachments, ({ one }) => ({
17 email: one(emails, {
18 fields: [attachments.emailId],
19 references: [emails.id],
20 }),
21}));