platform.organizations

Tenant catalog row. Holds identity only — presentation fields (legal name, address, logo, contact info) live in org.organization_settings.

Columns

Column	Type	Notes
id	UUID PK	gen_random_uuid()
name	VARCHAR(255)	Display name.
slug	VARCHAR(100)	UNIQUE. CHECK slug ~ '^[a-z0-9][a-z0-9-]*[a-z0-9]$'.
is_active	BOOL	NOT NULL. Default true.
created_at	TIMESTAMPTZ	NOT NULL. Default NOW().
updated_at	TIMESTAMPTZ	NOT NULL. Default NOW(). Auto-updated by trigger.

Referenced by every org.* table's org_id via ON DELETE RESTRICT.