D
DreamLake

DB Schema

User

Created on first login via vuer-auth token exchange. Global scope.

FieldTypeDescription
idObjectIdPrimary key
subString (unique)vuer-auth user ID (OIDC sub claim)
emailString?Email address
nameString?Display name
usernameString?Username
given_nameString?First name
family_nameString?Last name
pictureString?Avatar URL
email_verifiedBoolean?Email verification status
metadataJson?Arbitrary metadata
deletedAtDateTime?Soft delete timestamp
createdAtDateTimeCreated timestamp
updatedAtDateTimeLast updated timestamp

Indexes: deletedAt