Table: teams

Connected to

This table references:

• assets(id) via column hero_asset_id

Referenced by:

• assets — column team_id
• featured_items — column team_id
• field_default_override — column team_id
• posts — column team_id
• team_closure — columns ancestor_id, descendant_id
• team_follows — column team_id
• team_memberships — column team_id
• team_parents — columns child_id, parent_id
• user_capability_grants — column team_id
• user_capability_revokes — column team_id
• user_roles — column team_id

Columns

Column	Type	Nullable	Notes
id	uuid	no	Default gen_random_uuid()
slug	text	no	—
name	text	no	—
description	text	no	Default ''::text
origin_server_id	uuid	yes	—
created_at	timestamp	no	Default now()
updated_at	timestamp	no	Default now()
deleted_at	timestamp	yes	—
hero_asset_id	uuid	yes	References assets(id)

Full DDL

CREATE TABLE public.teams (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    slug text NOT NULL,
    name text NOT NULL,
    description text DEFAULT ''::text NOT NULL,
    origin_server_id uuid,
    created_at timestamp with time zone DEFAULT now() NOT NULL,
    updated_at timestamp with time zone DEFAULT now() NOT NULL,
    deleted_at timestamp with time zone,
    hero_asset_id uuid
);

---

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