Table: promo_bands

Connected to

Referenced by:

• featured_items — column band_id

Columns

Column	Type	Nullable	Notes
id	uuid	no	Default gen_random_uuid()
title	text	no	Default ''::text
blurb	text	no	Default ''::text
cta_label	text	no	Default ''::text
cta_url	text	no	Default ''::text
enabled	boolean	no	Default false
after_page	integer	no	Default 1
scope	text	no	Default 'org'::text
created_at	timestamp	no	Default now()
updated_at	timestamp	no	Default now()
created_by_user_ref	bigint	yes	—

Constraints

• CONSTRAINT promo_bands_after_page_check CHECK ((after_page >= 1))
• CONSTRAINT promo_bands_cta_pair_check CHECK ((((cta_label = ''::text) AND (cta_url = ''::text)) OR ((cta_label <> ''::text) AND (cta_url <> ''::text))))
• CONSTRAINT promo_bands_cta_url_check CHECK (((cta_url = ''::text) OR (cta_url ~ '^(https?://[^/]|/[^/])'::text)))
• CONSTRAINT promo_bands_scope_check CHECK ((scope = ANY (ARRAY['public'::text, 'org'::text])))

Full DDL

CREATE TABLE public.promo_bands (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    title text DEFAULT ''::text NOT NULL,
    blurb text DEFAULT ''::text NOT NULL,
    cta_label text DEFAULT ''::text NOT NULL,
    cta_url text DEFAULT ''::text NOT NULL,
    enabled boolean DEFAULT false NOT NULL,
    after_page integer DEFAULT 1 NOT NULL,
    scope text DEFAULT 'org'::text NOT NULL,
    created_at timestamp with time zone DEFAULT now() NOT NULL,
    updated_at timestamp with time zone DEFAULT now() NOT NULL,
    created_by_user_ref bigint,
    CONSTRAINT promo_bands_after_page_check CHECK ((after_page >= 1)),
    CONSTRAINT promo_bands_cta_pair_check CHECK ((((cta_label = ''::text) AND (cta_url = ''::text)) OR ((cta_label <> ''::text) AND (cta_url <> ''::text)))),
    CONSTRAINT promo_bands_cta_url_check CHECK (((cta_url = ''::text) OR (cta_url ~ '^(https?://[^/]|/[^/])'::text))),
    CONSTRAINT promo_bands_scope_check CHECK ((scope = ANY (ARRAY['public'::text, 'org'::text])))
);

---

Please see the schema overview for context. This document was last regenerated on 2026-09-23T03:23:00.434Z.