Notifications — Data Model
This feature owns no tables. Persistence is in the source domains:
| Source | Used by |
|---|---|
class_sessions + bookings + users (via memberships) | Class reminders |
subscriptions + users | Expiration warnings |
bookings (cancellations) | Cancellation emails |
There is no notifications / email_log table. Resend’s dashboard is the only delivery audit trail.
PII handling
- Emails contain member names, class names, dates. Sent through Resend (third-party processor).
- Resend retains delivery metadata per their policy.
- No DB-level PII storage from this feature.
Multi-org isolation
- Class reminders + expiration warnings are queried with full joins to org for sender branding (logo, name). No cross-org leakage.
Soft / hard delete
n/a — feature owns no rows.