Routines

Routines

Name Type Language Deterministic Return Type Security Restriction Comments
bootstrap_oldest_outstanding_event_occurred_at() FUNCTION sql false timestamp with time zone DEFINER
bootstrap_company_id_by_password_reset_token_hash(p_token_hash text) FUNCTION sql false uuid DEFINER
bootstrap_count_outstanding_event_publications() FUNCTION sql false bigint DEFINER
bootstrap_company_id_by_normalized_email(p_normalized_email text) FUNCTION sql false uuid DEFINER
bootstrap_expired_stay_candidates(p_today date) FUNCTION sql false TABLE(company_id uuid, worker_id uuid, display_name character varying, stay_expiry_date date) DEFINER
bootstrap_claim_event_publications(p_owner text, p_lease_duration_millis bigint, p_batch_size integer, p_max_attempts integer) FUNCTION plpgsql false TABLE(event_id uuid, company_id uuid, review_required boolean) DEFINER
bootstrap_company_id_by_worker_link_token_hash(p_token_hash text) FUNCTION sql false uuid DEFINER
bootstrap_company_id_by_refresh_token_hash(p_token_hash text) FUNCTION sql false uuid DEFINER