Ir al contenido

Table: asset_subtitle_tracks

Esta página aún no está disponible en tu idioma.

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.

This table references:

  • assets(id) via column asset_id
ColumnTypeNullableNotes
asset_iduuidnoReferences assets(id)
langtextno-
labeltextnoDefault ''::text
file_hashtextno-
source_formattextno-
confidencerealnoDefault 1.0. Quality of the conversion to WebVTT: 1.0 for text-based sources, lower for tracks converted from bitmap subtitles by OCR.
created_attimestampnoDefault now()
  • 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])))

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.