Table: email_verification_token

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)
token_hash	bytea	no	—
purpose	text	no	Default 'register'::text
created_at	timestamp	no	Default now()
expires_at	timestamp	no	—
consumed_at	timestamp	yes	—

Constraints

• CONSTRAINT email_verification_token_purpose_check CHECK ((purpose = ANY (ARRAY['register'::text, 'email_change'::text])))

Full DDL

CREATE TABLE public.email_verification_token (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    user_ref bigint NOT NULL,
    token_hash bytea NOT NULL,
    purpose text DEFAULT 'register'::text NOT NULL,
    created_at timestamp with time zone DEFAULT now() NOT NULL,
    expires_at timestamp with time zone NOT NULL,
    consumed_at timestamp with time zone,
    CONSTRAINT email_verification_token_purpose_check CHECK ((purpose = ANY (ARRAY['register'::text, 'email_change'::text])))
);

---

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