User settings operational database

🌐 This document is available in both English and Ukrainian. Use the language toggle in the top right corner to switch between versions.

1. Overview

The settings database function main function is to store user settings.

Unresolved include directive in modules/arch/pages/architecture/registry/operational/user-settings/settings-db.adoc - include::partial$architecture-workspace/documentation-templates/component-design-template/db-schema-legend.adoc[]

3. Data structures

3.1. notification_channel

User communication channels configuration

Column name Description
`id uuid (PK)` Row ID
`settings_id uuid` (references settings.id) User settings ID
`channel enum` Communication channel name for the message template usage EMAIL - Email messages sending DIIA - Sending of push-notification to customer-facing application
`address text` Address of message sending (optional, depending on communication channel type)
`deactivation_reason text` Reason for the previous deactivation of the channel
`is_activated boolean` Channel activation status
`created_at timestamp with time zone` Date/time of record creation
`updated_at timestamp with time zone` Date/time of record update

Column name
Description

id uuid (PK)
Row ID

settings_id uuid (references settings.id)
User settings ID

channel enum
Communication channel name for the message template usage

EMAIL - Email messages sending
DIIA - Sending of push-notification to customer-facing application

address text
Address of message sending (optional, depending on communication channel type)

deactivation_reason text
Reason for the previous deactivation of the channel

is_activated boolean
Channel activation status

created_at timestamp with time zone
Date/time of record creation

updated_at timestamp with time zone
Date/time of record update

Uniqueness restrictions

Uniqueness restrictions
`settings_id,channel`

settings_id,channel

3.2. settings

User settings

Column name Description
`id uuid (PK)` Row ID
`keycloak_id uuid` External user ID in keycloak