video

21502 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
pub_id varchar 32 null
bookmark.video_id bookmark_video_id_fkey R
comment.video_id comment_video_id_fkey R
dislike.video_id dislike_video_id_fkey R
like.video_id like_video_id_fkey R
manual_video_review.video_id manual_video_review_video_id_fkey R
moderation.video_id moderation_video_id_fkey R
pin_video.video_id pin_video_video_id_fkey R
report_video.video_id report_video_video_id_fkey R
video_share.video_id video_share_video_id_fkey R
video_watch.video_id video_watch_video_id_fkey R
category varchar 128 √ null
hash_tags_str varchar 264 √ null
description varchar 1024 √ null
size_kb int4 10 √ null
total_time_ms int4 10 √ null
title varchar 2048 √ ''::character varying
video_hash varchar 4096 √ null
high_res_url varchar 512 √ null
med_res_url varchar 512 √ null
low_res_url varchar 512 √ null
share_url varchar 512 √ null
likes int4 10 null
dislikes int4 10 null
comments int4 10 null
bookmarks int4 10 null
shares int4 10 √ null
reports int4 10 null
file varchar 512 null
transcript text 2147483647 √ null
thumbnail varchar 512 √ null
nsfw_score float8 17,17 √ null
profanity_words varchar 2048 √ null
half_life int4 10 √ null
video_type varchar 64 √ null
video_source varchar 64 null
is_approved bool 1 null
status varchar 32 null
moderator_comment varchar 1024 √ null
owner_id varchar 64 null
user.userid video_owner_id_fkey R
nsfw_score_json jsonb 2147483647 √ null
thumbnail_small varchar 512 √ null
auto_category varchar 264 √ null
video_transcription_data jsonb 2147483647 √ null
compression_ratio float8 17,17 null
video_metadata jsonb 2147483647 √ null
customer_id varchar 8 √ null
customer.id video_customer_id_fkey R
interest_ids _varchar 2147483647 √ null
group_ids _varchar 2147483647 √ null
ref_link varchar 2048 √ null
created_at timestamptz 35,6 √ now()
updated_at timestamptz 35,6 √ now()
deleted_by varchar 32 √ null
admin_delete_reason varchar 1024 √ null
campaign_id varchar 8 √ null
campaign.id video_campaign_id_fkey R
admin_delete_time timestamptz 35,6 √ null
tagged_user_ids _varchar 2147483647 √ null
views int8 19 √ null
poll_id varchar 8 √ null
poll.id video_poll_id_fkey R
download_enabled bool 1 √ null
srt_files_url jsonb 2147483647 √ null
parent_library_content_id varchar 8 √ null
sales_library_content.id video_parent_library_content_id_fkey R
qna_processing_status qna_processing_status 2147483647 √ null
snippet_indexing_status snippet_indexing_status 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
video_pkey Primary key Asc pub_id

Relationships

Close relationships within degrees of separation