Table: asset_subtitle_tracks

Connected to

This table references:

• assets(id) via column asset_id

Columns

Column	Type	Nullable	Notes
asset_id	uuid	no	References assets(id)
lang	text	no	—
label	text	no	Default ''::text
file_hash	text	no	—
source_format	text	no	—
confidence	real	no	Default 1.0
created_at	timestamp	no	Default now()

Constraints

• CONSTRAINT asset_subtitle_tracks_confidence_check CHECK (((confidence >= (0)::double precision) AND (confidence <= (1)::double precision)))
• CONSTRAINT asset_subtitle_tracks_lang_check CHECK (((lang ~ '^[A-Za-z]{1,8}(-[A-Za-z0-9]{1,8}){0,4}$'::text) OR (lang = 'und'::text)))
• CONSTRAINT asset_subtitle_tracks_source_format_check CHECK ((source_format = ANY (ARRAY['vtt'::text, 'srt'::text, 'ssa'::text, 'ass'::text, 'sub'::text, 'idx'::text, 'whisper'::text])))

Full DDL

CREATE TABLE public.asset_subtitle_tracks (
    asset_id uuid NOT NULL,
    lang text NOT NULL,
    label text DEFAULT ''::text NOT NULL,
    file_hash text NOT NULL,
    source_format text NOT NULL,
    confidence real DEFAULT 1.0 NOT NULL,
    created_at timestamp with time zone DEFAULT now() NOT NULL,
    CONSTRAINT asset_subtitle_tracks_confidence_check CHECK (((confidence >= (0)::double precision) AND (confidence <= (1)::double precision))),
    CONSTRAINT asset_subtitle_tracks_lang_check CHECK (((lang ~ '^[A-Za-z]{1,8}(-[A-Za-z0-9]{1,8}){0,4}$'::text) OR (lang = 'und'::text))),
    CONSTRAINT asset_subtitle_tracks_source_format_check CHECK ((source_format = ANY (ARRAY['vtt'::text, 'srt'::text, 'ssa'::text, 'ass'::text, 'sub'::text, 'idx'::text, 'whisper'::text])))
);

---

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