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

Emacs 29.3 (Org mode 9.6.15)