Users

The user table consists of the following entries:

• user_id
• user_name
• roles
• display_name
• created_at
• last_login_date

Passkeys

• passkey_id
• user_id UUID
• credential_id
• public_key
• attestation_type
• aaguid
• sign_count
• creation_at
• last_used_at
• updated_at
• credential_type
• transports
• backup_eligible
• backup_state

Documents

Jobs

Webauthn Sessions

• id
• session_data
• created_at

Refresh Token

• id
• user_id
• token_hash
• expires_at

Invite Link

• id
• created_by
• secret_hash
• created_at
• expires_at
• claimed_by
• claimed_at

Sound Snippets

• sound_snippet_id
• document_id
• sound_index
• graphemes
• phonemes
• audio