Table: asset_companions

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)
companion_path	text	no	—
object_hash	text	no	References storage_objects(hash)
content_type	text	no	Default 'application/octet-stream'::text
size_bytes	bigint	no	—
created_at	timestamp	no	Default now()

Constraints

• CONSTRAINT asset_companions_companion_path_check CHECK (((length(companion_path) >= 1) AND (length(companion_path) <= 512)))
• CONSTRAINT asset_companions_size_bytes_check CHECK ((size_bytes >= 0))

Full DDL

CREATE TABLE public.asset_companions (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    asset_id uuid NOT NULL,
    companion_path text NOT NULL,
    object_hash text NOT NULL,
    content_type text DEFAULT 'application/octet-stream'::text NOT NULL,
    size_bytes bigint NOT NULL,
    created_at timestamp with time zone DEFAULT now() NOT NULL,
    CONSTRAINT asset_companions_companion_path_check CHECK (((length(companion_path) >= 1) AND (length(companion_path) <= 512))),
    CONSTRAINT asset_companions_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.