Table: teams
Esta página aún no está disponible en tu idioma.
Connected to
Section titled “Connected to”This table references:
assets(id) via columnhero_asset_id
Referenced by:
assets: columnteam_idfeatured_items: columnteam_idfield_default_override: columnteam_idposts: columnteam_idteam_closure: columnsancestor_id,descendant_idteam_follows: columnteam_idteam_memberships: columnteam_idteam_parents: columnschild_id,parent_iduser_capability_grants: columnteam_iduser_capability_revokes: columnteam_iduser_roles: columnteam_id
Columns
Section titled “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). The team’s chosen hero picture; NULL means the initials tile. Only an asset that is public and belongs to this team qualifies, checked when it’s chosen and again whenever the team rail renders, so an asset made restricted later drops out. The viewer’s mature-content setting also applies. If the asset is deleted, the team reverts to its initials. Local to this instance. |
Full DDL
Section titled “Full DDL”This is the table’s CREATE TABLE statement. Constraints added with separate ALTER TABLE statements, including foreign-key ON DELETE rules, and indexes are defined elsewhere in the dump; see the complete app/schema.sql.
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);See the schema overview for context.