videos

100 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
video_products.video_id video_products_video_id_fkey R
video_views.video_id video_views_video_id_fkey R
shop_id INT 10 null
shops.id videos_shop_id_fkey R
staff_id INT 10 null
users.id videos_staff_id_fkey R
title VARCHAR 100 null
description VARCHAR 1000 √ null
video_url VARCHAR 255 null
thumbnail_url VARCHAR 255 √ null
is_public BIT 1 1
created_at DATETIME 19 CURRENT_TIMESTAMP
updated_at DATETIME 19 CURRENT_TIMESTAMP
deleted_at DATETIME 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
videos_shop_id_fkey Performance Asc shop_id
videos_staff_id_fkey Performance Asc staff_id

Relationships

Close relationships within degrees of separation