Table: user_blocks

Columns

Column	Type	Nullable	Notes
blocker_user_ref	bigint	no	—
blocked_user_ref	bigint	no	—
reason	text	yes	—
created_at	timestamp	no	Default now()
origin_server_id	uuid	yes	—

Constraints

• CONSTRAINT user_blocks_check CHECK ((blocker_user_ref <> blocked_user_ref))

Full DDL

CREATE TABLE public.user_blocks (
    blocker_user_ref bigint NOT NULL,
    blocked_user_ref bigint NOT NULL,
    reason text,
    created_at timestamp with time zone DEFAULT now() NOT NULL,
    origin_server_id uuid,
    CONSTRAINT user_blocks_check CHECK ((blocker_user_ref <> blocked_user_ref))
);

---

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