File
Blob: src/worker/db/relations.ts
| 1 | import { relations } from "drizzle-orm"; |
| 2 | import { attachments, emails, inboxes } from "@/worker/db/schema"; |
| 3 | |
| 4 | export const inboxesRelations = relations(inboxes, ({ many }) => ({ |
| 5 | emails: many(emails), |
| 6 | })); |
| 7 | |
| 8 | export 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 | |
| 16 | export const attachmentsRelations = relations(attachments, ({ one }) => ({ |
| 17 | email: one(emails, { |
| 18 | fields: [attachments.emailId], |
| 19 | references: [emails.id], |
| 20 | }), |
| 21 | })); |