lives

100 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
live_analytics.live_id live_analytics_live_id_fkey R
live_archives.live_id live_archives_live_id_fkey R
live_comments.live_id live_comments_live_id_fkey R
live_kicks.live_id live_kicks_live_id_fkey R
live_likes.live_id live_likes_live_id_fkey R
live_product_sales.live_id live_product_sales_live_id_fkey R
live_products.live_id live_products_live_id_fkey R
live_promotions.live_id live_promotions_live_id_fkey R
live_rating_stats.live_id live_rating_stats_live_id_fkey R
live_ratings.live_id live_ratings_live_id_fkey R
live_staffs.live_id live_staffs_live_id_fkey R
live_viewers.live_id live_viewers_live_id_fkey R
pinned_comments.live_id pinned_comments_live_id_fkey R
shop_id INT 10 null
shops.id lives_shop_id_fkey R
title VARCHAR 50 null
thumbnail_url VARCHAR 255 √ null
started_at DATETIME 19 √ null
ended_at DATETIME 19 √ null
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
lives_shop_id_fkey Performance Asc shop_id
title Must be unique Asc title

Relationships

Close relationships within degrees of separation