Table: saved_search

Connected to

This table references:

• user(ref) via column owner_user_ref

Columns

Column	Type	Nullable	Notes
id	uuid	no	Default gen_random_uuid()
owner_user_ref	bigint	no	References user(ref)
name	text	no	—
dsl	text	no	—
notify_channel	text	no	Default 'email'::text
notify_interval_minutes	integer	no	Default 60
enabled	boolean	no	Default true
last_result_hash	text	yes	—
last_result_ids	uuid[]	yes	—
last_run_at	timestamp	yes	—
last_notified_at	timestamp	yes	—
origin_server_id	uuid	yes	—
created_at	timestamp	no	Default now()
updated_at	timestamp	no	Default now()

Constraints

• CONSTRAINT saved_search_notify_channel_check CHECK ((notify_channel = ANY (ARRAY['email'::text, 'none'::text])))
• CONSTRAINT saved_search_notify_interval_minutes_check CHECK ((notify_interval_minutes >= 1))

Full DDL

CREATE TABLE public.saved_search (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    owner_user_ref bigint NOT NULL,
    name text NOT NULL,
    dsl text NOT NULL,
    notify_channel text DEFAULT 'email'::text NOT NULL,
    notify_interval_minutes integer DEFAULT 60 NOT NULL,
    enabled boolean DEFAULT true NOT NULL,
    last_result_hash text,
    last_result_ids uuid[],
    last_run_at timestamp with time zone,
    last_notified_at timestamp with time zone,
    origin_server_id uuid,
    created_at timestamp with time zone DEFAULT now() NOT NULL,
    updated_at timestamp with time zone DEFAULT now() NOT NULL,
    CONSTRAINT saved_search_notify_channel_check CHECK ((notify_channel = ANY (ARRAY['email'::text, 'none'::text]))),
    CONSTRAINT saved_search_notify_interval_minutes_check CHECK ((notify_interval_minutes >= 1))
);

---

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