AD05
Notification Management
Notifications sent, the rules that send them, and the channels they go through.
Schema v01 has no notification table, no notification rule, no template, no channel and no delivery status. The only address on record is app_user.email.
Total Sent
—
no notification table in schema v01
Delivered
—
no delivery status
Failed
—
no delivery status
Pending
—
no notification table
Active Rules
—
no notification-rule table
Notifications
TitleModuleTypeChannelRecipientsStatusSent At
No notification rows: Document Expiring Soon, Quality Check Failed, User Access Granted and Data Import Completed have no store and no sender.
What the database does hold
users with an email addressasking
notification rowsnot in schema v01
notification rulesnot in schema v01
Notification Rules
module, type, channel, recipients, template
Nothing to show yet
No notification-rule table.
Templates
placeholders such as {Material} {Location} {CurrentQty}
Nothing to show yet
No template table.
Channels
In-App / Email / SMS / Push
Nothing to show yet
No channel configuration; nothing sends.
Recipients
teams such as Purchasing Team, Warehouse Team
Nothing to show yet
No team table; app_user holds a role, not a team.
Delivery Errors
Nothing to show yet
No delivery record.
Settings
per-user notification preferences
Nothing to show yet
app_user has no preferences column.