Table: featured_items

Connected to

This table references:

• teams(id) via column team_id

Columns

Column	Type	Nullable	Notes
id	uuid	no	Default gen_random_uuid()
subject_kind	text	no	—
subject_id	uuid	no	—
position	integer	no	Default 0
created_at	timestamp	no	Default now()
created_by_user_ref	bigint	yes	—
scope	text	no	Default 'org'::text
team_id	uuid	yes	References teams(id)

Constraints

• CONSTRAINT featured_items_scope_check CHECK ((scope = ANY (ARRAY['public'::text, 'org'::text, 'team'::text])))
• CONSTRAINT featured_items_subject_kind_check CHECK ((subject_kind = ANY (ARRAY['asset'::text, 'collection'::text])))
• CONSTRAINT featured_items_team_scope_check CHECK ((((scope = 'team'::text) AND (team_id IS NOT NULL)) OR ((scope <> 'team'::text) AND (team_id IS NULL))))

Full DDL

CREATE TABLE public.featured_items (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    subject_kind text NOT NULL,
    subject_id uuid NOT NULL,
    "position" integer DEFAULT 0 NOT NULL,
    created_at timestamp with time zone DEFAULT now() NOT NULL,
    created_by_user_ref bigint,
    scope text DEFAULT 'org'::text NOT NULL,
    team_id uuid,
    CONSTRAINT featured_items_scope_check CHECK ((scope = ANY (ARRAY['public'::text, 'org'::text, 'team'::text]))),
    CONSTRAINT featured_items_subject_kind_check CHECK ((subject_kind = ANY (ARRAY['asset'::text, 'collection'::text]))),
    CONSTRAINT featured_items_team_scope_check CHECK ((((scope = 'team'::text) AND (team_id IS NOT NULL)) OR ((scope <> 'team'::text) AND (team_id IS NULL))))
);

---

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