Table: audit_events

Columns

Column	Type	Nullable	Notes
id	uuid	no	Default gen_random_uuid()
event_type	text	no	—
occurred_at	timestamp	no	Default now()
subject_user_ref	bigint	yes	—
actor_user_ref	bigint	yes	—
ip	inet	yes	—
user_agent	text	yes	—
metadata	jsonb	no	Default '{}'::jsonb
legal_hold	boolean	no	Default false
category	text	yes	—

Full DDL

CREATE TABLE public.audit_events (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    event_type text NOT NULL,
    occurred_at timestamp with time zone DEFAULT now() NOT NULL,
    subject_user_ref bigint,
    actor_user_ref bigint,
    ip inet,
    user_agent text,
    metadata jsonb DEFAULT '{}'::jsonb NOT NULL,
    legal_hold boolean DEFAULT false NOT NULL,
    category text GENERATED ALWAYS AS (split_part(event_type, '.'::text, 1)) STORED
);

---

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