Table: roles

Connected to

This table references:

• roles(id) via column parent_id

Referenced by:

• role_capabilities — column role_id
• roles — column parent_id
• user_roles — column role_id

Columns

Column	Type	Nullable	Notes
id	uuid	no	Default gen_random_uuid()
parent_id	uuid	yes	References roles(id)
name	text	no	—
description	text	no	Default ''::text
origin_server_id	uuid	yes	—
created_at	timestamp	no	Default now()
updated_at	timestamp	no	Default now()

Full DDL

CREATE TABLE public.roles (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    parent_id uuid,
    name text NOT NULL,
    description text DEFAULT ''::text 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
);

---

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