Table: asset_subtitle_tracks
Subtitle and caption tracks attached to video or audio assets. A track isn’t an asset in its own right and isn’t counted as one. Each track belongs to its parent asset and is deleted with it.
Connected to
Section titled “Connected to”This table references:
assets(id) via columnasset_id
Columns
Section titled “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. Quality of the conversion to WebVTT: 1.0 for text-based sources, lower for tracks converted from bitmap subtitles by OCR. |
created_at | timestamp | no | Default now() |
Constraints
Section titled “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
Section titled “Full DDL”This is the table’s CREATE TABLE statement. Constraints added with separate ALTER TABLE statements, including foreign-key ON DELETE rules, and indexes are defined elsewhere in the dump; see the complete app/schema.sql.
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]))));See the schema overview for context.