Table: user_roles

Connected to

This table references:

• roles(id) via column role_id
• teams(id) via column team_id

Columns

Column	Type	Nullable	Notes
user_ref	bigint	no	—
role_id	uuid	no	References roles(id)
assigned_at	timestamp	no	Default now()
assigned_by_user_ref	bigint	yes	—
team_id	uuid	yes	References teams(id)

Full DDL

CREATE TABLE public.user_roles (
    user_ref bigint NOT NULL,
    role_id uuid NOT NULL,
    assigned_at timestamp with time zone DEFAULT now() NOT NULL,
    assigned_by_user_ref bigint,
    team_id uuid
);

---

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