ores.inbox.notification_preference
Table of Contents
Whether a person is reached through one channel for one kind. The key is the account, the kind and the channel together, so a person holds one row for each pair they have chosen; no row means the kind's default.
The in-application copy is always kept, and a kind that is not
mail_optional ignores a choice to turn its mail off. The service applies both
rules when it delivers.
1. Flags
2. Columns
2.1. account_id
The person whose preference it is. FK reference to ores_iam_accounts_tbl.
2.2. kind_code
The kind the preference is for. FK reference to ores_inbox_notification_kinds_tbl, which the system tenant holds.
2.3. channel_code
The channel the preference is for. FK reference to ores_inbox_notification_channels_tbl, which the system tenant holds.
2.4. enabled
Whether the person is reached through this channel for this kind.
3. Foreign keys
3.1. account_id
3.2. kind_code
The lookup is system reference data, so the check reads the system tenant.
3.3. channel_code
The lookup is system reference data, so the check reads the system tenant.
4. SQL
4.1. Flags
5. C++
5.1. Flags
5.2. Repository
5.3. Domain includes
#include <string> #include <boost/uuid/uuid.hpp>
5.4. Entity includes
#include <string>
5.5. Conventions
5.6. Table display
| column | header |
|---|---|
| account_id | Account |
| kind_code | Kind |
| channel_code | Channel |
| enabled | Enabled |
| modified_by | Modified By |
| version | Version |
5.7. Custom repository methods
6. See also
- Notification requirements — the preferences requirement.
- ores.inbox.notification_kind — the kind a preference is for.
- ores.inbox.notification_channel — the channel a preference is for.