| Table of Contents |
|---|
Entities (tables)
Authentication factors
This entity defines authentication factors entity information structure:
| Column | Type | M/O | Purpose |
|---|---|---|---|
| id | uuid | M | |
| user_id | uuid | M | User FK |
| type | varchar | M | |
| factor | varchar | O | Factor value |
| is_active | boolean | M | |
| inserted_at | timestamp | M | |
| updateed_at | timestamp |
additional constraint: create unique index (user_id, type)
...
| M |
| type | factor |
|---|---|
SMS | "+380677778899" |
| PHONE | "+380677778899" |
| "pupkin.vasya@gmail.com" |
Change User entity
...
- count logins fail
- count 2FA fail
- block status of user
...
Users
This entity enrich a few attributes:
Store counters parameters for 2FA in `users.priv_settings` as structure :
{"login_error_counter":0,"otp_error_counter":0}
...
Information about blocked directly in entity `users`.
...
Column Type Purpose is_blocked boolean block_reason varchar (255), NULL
Сonstraints
- user have one active 2FA factor ( one of any type)
- unique index
...
- on user_id+type