live_viewers

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
live_id INT 10 null
lives.id live_viewers_live_id_fkey R
user_id INT 10 null
users.id live_viewers_user_id_fkey R
joined_at DATETIME 23 CURRENT_TIMESTAMP(3)
left_at DATETIME 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_live_viewers_live_id Performance Asc live_id
idx_live_viewers_user_id Performance Asc user_id
uniq_live_viewers_live_user Must be unique Asc/Asc live_id + user_id

Relationships

Close relationships within degrees of separation