Table: user_profiles

Columns

Column	Type	Nullable	Notes
user_ref	bigint	no	—
display_name	text	yes	—
bio	text	no	Default ''::text
avatar_url	text	yes	—
location	text	no	Default ''::text
website_url	text	yes	—
social_links	jsonb	no	Default '{}'::jsonb
origin_server_id	uuid	yes	—
created_at	timestamp	no	Default now()
updated_at	timestamp	no	Default now()
language	text	no	Default ''::text
theme	text	no	Default ''::text
hide_from_anonymous	boolean	no	Default false

Constraints

• CONSTRAINT user_profiles_theme_check CHECK ((theme = ANY (ARRAY[''::text, 'light'::text, 'dark'::text])))

Full DDL

CREATE TABLE public.user_profiles (
    user_ref bigint NOT NULL,
    display_name text,
    bio text DEFAULT ''::text NOT NULL,
    avatar_url text,
    location text DEFAULT ''::text NOT NULL,
    website_url text,
    social_links jsonb DEFAULT '{}'::jsonb NOT NULL,
    origin_server_id uuid,
    created_at timestamp with time zone DEFAULT now() NOT NULL,
    updated_at timestamp with time zone DEFAULT now() NOT NULL,
    language text DEFAULT ''::text NOT NULL,
    theme text DEFAULT ''::text NOT NULL,
    hide_from_anonymous boolean DEFAULT false NOT NULL,
    CONSTRAINT user_profiles_theme_check CHECK ((theme = ANY (ARRAY[''::text, 'light'::text, 'dark'::text])))
);

---

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