Notification Service Data Model
Auto-generated from TypeORM entity definitions. Last synced: 2026-03-15
Database schema: notif
EmailBranding
Table: email_branding
| Column | Type | Nullable | Primary | Unique | Default |
|---|---|---|---|---|---|
id | string | No | Yes | Yes | - |
tenantId | varchar | No | - | Yes | - |
logoUrl | varchar | Yes | - | - | - |
primaryColor | varchar | No | - | - | #2563eb |
secondaryColor | varchar | No | - | - | #6b7280 |
footerText | text | Yes | - | - | - |
replyToAddress | varchar | Yes | - | - | - |
companyName | varchar | No | - | - | Cloud Factory |
createdAt | Date | No | - | - | - |
updatedAt | Date | No | - | - | - |
NotificationPreference
Table: notification_preferences
| Column | Type | Nullable | Primary | Unique | Default |
|---|---|---|---|---|---|
id | string | No | Yes | Yes | - |
tenantId | uuid | No | - | - | - |
userId | uuid | No | - | - | - |
eventType | varchar | No | - | - | - |
emailEnabled | boolean | No | - | - | true |
inAppEnabled | boolean | No | - | - | true |
createdAt | Date | No | - | - | - |
updatedAt | Date | No | - | - | - |
NotificationTemplate
Table: notification_templates
| Column | Type | Nullable | Primary | Unique | Default |
|---|---|---|---|---|---|
id | string | No | Yes | Yes | - |
eventType | varchar | No | - | - | - |
type | varchar | No | - | - | - |
subject | varchar | No | - | - | - |
body | text | No | - | - | - |
description | varchar | Yes | - | - | - |
category | varchar | Yes | - | - | - |
sampleVariables | jsonb | Yes | - | - | - |
version | int | No | - | - | 1 |
active | boolean | No | - | - | true |
createdAt | Date | No | - | - | - |
updatedAt | Date | No | - | - | - |
Notification
Table: notifications
| Column | Type | Nullable | Primary | Unique | Default |
|---|---|---|---|---|---|
id | string | No | Yes | Yes | - |
tenantId | uuid | No | - | - | - |
userId | uuid | No | - | - | - |
type | varchar | No | - | - | - |
eventType | varchar | No | - | - | - |
subject | varchar | No | - | - | - |
body | text | No | - | - | - |
status | varchar | No | - | - | NotificationStatus.PENDING |
metadata | jsonb | Yes | - | - | - |
emailTo | varchar | Yes | - | - | - |
read | boolean | No | - | - | false |
readAt | timestamp | Yes | - | - | - |
sentAt | timestamp | Yes | - | - | - |
errorMessage | varchar | Yes | - | - | - |
createdAt | Date | No | - | - | - |
updatedAt | Date | No | - | - | - |