Table: storage_objects

Connected to

Referenced by:

• asset_alternates — column object_hash
• asset_companions — column object_hash
• assets — column file_hash
• storage_pins — column object_hash
• storage_variants — column object_hash

Columns

Column	Type	Nullable	Notes
hash	text	no	—
size_bytes	bigint	no	—
content_type	text	no	Default 'application/octet-stream'::text
backend	text	no	—
backend_bucket	text	yes	—
origin_server_id	uuid	yes	—
gc_eligible_at	timestamp	yes	—
created_at	timestamp	no	Default now()

Constraints

• CONSTRAINT storage_objects_hash_check CHECK ((hash ~ '^[0-9a-f]{64}$'::text))
• CONSTRAINT storage_objects_size_bytes_check CHECK ((size_bytes >= 0))

Full DDL

CREATE TABLE public.storage_objects (
    hash text NOT NULL,
    size_bytes bigint NOT NULL,
    content_type text DEFAULT 'application/octet-stream'::text NOT NULL,
    backend text NOT NULL,
    backend_bucket text,
    origin_server_id uuid,
    gc_eligible_at timestamp with time zone,
    created_at timestamp with time zone DEFAULT now() NOT NULL,
    CONSTRAINT storage_objects_hash_check CHECK ((hash ~ '^[0-9a-f]{64}$'::text)),
    CONSTRAINT storage_objects_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.