users

id
Nonempty
Hidden
password
Nonempty
Hidden
tokenKey
Nonempty
email
emailVisibility
verified
username
profile_picture
Single
role
user, moderator, admin
Single
showcase
reviews
Multiple
is_critic
description
banner_picture
Single
review_count
average_rating
balance
level
xp
created
Create
updated
Create/Update


achievements
id
title
description
xp_reward
icon
Single
created
Create
updated
Create/Update


media
id
path
title
type
movie, tv, game, anime
Single
overview
release_date
poster
Single
backdrop
Single
is_published
created_by
users
Single
average_rating
review_count
is_popular
characteristics
progress_type
created
Create
updated
Create/Update


review_likes
Nonempty
id
review_id
reviews
Single
user_id
users
Single
created
Create
updated
Create/Update


reviews
Nonempty
id
user_id
users
Single
media_id
media
Single
season_id
seasons
Single
media_type
movie, tv, game, anime
Single
content
ratings
overall_rating
has_spoilers
status
progress
like_count
created
Create
updated
Create/Update



seasons
Nonempty
id
media_id
media
Single
Nonzero
season_number
title
overview
release_date
poster
Single
average_rating
review_count
is_published
created_by
users
Single
created
Create
updated
Create/Update



support_tickets
Nonempty
id
user_id
users
Single
category
subject
message
status
open, in_progress, closed
Single
admin_notes
created
Create
updated
Create/Update



user_achievements
Nonempty
id
user_id
users
Single
achievement_id
achievements
Single
awarded_by
users
Single
Nonempty
awarded_at
created
Create
updated
Create/Update