Logo Developer Guide

user_data

Contains the user information for two-factor authentication. This table is not used for multi-user.

Relevant files:

  • apps/server/src/services/encryption/open_id_encryption.ts
Column Name Data Type Nullity Default value Description
tmpID Integer A sequential ID of the user. Since only one user is supported by Trilium, this value is always zero.
username Text The user name as returned from the OAuth operation.
email Text The email as returned from the OAuth operation.
userIDEncryptedDataKey Text An encrypted hash of the user subject identifier from the OAuth operation.
userIDVerificationHash Text A salted hash of the subject identifier from the OAuth operation.
salt Text The verification salt.
derivedKey Text A random secure token.
isSetup Text "false" Indicates that the user has been saved ("true").