| Table of Contents |
|---|
...
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 | M |
...
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
Authentication factors
- user have one active 2FA factor ( one of any type)
- unique index on user_id+type