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.

2. Database scheme

settings-schema
Legend
Diagram notation Table notation Meaning

ο and [PK]

(PK)

Primary key

[FK]

(references table.column)

Foreign key

●

column name in bold

Required field (not null)

column name in regular font

Optional field (null)

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
Uniqueness restrictions

settings_id,channel

3.2. settings

User settings

Column name
Description

id uuid (PK)
Row ID

keycloak_id uuid
External user ID in keycloak
Uniqueness restrictions

keycloak_id