Table: asset_alternates

Connected to

This table references:

• assets(id) via column asset_id
• storage_objects(hash) via column object_hash

Columns

Column	Type	Nullable	Notes
id	uuid	no	Default gen_random_uuid()
asset_id	uuid	no	References assets(id)
label	text	no	—
kind	text	no	Default 'authored'::text
object_hash	text	no	References storage_objects(hash)
content_type	text	no	Default 'application/octet-stream'::text
size_bytes	bigint	no	—
origin_server_id	uuid	yes	—
created_by_user_ref	bigint	yes	—
created_at	timestamp	no	Default now()
metadata	jsonb	no	Default '{}'::jsonb

Constraints

• CONSTRAINT asset_alternates_kind_check CHECK (((length(kind) >= 1) AND (length(kind) <= 64)))
• CONSTRAINT asset_alternates_label_check CHECK (((length(label) >= 1) AND (length(label) <= 256)))
• CONSTRAINT asset_alternates_size_bytes_check CHECK ((size_bytes >= 0))

Full DDL

CREATE TABLE public.asset_alternates (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    asset_id uuid NOT NULL,
    label text NOT NULL,
    kind text DEFAULT 'authored'::text NOT NULL,
    object_hash text NOT NULL,
    content_type text DEFAULT 'application/octet-stream'::text NOT NULL,
    size_bytes bigint NOT NULL,
    origin_server_id uuid,
    created_by_user_ref bigint,
    created_at timestamp with time zone DEFAULT now() NOT NULL,
    metadata jsonb DEFAULT '{}'::jsonb NOT NULL,
    CONSTRAINT asset_alternates_kind_check CHECK (((length(kind) >= 1) AND (length(kind) <= 64))),
    CONSTRAINT asset_alternates_label_check CHECK (((length(label) >= 1) AND (length(label) <= 256))),
    CONSTRAINT asset_alternates_size_bytes_check CHECK ((size_bytes >= 0))
);

---

Please see the schema overview for context. This document was last regenerated on 2026-07-26T08:25:29.520Z.