hellodb.io
MODELS · 13
/
20 refs · 101 fields
user
8
PK
id
uuid
email
varchar
display_name
varchar
country_code
varchar
is_email_verified
boolean
status
enum
created_at
timestamp
last_login_at
timestamp?
channel
9
PK
id
uuid
FK
owner_id
uuid
handle
varchar
title
varchar
description
text?
avatar_url
varchar?
subscriber_count
bigint
is_monetised
boolean
created_at
timestamp
video
10
PK
id
uuid
FK
channel_id
uuid
title
varchar
description
text?
duration_seconds
int
visibility
enum
status
enum
view_count
bigint
published_at
timestamp?
deleted_at
timestamp?
video_rendition
10
PK
id
uuid
FK
video_id
uuid
label
enum
codec
varchar
container
varchar
bitrate_kbps
int
storage_key
varchar
size_bytes
bigint
status
enum
created_at
timestamp
playlist
8
PK
id
uuid
FK
owner_id
uuid
title
varchar
description
text?
visibility
enum
item_count
int
created_at
timestamp
updated_at
timestamp
playlist_item
7
PK
id
uuid
FK
playlist_id
uuid
FK
video_id
uuid
FK
added_by_id
uuid
position
int
note
varchar?
added_at
timestamp
comment
9
PK
id
uuid
FK
video_id
uuid
FK
author_id
uuid
FK
parent_comment_id
uuid?
body
text
like_count
int
is_pinned
boolean
created_at
timestamp
deleted_at
timestamp?
subscription
6
PK
id
uuid
FK
subscriber_id
uuid
FK
channel_id
uuid
notifications
enum
is_hidden
boolean
created_at
timestamp
watch_history
8
PK
id
uuid
FK
user_id
uuid
FK
video_id
uuid
watched_seconds
int
watch_percent
decimal
device
enum
started_at
timestamp
last_seen_at
timestamp
video_like
5
PK
id
uuid
FK
video_id
uuid
FK
user_id
uuid
reaction
enum
created_at
timestamp
tag
5
PK
id
uuid
name
varchar
usage_count
bigint
is_blocked
boolean
created_at
timestamp
video_tag
6
PK
id
uuid
FK
video_id
uuid
FK
tag_id
uuid
source
enum
confidence
decimal?
created_at
timestamp
live_stream
10
PK
id
uuid
FK
channel_id
uuid
FK
video_id
uuid?
title
varchar
ingest_key
varchar
status
enum
scheduled_at
timestamp?
started_at
timestamp?
ended_at
timestamp?
peak_concurrent_viewers
int
110%
Opening YouTube