Table: resource_request

Connected to

This table references:

• user(ref) via column requester_user_ref
• capabilities(code) via column requested_capability
• user(ref) via column decided_by_user_ref

Referenced by:

• user_capability_grants — column request_ref

Columns

Column	Type	Nullable	Notes
id	uuid	no	Default gen_random_uuid()
requester_user_ref	bigint	no	References user(ref)
target_asset_id	uuid	no	—
requested_capability	text	no	References capabilities(code)
reason	text	no	Default ''::text
state	text	no	Default 'pending'::text
decided_at	timestamp	yes	—
decided_by_user_ref	bigint	yes	References user(ref)
decision_reason	text	no	Default ''::text
expires_at	timestamp	yes	—
requested_at	timestamp	no	Default now()

Constraints

• CONSTRAINT resource_request_state_check CHECK ((state = ANY (ARRAY['pending'::text, 'granted'::text, 'denied'::text, 'expired'::text])))

Full DDL

CREATE TABLE public.resource_request (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    requester_user_ref bigint NOT NULL,
    target_asset_id uuid NOT NULL,
    requested_capability text NOT NULL,
    reason text DEFAULT ''::text NOT NULL,
    state text DEFAULT 'pending'::text NOT NULL,
    decided_at timestamp with time zone,
    decided_by_user_ref bigint,
    decision_reason text DEFAULT ''::text NOT NULL,
    expires_at timestamp with time zone,
    requested_at timestamp with time zone DEFAULT now() NOT NULL,
    CONSTRAINT resource_request_state_check CHECK ((state = ANY (ARRAY['pending'::text, 'granted'::text, 'denied'::text, 'expired'::text])))
);

---

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