Table: sessions

Connected to

This table references:

• user(ref) via column impersonated_by_user_ref

Columns

Column	Type	Nullable	Notes
id	uuid	no	Default gen_random_uuid()
user_ref	bigint	no	—
token_hash	bytea	no	—
created_at	timestamp	no	Default now()
last_used_at	timestamp	no	Default now()
expires_at	timestamp	yes	—
revoked_at	timestamp	yes	—
ip	inet	yes	—
user_agent	text	yes	—
origin_server_id	uuid	yes	—
impersonated_by_user_ref	bigint	yes	References user(ref)

Full DDL

CREATE TABLE public.sessions (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    user_ref bigint NOT NULL,
    token_hash bytea NOT NULL,
    created_at timestamp with time zone DEFAULT now() NOT NULL,
    last_used_at timestamp with time zone DEFAULT now() NOT NULL,
    expires_at timestamp with time zone,
    revoked_at timestamp with time zone,
    ip inet,
    user_agent text,
    origin_server_id uuid,
    impersonated_by_user_ref bigint
);

---

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