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").