Table: user

Connected to

Referenced by:

• brush_packs — column owner_user_ref
• digest_queue — column user_ref
• email_verification_token — column user_ref
• federation_user_keys — columns user_ref, rotated_by_user_ref
• metadata_backfill_run — column started_by_user_ref
• resource_request — columns requester_user_ref, decided_by_user_ref
• saved_search — column owner_user_ref
• search_feedback — column user_ref
• search_reindex_run — column started_by_user_ref
• search_visual_backfill_run — column started_by_user_ref
• sessions — column impersonated_by_user_ref
• user_totp — column user_ref
• user_totp_recovery_code — column user_ref

Columns

Column	Type	Nullable	Notes
ref	bigint	no	—
username	varchar(50)	yes	—
password	varchar(255)	yes	—
fullname	varchar(100)	yes	—
email	varchar(100)	yes	—
usergroup	bigint	yes	—
last_active	timestamp	yes	—
account_expires	timestamp	yes	—
comments	text	yes	—
password_last_change	timestamp	yes	—
approved	bigint	no	Default 1
lang	varchar(11)	yes	—
created	timestamp	yes	Default now()
password_reset_hash	varchar(100)	yes	—
origin	varchar(50)	yes	—
actor_uri	text	yes	—
signing_public_key_pem	text	yes	—
signing_private_key_enc	bytea	yes	—
encryption_public_key	bytea	yes	—
encryption_private_key_enc	bytea	yes	—
email_verified_at	timestamp	yes	—
failed_login_count	integer	no	Default 0
lockout_until	timestamp	yes	—

Constraints

• CONSTRAINT user_approved_check CHECK ((approved = ANY (ARRAY[(0)::bigint, (1)::bigint, (2)::bigint, (3)::bigint])))

Full DDL

CREATE TABLE public."user" (
    ref bigint NOT NULL,
    username character varying(50),
    password character varying(255),
    fullname character varying(100),
    email character varying(100),
    usergroup bigint,
    last_active timestamp with time zone,
    account_expires timestamp with time zone,
    comments text,
    password_last_change timestamp with time zone,
    approved bigint DEFAULT 1 NOT NULL,
    lang character varying(11),
    created timestamp with time zone DEFAULT now(),
    password_reset_hash character varying(100),
    origin character varying(50),
    actor_uri text,
    signing_public_key_pem text,
    signing_private_key_enc bytea,
    encryption_public_key bytea,
    encryption_private_key_enc bytea,
    email_verified_at timestamp with time zone,
    failed_login_count integer DEFAULT 0 NOT NULL,
    lockout_until timestamp with time zone,
    CONSTRAINT user_approved_check CHECK ((approved = ANY (ARRAY[(0)::bigint, (1)::bigint, (2)::bigint, (3)::bigint])))
);

---

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