Attributes

User

Id: int, Key
Username: string, Required
Password: string, Required
HashSalt: string, Default random
Email: string, Required, Unique
CreationDate: date, Default SysDate

App_Achievement

Id: int, Key
Name: string, Required
Description: string, Required
Xp: int, Default 100

UserAchievement

UserId: int, Key
AchievementId: int, Key
UnlockDate: date, Default SysDate

Media

Id: int, Key
OriginalName: string, Required
Description: string, Required
ReleaseDate: date
CriticScore: int
CommunityScore: int
MediaType: string

Wishlist

MediaId: int, Key, FK
UserId: int, Key, FK
Name: string, Required, Default OriginalName
UserScore: int
AddedDate: date
CoverImage: string
Status: string, Default "Plan To Play/Read/Watch" 
Series: string
Icon: string
BackgroundImage: string
LastInteracted: date

Note

Id: int, Key
MediaId: int, FK
UserId: int, FK
Content: string, Required
CreationDate: date, Default SysDate
ModifiedDate: date, Default SysDate

MediaUser

MediaId: int, Key, FK
UserId: int, Key, FK
Name: string, Required, Default OriginalName
UserScore: int
AddedDate: date, Default SysDate
CoverImage: string
Status: string, Default "Plan To Play/Read/Watch" 
Series: string
Icon: string
BackgroundImage: string
LastInteracted: date
GameTime: int, Default 0
BookReadPages: int, Default 0
NrEpisodesSeen: int, Default 0
MangaReadChapters: int, Default 0
MovieSecondsWatched: int, Default 0

Game

Id: int, Key
MediaId: int, FK
ParentGameId: int, Default 1
IGDBId: int
OSMinimum: string
OSRecommended: string
CPUMinimum: string
CPURecommended: string
RAMMinimum: string
RAMRecommended: string
HDDMinimum: string
HDDRecommended: string
GPUMinimum: string
GPURecommended: string
HLTBMainInSeconds: int
HLTBMainSideInSeconds: int
HLTBCompletionistInSeconds: int
HLTBAllStylesInSeconds: int
HLTBCoopInSeconds: int
HLTBVersusInSeconds: int

Game_Achievement

Id: int, Key
GameId: int, Key, FK
Name: string, Required
Description: string, Required

Book

Id: int, Key
MediaId: int, FK
Language: string
TotalPages: int
Format: string
GoodreadsLink: string

Movie

Id: int, Key
MediaId: int, FK
Language: string
DurationInSeconds: int
TMDBId: int

TV_Series

Id: int, Key
MediaId: int, FK
Language: string
TMDBId: int

Season

Id: int, Key
TVSeriesId: int, FK
Name: string, Required
NrEpisodes: int

Manga

Id: int, Key
MediaId: int, FK
Language: string
TotalPages: int
NrChapters: int
NrVolumes: int
AnilistId: int

Anime

Id: int, Key
MediaId: int, FK
Language: string
NrEpisodes: int
EpisodeDuration: int
AnilistId: int

UserTag

Id: int, Key
UserId: int, FK
Name: string, Required
MediaType: string

MediaUserTag

MediaId: int, Key
UserId: int, Key
UserTagId: int, Key

Source

Id: int, Key
Name: string, Required
MediaType: string

MediaUserSource

MediaId: int, Key
UserId: int, Key
SourceId: int, Key

Genre

Id: int, Key
Name: string, Required

MediaGenre

MediaId: int, Key
GenreId: int, Key

Series

Id: int, Key
Name: String, Required

MediaSeries

MediaId: int, Key
SeriesId: int, Key
Index: String

Retailer

Id: int, Key
Name: string, Required

MediaRetailer

MediaId: int, Key
RetailerId: int, Key

Publisher

Id: int, Key
Name: string, Required

MediaPublisher

MediaId: int, Key
PublisherId: int, Key

Creator

Id: int, Key
Name: string, Required

MediaCreator

MediaId: int, Key
CreatorId: int, Key

Platform

Id: int, Key
Name: string, Required

MediaPlatform

MediaId: int, Key
PlatformId: int, Key

Link

Id: int, Key
Name: string, Required
Href: string, Required

MediaLink

MediaId: int, Key
LinkId: int, Key