187 lines
1.5 KiB
Plaintext
187 lines
1.5 KiB
Plaintext
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
|