model

type Album struct {
	ID          int
	SpotifyID   string
	Name        string
	TrackAmount int
	Popularity  int
	CoverID     string
	CoverURL    string
	UpdatedAt   time.Time

	// Non db fields
	Artists []Artist
}

type AlbumArtist struct {
	ID       int
	AlbumID  int
	ArtistID int
}

type AlbumUser struct {
	ID        int
	UserID    int
	AlbumID   int
	DeletedAt time.Time
}

type Artist struct {
	ID         int
	SpotifyID  string
	Name       string
	Followers  int
	Popularity int
	CoverID    string
	CoverURL   string
	UpdatedAt  time.Time
}

type Directory struct {
	ID       int
	UserID   int
	Name     string
	ParentID int

	// Non db fields
	Playlists []Playlist
}

type DirectoryPlaylist struct {
	ID          int
	DirectoryID int
	PlaylistID  int
}

type History struct {
	ID         int
	UserID     int
	TrackID    int
	PlayedAt   time.Time
	AlbumID    int
	ArtistID   int
	PlaylistID int
	ShowID     int

	// Non db fields
	Track Track
}

type HistoryFilter struct {
	UserID int
	Limit  int
	Offset int
	Start  time.Time
	End    time.Time
}

type Link struct {
	ID                int
	SourceDirectoryID int
	SourcePlaylistID  int
	TargetDirectoryID int
	TargetPlaylistID  int
}

type Playlist struct {
	ID            int
	SpotifyID     string
	OwnerID       int
	Name          string
	Description   string
	Public        bool
	TrackAmount   int
	Collaborative bool
	CoverID       string
	CoverURL      string
	SnapshotID    string
	UpdatedAt     time.Time

	// Non db fields
	Owner       User
	Duplicates  []Track
	Unplayables []Track
}

type PlaylistTrack struct {
	ID         int
	PlaylistID int
	TrackID    int
	CreatedAt  time.Time
	DeletedAt  time.Time
}

type PlaylistUser struct {
	ID         int
	UserID     int
	PlaylistID int
	DeletedAt  time.Time
}

type Show struct {
	ID            int
	SpotifyID     string
	Name          string
	EpisodeAmount int
	CoverID       string
	CoverURL      string
	UpdatedAt     time.Time
}

type ShowUser struct {
	ID        int
	UserID    int
	ShowID    int
	DeletedAt time.Time
}

type Task struct {
	// Task result
	ID       int // ID of the task result
	UserID   int // ID of the user that started the task
	RunAt    time.Time
	Result   TaskResult
	Message  string
	Error    error
	Duration time.Duration

	// Task fields
	UID    string // Identifier of the task
	Name   string
	Active bool
}

type TaskFilter struct {
	UserID  int
	TaskUID string
	Result  *TaskResult
	Limit   int
	Offset  int
}

type TaskResult string

type Track struct {
	ID         int
	SpotifyID  string
	Name       string
	Popularity int
	UpdatedAt  time.Time

	// Non db fields
	Artists   []Artist
	Playlist  Playlist
	CreatedAt time.Time
	DeletedAt time.Time
}

type TrackArtist struct {
	ID       int
	TrackID  int
	ArtistID int
}

type TrackFilter struct {
	UserID     int
	PlaylistID int
	Limit      int
	Offset     int
}

type User struct {
	ID          int
	UID         string
	Name        string
	DisplayName string
	Email       string
}