showcases

Showcases — product groupings used for display on the platform. Act as categories / collections.

• ETL strategy: merge
• PK: id

Columns

Column	Type	Description
id	INTEGER	PK.
id_tenant	INTEGER	FK → tenants.id.
id_origin	INTEGER	Parent showcase id when replicated.
id_showcase	INTEGER	FK → another showcases.id. Showcases can be nested.
is_free	BOOLEAN	Free-access showcase.
is_draft	BOOLEAN	Unpublished.
is_not_listed	BOOLEAN	Hidden from the public listing.
is_hidden	BOOLEAN	Fully hidden.
position	INTEGER	Display order.
title	TEXT	Showcase name.
created_at	TIMESTAMPTZ
deleted_at	TIMESTAMPTZ

Relationships

• Parent: tenants; self-relation via id_showcase.
• Children: products via id_showcase.