videos

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('videos_id_seq'::regclass)
video_assets.video_id video_assets_video_id_fkey C
title varchar 255 null
description text 2147483647 √ null
tags json 2147483647 √ null
format video_formats 2147483647 null
resolution_width int4 10 √ null
resolution_height int4 10 √ null
fps int4 10 √ null
target_duration int4 10 √ null
status video_statuses 2147483647 null
progress float8 17,17 √ null
thumbnail_path varchar 500 √ null
video_path varchar 500 √ null
preview_path varchar 500 √ null
duration int4 10 √ null
file_size int8 19 √ null
encoding_settings json 2147483647 √ null
script_data json 2147483647 √ null
script_text text 2147483647 √ null
created_by int4 10 null
users.id videos_created_by_fkey R
channel_id int4 10 √ null
channels.id videos_channel_id_fkey R
entry_id int4 10 √ null
entries.id videos_entry_id_fkey R
created_at timestamp 29,6 √ null
updated_at timestamp 29,6 √ null
completed_at timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
videos_pkey Primary key Asc id
ix_videos_title Performance Asc title

Relationships

Close relationships within degrees of separation