Ir al contenido

Table: saved_search

Esta página aún no está disponible en tu idioma.

This table references:

  • user(ref) via column owner_user_ref
ColumnTypeNullableNotes
iduuidnoDefault gen_random_uuid()
owner_user_refbigintnoReferences user(ref)
nametextno-
dsltextno-
notify_channeltextnoDefault 'email'::text
notify_interval_minutesintegernoDefault 60
enabledbooleannoDefault true
last_result_hashtextyes-
last_result_idsuuid[]yes-
last_run_attimestampyes-
last_notified_attimestampyes-
origin_server_iduuidyes-
created_attimestampnoDefault now()
updated_attimestampnoDefault now()
  • 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))
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-11-16T07:02:04.019Z.