model

type Album struct {
	ID        uuid.UUID `gorm:"type:uuid;primary_key;"`
	CreatedAt time.Time
	UpdatedAt time.Time
	DeletedAt gorm.DeletedAt `gorm:"index"`

	Title       string
	ReleaseDate time.Time
	Songs       []Song            `gorm:"constraint:OnDelete:CASCADE;"`
	Identifiers []AlbumIdentifier `gorm:"constraint:OnDelete:CASCADE;"`
}

type AlbumIdentifier struct {
	ID        uuid.UUID `gorm:"type:uuid;primary_key;"`
	CreatedAt time.Time
	UpdatedAt time.Time
	DeletedAt gorm.DeletedAt `gorm:"index"`

	Identifier string    `gorm:"not null"`
	AlbumID    uuid.UUID `gorm:"type:uuid;not null"`
	Album      Album
}

type Artist struct {
	ID        uuid.UUID `gorm:"type:uuid;primary_key;"`
	CreatedAt time.Time
	UpdatedAt time.Time
	DeletedAt gorm.DeletedAt `gorm:"index"`

	Name        string
	Identifiers []ArtistIdentifier `gorm:"constraint:OnDelete:CASCADE;"`
}

type ArtistIdentifier struct {
	ID        uuid.UUID `gorm:"type:uuid;primary_key;"`
	CreatedAt time.Time
	UpdatedAt time.Time
	DeletedAt gorm.DeletedAt `gorm:"index"`

	Identifier string    `gorm:"index;not null" `
	ArtistID   uuid.UUID `gorm:"type:uuid;not null"`
	Artist     Artist
}

type MBArtistCredit struct {
	ID   int    `gorm:"primaryKey"`
	Name string `gorm:"column:name"`
}

type MBRecording struct {
	ID             int             `gorm:"primaryKey"`
	GID            string          `gorm:"column:gid"`
	Name           string          `gorm:"column:name"`
	ArtistCreditID int             `gorm:"column:artist_credit"`
	ArtistCredit   *MBArtistCredit `gorm:"foreignKey:ArtistCreditID;references:ID"`
	Length         int             `gorm:"column:length"`
}

type Playlist struct {
	ID        uuid.UUID `gorm:"type:uuid;primaryKey"`
	CreatedAt time.Time
	UpdatedAt time.Time
	DeletedAt gorm.DeletedAt `gorm:"index"`

	Name           string          `gorm:"not null"`
	FolderID       uuid.UUID       `gorm:"type:uuid;index"`
	PlaylistFolder *PlaylistFolder `gorm:"foreignKey:FolderID"`
	UserID         uuid.UUID       `gorm:"type:uuid;index;not null"`

	PlaylistSongs []PlaylistSong `gorm:"foreignKey:PlaylistID;constraint:OnDelete:CASCADE;"`
}

type PlaylistFolder struct {
	ID        uuid.UUID `gorm:"type:uuid;primary_key;"`
	CreatedAt time.Time
	UpdatedAt time.Time
	DeletedAt gorm.DeletedAt `gorm:"index"`

	Name      string
	UserID    uuid.UUID  `gorm:"type:uuid;not null;index"`
	User      User       `gorm:"foreignKey:UserID"`
	ParentID  *uuid.UUID `gorm:"type:uuid;index"`
	Parent    *PlaylistFolder
	Children  []*PlaylistFolder `gorm:"foreignKey:ParentID"`
	Playlists []Playlist        `gorm:"foreignKey:FolderID;constraint:OnDelete:CASCADE;"`
}

type PlaylistSong struct {
	PlaylistID uuid.UUID `gorm:"type:uuid;primaryKey"`
	SongID     uuid.UUID `gorm:"type:uuid;primaryKey"`

	// Order is a fractional index string for sorting
	Order string `gorm:"type:text;not null;default:''"`

	CreatedAt time.Time

	// Associations
	Playlist Playlist `gorm:"foreignKey:PlaylistID"`
	Song     Song     `gorm:"foreignKey:SongID"`
}

type RequestMail struct {
	gorm.Model
	Category string
	Message  string
	UserID   uuid.UUID
	Status   RequestMailStatus
}

type RequestMailStatus int

type Setting struct {
	Key   string `gorm:"primaryKey"`
	Value string
}

type Song struct {
	ID        uuid.UUID `gorm:"type:uuid;primary_key;"`
	CreatedAt time.Time
	UpdatedAt time.Time
	DeletedAt gorm.DeletedAt `gorm:"index"`

	AlbumID     uuid.UUID `gorm:"type:uuid"`
	Album       Album
	Title       string           `gorm:"index"`
	Artists     []Artist         `gorm:"many2many:song_artists;constraint:OnDelete:CASCADE;"`
	SongFiles   []SongFile       `gorm:"constraint:OnDelete:CASCADE;"`
	Identifiers []SongIdentifier `gorm:"constraint:OnDelete:CASCADE;"`
}

type SongFile struct {
	ID        uuid.UUID `gorm:"type:uuid;primary_key;"`
	CreatedAt time.Time
	UpdatedAt time.Time
	DeletedAt gorm.DeletedAt `gorm:"index"`

	SongID   uuid.UUID `gorm:"type:uuid"`
	Format   string
	Duration uint
}

type SongIdentifier struct {
	ID        uuid.UUID `gorm:"type:uuid;primary_key;"`
	CreatedAt time.Time
	UpdatedAt time.Time
	DeletedAt gorm.DeletedAt `gorm:"index"`

	Identifier string    `gorm:"not null"`
	SongID     uuid.UUID `gorm:"type:uuid;not null"`
	Song       Song
}

type User struct {
	ID        uuid.UUID `gorm:"type:uuid;primary_key;"`
	CreatedAt time.Time
	UpdatedAt time.Time
	DeletedAt gorm.DeletedAt `gorm:"index"`

	Username     string     `gorm:"uniqueIndex;not null"`
	PasswordHash string     `gorm:"not null" json:"-"`
	IsAdmin      bool       `gorm:"default:false"`
	BannedUntil  *time.Time `gorm:"default:null"`
}