Table: assets

Connected to

This table references:

• asset_types(ref) via column asset_type
• storage_objects(hash) via column file_hash
• workflow_states(id) via column state_id
• teams(id) via column team_id

Referenced by:

• asset_alternates — column asset_id
• asset_companions — column asset_id
• asset_embedding_d768 — column asset_id
• asset_field_value — column asset_id
• asset_subtitle_tracks — column asset_id
• asset_tag — column asset_id
• asset_visual_embedding — column asset_id
• collection_resources — column asset_id
• creative_lineage — columns derivative_asset_id, source_asset_id
• extraction_failure — column asset_id
• post_assets — column asset_id
• posts — columns cover_asset_id, cover_thumbnail_asset_id
• search_feedback — column hit_asset_id

Columns

Column	Type	Nullable	Notes
id	uuid	no	Default gen_random_uuid()
title	text	no	Default ''::text
description	text	no	Default ''::text
asset_type	bigint	no	References asset_types(ref)
owner_user_ref	bigint	yes	—
status	text	no	Default 'active'::text
file_hash	text	yes	References storage_objects(hash)
file_extension	text	yes	—
file_size_bytes	bigint	yes	—
access	integer	no	Default 0
has_image	boolean	no	Default false
is_transcoding	boolean	no	Default false
metadata	jsonb	no	Default '{}'::jsonb
origin_server_id	uuid	yes	—
created_at	timestamp	no	Default now()
updated_at	timestamp	no	Default now()
deleted_at	timestamp	yes	—
search_text	tsvector	yes	—
state_id	uuid	yes	References workflow_states(id)
team_id	uuid	yes	References teams(id)
processing_status	text	no	Default 'ready'::text
thumbhash	bytea	yes	—
processing_attempts	integer	no	Default 0
processing_error	text	yes	—
processing_started_at	timestamp	yes	—
processing_finished_at	timestamp	yes	—
sensitivity	text	no	Default 'public'::text
page_count	integer	yes	—
deleted_reason	text	yes	—

Constraints

• CONSTRAINT assets_processing_status_check CHECK ((processing_status = ANY (ARRAY['pending'::text, 'processing'::text, 'ready'::text, 'failed'::text])))
• CONSTRAINT assets_sensitivity_check CHECK ((sensitivity = ANY (ARRAY['public'::text, 'team'::text, 'restricted'::text, 'embargo'::text])))
• CONSTRAINT assets_status_check CHECK ((status = ANY (ARRAY['draft'::text, 'active'::text, 'archived'::text])))

Full DDL

CREATE TABLE public.assets (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    title text DEFAULT ''::text NOT NULL,
    description text DEFAULT ''::text NOT NULL,
    asset_type bigint NOT NULL,
    owner_user_ref bigint,
    status text DEFAULT 'active'::text NOT NULL,
    file_hash text,
    file_extension text,
    file_size_bytes bigint,
    access integer DEFAULT 0 NOT NULL,
    has_image boolean DEFAULT false NOT NULL,
    is_transcoding boolean DEFAULT false NOT NULL,
    metadata jsonb DEFAULT '{}'::jsonb 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,
    search_text tsvector,
    state_id uuid,
    team_id uuid,
    processing_status text DEFAULT 'ready'::text NOT NULL,
    thumbhash bytea,
    processing_attempts integer DEFAULT 0 NOT NULL,
    processing_error text,
    processing_started_at timestamp with time zone,
    processing_finished_at timestamp with time zone,
    sensitivity text DEFAULT 'public'::text NOT NULL,
    page_count integer,
    deleted_reason text,
    CONSTRAINT assets_processing_status_check CHECK ((processing_status = ANY (ARRAY['pending'::text, 'processing'::text, 'ready'::text, 'failed'::text]))),
    CONSTRAINT assets_sensitivity_check CHECK ((sensitivity = ANY (ARRAY['public'::text, 'team'::text, 'restricted'::text, 'embargo'::text]))),
    CONSTRAINT assets_status_check CHECK ((status = ANY (ARRAY['draft'::text, 'active'::text, 'archived'::text])))
);

---

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