Table: user_totp_recovery_code

Connected to

This table references:

• user(ref) via column user_ref

Columns

Column	Type	Nullable	Notes
id	uuid	no	Default gen_random_uuid()
user_ref	bigint	no	References user(ref)
code_hash	bytea	no	—
used_at	timestamp	yes	—
created_at	timestamp	no	Default now()

Full DDL

CREATE TABLE public.user_totp_recovery_code (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    user_ref bigint NOT NULL,
    code_hash bytea NOT NULL,
    used_at timestamp with time zone,
    created_at timestamp with time zone DEFAULT now() NOT NULL
);

---

Please see the schema overview for context. This document was last regenerated on 2026-07-26T08:25:29.520Z.