Table: user_capability_grants

Connected to

This table references:

• capabilities(code) via column capability_code
• teams(id) via column team_id
• resource_request(id) via column request_ref

Columns

Column	Type	Nullable	Notes
user_ref	bigint	no	—
capability_code	text	no	References capabilities(code)
granted_at	timestamp	no	Default now()
granted_by_user_ref	bigint	yes	—
note	text	no	Default ''::text
team_id	uuid	yes	References teams(id)
expires_at	timestamp	yes	—
request_ref	uuid	yes	References resource_request(id)

Full DDL

CREATE TABLE public.user_capability_grants (
    user_ref bigint NOT NULL,
    capability_code text NOT NULL,
    granted_at timestamp with time zone DEFAULT now() NOT NULL,
    granted_by_user_ref bigint,
    note text DEFAULT ''::text NOT NULL,
    team_id uuid,
    expires_at timestamp with time zone,
    request_ref uuid
);

---

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