Skip to content

Banners

Table: public.banners

Columns

Column Type Default Description
id uuid PK UUID
title text NOT NULL Display title
image_url text NOT NULL Uploaded image
link_url text nullable Click target
link_type text 'url' url, product, category, promotion
sort_order int 0 Display order
is_active boolean true Active toggle
position text 'home_main' Placement
promotion_id uuid FK → promotions(id) nullable Linked promotion
created_at timestamptz now()

Indexes

  • idx_banners_position_active on (position) WHERE is_active = true
  • idx_banners_promotion_id on promotion_id

Positions

Position Location
home_main Home screen carousel (Flutter)
home_sidebar Sidebar (future)