Table: direct_messages

Columns

Column	Type	Nullable	Notes
id	uuid	no	Default gen_random_uuid()
sender_user_ref	bigint	no	—
recipient_user_ref	bigint	no	—
body	text	no	—
sent_at	timestamp	no	Default now()
read_at	timestamp	yes	—
origin_server_id	uuid	yes	—

Constraints

• CONSTRAINT direct_messages_body_check CHECK ((length(body) > 0))
• CONSTRAINT direct_messages_check CHECK ((sender_user_ref <> recipient_user_ref))

Full DDL

CREATE TABLE public.direct_messages (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    sender_user_ref bigint NOT NULL,
    recipient_user_ref bigint NOT NULL,
    body text NOT NULL,
    sent_at timestamp with time zone DEFAULT now() NOT NULL,
    read_at timestamp with time zone,
    origin_server_id uuid,
    CONSTRAINT direct_messages_body_check CHECK ((length(body) > 0)),
    CONSTRAINT direct_messages_check CHECK ((sender_user_ref <> recipient_user_ref))
);

---

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